Re: Dynamic SQL - From clause

[Pamela Lantzy <PLantzy@UAMAIL.ALBANY.EDU>]

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