Manual SQL statement & selection criteria

rbuser

Hi,

Was just wondering what ideas people have in the situation where you need to
create an SQL statement manually due to its complication within the data
definition. In this case you lose the ability for users to enter their own
filtering. Any way to encompass both? V6.03

Thanks

Alex

nardmoseley

Update to RB 9...

1. Use the new Report.OnInitializeParameters event to programmatically
create AutoSearchFields.
2. Use the new Report.BeforeOpenDataPipeline or the
Report.OnGetAutoSearchFieldValue event to apply the values entered by the
user to the SQL.
3. Use the new TdaSQLBuilder class to modify the SQL associated with the
datapipeline.

All of the above can be accomplished using RAP code or Delphi code.

rbuser

RB 9 does not work with Delphi 5 right?

Thanks

Alex

nardmoseley

Correct.

rbuser

I wont be able to upgrade to RB 9 in a hurry then, that will have to be a
longer term plan.

Cheers