Re: Dynamic SQL - From clause

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

Peter,

No need. Thanks.  I feared I might be losing my mind (again) when I couldn't 
find mention of it.

Richard

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


Richard,

You love to rouble me ...

It appears twix Version 3 manuals and Version 4 (and beyond) the explanation
of the construct

        FROM [{table_name} : $table_name]

was lost.

As I said it was on page 51 located in Chapter 2 "Working with SQR" in the
"SQR3 Workbench, SQR User's Guide, Version 3.0" book.

I can fax you a copy of the page if you like.

Peter

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@UMSYSTEM.EDU]
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