Dr. Hipp, thanks for the tip. I put
.bail on
in the script.
Ryan, I think I don't know how to trigger the bail out from within a SELECT
statement.
I tried
SELECT CASE (select count(*) from T1) WHEN (select count(*) from T2)
then 'OK' else RAISE(FAIL) END;
But this is definitely not the right way to do it. If I understand the doc
correctly, it should be an expression, but I don't see how I can do this...
thanks
gert
2015-04-01 20:44 GMT+02:00 Richard Hipp <drh at sqlite.org>:
> On 4/1/15, Gert Van Assche <gertva at gmail.com> wrote:
> >
> > My question is: when the import fails (detected in the script.sql file),
> I
> > would like to stop executing the batch file (runscript.cmd).
> >
> > Is there a way to do so?
> >
>
> Have you tried the -bail command-line option?
> --
> D. Richard Hipp
> drh at sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
