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 ?

sqlite-users mailing list

Reply via email to