Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics NAV Development Quick Start Guide

You're reading from   Microsoft Dynamics NAV Development Quick Start Guide Get up and running with Microsoft Dynamics NAV

Arrow left icon
Product type Paperback
Published in Dec 2018
Publisher Packt
ISBN-13 9781789612769
Length 210 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Alexander Drogin Alexander Drogin
Author Profile Icon Alexander Drogin
Alexander Drogin
Arrow right icon
View More author details
Toc

Table of Contents (10) Chapters Close

Preface 1. Getting Started with the NAV Development Environment FREE CHAPTER 2. Codeunits - Structuring C/AL Code 3. Tables - Creating Data Structure 4. Designing User Interface 5. Exchanging Data with XML Ports 6. NAV Event Model 7. Presenting Data in Reports 8. Debugging Your Code 9. Other Books You May Enjoy

Record variables

Record is one of the most important and widely used data types in C/AL code. A Record variable refers to a database table, and allows us to retrieve and manipulate table data. A code example in this section will demonstrate how to search data with a Record variable and update found records. This is a more business-related scenario than those we coded in previous sections. As an example, we will update sales prices for an item based on certain criteria calculated from other database tables.

Iterating over a recordset

To declare a Record variable, you must enter its name, select the Record data type in the DataType field, and choose one of the database tables as the variable's Subtype. In the next code...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image