>>How I can make the SELECT see what's in the buffer
>>(Validation reason).
>>
>>I used Transaction/Rollback in some cases, Used SUM()
>>in other cases.
>>
>>Is this can't do for now or I missed something.
>>If I did not miss anything, where is the wish list???
>>
>>Thank You
>>Merci Beaucoup
>I used a table with the BEGIN TRANSACTION,changed a field, did a SELECT * FROM table, and the new value was returned. Is this not what you are getting? Or are you looking for the original value?

Hi Larry

TRANSACTION works for me in works in many cases but the problem
with that approach that you need to TABLEUPDATE/ROLLBACK which
I can not do in a complex screen that where SUM() came handy.

I am wishing for addition to the SELECT statement such as

SELECT (dada...) BUFFER which give us what's in the buffer.

Thank you