Have an integer column in our order table that holds our order numbers.
Maximum ever is 999999
Command to generate a new number for new order, is to compute Max no.
from table and add 1
That becomes the new order no.
Last week the system conjured up a number or 10 or 12 digits, and added 1
If you looked at the table, that number did not exist.
Edit all using that number returned nothing.
I fixed it by setting a limit on the compute max command to 999999, but sure
would like to understand where that phantom number is coming from.
Dick Fey
--
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
