Re: [sqlite] How to use parameterized queries in SQLite.Net

2017-03-13 Thread Chris Locke
From a newbie's point of view, how is this better (if doing it in 'hard coded' format like below) than writing this code: command.CommandText = string.format("INSERT INTO trend_data (tag_key, value, value_timestamp) VALUES ({0}, {1}, {2})",2,234.56,now); I can sort of understand it if its in a su

Re: [sqlite] How to use parameterized queries in SQLite.Net

2017-03-13 Thread J. King
On March 13, 2017 4:15:57 PM EDT, Rob Richardson wrote: >To answer my own question: this works: > >using (SQLiteCommand command = m_conn.CreateCommand()) >{ >command.CommandType = CommandType.Text; >command.CommandText = "INSERT INTO trend_data (tag_key, v

Re: [sqlite] How to use parameterized queries in SQLite.Net

2017-03-13 Thread Rob Richardson
To answer my own question: this works: using (SQLiteCommand command = m_conn.CreateCommand()) { command.CommandType = CommandType.Text; command.CommandText = "INSERT INTO trend_data (tag_key, value, value_timestamp) VALUES (?, ?, ?)";

Re: [sqlite] A CTE to count the records (rows) for each table

2017-03-13 Thread Brian Curley
Statistics, even if generated at run-time, might be useful. One option, at least per the CLI, might be to output a variant of DRH's last SQL to be read back in. I've no idea as to the portability of this onto embedded systems, but it works "okay" on the CLI and on desktop apps...my test file was f

Re: [sqlite] A CTE to count the records (rows) for each table

2017-03-13 Thread Richard Hipp
On 3/13/17, Marco Silva wrote: > Hi, > > Does anyone knows a Common Table Expression (CTE) to be used with the > sqlite_master table so we can count for each table how many rows it > has. That is not possible. Each table (potentially) has a different structure, and so table names cannot be va

Re: [sqlite] A CTE to count the records (rows) for each table

2017-03-13 Thread Simon Slavin
On 13 Mar 2017, at 6:40pm, Marco Silva wrote: > Does anyone knows a Common Table Expression (CTE) to be used with the > sqlite_master table so we can count for each table how many rows it > has. The way SQLite stores its data is not helpful to counting the rows. The number of rows isn’t store

[sqlite] A CTE to count the records (rows) for each table

2017-03-13 Thread Marco Silva
Hi, Does anyone knows a Common Table Expression (CTE) to be used with the sqlite_master table so we can count for each table how many rows it has. -- Marco Arthur @ (M)arco Creatives ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Help file has no information

2017-03-13 Thread Rob Richardson
Thank you. That worked. (The button was labelled "unblock", not "unlock") RobR -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Graham Holden Sent: Monday, March 13, 2017 2:26 PM To: SQLite mailing list Subject: Re: [sqlite] Help

Re: [sqlite] Help file has no information

2017-03-13 Thread Graham Holden
Either don't store it on a network drive or right click, select properties and unlock (see https://social.technet.microsoft.com/Forums/en-US/20700886-2000-4c52-b706-aa1fb32d3dfb/cant-view-chm-file-contents?forum=W8ITProPreRel). I think. Graham Sent from my Samsung Galaxy S7 - powered by Three -

Re: [sqlite] Help file has no information

2017-03-13 Thread Simon Slavin
On 13 Mar 2017, at 6:14pm, Rob Richardson wrote: > The help file that is linked from the System.Data.SQLite home page appears to > have a table of contents but no information. No matter what page I select, > the page does not appear. This is the result of a bug in Microsoft’s display code.

[sqlite] How to use parameterized queries in SQLite.Net

2017-03-13 Thread Rob Richardson
Hello again. Since my attempt to find the official answer for myself has hit a snag, I'll just ask here. The examples I've seen for parameterized queries used with the SQLiteCommand class have shown named parameters, and the names usually begin with an "@" character. Is that character require

[sqlite] Help file has no information

2017-03-13 Thread Rob Richardson
The help file that is linked from the System.Data.SQLite home page appears to have a table of contents but no information. No matter what page I select, the page does not appear. RobR ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Where is the official document for System.Data.SQLite?

2017-03-13 Thread Rob Richardson
Blindness cured. I had visited that page but missed the super-sized, bold headline that said "Documentation for System.Data.SQLite". Thanks for opening my eyes. RobR -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Donald Grigg

Re: [sqlite] Where is the official document for System.Data.SQLite?

2017-03-13 Thread Donald Griggs
On Mon, Mar 13, 2017 at 1:44 PM, Rob Richardson wrote: > Where is the official document for System.Data.SQLite? And is there a > better list than this one to ask questions about System.Data.SQlite? Hi Rob, I don't use system.data.sqlite, but I believe you'll find the documentation at: http:

[sqlite] Where is the official document for System.Data.SQLite?

2017-03-13 Thread Rob Richardson
Where is the official document for System.Data.SQLite? And is there a better list than this one to ask questions about System.Data.SQlite? Specifically, I'm looking for the correct way to use the SQLiteCommand class and parameterized queries. Do parameters have to be named? Thank you.