The same could be accomplished by creating a “Application_SchemaVersion” SP which would return the necessary details.

The advantage would be that no search thru the domain would be required.

Sean

Hi Semjon

I had a similar need so what I do is I create a Domain

CREATE DOMAIN "FDBVersion_1.80.1451"
 AS SMALLINT;

Then I delete this and create a new one every time there is a new version.  I use the partial string "FDBVersion_" to look for an existing Domain.

Hope this helps

Kind regards
Bhavbhuti

 

Hello,

My main intend is to add some version information to a firebird database file, since I will use firebird as embedded database and installers/update mechanism will need this information.

The information should be available platform independent and I would prefer a solution not needing any database access.

I figured out it is possible to simply append manually some ascii data at the end of the db file (see picture attached). This would be my preferred solution. It seems to work (I can still read and write to the database and even manipulate the database structure). But maybe this is only luck? So my question is:

· Is it save to do this?

· Do you suggest another method instead of my? *

* Of course it is reasonable to store the version information inside the database in a special table, I think. But a kind of release-script could read this information, append it to the binary db file and any installer/updater does not need to search inside the database.

Thank you in advance.

Semjon Mössinger

[Non-text portions of this message have been removed]

-- 

Thanking you.

Yours Faithfully,

For Venus Software Operations

----

Mr. Bhavbhuti Nathwani

___________________________________________

Softwares for Indian Businesses at: http://www.venussoftop.com

venussoftop@...

venussoftop@...

___________________________________________

Please note: We reserve complete rights for policy changes in the future and the same will be applicable immediately as and when made.  Attachments may get corrupted before reaching you, in such a situation please let us know and we will resend you the same at the earliest.  We do not take any responsibility for data loss of any type and kind.  Data safety remains the sole the responsibility of the users of our softwares.

___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or confidential.  If you are not the addressee nor are you responsible for the delivery of the message to the addressee indicated in this email, then you may not copy or deliver this email to anyone and you should notify the sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject, if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by my company.