<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
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?<br />
<br />
Thanks!!<br />
<br />

</div>
</div>


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?

Thanks!!



VFP 9 &amp; MySQL - Copy Record Same Table

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

VFP 9 &amp; MySQL - Copy Record Same Table

VFP 9 & MySQL - Copy Record Same Table