Re: Database Name

[Jim Kimmell X2550 <jkimmell@BENTLEY.EDU>]

"Fernando Villaamil wrote:
>
> Does anyone know how to print the name of the database referenced in the USE
> statement on a report?  I don't see a predefined variable for SQR that has
> this information.  SInce we have both a Test and a Production Database
> defined to the system I would like to denote the database that was used in
> the reports to ensure there is no confusion when a printout is referenced by
> a user.
>
> Fernando A. Villaamil
> Miami Herald Publishing Company
> fvillaamil@aol.com

A easy way to handle the situation is to set-up a table that holds
header information.  You then select the header information for every
report run.  For the test database you would have a header like "Miami
Herald Publishing Company - Test".  Hope this helps.

James R. Kimmell
Bentley College
jkimmell@bentley.edu