From: jon bing
Visual FoxPro 9 SP2
Databases, Tables and SQL Server
Sunday, December 25, 2011 1:38:35 AM
This message was rated by:
I always use code below to insert record to MYSQL Product tbale
x1=sqlexec( nconn ,' insert into product( kode, name) values ( ?productc.kode, ? productc.name)
( productc is the cursor of product table where I entry or edit the data. )
The code above works fine for a small number of fields table, however as the size increased. I found it hard to keep track all the field.
Is it possible to use single command to insert record to my Product table since
my Productc cursor is EXACTLY THE SAME FIELDS AS THE PRODUCT TABLE?
I'm looking for something like..
------------------ so tht I don't have to write the fields one by one.
I already try some codes like that above, but still can't get it work.
Can anyone please advise,
Posted by jon bing @ 12/25/2011 1:38:35 AM
RE: INSERT COMMAND
Posted by Anders Altberg @ 12/25/2011 1:32:04 PM