Problem with report Paremeters and StoredProc

rbuser

Hellom i'm using interbase and RB 11.05. I have defined two parameters,
and when i edit the sql in text editor and i set

select *
from Z_INFORME( :FECHA_INICIO, :FECHA_FIN ) and try to save it i get
the error Dynamic SQL ERROR,
SQL Error Code = -104
Token unknown line 2 char 19
,

If i replace the query for

select *
from Z_INFORME( ?FECHA_INICIO, ?FECHA_FIN )
i can save the query, but i can't use parameters

Thanks

nicocizik

Hi Chus,

In my testing with stored procedures and parameters with Interbase,
everything seems to function as expected. You will want to continue to use
the ":Param" syntax. ReportBuilder parses the SQL code and simply replaces
any defined parameters with the value given.

A couple things to keep in mind are to be sure the parameter names are
correct and that the parameter types will work with the stored proc.

--
Regards,

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