>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

Add ? before the myID, e.g.

STORE iReemb1.ID TO  myID 


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

asa=SQLEXEC(lnHandle,cSQL )

and re-try.