Re: System Variable $username Returns Database Name

["Eric A. Eastman" <erice@ontko.com>]

On Fri, 14 Feb 1997, Jim Wolfe wrote:

> Howdy All,
>
> I'm using SQR 3.0.7.1 and want to use the system variable $username
> to print the user's userid on the report.  However, it returns the
> database name instead!  Is this a bug in SQR or am I not holding my
> mouth right?
>
> Ideally, I'd like to have a "$database" system variable, too, to be
> able to print on the report which database the report reflects.
>
> Thanks.
>
> Jim Wolfe
>

Jim,

$username refers to the database user.

See the getenv function under the let command page 228 in the manual.
For looking at environment variables.
The example given is

let $myuser = getenv('USER')

Eric

------------------------------------------------------------------------
Eric Eastman    | Ray Ontko & Co. | Adverbs are endangered; act quickly.
erice@ontko.com | Richmond, IN    | http://www.ontko.com/, ftp.ontko.com