Jason,


It seems that when you use the OnPrepareSQL event of a TIBOQuery, that the
'Sender' parameter is not the IBOQuery itself, but an internal query.

This means you cannot do stuff like this:

procedure TRejectionOverviewReportDataModule.MyIBOQueryPrepareSQL(
Sender: TObject);
begin
FixWhereClause(Sender as TIBOQuery);
end;

But you have to revert to referencing explicit objects like this:

procedure TRejectionOverviewReportDataModule.MyIBOQueryPrepareSQL(
Sender: TObject);
begin
FixWhereClause(MyIBOQuery);
end;


Jeroen W. Pluimers
Consultant at All I'M
http://www.all-im.com