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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer