GetTableTriggerMask(TableNumber : Integer) : Integer IF TableNumber = DATABASE::"Change Log Entry" THEN EXIT(0); IF COMPANYNAME = '' THEN EXIT(0); IF TableNumber IN [DATABASE::"Change Log Setup",DATABASE::"Change Log Setup (Table)", DATABASE::"Change Log Setup (Field)"] THEN EXIT(15); IF NOT ChangeLogSetupRead THEN BEGIN IF ChangeLogSetup.GET THEN; ChangeLogSetupRead := TRUE; END; IF NOT ChangeLogSetup."Change Log Activated" THEN EXIT(0); IF NOT TempChangeLogSetupTable.GET(TableNumber) THEN BEGIN IF NOT ChangeLogSetupTable.GET(TableNumber) THEN BEGIN TempChangeLogSetupTable.INIT; TempChangeLogSetupTable."Table No." := TableNumber; END ELSE TempChangeLogSetupTable := ChangeLogSetupTable; TempChangeLogSetupTable.INSERT; END; ResultMask := 0; WITH TempChangeLogSetupTable DO BEGIN IF "Log Insertion" <> "Log Insertion"::" " THEN ResultMask := 1; IF "Log Modification" <> "Log Modification"::" " THEN ResultMask := ResultMask + 2 + 8; // also rename IF "Log Deletion" <> "Log Deletion"::" " THEN ResultMask := ResultMask + 4; END; EXIT(ResultMask);
Comments
And (that's the point of error) you have at least one record in Change log table.
Delete records and it should work.
Go to tools>Security>Roles.
Just add the Table ID with the permissions you want in the concerned role.
Make a new role if you wish to.
Assign the role to the user ID from which you want to access.
Logoff and logon.
Deep
India
Change log table still have one empty record inside, after deletion problem solved.
Both fields in that table have "notBlank=No" attribute, which enables "invisible" empty record insertion.