Subject Re: [ib-support] Re: Get the username or uid of the current session's user
Author Martijn Tonies
Hi Magnus,

It isn't a field - it's a function.

There are more:


But to simply get these values, you need the SQL construct:
select ... from ...

And RDB$DATABASE is a single row column and therefor returns
the value of the function only once.

You can also write statements as:
insert into mytable (datecolumn) values (current_date)

-- see, it's a function :)

Hope this helps,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."

> > select USER from rdb$database
> Thanks!
> Why is USER not shown when I do a "show table rdb$database;"?
> Are there other "hidden" fields in there?