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