This article by Erlend Dalen, explains the different options to use when you need to search and retrieve a set of data from the database. It shows you how to create a query, how to create a view, and how to write different select statements.
In this article, you will learn about the different methods of retrieving data from the database. They are as follows:
- Queries which are reusable and often used in reports and periodic Jobs
- Views that are created in AOT and translated to optimized select statements at runtime
- Select statements to use in X++ to fetch data from the database to the application
This article by Dr. Jayaram Krishnaswamy, shows how you may retrieve XML data from a relational database and write it to a folder on your file system as a text or xml file using Microsoft SQL Server Integration Services 2008. The following are the different steps involved in this EL process (there being no transformation):
- Creating a stored procedure that retrieves XML
- Creating a package in BIDS or Visual Studio 2008
- Adding and configuring a ExecuteSQL task
- Adding and configuring a Script task
- Running the package and verifying the results
This article by Rahul Pitre, will help you try your hands at writing your own HTML mark up to tweak your site.How to install off-the-shelf components to enhance your website is the next skill you'll learn in this article. You'll install a custom FAQ component because the built-in FAQ page doesn't work as advertised.
In this article you will:
- Add an HTML module to your page.
- Write HTML in the HTML module. Chances are that you don't know a lot about HTML. So, you'll take a crash course on a small subset of HTML that will help you to get started with writing your own markup, if you so desire.
- Perform some common page-building tasks such as embedding flash movies, PayPal buttons, and other such external content in your web pages using the HTML module.
- Download and install an FAQ solution that renders a customized FAQ page.
In this article by Rahul Pitre you'll start using the design tools to personalize your site's headers and footers. You'll customize its name and slogan, and in the bargain put your distinctive stamp on your website.
In this article, you will:
- Decide what your website's title should be, and set it in your template
- Decide what your website's slogan should be, and set it in your template
- Decide what information should go into your website's footer, and set it
In this article David Studebaker, we will review the components that make up reports. We'll look in detail at the triggers, properties, and controls that are part of NAV reports. We will study the Report Designer tools that are a combination of pure NAV (the C/SIDE Report Designer) and the Visual Studio Report Designer that is tightly integrated into NAV 2009. We'll create some reports with the Report Designer tools. We'll also modify a report or two using the Report Designer. We'll examine the data flow of a standard report and the concept of reports used for processing only (with no printed or displayed output).Read Report components in NAV 2009: Part 1 in full