you might want to issue an sql update and send that to your remote database:
something like the following code would put all the names to 'test' in your remote db. You can add a where clause to filter.
cSQL = "update reemolso (name = 'test') "
SQLEXEC(lnHandle, cSQL)
I could access database and browse my table using commands below.
>
>No I would like to do a simple task as "replace all OK with .T." in my table.
>
>Please help me.
>
>>
>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
>
>SELECT reembolso
> replace nome WITH 'test'
>
>
>
>ELSE
>*error description
>endif
>=SQLDISCONNECT(lnHandle)
>
>>
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
