Changing transaction type from UpdateNoLocks to Update

Cindy_Pret
Cindy_Pret Member Posts: 8
edited 2010-01-11 in NAV/Navision Classic Client
Microsoft Dynamics NAV Classic
You cannot change the transaction type after you start the transaction.

A transaction starts when the program executes the first database operation, such as FIND, NEXT, INSERT, DELETE, MODIFY, SUM, and COUNT.

The error occurred because you were trying to change the transaction type from UpdateNoLocks to Update.
OK

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

    I suppose your question is: What causes this error?

    It means you are in a transaction with a certain transaction type. And you want to change the transaction type.

    Probably in your code is some "CURRENTTRANSACTIONTYPE"-command to change it.
    Or maybe you are in a transaction and run a report that has property "TransactionType" set to a different value.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Cindy_Pret
    Cindy_Pret Member Posts: 8
    Thank you for your reply

    I got the error on a report that is utilized for processing. The transaction type of the report was set to update. I then changed the transaction type to UpdateNoLocks, and the issue were resolved.

    Thank you once again.

Categories