[sqlite] select * where abc like "xxx" works, ...where abc='xxx' fails

I am using Sqlite under QT 5.12.0. Why does the "=" query fail and the "like" query work? There are no wildcards involved. I create the table this way: QString sqlcreate = QLatin1String( "CREATE TABLE songfiletable (" "songfile_id INTEGER PRIMARY KEY," "dancename TEXT"

Re: [sqlite] select * where abc like "xxx" works, ...where abc='xxx' fails

On 4 Jun 2019, at 12:46am, Doug wrote: > Why does the "=" query fail and the "like" query work? To help us investigate ... Which version of SQLite is this ? You can use SELECT sqlite_version(); to find out. What do you mean by 'work' and 'fail' ? Are you referring to an error code ?

Re: [sqlite] select * where abc like "xxx" works, ...where abc='xxx' fails

t;From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Doug >Sent: Monday, 3 June, 2019 17:47 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] select * where abc like "xxx" works, ...where >abc='xxx' fails > >I