I use this approach as to obtain random records from a view, after selecting the desired IDs in a temporary cursor, then passing the IDs from the cursor. In my case I have no table in the database with the name of 'tempquery' so I 've to use the clause ' ... IN (Select id from tempquery) ' which works great with VFP6, but no more with VFP7.

TIA

Bruno Maddalozzo



In this case, why wouldn't you just use:
SELECT tb1.*;
FROM data1!Table1 tb1, tempquery;
WHERE tb1.id = tempquery.id

(or use a JOIN)

Rick

>When creating views with the VIEW DESIGNER with VFP6 as to obtain a view like:
>SELECT *;
> FROM data1!Table1;
> WHERE Table1.id IN (Select id from tempquery)
>
>No error occurs.
>
>When trying the same operation with VFP7, this is no more possible, and the following error is raised:
>
>"Index does not match the table. Delete the index file and re-create the index"
>
>Is this a (documented) bug or a wanted exclusion by MS?
>
>Strange is that the view can still be created by code.
>
>Thank you in advance.
>Bruno Maddalozzo