SQL only reports committed records. You could possibly do a SCAN..ENDSCAN.
-myron kirby-
==========================
>I have a table in a form with the buffermodeoverride set to 5. I add records to it with an append statement. Before doing a tableupdate() I do a select * from table and nothing shows up. However, when I do a browse at this point the records I appended show up. Is this a bug or how can I get records to show up in a select on a buffered table?