Error during inserting a record in table

Sup

Hi,
I have created two tables. And created a codeunit in which I try to insert values into these tables.
I get the following error:
You cannot make any changes to the database until a transaction has been started.

Any idea why I am getting this error? Do I need to set some properties on the table or CodeUnit?

Thanks & Regards,
Sup

Sup

Now it works when I run it independently but when I try to call this CodeUnit from form 10038 - Sales Order Stats then it gives me that error.
You cannot make any changes to the database until a transaction has been started.

Thanks & Regards,
Sup

kriki

#-o That is a new one! Is this word-by-word and character-by-character the error Navision shows?

jelias56

YES..
I know this is an old posting but I got the samw error. I consulted with two other developers who had never heard of it. The solution was to move my code away from the OnInitDataport trigger to the OnPreDataport trigger.

thaug

I've seen that error before, and what you did to solve it is what I did to solve it. It was a stupid coding mistake on my part.

Miklos_Hollender

Thaug and Jelias56,

can you please describe the error and the solution so that others can avoid this problem? And then maybe put [SOLVED] in the topic?

Rule

I think he had put the code in a wrong trigger.
It think it is not possible to write data in a table on the onInit trigger.

Correct me if i'm wrong