On 24 Aug 2006, at 17:04, [EMAIL PROTECTED] wrote:
I would like my program to be able to find out what version of itself made a database. Is there a way to store random information like that inside a database? I suppose I could use a totally separate table for random information, but that seems a bit overkill...
A seperate table is the solution nevertheless, just create a schema_version table with just one field: "version". Only change the schema version number if you actually make changes to the database. It will also enable your users to skip a few version and then upgrade the database several steps: if schema_version.version < 3 then ..., if schema_version.version < 4 then ..., if schema_version.version < 5 then ...
Best regards Peter De Berdt _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
