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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users