Hi. I have a very simple Sql query
query.prepare("select FIO from inspectors where FIO=:FIO");
When it is executed I get this error:
When I change my Sql statement to
@"select id from inspectors where FIO=:FIO"@
the error is gone.
So, what is the problem?Thanx a lot!
and which assert is hit? What's it's condition?
Also IMO your first query doesn't make much sense :)
I just check if I already have a record with this FIO. At the beginnig my query was
@select *from inspectors where FIO=:FIO@
But i still had this mistake.And only when I change it to
@select id from inspectors where FIO=:FIO@
it works fine
select from inspectors where FIO=:FIO
You are missing a space after the ""
I'm very sorry. I wrote it wrong only here. In my programm the query is correct=)
may it be possible that text.trimmed() results in an empty string in your application?
No, it is impossible....May it be connected somehow with the fact that one of the fields in my db has got type TEXT?