|Subject||RE: [firebird-support] Looking for some suggestions...Vertical market apps|
> This looks pretty much like what we were expecting to develop. Ain it's own one record table, called version, minor, major etc fields
> couple of
> questions from your answers:
> a. Where do you store the version number of the DB? Is this in data in
> the database or somewhere in meta data?
> b. Is there a way that you know, where an application can detect ifif you are not using sysdba for all your connections, i.e. you use the
> other users are logged into the database, to be sure that they can run any
> utility scripts without logged in users getting in the way?
security db for your users and not your own schema, then you can use the
shutdown db method but this has it's own problems.
> c. You mentioned that there is no need to unload the data from theonly if you alter table drop field... you'll loose the data in that field.
> database when the schema is altered. Am I to assume, that statements like
> 'ALTER TABLE', etc. will not affect data stored in the tables in Firebird?
If you want to change the datatype, then depending on how bad you have to do
it, you'll crea a temp field, update that field from the old field, drop the
old one, create a new one and update the new on from the old one, then drop
that temp one. Generally I don't need to do this. If you are adding fields
you don't have to worry at all.