>I've read the old threads so I know that this has been discussed -- could somebody just help me clarify my thoughts...
>
>Is it true to say that when using table buffering, performing a SQL Select on the buffered data will always result in the oldval() values of the table?? Is there ANY way around this?
>
>Thanks,
>Valerie
Valerie, I don't think there is a way around it, because you have to clear the data out of your local buffers before the SQL can see it. If you're querying on a table you're also editing, just add a tableupdate() before the query (or requery).
Barbara