All, just upgraded from v.3.3.6 to current (a big jump), and found that a file that previously worked one way now works another.
At the sqlite command prompt I type .read tmp.txt the contents of tmp.txt are as follows .echo on .separator ' ' .headers on .output sbs2011-11-17.txt select a.modes as Code,f.callsign as Callsign,a.registration as Reg,a.icaotypecode as Type, a.OperatorFlagCode as Oper,case when a.interested = 0 then ' ' else '*' end as Seen, a.modescountry as Country,f.firstaltitude as FirstAlt,f.lastaltitude as LastAlt, f.FirstLat as Pos,Time(f.endtime) as [Last Update],Date(f.endtime) as Date from flights f, aircraft a where f.aircraftid = a.aircraftid and date(f.EndTime) = "2011-11-17" order by f.endtime; .output stdout The output of the sql goes to the named sbs2011-11-17.txt file. Under v.3.3.6 I got my column headers (.headers on) and my sql results. Now I get that, plus the actual sql statement itself. How do I suppress the sql statement from appearing on the file? Rick Timms _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
