Ciao SQLiters,
The separators don't change back to the defaults automatically after change of mode from 'asci' to 'list'. Perhaps a '.mode def' or something like that would help to do so? Defaults --[[z4us|binz--]] sqlite3 o1.sqc '.sho' ? ? ? ? echo: off ? ? ? ???eqp: off ? explain: off ? ???headers: off ? ? ? ? mode: list ???nullvalue: "" ? ? ? output: stdout colseparator: "|" rowseparator: "\n" ? ? ???stats: off ? ? ???width: Test of current behaviour --[[z4us|binz--]] sqlite3 o1.sqc '.read o2def.sql' echo: off eqp: off explain: off headers: on mode: ascii nullvalue: "" output: stdout colseparator: "\037" rowseparator: "\036" stats: off width: titt1a2b echo: off eqp: off explain: off headers: on mode: list nullvalue: "" output: stdout colseparator: "\037" rowseparator: "\036" stats: off width: titt1a2b --[[z4us|binz--]] cat o2def.sql .he on create table t1 (ti integer primary key, tt text) without rowid; insert into t1 values (1,'a'); insert into t1 values (2,'b'); .mo asci .sho select * from t1; .mo list .sho select * from t1; Kind regards |?Cordiali saluti | Vriendelijke groeten | Freundliche Gr?sse, Klaas `Z4us` V ?- LinkedIn# 437429414