>I am building a Reindex (Reorganize) that will redue all indexes and drop deleted records. After a couple of suggestions from this forum, I am at the point of an Append From that fails because of autoincrement primary keys being read only. In the old days, prior to vpf6 you could COPY FILE to xxx then APPEND FROM xxx and that was that. Today, with create table pk, the append wants to increment.
>
>Any ideas.
>
>Dallas
Have you tried the suggestions from VFP Help topic, "APPEND FROM Command"?
"If the target table uses autoincrementing, APPEND FROM fails if AUTOINCERROR is set to ON, unless the FIELDS option is used to omit the AUTOINC column. Setting AUTOINCERROR to OFF or turning off autoincrementing in the target table by using CURSORSETPROP( ) allows the APPEND FROM to succeed. The target table's autoincrementing field or fields are incremented according to the values specified, and the values in source table are not applied."
Chris