I am not clear. My understanding is that the autoincrement field keeps the last used value somewhere in the header of the table (correctly if I am wrong). What happens if the header of the table becomes corrupted. How do you correct it?
>No more, no less likely.
>
>>Hi,
>>
>>I need to add a table to my database and thought that would be a good idea to try autoincrement for the PK field for this table. The table won't be very important and the use will be kind of limited so the reduction of speed, on update is not a big concern for me (this is what I read in VFP 9 help). What does concern me is how more likely such table to become corrupted? And if it does become corrupted, is it more difficult to troubleshoot such case, as compared to the table without autoincrement field?
>>
>>TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
