Ivan Prenosil wrote:

> > But how can I NOT alter the table (ie add a new field) if the field
> > exists ? (written as a SQL statement using iSQL IB6)
>
> If the field exists, you get error message and table will NOT be altered.
> isql script will continue after error.
>

Which is fine, but checking every error to see if it is a 'real' error is a
pain.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further