[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Dynamic Query Variables



>Begin-Procedure main
>let $from_table='company'
>begin-select
>co_nbr
>from [$from_table]

 from [existing_table:$from_table]

>end-select
>End-Procedure main

This works on Oracle, I'm not sure about sybase.  Insert any existing table
name where I put "existing_table".

************************************
*  Sean M. Shaw                    *
*  Oracle Data Automation Manager  *
*  The University of New Mexico    *
*  Health Sciences Center Library  *
*  Albuquerque, NM 87131-5686      *
*  Work:  505.277.6109             *
*  Fax:   505.277.5350             *
*  EMail: sshaw@biblio.unm.edu     *
************************************