Native and SQL locking

NaviDev
NaviDev Member Posts: 365
edited 2008-02-15 in NAV/Navision Classic Client
It states in the documents that native is capable of table locking, and using the SQL option has up to the row level locking (record level locking). Does native navision and sql option navision have differences in terms of coding the two? I tried to compare CU 12 of native and SQL but seem's no difference at all.
Navision noob....

Comments

  • kine
    kine Member Posts: 12,562
    Native and SQL is using same objects, it means no changes in code. The change is on the backend - on the server itself. It means that same code will do something else on the Native DB and on MS SQL DB.

    If you use LOCKTABLE on Native, it will lock the whole table. If you use it on MS SQL, it will lock the records (or pages etc.) which you will read.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    The beauty of NAV is that there is just one code base, you don't have to learn two languages to be able to develop for either database server, although you should know what the differences are so you can write SQL Server friendly code. It is also a pain in the neck, because we can't take advantage of many SQL Server capabilities.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories