>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only