Here's a method that's a little more complicated, but I know it will work. You create a record and append the record to it, then append the record back into the table. Let's say the table is named mytable.
=AFIELDS(aMyFields)
CREATE CURSOR temp FROM ARRAY aMyFields
m.nRecNo=RECNO('mytable')
APPEND FROM mytable FOR RECNO('mytable')=m.nRecNo
SELECT mytable
APPEND FROM DBF('temp')
That should do it.
>>Try this:
>>
>>SCATTER MEMVAR MEMO
>>INSERT INTO mytable FROM MEMVAR
>>>Hi,
>>>
>>>Is there any way to duplicate a record with a character field, a memo field and a general (image) field ?
>>>
>>>Regards,
>
>It did not work with General fields. It only copies the character field and the memo field.
>
>Regards,