How can i disable parameter check in RB 11

rbuser

Hello i'm using RB 11.08 and trying to assign to a pipeline an "execute
block " from firebird.

Inside execute block there is sentences like

select Field1,...,FieldN
from table
where FieldW1 = :FieldW1.

When i try to save the pipeline i get errors like No report paremeter
found for :FieldW1, but FieldW1 is not a report parameter, comes from
ther query.

Is there eny option to setup the report to not check parameters, or
change the caracter used to prefix the parameter. For example use '?'
instead of ':'

Regards, Jesus

nicocizik

Hi Jesus,

The Parameter syntax ":" is used by DADE to access the report parameter
information defined. If you would like to bypass, you will need to
manually create the SQL that is sent to the DB using the SQL tab in the
query designer.

rbuser

Hi Nico, i'm using that option, but an error raises.

Regards, Jesus

nicocizik

I apologize, I misspoke. We added a feature for RB 12 that checks to
see if the parameter is available and if it isn't, the SQL text is sent
as-is. Unfortunately it is not possible to turn this off in RB 11.

Please consider upgrading to the latest version of ReportBuilder. See
the following web page form some of the exciting new features available
since RB 11.

http://www.digital-metaphors.com/rbWiki/General/What's_New

rbuser

Nico Cizik (Digital Metaphors) wrote:



I have upgraded but have no time to upgrade RB in my product.

Thanks, Jesus