Error Message:You cannot make any changes to this database until the transaction has to be started.

Dynamics 365 Business Central/NAV Developers Forum
#1

Hi all

I have writern below code at OnActivateForm() of slaes order screen

IF SalesSetup.GET THEN
BEGIN
SalesSetup.“Sales List Filter”:=TRUE;
SalesSetup.MODIFY;
END;

While running the sales order form i’m getting an error message please see the attached picture.i have checked with partner source also.is there any way to resolve this.

6740.ErrorMSg.bmp (177 KB)

Thanks

Jerome Marshal.j

#2

What is the objective of this code. can u give details

#3

when the system gets the ‘salessetup’, and the value of “sales list filter” is already ‘TRUE’, it doesnt do anything. thus ‘modify’ command will result error.

#4

The problem is the trigger.There is some triggers will not insert record into table

for example

OnActivateForm()

OnDeactiVateForm()

if you use MODIFY or MODIFYALL at these type of triggers you will get the error which i mentioned.

Thanks

Jerome Marshal.J