.mode defaults

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

.mode defaults

KlaasV
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

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Klaas "Z4us" V, MetaDBA at InnocentIsArt.EU