Empty Selection returns an error

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Kirchi
Posts: 5
Joined: Tue 21 Aug 2012 15:16

Empty Selection returns an error

Post by Kirchi » 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?

Post Reply