.bail command in SQLite

Ya I have set .bail ON and given a column name which does not exist in Table. Its showing error of no such column.

0

have you set bail ON while executing select command......because it works only when bail command is set.

0

Hi Pravin. Will it not work in SQLite command window? I have applied select statement on a Table for a record which does not exist. So its an error but it doesn't stop processing. Please explain how I can test this command. Thanks.

0

Pravin More15y ago

Hi Monika,

The .bail command controls the error handling behaviour.it only affect noninteractive sesions ,when SQL commands are being read from a file or from standard input.
so,if the "bail" flag is set,any error will cause the processing to stop.
the default is off.

Thanks,

Pravin.

0