filter dates with two DateTimePicker

0

Hi, I'm trying to filter dates with two DateTimePicker by clicking on a button and the result appears in the grid using the MYDAC component and as a database MYSQL workbench This is my code:

query.clear;
query.SQL.ADD('select * from compañia1 where fechavencimiento1 between'
       + ':FECHA_INI and :FECHA_FIN order by fechavencimiento1');
query.parambyname('FECHA_INI').AsDate := DateTimePicker1.date; 
query.parambyname('FECHA_FIN').AsDate := DateTimePicker2.date;
query.open;

When I try to compile, I get this error:

  

"parametren 01-06-208 not found"

I hope you can help me thanks

    
asked by pablo 21.06.2018 в 04:57
source

0 answers