Hi

The mySQL command below worked

cSQL = "UPDATE reembolso set exp=1  "
asa=SQLEXEC(lnHandle,cSQL )

Now it became complicated because I am trying to make it conditional using a VFP variable.
as below

STORE iReemb1.ID TO  myID 


   cSQL = "UPDATE reembolso set exp=1  where ID <=  myID   "

asa=SQLEXEC(lnHandle,cSQL )

Looks like the mySQL command does not accept the VFP variable directly.

This variable is necessary because it is the last record I got from a VFP cursor which I pre-generated from
the remote table in order not to permit replacements beyond it.

Is there a way I can I pass it ?

Moises