See Cetin's today post Re: How to use SQL OpenRowSet thru VFP9 Message #1170966
>You can't. You must prepare the list and SELECT beforehand. >
>SELECT .... && your "I want to use here vfp Statement"
>lcList = []
>SCAN
> lcList = lcList + IIF(EMPTY(lcList),[],[,]) + TRANSFORM(FieldName)
>ENDSCAN
>
>SQLExec(gnconnhandle,'select * from product where prcode in ('+ lcList+ ')','product')
>
>
