Wacko requirement ;-)

rbuser

Nard (hopefully)

We are trialling RB 7.03 pro and we are using DADE and so far so good (
actually very good ). We would like to, from a CODE-BASED not a GUI
perspective, add SQL statements to the DADE portion of a report, so that a
user can visually see it in the data and they MAY alter it, but 90% of the
time they will not.

We found out how to hook up the session in the DataSettings, that was easy
:-

ppDesigner.DataSettings.SessionType := 'FIBSession';
ppDesigner.DataSettings.DatabaseName := 'pFIBDatabase';

But we would like to know how to add and alter via code the SQL statements
in the DADE ( not the pipeline !! ) on the fly ( in code ).

The reason for doing this is two-fold.

1. We have our own Report Designor application that allows us to generate a
report and in this application is a modified EMS Query Builder which will
allow us to use selectable-stored procedures on our firebird database. As we
have modified this to fit requirments I would like to keep using it.
2. We may have SQL in a statement, that depending on user settings ( on the
fly ) we may want to change grouping / ordering or summations without having
to need several reports.

Sorry that I never ask the easy questions ;-)

Thanks ( in anticipation )
Tony Danby, Point4, Developer

( Delphi 6, RB 7.03 pro and Firebird with FIBPlus and daFIBPlus )