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
