>Hi
>I have an app that copies records to SQL and it works fine I wanted to try it against VFP tables but it crashes. It adds the first record fine but then return the error
>
>"Additional information: Column 'pk' is constrained to be unique. Value '' is already present."
>
>I have set the primary field "pk" as AutoInc and have a primary index on it. If I add records at the command window it works ok. So what have I forgotten to do?
>TIA
>Stuart
Stuart,
I don't know MM but sounds like you're trying to insert a record with a provided PK value and autoinc fields are readonly. What's your insertCmd?
Cetin