>A coworker is attempting to query (using vb.net) a free foxpro table and join it to a query from sql server 2000 using the 'IN' clause. The query error message returned states that there are too many elements in the IN clause????
>
>Is there an easy way to do this?
>
>Join a foxpro free table with a result from sqlserver? Right now he queries the foxpro table into a temporary table and then queries it looking for in... the sqlserver select.
What is the exact query?
If I'm not mistaken (and I think I am) IN in VFP versions prior to VFP9 was similar to INLIST() function that had the 24 items limit.
E.g. myValue IN (val1,....) was the same as INLIST(myValue, ...). But I'm not certain about it.
If it's not broken, fix it until it is.
My Blog