>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 ....
lcList = []
SCAN
lcList = lcList + IIF(EMPTY(lcList),[],[,]) + TRANSFORM(FieldName)
ENDSCAN
SQLExec(gnconnhandle,'select * from product where prcode in ('+ lcList+ ')','product')
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.