>Hello.
>I have an array full of primary-key values for a table.
>
>Is there a way in VFP that I can query against this array to extract values from a table?
>
>Something like
>SELECT * FROM mytable where mytable.PK in myarray
>
>Thank you.
Well, there is a way, but it's not optimizable:
SELECT * FROM mytable WHERE ASCAN(myarray,PK,1,-1,-1,2+4) > 0
Another way is copying the array to a cursor and using a normal Query.
Fernando D. Bozzo
Madrid / Spain