On 27 Jan 2017, at 5:51pm, Clyde Eisenbeis <cte...@gmail.com> wrote:
> System.Data.SQLite.SQLiteCommand sqliteCmd = > sqliteConnection.CreateCommand()); > > sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + > stTableName + " WHERE " + stLikeFieldName + " LIKE '%' || ?1 || '%'"; > > sqliteCmd.Parameters.Add(new SQLiteParameter("string", > liststLikeFieldValue[0])); > > SQLiteDataReader sqlReader = sqliteCmd.ExecuteReader(); > ----------------------------- > > Error msg: "unknown error ... Insufficient parameters supplied to the command" Please tell us what string is in your variable sqliteCmd.CommandText when you execute the sqliteCmd.ExecuteReader method. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users