RE: [sqr-users] Dynamic variable in select query.

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Hi Suresh,
you can use SQR dynamic SQL variables for this.
e.g.
if {Condition}
$Dynamic_var = ', Some Table name'
else
$Dynamic_var = ''


select
A
from
TableA1 [$Dynamic_var]

Steve.


-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Shailesh Sugandhi
Sent: Wednesday, 12 November 2003 1:27 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Dyanmic variable in select query.


Hi,

My requirement is, I have to add one dynamic variable to existing SQR select
clause. Depending on condition, its value needs to be populated. E.g My
exisitng query is :

select
A from TableA1.

if {Condition}
$Dynamic_var = 'Some Table name'
else
{Dynamic variable should be empty}

What i should write if i don't want to pass any table name in case if
condition is false. Can i safely write 'dual'?

For example,

if {condition is false}
select
A from TableA1, dual.


Thanks & Regards,
Shailesh Sugandhi

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users