Empty Selection returns an error
Posted: Thu 10 Nov 2016 06:49
Hello,
I have a selection on an sqlite Database which returns an error
ESQLiteError 'near "=": syntax error'
when selection returns no records.
The Selection looks like this:
Select * From myTable where date<:myDate
when the table has record with a date which is smaller that the defined parameter then it works.
What ma I doing wrong?
I have a selection on an sqlite Database which returns an error
ESQLiteError 'near "=": syntax error'
when selection returns no records.
The Selection looks like this:
Select * From myTable where date<:myDate
when the table has record with a date which is smaller that the defined parameter then it works.
What ma I doing wrong?