Subject RE: [ib-support] generator of generators
Author Alan McDonald
there's nothing inherently wrong with DDL scripts AFAIK. Maybe I'm silly,
but when I pass out an upgrade to my applications, the minor version number
increase coincides with a metadata upgrade to the database. Everytime my
applications fire up, the first thing they do is check the version of the
database. If the application is a (or more) step(s) ahead, then IB_Script
components fire up to upgrade the database and commit the changes. Since
these scripts are left in the source, it is possible then, to bring a
database several versions old up to date in one transparent step. There is,
of course a note and my users are aware that an upgrade must be done while
noone else is working on the database. But I haven't had a problem with this
strategy yet.
In Duilio's case, I would rather do it with multiple tables. Since no two
companies are allowed to see other company's data, then separate tables
would be ideal - especially since permissions would be easier to manage. But
it's his project.

-----Original Message-----
From: Svein Erling Tysvaer
Sent: Monday, 3 March 2003 8:52 PM
Subject: Re: [ib-support] generator of generators

the one thing that bothers me is that you want to do DDL from within your
application. Unlike Helen, I cannot say exactly why, but it does ring a
warning bell.

The one article that I think may get you on a better track is "An Auditable
Series of Numbers" found on

Regardless of whether this helps or not, I hope you find a good solution to
your problem.


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to