Hi David,

You are right David, SQL only reports commited values. Actually I realised it after posting a thread.

Bye
Jayesh

>Jayesh,
>
>Depending on the buffering and views you are using the SELECT will not return the current value for the sum. A SCAN loop or the CALCULATE command will work.
>
>>SELECT SUM(tcfield);
>>FROM &lcalias;
>>INTO ARRAY lasum