SQLite Forum

"headers on" yet no headers
Login
Hi,

It looks unlikely that I'm the first to notice this but I can't find anything in the forum.

I use the command line utility sqlite3.exe to write the results of a query to a TAB-separated file, using the headers on setting. When the query doesn't return any rows, there will be no header line in the output file. I would VERY MUCH prefer to get a file with header line (and nothing else of course).

Cheers,

John