Today, Benjamin Rutt <[EMAIL PROTECTED]> wrote:
> Modifying db schema is not trivial or elegant with any RDBMS that I've
> ever heard of. Besides, adding a new field on the fly is easy with
> the current bbdb implementation. Doing it with a RDBMS would be quite
> difficult, and many RDBMS implementations have limitations on how you
> can modify tables once they have been created.
There is no need to do that. None at all. With the design I crafted this
morning (again, it can be found at
http://www.htlwrn.ac.at/d96001/bbdb/bbdb-er.html), you do not need to
ALTER TABLE or do similar evilness. All you have to do is INSERT a row
into field-names and let the triggers do the rest (or, if there are no
triggers available, you will have to call another procedure, but that
should be all).
Take a look at it, I know that this must work. (-8
> Benjamin
regards,
--
Andreas Fuchs, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, antifuchs
_______________________________________________
bbdb-info mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/mailman/listinfo/bbdb-info
