Re: [Gnumed-devel] Introducing myself and questions on billing/accounting

[Karsten Hilbert]

On Fri, May 20, 2011 at 11:34:32AM +0200, Hilbert, Sebastian wrote:

> I remember from attempts to interface SQL ledger that calling the new invoice 
> script the invoice number was automatically generated inside SQL ledger. This 
> did break when for some reason the next in sequence was already taken. It did 
> not choose next in sequence + 1 and try that but rather refuse to set a 
> number 
> automatically.  

That's a tell-tale sign of database design drain-bamage by
confusing surrogate unique primary keys with *sequential*
invoice IDs often required by local financial laws.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346