Nico,

try to assign American date style instead, I would bet this is a date type
problem.

tmpDate:='01/01/2001';

SQLWhereItems.Add ('DATE_TRANSACTION = ' + #39 + tmpDate +#39);



Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com