Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does auto inc field work with cursor adapter?
Message
From
04/02/2011 22:11:53
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01498851
Message ID:
01498860
Views:
56
>Hi,
>
>I have a couple of questions on using Auto Inc field. I have never used them before and consider adding/using for a table that currently has no PK field. So I want to add
>
>1. Will a table with an Auto Inc field work with a cursor adapter? That is, can I add/edit/delete records in this table via cursor adapter object?

Yes. You have to get the "real" PK value after insert operation if the newly created CA record needs it elsewhere (as a FK in parent-child relations).
>
>2. Do you find that adding an Auto Inc field make the table more susceptible to corruption (than table without such field)?

corruption no. But if the seed value is/turns somehow wrong, you have to take action, as the table might be insert-blocked.
Also slightly more work if appending is part of the tasks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform