Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting primary key after an insert
Message
From
06/06/2006 15:41:57
 
 
To
06/06/2006 13:24:30
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01127217
Message ID:
01127466
Views:
18
>>Since you decided to ignore my questions, I don't know if this is what you need, but you can use functions in INSERT command, it doesn't matter whether you execute the command using ADO, OLEDB or ADO.NET.
>>
>>INSERT INTO ... VALUES (..., GETAUTOINCVALUE(0), ...)
>
>I don't understand how I could get a handle on that value after the insert command is done.

Hi Michel,

If your question is how to get AUTOINC value after INSERT command generated one then I've already answered this question in my first reply on this thread. Simply call GETAUTOINCVALUE(0) as a procedure.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform