>>Hi,
>>
>>If I load a view, append some records, delete some and then, execute a query that extracts data from the view, I got only the records as they were before I did some modifications. But, if I execute a tableupdate, all works OK.
>>
>>I don't get the new records and the deleted ones is always in the query. I don't know if I'm missing a point!
>>
>>Please help!
>
>You got exact result that you should expect: querying a view actually means querying of underlying table(s). That's the way how it was designed. And you really have to issue tableupdate() to get right query result.

Hi, thanks for the reply.

I was afraid to get this answer. What I was hoping to do is to verify all the information entered before commiting to the SQL Server table. One of my verification was to query a view but I guess I will SCAN it instead.

Thanks again...