Re: Dynamic SQL - From clause

["Knapp, Richard" <KnappR@UMSYSTEM.EDU>]

Hi Paul,

Is the reference you mention an example for the preceding description of 
begin-select?  If so, we are on the same page (as they say) and I don't see the 
construct.  Could be blinder that usual.

Richard

-----Original Message-----
From: Paul Hoyte [mailto:phoyte@SHARIDIONNE.COM]
Sent: Wednesday, October 02, 2002 9:29 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Richard:

Look at page 49 in the reference manual for version 4.3.......bottom
half of the page....

Paul Hoyte
Sharidionne Inc.
(248) 559-6868
Email: phoyte@sharidionne.com



-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net] On Behalf Of Knapp, Richard
Sent: Wednesday, October 02, 2002 10:06 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Hmmmm.  My documentation is for 4.3 and I can't find mention of this
feature. I'm assuming that it would be discussed either in the
begin-select, begin-sql or dynamic SQL sections.  I'm looking in both
the 'Language Reference' and 'User Guide'.

I hate to trouble you, but could you say, rather than the page number,
what section of what manual the discussion occurs in?

Many Thanks.

Richard

-----Original Message-----
From: Peter Burton [mailto:pburton@BRIO.COM]
Sent: Wednesday, October 02, 2002 8:49 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Richard,

I would guess since version 2.x (~1989).

The earliest book I have is from SQR 3 and this feature is discussed on
Page 51.

Page

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@UMSYSTEM.EDU]
Sent: Wednesday, October 02, 2002 9:34 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Peter,

What version of SQR does this feature appear in?

Thanks,

Richard Knapp
Database Programmer/Analyst
Administrative Systems Project
University of Missouri System
573-884-3157
knappr@umsystem.edu


-----Original Message-----
From: Pamela Lantzy [mailto:PLantzy@UAMAIL.ALBANY.EDU]
Sent: Wednesday, October 02, 2002 7:26 AM
To: SQR-USERS@list.iex.net
Subject: Re: Dynamic SQL - From clause


Thanks for the explaination

-----Original Message-----
From: Peter Burton [mailto:pburton@BRIO.COM]
Sent: Tuesday, October 01, 2002 6:58 AM
To: SQR-USERS@LIST.IEX.NET
Subject: Re: Dynamic SQL - From clause


Pamela,

The [{table_name}:$Table_name] construct directs SQR to use {table_name}
at compile time to validate the BEGIN-SELECT paragraph and uses the
contents of $Table_name at runtime.

Peter

-----Original Message-----
From: Pamela Lantzy [mailto:PLantzy@UAMAIL.ALBANY.EDU]
Sent: Tuesday, October 01, 2002 6:23 AM
To: SQR-USERS@list.iex.net
Subject: Dynamic SQL - From clause


I have seen this in a couple SQRs, but I am not sure what this does.


FROM [PS_COMMUNICATION:$table] V

$table gets populated with a different table name.  There isnt a comma
to separate the 2 tables.  In the where clause there is nothing that
joins these 2 tables together.

Is if $table is not assigned a table name then it will use
PS_COMMUNICATION as an alternative, but if $table is assigned, it will
use that and ignore PS_COMMUNICATION?


I couldnt find any explainations of using : in the from.

Thanks.
Pam