There's one already SELECT-SQL working with local buffered data Wish #580. Just add your rate/comment to it.

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