Native and SQL locking

NaviDev

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.

kine

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.

DenSter

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.