Alejandro,

You can't. If you need to do this then you will have to use the procedural way such as scan endscan.

>How to perform a SQL select on a buffered table that will take into account buffered records: Does anybody have a solution that does not involve starting a transaction, tableupdating, running select and then reversing transaction?
>
>TIA,
>
>Alex