Derek Atkins schrieb: > Herbert Thoma <[EMAIL PROTECTED]> writes: > >> Ah well, I have a 30", 2560 pixel wide screen, 256 chars on a single >> line is possible, if the font is not too large ... >> >> Rolf wants german SKR4 account codes and these are 6 or 8 digit numerical >> codes, but that fact does not help since other users may have (miss-) >> used the account code field with longer codes. > > It is not a mis-use of the field to have longer codes. > I agree, 32 is too long. > > What exactly is the use-case for using codes as a primary key?
I don't know and http://bugzilla.gnome.org/show_bug.cgi?id=560165 doesn't tell either. In my opinion the mapping of account to code is a one-to-one relationship and I see no reason for account code being used as a primary key, one could (and should) use the account key. > Keep in mind that the SQL Backend data store is just that, a > data store. GnuCash does NOT use database constraints, and > for Accounts it doesn't even need to use an Index, because GnuCash > does (should!) load in all the accounts at start time. > > So... All searches on accounts are done in core in the gnucash app > without looking at the DB backend. I agree. Herbert. > -derek -- Herbert Thoma Dipl.-Ing., MBA Head of Video Group Multimedia Realtime Systems Department Fraunhofer IIS Am Wolfsmantel 33, 91058 Erlangen, Germany Phone: +49-9131-776-6130 Fax: +49-9131-776-6099 email: [EMAIL PROTECTED] www: http://www.iis.fhg.de/ _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
