>>Anyone know the fastest, easiest, cleanest way to copy a record. The only thing I don't want copied is the cID field that gets updated with newid(). Everything else needs copying.
>>
>>BTW --- APPEND FROM ARRAY doesn't update cID
>>
>>
>>Thanks 4 your help.
>
>In general you can use:
>scatter memvar memo
>m.cID=newID()
>append blank
>gather memvar memo
Rather than using SCATTER/GATHER MEMVAR, I've found it far better to use SCATTER/GATHER NAME, which creates an object:
SCATTER NAME oTemp MEMO
oTemp.cID = newID()
APPEND BLANK
GATHER NAME oTemp MEMO
If the table automatically assigns a default value on adding a new record, this should read:
SCATTER NAME oTemp MEMO
APPEND BLANK && default ID assigned on APPEND
oTemp.cID = cID
GATHER NAME oTemp MEMO