Why would you expect mySQL to have access to VFP memory (where the variable is stored).

Build the string, then send it

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

>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