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

[Ashish Bhatt <ashish_bhatt@HOTMAIL.COM>]

I did this yesterday. But how to get the values.

----- Original Message -----
From: "Holger Noreke" <holger@NOREKE.COM>
To: <SQR-USERS@list.iex.net>
Sent: Saturday, October 20, 2001 11:05 AM
Subject: Re: SQR Question: Getting Values of Dynamic Columns in select


> Ashish,
>
> Try [$C1] instead of $C1
>
> -Holger Noreke
> Noretec Consulting Group, Inc.
> hnoreke@noretec.com
>
>  -----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 7: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.
>