>at the time of purchase/sales data entry i am showing balance stock :
>
>select itemcode, sum(iif(type='purchase',qty,-1*qty)) as balance from inout group by itemcode into dbf bal
>
>it is showing same value to all users, not add/less the qty of buffered records.
>
>warm regards,
>mk.

??? Did I say something different? Maybe you're seeking for new 'with buffering=.t.' clause of select-SQL.
Cetin