Woody wrote:

>> I don't know how expensive it is to perform these queries, but I'm
>> interested in how you folks are logging your patches.
>
> I keep a version update table in each database. It stores the version number
> of the update, the SQL text and the date it was done. A management function
> in most of my apps checks an update file in a known location against the
> database to see if any updates are needed. If any are needed, they are done,
> one at a time, and the information stored in the version table.

I prefer that way too. You can read about it in detail in this paper
from one of Firebird Conferences:

http://www.ibphoenix.com/downloads/FirebirdConf2006/HOWTO-TPZ205-R/HOWTO-TPZ205-R.zip

HTH


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com