Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting primary key after an insert
Message
 
 
À
05/06/2006 17:27:42
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:
01127228
Vues:
24
Can you use VFP GETAUTOINCVALUE() Function ?

>I am using VB.NET to insert a record in a VFP table which contains a primary key field which is defined auto incremental. So, basically, I am doing something like this to insert the record:
>
>
>INSERT INTO School (Title) VALUES ("This is my school name")
>
>
>However, in that particular case, I need to insert child records right after. As oppose to SQL Server, I cannot rely on the identity field by adding it in my SQLInsert command. So, how would I proceed to get this key in order to insert the child records and have them linked to the proper parent?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform