>>>>>
select * from customer where exists (select * from orders)
>>>>>result in C5 error. Expected no error (not talking about SQL being logical or not).
>>>>
>>>>Works find for me. If tables are available, I get browse window. If they are not, I get error "File 'customer.dbf' does not exist".
>>>
>>>You do? Then why it's causing a crash here:( Deleted foxuser* already and tested with some other tables too, it doesn't crash if I icnlide a where clause).
>>>Cetin
>>
>>Broken indexes on these tables?
>>Invalid database container?
>>corrupted DBFs?
>
>I thought all of them. It just C5 with VFP9 but not 7, same tables, other tables, new tables. Probably related to some fluke. If not happening elsewhere I can live with it:)
>In my case I only hit it with a premature [ENTER] pressing.
>Cetin
What happens if you try my first test (that with CREATE CURSOR) or try with SET TABLEVALIDATE=0?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.