>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.
For workaround see Accessing rows in a table buffered view Message #666224.