Martin wrote:
...
Example (maybe via .read):
.once .dat
select date('now');
.let f system echo "words-`cat .dat`.txt"
.once -let f
select word from words order by 1;
..
Sorry for replying only to this single point. The proposed ".let"
command is not essential here. As a student I was impressed by the
SNOBOL programming language because it allowed "dynamic code
generation" (writing before the foot). From the SQLite command line
this works too:
.once tmp1.sql
values ('.once words.' || date() || '.dat'),
('select * from words;');
sqlite> .read tmp1.sql
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
