[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Introducing myself and questions on billing/accountin
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Introducing myself and questions on billing/accounting |
Date: |
Fri, 20 May 2011 13:15:54 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, (continued)
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Chris Travers, 2011/05/19
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Jim Busser, 2011/05/19
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Jim Busser, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Jim Busser, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Karsten Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Sebastian Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Chris Travers, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Sebastian Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Jim Busser, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Sebastian Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting,
Karsten Hilbert <=
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Karsten Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Karsten Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Jim Busser, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Karsten Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Sebastian Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Karsten Hilbert, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Chris Travers, 2011/05/20
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Karsten Hilbert, 2011/05/21
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Chris Travers, 2011/05/21
- Re: [Gnumed-devel] Introducing myself and questions on billing/accounting, Chris Travers, 2011/05/20