AL - Wikipedia

Loading...
C/AL C/AL (Client/server Application Language) is the programming language used within C/SIDE the Client/Server Integrated Development Environment in Microsoft Dynamics NAV (Formerly known as Navision Attain). C/AL is a Database specific programming language, and is primarily used for retrieving, inserting and modifying records in a Navision database. C/AL resembles the Pascal language on which it is based. The original C/AL compiler was written by Michael Nielsen.[1]

Contents Examples Hello World Filtering and retrieving record Looping and data manipulation See also References External links

Examples Hello World This is the classic Hello World example. Since the C/SIDE (Client/Server Integrated Development Environment) does not have a console to output text, this example is made using a dialog box as the visual interface. MESSAGE('hello, Jeegen');

Filtering and retrieving record Variables in C/AL are not defined through code, but are defined via the variable declaration menu in the C/AL editor. In this example Item is assumed to be a variable of type Record. IF Item.GET('31260210') THEN MESSAGE(STRSUBSTNO('Item name is: %1',Item.Description)); Item.RESET; Item.SETRANGE("No.",FromItem,ToItem); Item.FINDLAST;

.

Looping and data manipulation Looping over a recordset and modifying the individual records is achieved with only a few lines of code. Item.RESET; Item.SETRANGE("Blocked",TRUE); IF Item.FINDSET THEN REPEAT IF Item."Profit %" < 20 THEN BEGIN Item."Profit %" := 20; Item.MODIFY(TRUE); END; UNTIL Item.NEXT = 0; Item.MODIFYALL("Blocked",FALSE);

See also Microsoft Dynamics NAV

References 1. Studebaker, David, "Programming Microsoft Dynamics NAV 2009," p. 8 (2009)

External links Microsoft Dynamics NAV Official Site (http://www.microsoft.com/en-us/dynamics/erp-nav-overview.aspx) Retrieved from "https://en.wikipedia.org/w/index.php?title=C/AL&oldid=792613096"

This page was last edited on 27 July 2017, at 15:20. Text is available under the Creative Commons Attribution-ShareAlike License; additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy. Wikipedia® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization.

Loading...

AL - Wikipedia

C/AL C/AL (Client/server Application Language) is the programming language used within C/SIDE the Client/Server Integrated Development Environment in ...

52KB Sizes 4 Downloads 13 Views

Recommend Documents

No documents