General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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