Hello,
I have the next code :
nhandle = sqlconnect('Estadis_ds','root','')
= sqlsetprop(nHandle, 'Transactions', 2) && Manual transactions
select 1
use hesta alias esta
select esta
go top
do while .not. eof()
nhandle,"insert into tabla1 values (esta->campo1)")
sqlexec(nhandle)
sqlcommit(nhandle)
select esta
skip
enddo
select 1
use
sqldisconnect(nhandle)
The problem is :
This code not write in the MySQL table "tabla1", I execute MySQL front and the table "tabla1" was empty.
The ODBC is the correct and no errors found.
Could you help me ?
Many thanks