In QSqlTableModel using SQLITE 3.27.1, I set the filter to:
where dancegroupname and dancename are TEXT fields in songfiletable.
When I setFilter(...) and select(), I get no records. There are 2 records in the database table which meet the criteria; they are not returned. This is a bug.
More information: If I code the filter with "like" instead of "=" using exactly the same query values, 2 records are returned:
I coded a test query (in the same project) using the same database and table. When I execute the test query (logically equivalent), the 2 records are returned:
I opened a terminal window and ran sqlite3.exe with following query. It returned 2 records (as expected). I used "like" instead of "=" because the "=" query failed to return any records.