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
