*bug description:* Using PRAGMA busy_timeout outputs the value which in case of html output screws up the display. To be more precise, it creates an extra row/recordset with the timeout value, which is what then shows on the html page.
There should be a way to say "set the pragma, but don't output it". It is especially important for -html mode which is designed for end-user consumption. What's more, it's very difficult to grep away as you can see. *To replicate:* echo "create table foo as select 1 as c;select * from foo;" |sqlite -html -header -cmd "PRAGMA busy_timeout =1000;" :memory: *<TR><TH>timeout</TH>* *</TR>* *<TR><TD>1000</TD>* *</TR>* <TR><TH>c</TH> </TR> <TR><TD>1</TD> </TR> Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
