Eclipse Community Forums: BIRT » naming parameters in queries

Help

Home

Home » Archived » BIRT » naming parameters in queries

Show: Today's Messages :: Show Polls :: Message Navigator

naming parameters in queries [message #729930]

Tue, 27 September 2011 09:49

Christian

Messages: 72
Registered: July 2009

Member

Hello!

Is there a way to name the parameters in a query? If you write a complex
query with a lot of parameters it is difficult to read with many "?" in
the query, especially if you need the same parameter multiple times in
the query.

What I have in mind is instead of:

select * from mytable where field = ?

to write some sort of this:

select * from mytable where field = :MY_PARAMETER

Is something like this supported by BIRT?

Thanks,
Christian

Report message to a moderator

Re: naming parameters in queries [message #729945 is a reply to message #729930]

Tue, 27 September 2011 10:36

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

It's not really a BIRT issue. It's how the JDBC standard passes parameters.

Richard

Report message to a moderator

Re: naming parameters in queries [message #731215 is a reply to message #729945]

Fri, 30 September 2011 09:36

Christian

Messages: 72
Registered: July 2009

Member

Am 27.09.2011 12:36, schrieb Richard A. Polunsky:
> It's not really a BIRT issue. It's how the JDBC standard passes parameters.

Thanks for that input.

I now tried the "Query Builder" and it seems to support named
parameters. I will see if that is the right path for me :)

Christian

Report message to a moderator

Previous Topic:	Null serializer factory specified.
Next Topic:	Different series label

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 13:08:39 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter