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.
--sb--