>>>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
>
>No, I don't hink that would work for him. "WITH BUFFERING" would only allow the user to query their own buffered data, not another workstation's.

Fred,
Sounds like my English is getting worse nowadays:) I didn't mean the other user's buffer. He wouldn't even be able check his own buffer if not in same session.
Cetin