How I use second time a parameter

[vovidiu]

Hello,

How I can use a parameter for the second time.

For example:
select d.name, e.name, e.sal
from dept d, emp e
where d.deptid = e.deptid
and e.sal between &
and ??Sal_Min?? + 1000

Parameter Sal_Min must be used second time.

Thanks,
Ovidiu

 

[Marco Kalter]

The current Query Reporter version has a bug that requires that you specify the type of the secondary usage of the substitution variable. For example

select d.name, e.name, e.sal
from dept d, emp e
where d.deptid = e.deptid
and e.sal between &<name="Sal_Min" type="integer">
and &<name="Sal_Min" type="integer"> + 1000

When the next patch release is available, you can simply specify:

select d.name, e.name, e.sal
from dept d, emp e
where d.deptid = e.deptid
and e.sal between &<name="Sal_Min" type="integer"> and &Sal_Min + 1000

------------------
Marco Kalter
Allround Automations

 

[vovidiu]

Thank you,

I waiting next patch.

Ovidiu