>I had to add an auto increment field in a table. So far so good, it went well. But, the table was already created with a bunch of records. So, I wanted to punch the IDs in it. However, VFP tells me that the field is read only. How can I achieve that once I have some records in it?
First add the field w/o autoinc, REPLACE ALL with some IDs Check the last and then ALTER TABLE to make it autoinc with the NEXT LastID+1
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
