>>>>

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