Re: Ignoring Errors in DBACCESS

Richard Thomas wrote: > > Fred Prose wrote: > > > > > Is there a way to tell DBACCESS or ISQL to ignore errors in an SQL > script > > file? For example, don't stop if a DROP TABLE statement executes and > the > > table doesn't exist. > > > > > > Fred, > > For ISQL, the short answer is no. Any error will cause it to stop > processing. For DB-ACCESS, the opposite is true - the default behaviour > is to continue after error. This is only true in commandline mode. In menu mode the default, and only behavior, is to stop on the first error. So the correct response to Fred is: Run your scripts from commandline mode: dbaccess mydatabase myscr -OR- dbaccess mydatabase - <myscr.sql -OR- dbaccess mydatabase <<EOSQL <sql> . . <sql> EOSQL Art S. Kagel