General information
Category:
Coding, syntax & commands
Title:
Create a duplicate record
how do I create a duplicate record in a table. The table does have memo fields. Also this table has a default value that creates a primary key (for example nextid("fscgnt_tbl"). I also need to modify one field while duplicating the record. I thought about selecting the record into a cursor, then modifying the single field and then writing it out, but I also have a child table where where I may need to gather several records at a time and need a single field changed on those records. I don't know if scan...endscan is best way to go about or is there another more efficient technique?
thanks
Nick
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only