Using variables on IRD Database Wizard Query

[cavagnaro]

Hi guys,
I never used this option too much but now as customer can't do WS I must...
I'm trying to do a simple query with the ANI as the data being queried against a customer table. I tried:

[code]
select clientedata from dual where ani = vANI
[/code]

But it doesn't understand that vANI is a variable...how to tell IRD it is?

Thanks!

[catanirex]

create a stored procedure with the simple question. Then it is easy to pass the variable.
Thats how we do it

[terry]

Basically I tried just th same sql statement and IRD detected variable correctly.
What is IRD version that you use?

[Timur Karimov]

Hi there.
You try to did it in query mode? Why? If you need a simple select  - just do it with standard select wizard.
WBR Tim

[cavagnaro]

Hi guys,
Thanks a lot for the answers.

catarinex, yeah, I asked that too, but on customer it is like asking to develop a whole system...and need to go over N hands and approvals...sucks. Until that I need this working

terry, can you please share screenshots of what you did exactly? My IRD version is 8.1.300.22

Timur, yes, on query mode. Because it looks simpler, no the select wizard I need to create the table access, format and all that. As there are going to be like 20 of these I see it as a unnecessary task load and maintenance...

[Timur Karimov]

Well, i don't think what is supported by URS but try such syntax:
select clientedata from dual where ani = {vANI}
HIH
WBR Tim

[cavagnaro]

Yeah, tried that already the same day and DBServer saw it as it, no translation to a variable...

[terry]

I put some screenshots below.
http://www.4shared.com/zip/c81kTY6Eba/DB_online.html

But basically what I did is quite straightforward- create query as mentionesd, assign vANI value like 11111 and make request.
Up to my knowledge IRD supposed to check every name FOLLOWING operation like =, >, < etc for is it variable or not.

If there is no any misprinting (in name of vartiable, etc) and it is still not working then probably there is some hidden defect in IRD and Genesys Tech Support need to be contacted.

Also may be one thing to try - assign entire query as is to some variable (say MyQuery) and as query in DB Wizard use query in form @sql=MyQuery
 

[cavagnaro]

Thanks a lot terry! Will open a ticket with Genesys. Mine is like that.