On 16 Aug 2019, at 4:40pm, Martin <mdransfield...@btinternet.com> wrote:

> select * from sqlite_parameters

You are expected to create this table yourself, either directly or by using one 
of the parameter commands.  See

<https://sqlite.org/cli.html#sql_parameters>

This sequence works.  You should be able to use it to progress:

sqlite> .schema
sqlite> .param init
sqlite> .schema
CREATE TABLE temp.sqlite_parameters(
  key TEXT PRIMARY KEY,
  value ANY
) WITHOUT ROWID;
sqlite> .param list
sqlite> .param set nodeNum 67
sqlite> .param list
nodeNum 67
sqlite> SELECT * FROM temp.sqlite_parameters;
nodeNum|67
sqlite> SELECT * FROM sqlite_parameters;
nodeNum|67
sqlite> 
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to