Unfortunately, you can not perform a select on a buffered record set.

Use SCAN AND SEEK instead.

Mace

>Hi,
>How could I SELECT all of the records from uncommited view? I need to do this because I want to check the existence of records in the view. That will be more than one record. I tired to use SELECT ....WHERE myKey NOT IN (SELECT myKey FROM myview).. but the subquery always return EMPTY record.
>
>Any ideas?
>
>Thank you