modify query run-time

rbuser

Hi NIck,
i woudl like to ask nif possible to change sql statemente at run-time
with rap funzionality before report execute query.

There is some example in wiki site ??

Best regards
Paolo Angeretti

nicocizik

Hi Paolo,

Yes, if you are using DADE, you can alter the query using the
TppSQLBuilder class. This class gives you a number of useful routines
to easily manipulate the SQL object. See the TppSQLBuilder topic in the
RBuilder help as well as the following articles.

http://www.digital-metaphors.com/RBWiki/DADE/SQLBuilder

If you are not using DADE, you will need to create a pass-thru function
to access your external datsets.