>O.K. so I have an inventory database which I have designed and I need to move records from 1 table to another, the issue is there are certain fields that will not transfer. The code I was working with (Thanks Naomi N.) was correct for transferring a whole record. My problem is where would the except clause get inserted with the scatter command?
>
>I have searched VFP help and the examples therein only exist to confuse
>
>the code is as follows:
>
>

>
>scatter name loRecord memo
>insert into mynewtable from name loRecord &&(verify this syntax,)
>delete from myoldtable where ID = loRecord.ID
>
>
>

>
>If anyone has any ideas thanks in advance
>
>Thanks
>
>Fred W.

From http://msdn.microsoft.com/en-us/library/3e7k65t6(VS.80).aspx

select myTable
scatter FIELDS EXCEPT ID MEMO name loRecord
insert into mynewtable from name loRecord 
delete && we're deleting current record just transferred.