problem with insert

Saro
Saro Member Posts: 58
hi all, happy new year
my first problem of the new year,
is it possible to tell navision to do an insert without locking a table from a form? i am looping through a process and inserting records into a table,
and another process is making updates, these two processes affect mutually exclusive recordsets so i need to prevent the system from locking the table when process one wants to insert records so that process two can update the records

may it be a better and more prosperous year to all
s.
Saro

Comments

  • lubost
    lubost Member Posts: 633
    The only way you have is only committing transaction after each modify.
  • kine
    kine Member Posts: 12,562
    Yes, there is no way for that. But the behaviour is different for MS SQL and Native DB. Which one you are using?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.