>thanks Sergey
>
>i want to write one new sql statement
>vfp - statement
>select code from _tmp
>
>SQLExec(gnconnhandle,'select * from product where prcode in ( i want to use here vfp Statement','product')
>can it possible

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')