Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicating a record
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00118384
Message ID:
00118533
Views:
25
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,
Previous
Reply
Map
View

Click here to load this message in the networking platform