<i><font color="#663300">We've been using the application since Janurary of last year without any problems with the id field untill I installed a new version. Take note that I recently lost my hard drive and had to re-install everything incuding FoxPro up to service pack 4. I had the project directory backed up, including the codebook directories, and went on from there.
I'm thinking that somehow I've lost some foxpro settings that may have been crucial for codebook to run properly? I'm thinking that there is some problem with regard to multiusers and the id table? It seems that codebook is not trapping the error when a conflict occurs as I think it has in the past. The users are getting kicked out of the program when the error occurs, so I was wondering what I should do to remedy this problem.</font></i>
By any chance did you restore an old version of the ID/NextPK table? This would cause exactly what you described.
One solution is to determine the MAX(cID) of each table, and then set the next available value in the ID table to 1 greater than that.
<font color="#cc0000"> ___/
/
__/
/
____/</font>
Ed Leafe
©2001 Ed Leafe |
