On 2011 Dec 21, at 14:41, Peter Buchanan wrote: > Also, users have (against my advice...) insisted that when a document is > cancelled, the number should be released for use again, and it must be used > on the very next shipment to that port. So if 0019 was cancelled and 00030 > had was the most recent document, then the next document would get 0019, and > not 0031.
Repeatedly tell them that they're crazy, that no competent database professional would EVER do it this way, and that they can ask a dozen other authorities if they don't believe you. If they're still pig-headed about it, devise a 2nd, parallel (and maybe best hidden-from-view) system that does it the right way, so you can sort out the inevitable confusions and mix-ups for these undeserving bozos. Then be sure to document what you do for the benefit of your successor and start looking for work elsewhere. = = = = = = Richard S. Russell 2642 Kendall Av. #2 Madison WI 53705-3736 608+233-5640 [email protected] http://richardsrussell.livejournal.com/ Sun god! Sun god! Ra, Ra, Ra!
