General information
Category:
Coding, syntax & commands
There is a table called po_no which is used to get the next po #. When the user chooses to add a po, the po # is the current value in po_no.next_no. Then the table value is incremented by one (value of next PO). This works just fine when I have one instance of the program running. When I try to run two instances, the table value has not been update when I try to add the second po (they both try to use the same #). The following code is used:
SELECT po_no
temp_pono = po_no.next_no
THISFORM.txtPO_no.VALUE = temp_pono
REPLACE po_no.next_no WITH (temp_pono+1)
What should I do to force the table update?
Thanks in advance for your help
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