Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Default unique ID values for a field in a remote table ?
Message
From
01/06/1998 15:26:34
 
 
To
01/06/1998 15:19:31
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00103696
Message ID:
00103751
Views:
35
>>If you mean that you use VFP interface connected to VFP tables using remote views, than you probably took wrong way, just because using local views you will get the same thing but avoid one (redudndant, in this case) ODBC layer. Surely, unique ID generation will work the same way in both cases.
>
>I know that I can set the exclusive property on the local views of my data session, but this isn't possible with Remote Views. And I'm using them because I need multi-user access to the same tables, that need to be located on a server computer. I don't know how to implement a different solution.
>I know what I should do to generate an unique id, but I don't know a way to lock the table used to store the latest index...

Remore views and ODBC are both used when you should connect to non-VFP data source (usually RDBMS as SQL-Server,Oracle,Sybase,etc). If you use VFP data you should take normal way working with local views and/or plain tables. Local view is always exclusive because it always exists locally, so don't worry about this. Actually multi-user integrity supported by buffering and generic app flow.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform