Hi Matt,

Sometimes it helps to check Help :) There is EXCEPT clause in this command, so you can omit autoinc fields.

>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