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
02/06/1998 11:43:51
 
 
To
02/06/1998 11:27:34
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00103696
Message ID:
00104027
Views:
50
>Normal ID generation procedure (can be stored or regular) is foolowing:
>You have separate table 'Setup.dbf' with two fields 'Tablename','NewID'.
>***Procedure GetNewid
[...]

Right, thanks. This way the only way to retrieve the new index to show it on my form (without requerying the table), would be to call GetNewId as a regular procedure, maybe just before the TableUpdate(). But what should I do if the update fails for whatever reason ? I'd like to avoid 'holes' in the ID field, and so the stored procedure should be preferred. But then, how could I get the new id back to my code ?
Sincerely,

Andrea Brajuka
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform