[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: sorting invoice numbers by numerical order
- Subject: Re: sorting invoice numbers by numerical order
- From: Luke <..hidden..>
- Date: Tue, 16 Feb 2010 17:43:28 -0500 (EST)
This discussion has reminded me of an annoying quirk. Well, having to
compensate for it last night also reminded me of it.
<?lsmb YYYY ?><?lsmb MM ?>00001
as the default, might get me:
Whereas I would expect:
This has frustrated me since SQL-Ledger. I have to manually reset the
defaults at the start of any period for which I use a variable string of
One way to handle it, to cover various use cases, might be with a
variable which specifies lowest sequence number, with a certain maximum
digit count to be left-padded. Example:
<?lsmb YY ?><?lsmb mm ?><lsmb lowestnumber 5 ?>
That way, the portion that is in the lowest sequence, will always use the
lowest available sequence number in the context of the whole string.
The obvious first problem with this idea, is execution time, as it
requires a query to determine the next available sequence number.
The second problem is the fact that sequences may include things other
The first seems simple enough: if you use this method, expect longer
execution times when generating numbers.
The second, however, would seem significantly problematic. A single
hyphen, or leading 0 (0902-00001) would break the functionality.