Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autoincrement ID
Message
From
16/07/2003 12:13:03
 
 
To
16/07/2003 11:26:41
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00810682
Message ID:
00810711
Views:
11
This message has been marked as the solution to the initial question of the thread.
The record pointer should be at the record just inserted, so you should be able to do
liNewId = Alias.KeyField
>Hi
>
>I have a table with an autoincrement field. I add a record.
>
>How can I tell what value has been assigned? I am flirting with rlock("0", "alias") to lock the table header (to at least prevent any other inserts until I have determined the new ID) but it's not going that well.
>
>Is there a canned answer anywhere?
>
>Cheers
>
>Stuart Dunkeld
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform