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

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Good point.  It also helps to give the SQR compiler a hint of what the table
might be so it can validate the column names.  I think the syntax would be:

from [$tablename : PS_PERSONAL_DATA PD]


-----Original Message-----
From: Harry R Harris [mailto:HHARRIS@alegent.org]
Sent: Thursday, February 19, 2004 10:30 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Dynamic FROM clause with DYNAMIC WHERE clause


If PeopleSoft try PS_

>>> pmezzull@esboces.org 02/19/04 12:26PM >>>
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

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

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