On Thu, 25 Jul 2002, Stumbaum, Rainer wrote: [snip]
> The way I would prefer would be, to have those defaults in a table > with the following structure > > UserID > Parameter > Value And perhaps a table with a list of valid parameters that would be used for RI. > and then for the Parameter a key field table with all the possible > values (maybe the value field even as a text field so you could even > put the signatures in there...... > > Means, if somebody wants to extent, he could just add his parameter to > the key field table and assign the value to the user account... Someone, as in, database/SQL-Ledger administrator (I'm a bit of a control freak). > One thing which I personally still don't like is this members file > which contains all the user specific data, in my belief this should go > into the database as well.... I've been considering this for a long time but didn't want to 'get into it' since I was more than happy with the results that SQL-Ledger provides. Coming from a database design and application develop background I even prefer that access to tables and functions of the database should be enforced by the RDBMS instead of the code. I have another application I'm working on that will use this method and once I get it realized I'll present it for consideration. And as one last parting thought you method could also hold the templates, HTML, PS, LaTeX which would divorce the user completely from a specific system to log into. And simplistically all they'd need is a web server with SQL-Ledger installed and their database connection information. (This may be taking it a bit far :-) Rod -- "Open Source Software - Sometimes you get more than you paid for..." ------------------------------------------------------- This sf.net email is sponsored by: Jabber - The world's fastest growing real-time communications platform! Don't just IM. Build it in! http://www.jabber.com/osdn/xim ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
