> >lcServer="siteground150.com" >lcPort= 3306 >lcDatabase= "monitorr_acrisoft" >lcUser= "monitorr_monitor" >lcPassword= myPassword >lcStringConn="Driver={MySQL ODBC 5.1 Driver};Server=&lcServer;Port=lcPort;Option=16384;Stmt=;Database=&lcDatabase;Uid=&lcUser;Pwd=&lcPassword" >SQLSETPROP(0,"DispLogin",1) >lnHandle=SQLSTRINGCONNECT(lcStringConn) >upit="select * from reembolso" >IF lnHandle > 0 > rez=SQLEXEC(lnHandle, upit, "ctable1") > BROWSE >And what's the alias of the cursor you're browsing? It should be ctable1.
>SELECT reembolso && fails hereOf course it fails, that table is on the remote server. You, actually, never opened that table. Your remote server did, and it sent you a recordset from that table.
> replace nome WITH 'test' && fails hereYou probably didn't stay on the ctable1 alias, or ctable1 didn't have a nome field, but it shouldn't have failed - it may still work if you remove the previous SELECT reembolso line.