Modify sql in DADE

rbuser

Whilst i've been a happy developer using report builder for a few years,
i've never really looked into DADE and the data tab a great deal. After
creating a new query using teh Query wizard, is it possible to edit the
report SQL directly and still have the autosearch dialogs appear? Sometimes
it is useful to credit parts of the sql directly yet still want the report
builder search criteria to work.

Thanks for any help

James

nicocizik

Hi James,

Once you edit the SQL manually in DADE, you loose all of the Query Designer
options and dataset linking capability. If you would still like to add
autosearch to the edited query, you will need to do so manually using the
TdaSQLBuilder class. This class was created to easily access and manipulate
the SQL object in DADE. See the TdaSQLBuilder topic in the RBuilder help
for more information and example code.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com