[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: Dynamic Query Variables
- Subject: Re: Dynamic Query Variables
- From: "Sean M. Shaw" <sshaw@BIBLIO.UNM.EDU>
- Date: Thu, 29 Feb 1996 08:57:45 -0700
>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 *
************************************