Hi Matt,
You can use SET AUTOINCERROR OFF to suppress the error or you can use REMOVEPROPERTY() to remove "ipkey" from loCurrentJob object.
I'm not sure why do you want to use REPLACE after GATHER if you can change/set properties of the loCurrentJob object before GATHER.
>Need some guidance here... I am trying to copy the data in one record to a new record in the same table, then change the JobNo field to some new Job umber that I already have and validated as unique.
>
>The problem is that the table has an AutoInc field named "ipkey", and VFP does not want to let me do a GATHER for obvious reasons.
>
>So, I understand why it has this limitation because of autoinc, I just want to know how one works around it.
>
>Presently, to get around it, I am doing a REPLACE command on every field except ipkey, but I was hoping to use the SCATTER NAME / GATHER NAME method to avoid having to list out every field, and so I would have code that is independent of the field names.
>
>Here's what I wanted to use:
>
>Select 0
>Use Jobs order jobno
>... navigate to the desired record ..
>SCATTER NAME loCurrentJob
>Append Blank
>Gather NAME loCurrentJob
>replace JobNo with lcNewJobNo && a passed in value, already validated
--sb--