component TEasyTable ([login to view URL]) uses a proprietary SQL subset.
We would like to be able to use the following SQL code:
select * from atable where adate='2011-9-29' /*1*/
(for both a TEasyTable and a TEasyQuery component).
The purpose is to be able to use the same SQL commands for both TEasyTable and TpFIBDataset components.
Currently SQL /*1*/ will raise an error when used for a TEasyTable component .
This code should be written as
select * from atable where adate=TODATE('2011-9-29','yyyy-mm-dd')
in order to work.
The coder will change the TEasyTable components source so that the parser will correctly understand and execute the sql code /*1*/