NAV 2013 | Keys in Symbol Menu

One of the things that I noticed while doing some development in NAV2013 is that keys are now part of the Symbol Menu (F5) in the C/AL editor! This allows you to select all active keys for example when using SETCURRENTKEY. Very handy, since most of the time you had to go to for example the design of the table to look for keys, copy and paste, and then implement the quotes. How cool is this! NAV2013 rocks!

Bron : Mark Brummel
Lees meer…

Keys, Queries, and Performance

When you write a query that searches through a subset of the records in a table, you need to be careful when you define the keys both in the table and in the query so that Microsoft Dynamics NAV can quickly identify this subset. For example, the entries for a specific customer will usually be a small subset of a table containing entries for all the customers.

Bron : MSDN
Lees meer…