Transaction Error

upasanisandip

Hi everyone,
Does any know about this error.

You cannot make any changes in the database until a transaction has been started.

Thanks,
Sandip.

easabangan

Where does this error occur?

upasanisandip

i have written one function to insert record in one new table created by me in the following event

Form-onNextRecord()
InsertRecordIntoInvoiceSrno;


InsertRecordIntoInvoiceSrno()
InvoiceItemSrNo1.INIT;
InvoiceItemSrNo1."Vendor Code":="Buy-from Vendor No.";
InvoiceItemSrNo1."Item Code":="No.";
InvoiceItemSrNo1.INSERT;

upasanisandip

upasanisandip wrote:

i have written one function to insert record in one new table created by me in the following event

Form-onNextRecord()
InsertRecordIntoInvoiceSrno;


InsertRecordIntoInvoiceSrno()
InvoiceItemSrNo1.INIT;
InvoiceItemSrNo1."Vendor Code":="Buy-from Vendor No.";
InvoiceItemSrNo1."Item Code":="No.";
InvoiceItemSrNo1.INSERT;

In purchase line subform i am writing this function.

kine

You cannot modify DB in OnNextRecord. This trigger is just for reading the DB...

DenSter

It's not really a good idea to program any data manipulation in the form. If you have no choice but to have a form event modify data, you should program the thing as a function in the table and call the function from the form.

jelias56

Yes ... it cost me a day of development time. No one I know had heard of such an error. I called a code unit that manipulated data on the OnInitDataport trigger of a dataport. After a day of frustration, I moved the code to the OnPreDataport trigger and the problem disappeared.

petevans

The same applies to triggers in Forms. You will get this error if you put a "MODIFY" in trigger OnNewRecord on forms.

PS: There is an older thread discussing the same topic here:

http://www.mibuso.com/forum/viewtopic.php?t=9570&highlight=cannot+make+changes+database+transaction+started