This is your resource to discuss support topics with your peers, and learn from each other.
I have a DataSource like that: "song.db"
But when I set a query have slash (/) character like
SELECT * FROM song_table WHERE album = "abc/xyz"
. The DataSource cannot be load. Any one give me a solution? thanks so much
Maybe you need to "escape " the char, so
SELECT * FROM song_table WHERE album = "abc
thankyou for reply but it does't work. And in general language we don't need to escape the slash only backslash must be escape :-ss
I use the query in a sqlite cliente (sqliteman) and works fine so the problem could be with qml...
Try changing the "/" to %2F so try with
SELECT * FROM song_table WHERE album = "abc%2Fxyz"
still doesn't work . I think it's a bug of DataSource.