On 27 Jan 2017, at 5:51pm, Clyde Eisenbeis <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
