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