Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting primary key after an insert
Message
De
08/06/2006 11:18:47
 
 
À
08/06/2006 11:09:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01127217
Message ID:
01127856
Vues:
26
>>Here is some VB.NET sample that demonstrates how to get AUTOINC value back after Insert:
>
>Thanks, this is some very interesting good. In the first approach, as the value of the auto incremental field is returned in a secondary command into the adapter, does this guarantee that the value returned is in fact the incremental key that was generated by the insert command in this code?
>

Yes, as long as GETAUTOINCVALUE(0) is executed immediately after INSERT and through the same connection.

>By that, I mean that if two users are executing this code, is there a chance that the value returned is the value of the insert of the other user? >

No, no chance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform