>Never say never. :)
>
>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 ....
>>lcList = []
>>SCAN
>> lcList = lcList + IIF(EMPTY(lcList),[],[,]) + TRANSFORM(FieldName)
>>ENDSCAN
>>
>>SQLExec(gnconnhandle,'select * from product where prcode in ('+ lcList+ ')','product')
>>
>>
I read it. But I doubt (I can't test it right now) that if the DBF is on my local machine (no shares) and SQL Server is somewhere in space the OPENROWSET will works.
Also isn't my way faster than with OPENROWSET() :-)
But you are right, always there is a way. If I remember right one Russian saying says: Если нельзя, но очень хочится - то можна :-). Excuse me for the spelling, I didn't wrote in Russian almost 20 years.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.