Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting primary key after an insert
Message
From
07/06/2006 22:23:40
 
 
To
06/06/2006 18:16:46
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:
01127755
Views:
29
>I understand GETAUTOINCVALUE(0) will return the primary key used at the insert time. But, where would it be returned.
>

By default, execution of a procedure through VFPOLEDB returns result set with one record and one field, which contains procedure's return value.

BTW, GETAUTOINCVALUE(0) doesn't return primary key used at insert time, it returns last generated AUTOINC value.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform