>>>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
I am still confused. Give me an example of what you are trying to do and why and what does SUM() do for you?