Re: Database

[Ray Ontko <rayo@ONTKO.COM>]

Jimmy,

> Does anyone know whether if it is possible for the SQR program to be
> located in one
> database and yet retrieve data from another database within the same
> server?  If so,
> how can it be accomplished?

If you're using Sybase, use the USE command of SQR.

Or, prefix the tablename with "database.." as in

   begin-select
   ...
   from database..tablename
   ...
   end-select

Ray
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/