Hi

I am about to write a report module for a customer in delphi5 using an TIB_Query and FastReport

The generic SQL will be as below , with the search date criteria set by the user.

select id from pins
where Cast(status_changed as Date) >= Cast('5-Nov-2003' as Date) and Cast(status_changed as Date) <= Cast('15-Nov-2003' as Date)


Obviously I can build this SQL statement up in my program and set the SQL property without any problems.

I don't think however this is the best way to do it in Ibobjects.

Can anyone recommend a better way ?

Rgds

Peter
Cyionics Ltd

[Non-text portions of this message have been removed]