Thanks. Is it just me or does this sound like a good item to place in the wish list?

Alex

>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?