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
