sqliteCmd.CommandText = SELECT fstPriority, fstInfo, fstDateCreated,
fstDateModified, fiKeyID FROM MemoPadTable WHERE fstInfo LIKE '%' ||
?1 || '%'"
liststLikeFieldValue[0] = "bruce"
On Fri, Jan 27, 2017 at 11:55 AM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
