Is there any error handling available in the SQLite 3.0.8 command shell? Using sqlite3 test.db "read my.sql" from the commandline, I don't see a way to embed an exit into the script file in case something goes wrong with one step or another.
I want to use the shell read a script like this from my.sql: create temp table tmp_tbl (...); .import somefile.txt --exit here if the import fails ... How do I test for the failed import, and exit? Thanks! -Clark