Hi all. I am using VFP 9 to connect to a mysql db via odbc using sqlselect. All is working fine, I can read/write to the db and all tables. But I have a question.
I have encountered several situations where it would be nice to be able to copy the data from an existing record to a new record in the same db/table.
So, for example, say I have a record (example record_id = 100), and I want to copy all the data for this record to a new record (record_id = 101), how would I do that?