Dick, pack your indexes and constraints. You have a spurious index entry I suspect. Albert
> On Jan 15, 2018, at 8:48 AM, Carpet Broker, Dick Fey <[email protected]> > wrote: > > 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. -- 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.
