Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transactions and GetAutoincValue()
Message
 
 
To
22/05/2009 15:29:38
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01373138
Message ID:
01401599
Views:
42
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform