On 13 Jan 2018, at 7:54pm, Shane Dev <devshan...@gmail.com> wrote:
> What do you mean by 'indirect phase'? Having to execute a command to find the command you want to execute. > The results of execution - > > sqlite> select '.once tc'||strftime('%s','now'); > .once tc1515872821 > sqlite> > > obviously the numeric part of the file name will change depending on the > time of statement execution - or do I misunderstand your question? So the purpose of this is to find compose a filename which includes a timestamp ? For prototype purposes you should be able to do this in whatever shell you’re using to run the SQLite shell tool. For real project uses you should be doing it in whatever language your programming in, of course. You can’t use the SQLite shell tool for real project purposes on multiple platforms. It won’t run on many IoT devices, of course. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users