Problem with querys since update version 11

rbuser

Hello, we have update our app to rb11. We have one problem. We use
interbase and all the querys are inpu in the designer trough the text
sql option. Since th upgrade if one query has parameters like

select *
from any_table
where idtable = :id

when i save the sql i get an exception

Dynamic SQL error
SQL Error code -104
Unexpected end of command

This option is working rigth in version 10.x

rbuser

Chus GZarco wrote:


I missed tha after the exception and error is shown with the message

No Report Parameter for :id

nardmoseley

RB 11 has new Parameter and SQL features.

From the Design workspace you can define Report.Parameters that can
optionally have AutoSearch and Lookup behaviors.

From the Data workspace you can bind query's to Report.Parameters using
either the Query Designer or by manually editing the SQL and use the
:ParamName notation.

Prior versions of RB did not support :ParamName notation, not sure how you
were able to use that synatax. For your report, I recommend defining a
Report.Parameter called id


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com