Re: Dynamic SQL - From clause

[Peter Burton <pburton@BRIO.COM>]

Paul,

That form is for a fully dynamic table reference.  That form forces SQR to
suspend validation of the BEGIN-SELECT until runtime and therefore cannot
use the database to provide the class of the select columns during the scan
phase.  Therefore, you need to specify the class (i.e. number, date) of
columns which are not defined as characters.

Peter

-----Original Message-----
From: Paul Hoyte [mailto:phoyte@SHARIDIONNE.COM]
Sent: Wednesday, October 02, 2002 10: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