Hi,

The SELECT will always read from the underlying table. The only way I know of achieving what you need (and it's ugly) is:

BEGIN TRANSACTION
TABLEUPDATE()
SELECT ......
ROLLBACK

HTH,
Viv

>I need to use some values from a buffered view in order to run a selec statement. If the view is not saved, the selec doesn't work, if I grab the value from the control related to the view, the selec doesn't work either. Only when the view is saved the selec works. What could be wrong or how can I solve this?
>
>The source data for both the selec and the view is the same table.
>
>TIA