Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving PKs from an inserted row (CursorAdapter)
Message
De
24/10/2003 13:58:51
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00841822
Message ID:
00842347
Vues:
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,

My pleasure, Martin.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform