Hi Simion, What do you mean by 'indirect phase'?
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? On 13 January 2018 at 20:40, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 13 Jan 2018, at 7:33pm, Shane Dev <devshan...@gmail.com> wrote: > > > I use mainly Linux (bash) and Windows (powershell) but my target > platforms > > also include Android, iOS, IoT (anything that can link against the sqlite > > library). At this stage, I am trying to prototype as much as possible > using > > only the SQLite shell. > > Your theory is sound. You should be able to build a SQL command using the > results from another SQL command. But there must be a way to express your > SELECT in a way which doesn’t require the indirect phase, and your command > looks especially simple. > > Can you post what the results of > > select '.once tc'||strftime('%s','now'); > > are expected to look like ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users