> Good Morning
>
> I was trying to find the system table in Firebird that stores
> the object
> names and their properties but could not find it... first of all is there
> such a table in Firebird? and if there is can I restructure it by adding
> fields to it?
>
> My application has all the table definitions hardcoded (also stored
> procedures, UDFs...) whenever I update my application and one of those
> object definitions was modified i want my application to update it
> automatically on the server. The reason why we do this is of
> course is when
> we release new versions we just send the .exe to the client which
> should do
> all the updating work...
>
> I want to store the version numbers given to this objects into a table
> in the database and whenever I launch a new version of the application I
> want the application to scan the object tables to retrieve the
> names of the
> objects that should be Altered and alter them....
>
> Thanks in advance
>
> Vahan

I doubt this is a good recipe. I have a version table. I also have update
scripts in my applications. The app starts and tests the version table
first. if it's higher than the app, the app terminates. if it's lower than
the app then the app runs scripts to update the database. Tools like
database comparer will create the script for you and you run it in a script
component taking necessary precautions against being the only user connected
at the time of the script firing etc.
Alan