What do you mean by 'indirect phase'?
The results of execution -
sqlite> select '.once tc'||strftime('%s','now');
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
> > 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
> > 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 ?
> sqlite-users mailing list
sqlite-users mailing list