Check Re: Sending a list from vfp Message #829213 and Re: Table as Variable, passing from VFP to an SQL SP. Message #788283


>Native data Senario.
>localcur
>select somefields from mytable where mytable.keyfield in (select keyfield from localcur)
>the above works fine with native VFP data.
>
>SQL data senario
>localcur
>*** the localcur can not be used in SQLEXEC, therefore i populate the data into an array:
>select keyfield from localcur into array myarray
>Is there an SQL syntax similar to:
>sqlexec(lhandle,[select somefields form mytable where myrable.keyfield in myarray)
>Please note: I would like to avoid the creation of a string with data from the array.