isql error code

[piervalli]

Dear,

I have created this script

SET bin="C:\Program Files\Firebird\Firebird_5_0"
SET script=./indexSql.txt
SET username=SYSDBA
SET password=firebirdsql
SET PATDB=c:\temp\database.fdb
%bin%\isql -i %script% -u %username% -p %password% %PATDB%
if %ERRORLEVEL% NEQ 0 echo Error

If the database does not exists isql return always 0, It should be return an error code.

What do you think?

Thanks Pier

[hvlad]

Did you tried -bail switch https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/isql/firebird-isql.html#isql-switches

or command https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/isql/firebird-isql.html#isql-set-bail

?

[piervalli]

Sorry, it is works with -b

Thanks

[piervalli]

Resolved