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

2017-03-14 Thread Keith Medcalf
rch, 2017 00:53 > To: SQLite mailing list > Subject: Re: [sqlite] How to use parameterized queries in SQLite.Net > > 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.Com

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

2017-03-14 Thread Graham Holden
laxy S7 - powered by Three Original message From: Chris Locke Date: 14/03/2017 06:52 (GMT+00:00) To: SQLite mailing list Subject: Re: [sqlite] How to use parameterized queries in SQLite.Net From a newbie's point of view, how is this better (if doing it in '

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

2017-03-14 Thread Clemens Ladisch
Chris Locke wrote: > 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); Using paramete

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

2017-03-14 Thread Hick Gunter
[email protected]] Im Auftrag von Chris Locke Gesendet: Dienstag, 14. März 2017 07:53 An: SQLite mailing list Betreff: Re: [sqlite] How to use parameterized queries in SQLite.Net From a newbie's point of view, how is this better (if doing it in 'hard coded' fo

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

2017-03-13 Thread Chris Locke
inal Message- > From: sqlite-users [mailto:[email protected]] > On Behalf Of Rob Richardson > Sent: Monday, March 13, 2017 2:23 PM > To: General Discussion of SQLite Database (sqlite-users@mailinglists. > sqlite.org) > Subject: [sqlite] How to use

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

2017-03-13 Thread J. King
ecuteNonQuery(); >} > >RobR > >-Original Message- >From: sqlite-users >[mailto:[email protected]] On Behalf Of Rob >Richardson >Sent: Monday, March 13, 2017 2:23 PM >To: General Discussion of SQLite Database >(sqlite

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

2017-03-13 Thread Rob Richardson
[email protected]] On Behalf Of Rob Richardson Sent: Monday, March 13, 2017 2:23 PM To: General Discussion of SQLite Database ([email protected]) Subject: [sqlite] How to use parameterized queries in SQLite.Net Hello again. Since my attempt to find the official answer for

[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