>>>>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
I knew you knew that, it was more for the lurkers.