Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP equivalent to scope identity()
Message
 
À
06/08/2004 22:25:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00931503
Message ID:
01196669
Vues:
10
>If I'm inserting into a VFP8 table that has an autoinc integer field, and I'm inserting from an external program that using the VFP OLE DB Provider, is there anyway to retrieve the key that was generated from the insert?
>
>(Basically, I'm looking for an equivalent of SELECT Scope_Identity() that's in SQL Server.
>
>Thanks,
>Kevin

Did you tried GETAUTOINCVALUE(). This is VFP 9 function and I am not sure if it will works with OLEDB (Because it is not in HELP for supported commands and functions for OLEDB provider).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform