RE: [sqr-users] Dynamic FROM clause with DYNAMIC WHERE clause

["Bambach, Tom" <TBambach@genchemcorp.com>]

Paul,

If PeopleSoft, put 'PS_' in front of 'PERSONAL_DATA' like
someone else suggested.  I would also remove ' PD' from
the variable and put it in the FROM...

let $table_name = 'PS_PERSONAL_DATA'



begin-SELECT
pd.emplid
....
...
...

FROM [$table_Name] PD
[$where]

end-SELECT

Tom

> -----Original Message-----
> From: Mezzullo, Paul [SMTP:pmezzull@esboces.org]
> Sent: Thursday, February 19, 2004 1:27 PM
> To:   SQR RUG (sqr-users@sqrug.org)
> Subject:      [sqr-users] Dynamic FROM clause with DYNAMIC WHERE clause
> 
> Greetings,
> 
> I'm getting an error when I add the table name dynamically to the Select
> statement below.
> The statement with the dynamic where clause was working perfectly until I
> introduced the dynamic "FROM [$table_Name]". 
> The variable "$table_name" is being correctly initialized in the program
> but
> I'm still getting an error. I'm using Oracle ...
> 
> If anyone has an idea on how to correct this it would be greatly
> appreciated.
> 
> Thank You
> - Paul
> 
> 
> --------------------------------------------------------------------------
> --
> ------
> 
> let $table_name = 'PERSONAL_DATA PD'
> 
> 
> 
> begin-SELECT
> pd.emplid
> ....
> ...
> ...
> 
> FROM [$table_Name]
> [$where]
> 
> end-SELECT
> 
> 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users