Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

[R Smith]

On 2017/01/26 5:04 PM, Clyde Eisenbeis wrote:
I've also tried:

   string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName
+ " WHERE " + stLikeFieldName + " LIKE ('%' || " +
liststLikeFieldValue[0] + " || '%')";

which does not work.

Could you kindly simply output the resulting string to the console or 
whatever output you use so we can see the final query string that gets 
passed to SQLite.

There's a whole list of things that could go wrong. Guessing will get us 
nowhere.




_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users