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

["Harry R Harris" <HHARRIS@alegent.org>]

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