On March 13, 2017 4:15:57 PM EDT, Rob Richardson <[email protected]> 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, value, >value_timestamp) VALUES (?, ?, ?)"; > SQLiteParameter param; > param = new SQLiteParameter(); > param.Value = 2; > command.Parameters.Add(param); > param = new SQLiteParameter(); > param.Value = 234.56; > command.Parameters.Add(param); > param = new SQLiteParameter(); > param.Value = DateTime.Now; > command.Parameters.Add(param); > rowsAffected = command.ExecuteNonQuery(); > } > >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 >([email protected]) >Subject: [sqlite] How to use parameterized queries in SQLite.Net > >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 required for named >parameters? Is that the correct leading character? Is it required to >include that leading character in the name given to the SQLiteParameter >object? > >I'm used to using the System.Data.ODBC classes, which do not support >named parameters, but they do support unnamed parameters, represented >by question marks. The order in which the parameters are attached to >the command object determines the association between the parameter >object and the query parameter. Unnamed parameters would be easier for >me to work with than named ones. Does SQlite.Net support unnamed >parameters? > >Thank you. > >RobR > > >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
In case it's useful, see here for all your options: <http://sqlite.org/lang_expr.html#varparam> -- J. King _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
