Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable views and autoinc
Message
From
24/01/2007 10:49:33
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01176384
Message ID:
01188713
Views:
12
>>AutoInc clashes with Table buffering applied on parent table. One may rethink interface to avoid these cases.
>
>The only other way (besides the kludge approach I already thought off) I see is to not allow to enter children unless we saved the parent.

I think you exaggerate. Frankly, I never get in this situation (generally speaking I don't use Tableupdate, except special cases), but why do you need to have table buffering on parent? You could have row buffering and go by each record, saving parent record, getting Id, and then saving child records.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform