How can i save login data (user id or user name) into SQL table of NAV.

flesenne
flesenne Member Posts: 7
in NAV/Navision Classic Client
Hello,
Which data are used to store login data. I want to use these data to save login information into article ledger.
As my customer used SQL server and Nav5.0, is it a good idea to write trigger and stored procedure ?
Thanks for your help

Answers

  • 4388331
    4388331 Member Posts: 2
    Hi,
    Actually, user logins are stores in following tables:

    Database logins in the table 2000000002 "User".
    Windows logins in the table 2000000054 "Windows Login".

    But I don't understood, in what "article ledger" you want to save them?
  • JohnHunter
    JohnHunter Member Posts: 45
    Take a look: Codeunit 1 ApplicationManagement, procedure LogInEnd
    UserTimeRegister."User ID" := USERID;
  • flesenne
    flesenne Member Posts: 7
    Thanks for your reponses.
    I give you more informations about my need because i would like only modify table (no codeunit modif. as you suggest).
    I want to add User ID in the Capacity Ledger Entry table. To do that i try to get User ID from Item Register table where Capacity Ledger Entry.Entry No >= Item Register.From Capacity Entry No. and Capacity Ledger Entry.Entry No <= Item Register.To Capacity Entry No.

    To do that i added User ID into Capacity Ledger Entry table with Data type = Code and Calc formula using lookup but the following formula is not working.

    lookup("Item Register"."User ID" WHERE (From Capacity Entry No.<=FIELD(Entry No) AND (To Capacity Entry No.>=FIELD(Entry No))

    Could you give me some informations to help me ?

    Thanks

Categories