Thanks. Was able to open the .chm file.
I tried this:
-----------------------------
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"
On Fri, Jan 27, 2017 at 1:10 AM, GB <gbi...@web.de> wrote:
> Clyde Eisenbeis schrieb am 26.01.2017 um 18:45:
>>
>> It appears that sqlite3 is not part of System.Data.SQLite.
>>
> Aaah! Now we get somewhere! You should have told us from the beginning that
> you are using SQLite through the .NET/MONO Wrapper. All the mentioning of
> sqlite3_bind_* and the like refer to the native interface of SQLite.
>
> Set up your command string with placeholders like others already stated:
>
> " AND fstInfo LIKE ('%' || ?1 || '%') AND fstInfo
> LIKE ('%' || ?2 || '%')"
>
> Now add your values to the Parameters-Collection of your Command-Object:
>
> myCmd.Parameters.Add(new SQLiteParameter(...));
>
> Also seedocumentation to System.Data.Common
> <https://msdn.microsoft.com/en-us/library/system.data.common%28v=vs.110%29.aspx>
> (especially DbCommand and DbParameter) which System.Data.SQLite is derived
> from.
>
> If you are working with VS on windows, download the .chm-File from
> http://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimetype=application/x-chm
> Then right-click on the file and open its properties. In the lower part of
> that dialog you will find a security warning with an "Unblock"-button. Click
> it, and you should be able to open the file.
>
> If you don't have a .chm-reader, see
> https://support.microsoft.com/en-us/help/917607/error-opening-help-in-windows-based-programs-feature-not-included-or-help-not-supported
>
>
> _______________________________________________
> 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
