General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Field value in Multiuser environment
I am using Sales.SalesNum field as an invoice number, which will increment automatically each time the user append
a new invoice.
I place the master SalesNum in Data.SalesNum, so when the user click the new button the textbox "TxtSalesNum"
will have the value Data.SalesNum + 01.
The problem accured in multiuser environment.
User 1 : giving SalesNum = 1
User 2 : giving Salesnum = 1
User 1 save the invoice and having salesnum = 1 and click the new button. TxtSalesnum.value = 2
User 2 Save the invoice and having salesnum = 2. But when he click the new button, he have TxtSalesnum.value = 2
not 3.
Thank's
In Save Procedure
Sele Data
Repl SalesNum with SalesNum + 01
TableUpdate(.T.)
Unlock All
in PNew Procedurte ( When The user click the New Button)
Thisform.TxtSalesNum.Value = Data.SalesNum + 01
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only