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
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 ?
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"
3 matches
Mail list logo