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.
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:
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
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
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
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.
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
-
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
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
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
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
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
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 (?, ?, ?)";
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
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
15 matches
Mail list logo