Re: SQR Question: Getting Values of Dynamic Columns in select

["Schelske, Steve K." <SKSchelske@AAAMICHIGAN.COM>]

When you're selecting dynamic columns, you have to explicitly state the type
of data that is going to be returned in that column

Try

begin-select

[$C1] &xxxx=CHAR

     do Write-Data
from [$table_name]
where AUDIT_STAMP < SYSDATE - 1300
end-select

and use &xxxx in your Write-Data (or move it to a $string variable first).

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Ashish Bhatt
Sent: Saturday, October 20, 2001 10:35 AM
To: SQR-USERS@list.iex.net
Subject: SQR Question: Getting Values of Dynamic Columns in select


Hi Peoplesoft and SQR Gurus,

I hope you are doing fine today.

I am facing tough time in getting the values of
Dynamic Columns in the select.

I am having below SQR code:

begin-select
$c1
     do Write-Data
from [$table_name]
where AUDIT_STAMP < SYSDATE - 1300
end-select


In the above $c1 is all the column names of the table.

I want the values returned by above select.

Can you please give me some idea how this can be done
?

Thanks in advance.

Have a nice day and great weekend.

Regards.

Ashish Bhatt.