Hi

I have an existing application, that connects to a Firebird database
created by 3rd party database manager. I would now like my 'updated'
application to create several new fields in the database. AFAIU i can
use a script with something like:

ALTER TABLE SONGS
ADD ARTIST1_ID INTEGER;
COMMIT;

(from a previous post :)

and then do
IB_script1.execute;
after connecting to the database.

This seems to work ok the first time its run, but once the new field
has been added, running the program again causes problems, i assume
due to trying to create a field that already exists.

Is it enough to simply use
try IB_script1.execute

or should I be trying to determine if the field exists, and if so how?

Many thanks for any help given