Get the active user

akman

Hi
Is there anyway to get the user that is active?
I need this because I want to put the user id in every record of a new table. For example user A creates a new record in table 50000, I want in the field "User" of this record to have the value "A".
Thanks!

Saalek

Hi

Use USERID function

field:=USERID;

This function gives you current user

Bye

rsfairbanks

USERID (Database)
Use this function to have the system return the ID of the current user.

ID := USERID
ID

Data type: text constant or code

This string contains the ID of the current user.

Comments
Unless set up otherwise, the system prompts you for a user ID and password when you start the application. This function returns the user ID entered there.

Example
This example shows how to use the USERID function.

User := USERID;
MESSAGE(Text000, User);

Create the following text constant in the C/AL Globals window:

Text Constant
ENU Value

Text000
'The system was started by %1'


A typical result:

The system was started by: JOE

DenSter

Make sure it has the same data type, Code, with a length of 20. You can even link the field to the User table if you want.

kine

DenSter wrote:

Make sure it has the same data type, Code, with a length of 20. You can even link the field to the User table if you want.

Do not do it. If you use Windows Authentication, you will have just problems... :-)