Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving PKs from an inserted row (CursorAdapter)
Message
From
24/10/2003 08:58:51
 
 
To
23/10/2003 17:57:28
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00841822
Message ID:
00842036
Views:
26
Hi, Aleksey.

>CursorAdapter.AfterInsert event is the place to refresh AUTOINC values during TABLEUPDATE.
>
>For ODBC or ADODB.Command based Insert, execute SELECT @@IDENTITY using the same connection and simply replace value for the local field. This method might not work as expected if Insert command inserts into more than one IDENTITY field.
>
>For ADODB.Recordset based Insert, move to the last record in the Recordset, get value from its field and replace the local field. This method (moving to the last record) works for adOpenStatic recordset, I am not sure how it'll work for different recordset type.

This is exactly what I wanted. It's great to have you around.

Best regards,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform