Search icon Close icon
Search icon
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Programming Microsoft Dynamics 365 Business Central - Sixth Edition

You're reading from  Programming Microsoft Dynamics 365 Business Central - Sixth Edition

Product type Book
Published in Apr 2019
Publisher Packt
ISBN-13 9781789137798
Pages 536 pages
Edition 6th Edition
Languages
Concepts
Authors (3):
Marije Brummel Marije Brummel
Profile icon Marije Brummel
LinkedIn
Author, programmer, consultant, project manager, presenter, evangelist, sales person, and a trainer. It's next to impossible to find someone as experienced as Marije Brummel in the Business Central community. Marije received the Microsoft MVP and the NAVUG All-Star awards among several others. She has chaired the Dynamics Credentialing committee and has authored official Microsoft Exam materials. She's the go-to girl for performance troubleshooting and upgrade challenges. One of her biggest achievements was introducing Design Patterns into the Business Central community. Her books, blog articles, and YouTube videos have influenced almost everyone involved with Business Central. She enjoys the outdoors with her dog and loves spending time with her family.
See other products by Marije Brummel
David Studebaker David Studebaker
Profile icon David Studebaker
LinkedIn
David Studebaker has been designing and developing software since 1962 as a developer, consultant, manager, and business owner. In 1967, David coauthored the first general-purpose SPOOL system, an AT&T / IBM joint project. He has been a founding partner in several firms, most recently Studebaker Technology and Liberty Grove Software. David's publications include a decade of technical reviews for ACM Computing Reviews and a number of articles on shop floor data collection. David originated the Packt series of books on programming Dynamics Business Central (aka Dynamics NAV). He has a BS in mechanical engineering from Purdue University and an MBA from the University of Chicago. He is a life member of the Association for Computing Machinery.
See other products by David Studebaker
Christopher D. Studebaker Christopher D. Studebaker
Profile icon Christopher D. Studebaker
LinkedIn
Chris Studebaker was a certified environmental consultant working with manufacturing facilities to meet national and state regulations before he started working with Navision in 1999. After working on regulatory reporting, data analysis, project management, and subcontractor oversight, Chris has used those skills to sell, develop, and implement NAV for the past 20 years. He has specialized in retail, manufacturing, job shop, and distribution implementations, mostly in high-user-count, high-data-volume applications. Chris acts in a consulting and training role for customers and for peer NAV professionals. He has a Bachelor of Science degree from Northern Illinois University and has done graduate work at Denmark Technical University.
See other products by Christopher D. Studebaker
View More author details

Table of Contents (12) Chapters

Preface Introduction to Business Central Tables Data Types and Fields Pages - The Interactive Interface Queries and Reports Introduction to AL Intermediate AL Advanced AL Development Tools Successful Conclusions Assessments Other Books You May Enjoy

The SETCURRENTKEY procedure

The syntax for SETCURRENTKEY is as follows:

[BooleanValue :=] Record.SETCURRENTKEY(FieldName1,[FieldName2], ... )

Because Business Central is based on the SQL Server database, SETCURRENTKEY simply determines the order in which the data will be presented for processing. The actual choice of the index to be used for the query is made by the SQL Server Query Analyzer. For this reason, it is very important that the data and resources available to the SQL Server Query Analyzer are well maintained. This includes maintaining the statistics that are used by the Query Analyzer, as well as making sure that efficient index options have been defined. Even though SQL Server picks the actual index, the developer's choice of the appropriate SETCURRENTKEY parameter can have a major affect on performance.

The fields that are used in the SETCURRENTKEY command do not have to match a key in the table definition. You can also use FlowFields as fields for...
lock icon The rest of the chapter is locked
arrow left Previous Chapter
Chapter 1 of 12
Next Chapter arrow right
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.
Sign up now
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
Start free trial
Renews at $15.99/month. Cancel anytime}

Authors (3)

Left arrow icon
Profile icon Marije Brummel
LinkedIn
Author, programmer, consultant, project manager, presenter, evangelist, sales person, and a trainer. It's next to impossible to find someone as experienced as Marije Brummel in the Business Central community. Marije received the Microsoft MVP and the NAVUG All-Star awards among several others. She has chaired the Dynamics Credentialing committee and has authored official Microsoft Exam materials. She's the go-to girl for performance troubleshooting and upgrade challenges. One of her biggest achievements was introducing Design Patterns into the Business Central community. Her books, blog articles, and YouTube videos have influenced almost everyone involved with Business Central. She enjoys the outdoors with her dog and loves spending time with her family.
Read more
See other products by Marije Brummel
Profile icon David Studebaker
LinkedIn
David Studebaker has been designing and developing software since 1962 as a developer, consultant, manager, and business owner. In 1967, David coauthored the first general-purpose SPOOL system, an AT&T / IBM joint project. He has been a founding partner in several firms, most recently Studebaker Technology and Liberty Grove Software. David's publications include a decade of technical reviews for ACM Computing Reviews and a number of articles on shop floor data collection. David originated the Packt series of books on programming Dynamics Business Central (aka Dynamics NAV). He has a BS in mechanical engineering from Purdue University and an MBA from the University of Chicago. He is a life member of the Association for Computing Machinery.
Read more
See other products by David Studebaker
Profile icon Christopher D. Studebaker
LinkedIn
Chris Studebaker was a certified environmental consultant working with manufacturing facilities to meet national and state regulations before he started working with Navision in 1999. After working on regulatory reporting, data analysis, project management, and subcontractor oversight, Chris has used those skills to sell, develop, and implement NAV for the past 20 years. He has specialized in retail, manufacturing, job shop, and distribution implementations, mostly in high-user-count, high-data-volume applications. Chris acts in a consulting and training role for customers and for peer NAV professionals. He has a Bachelor of Science degree from Northern Illinois University and has done graduate work at Denmark Technical University.
Read more
See other products by Christopher D. Studebaker
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
Microsoft Dynamics NAV Development Quick Start Guide
Microsoft Dynamics NAV Development Quick Start Guide
Microsoft Dynamics NAV is an enterprise resource planning (ERP) software suite for organizations. The system offers specialized functionality for manufacturing, distribution, government, retail, and other industries. This book gets you started with its integrated development environment for solving problems through customizing business processes.
Dec 2018 7 hours 0 minutes
Microsoft Dynamics 365 Business Central Cookbook
Microsoft Dynamics 365 Business Central Cookbook
With this comprehensive guide, you will become familiar with the latest Dynamics 365 Business Central which is a complete business application management application. It helps you streamline business processes in your company, connect the company across the individual departments, and enhance customer interactions.
Aug 2019 12 hours 40 minutes
Dynamics 365 Business Central Development Quick Start Guide
Dynamics 365 Business Central Development Quick Start Guide
Microsoft Dynamics 365 Business Central is the new SaaS ERP proposition by Microsoft. The latest version comes has many exciting features guaranteed to make your life easier. This book is an ideal guide to Dynamics 365 and will help you get started with implementing and designing solutions for real-world scenarios.
Aug 2018 7 hours 28 minutes
Microsoft Dynamics NAV 2016 Financial Management
Microsoft Dynamics NAV 2016 Financial Management
Discover how easy it is to manage finance by using Microsoft Dynamics NAV 2016. This book will help you get practical knowledge of cash flow management, currencies, intercompany postings, budgets, and accounting implications in areas such as jobs, services, warehousing, and manufacturing.
Jan 2017 7 hours 24 minutes
Implementing Microsoft Dynamics 365 Business Central On-Premise
Implementing Microsoft Dynamics 365 Business Central On-Premise
Microsoft Dynamics Business Central is a complete ERP software solution for all kinds of organizations. It is fast to implement and easy to configure and use. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book details new features and functionalities available in Dynamics Business Central and NAV.
Dec 2018 25 hours 28 minutes
Extending Microsoft Dynamics NAV 2016 Cookbook
Extending Microsoft Dynamics NAV 2016 Cookbook
Jan 2017 15 hours 16 minutes
Mastering Microsoft Dynamics 365 Business Central
Mastering Microsoft Dynamics 365 Business Central
Mastering Microsoft Dynamics 365 Business Central is a comprehensive solution which will help you in managing end-to-end business requirements with its features to connect to your financials, sales, service, and operations to streamline business processes. This book will help you in advancing with developing the solutions for your customers with improved interactions and better decisions.
Dec 2019 25 hours 40 minutes
Automated Testing in Microsoft Dynamics 365 Business Central
Automated Testing in Microsoft Dynamics 365 Business Central
Dynamics 365 Business Central is the new Cloud-based SaaS ERP proposition from Microsoft. It’s not as simple as it used to be way back when it was called Navigator, Navision Financials, or Microsoft Business Solutions-Navision. Our development practices are becoming more formal, and with this the call for test automation is pressing on us. This book will teach you to leverage testing tools available with Dynamics 365 Business Central to perform automated testing.
Apr 2019 7 hours 24 minutes
Mastering Microsoft Dynamics NAV 2016
Mastering Microsoft Dynamics NAV 2016
With the latest release, Microsoft has rolled out several new features for developers, administrators, consultants, and users alike, to tailor their implementation to best meet each individual’s requirements. This book will help you get a firm understanding of the ins and outs of the latest version of Dynamics NAV.
Mar 2017 15 hours 0 minutes
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Engineering Manager's Handbook
Engineering Manager's Handbook
Engineering Manager's Handbook is a comprehensive guide for managers to excel in their role, foster customer-centric digital products, learn leadership, team building, and balancing technical work with management. You’ll also explore how to develop trust, authority, and collaboration to drive success and make a lasting impact.
Sep 2023 9 hours 16 minutes
C++ Game Animation Programming
C++ Game Animation Programming
Video game characters have a fascinating history, evolving from simple 2D sprites to high-polygon 3D models. Take a look behind the curtain and learn how to build a 3D renderer, load character models, play animations and blend between them, and create large crowds of animated people with this comprehensive C++ game animation programming guide.
Dec 2023 16 hours 0 minutes
Gamification for Product Excellence
Gamification for Product Excellence
This book helps you to take your product management strategy to the next level by standing out in crowded markets. Along with boosting user adoption rates by creating engaging products that incorporate playful elements, learn gamification theory and how to integrate it into your design, product development, and product management processes.
Sep 2023 11 hours 40 minutes
Supercharging Productivity with Trello
Supercharging Productivity with Trello
Supercharging Productivity with Trello is the ultimate guide for anyone looking to boost their productivity with digital tools. Whether you're new to Trello or a seasoned professional, this book covers everything from core features to advanced automation, and Power-Ups.
Aug 2023 11 hours 24 minutes
Automate It with Zapier and Generative AI
Automate It with Zapier and Generative AI
This comprehensive guide takes you through the concepts of business process automation, showing you how Zapier can facilitate it without having to write code and helping you to boost productivity. You’ll learn how to save time, reduce costs, and make your business recession-proof by using Zapier to automate tasks in your cloud-based business apps.
Aug 2023 23 hours 32 minutes
Scoring to Picture in Logic Pro
Scoring to Picture in Logic Pro
In this book, you’ll explore a variety of techniques to synchronize music to picture using Logic Pro. Though this is not a technical manual, it will teach you how to make the best use of Logic Pro and how to wield this technology to maximize your potential when scoring to picture.
Sep 2023 13 hours 44 minutes
Mastering Information Security Compliance Management
Mastering Information Security Compliance Management
This concise book equips you with the knowledge and practices needed to establish and maintain an effective information security management system. The chapters provide insights into ISO/IEC 27001/27002:2022, risk management, ISMS development, incident management, audit processes, and strategies for continuous improvement.
Aug 2023 7 hours 52 minutes
Implementing Atlassian Confluence
Implementing Atlassian Confluence
Implementing Atlassian Confluence provides both a high-level overview and an insightful path for remote collaboration with Atlassian Confluence. With this multi-layered yet practical guide, you’ll be able to set up Confluence-based collaboration with minimum external consultancy services to ensure smooth and close coordination between teams.
Sep 2023 13 hours 32 minutes
R Bioinformatics Cookbook
R Bioinformatics Cookbook
This book takes a unique problem–solution approach to handling complex tasks in the bioinformatics domain using different datasets present in the book. With the help of real-world examples, you’ll learn to put each independent recipe to use to tackle problems in the field of bioinformatics.
Oct 2023 13 hours 12 minutes
Build Your Own Metaverse with Unity
Build Your Own Metaverse with Unity
Build Your own Metaverse with Unity is a practical guide for developers to create their own metaverse - a virtual world with infinite possibilities. It empowers you to identify gaps in existing metaverses and improve upon them, enabling you to shape your virtual world.
Sep 2023 19 hours 32 minutes
Right arrow icon