Are you putting the view in the DE of a form? If so, in the BeforeOpenTables, you need to put:
set talk off
set deleted on
Either that, or set NoDataOnLoad property of the cursor to TRUE. Then after the form loads, you can REQUERY() the view in something like the Activate or Init or right before you need the contents of the view.
>That worked fine, however, when I set deleted on, and use a view on the table with the deleted records, the deleted records show up in the view. I have a GROUP BY, and ORDER BY clause in the query BTW. Why would deleted records show up?
>
>thanks
>
>>>I have two tables. I need to find and eliminate records in table 2, that are in table 1 using two variables, field 1 and field 2. Any ideas how to do this?
>>>
>>>thanks
>>
>>Assuming both fields are character data type and the same in both tables:
>>
>>delete from Table2 where Field1+Field2 in (select Field1+Field2 from Table1)
>>
>>Otherwise, you will have to Transform() [or convert] them to character strings. You should also test this on copies of your tables with a subset of the data. It worked for me when I tested it.
Mark McCasland
Midlothian, TX USA