Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transactions and GetAutoincValue()
Message
 
 
À
22/05/2009 15:29:38
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01373138
Message ID:
01401599
Vues:
36
>Indirectly, by looking at the next value returned, from the next transaction - you should be able to see whether it skipped or not.

The problem is - we have two updatable views: parent and child. We want to insert a new record into the Parent and corresponding records into the child tables in one transaction.

How would we get ParentID without tableupdate on the parent using AutoInc column?

I was having similar problems with AutoInc field and CA some time ago. I believe AutoInc fields have more troubles than it worth than we come to parent/child relations.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform