Knowledge (XXG)

C/AL

Source 📝

32: 1992: 2014: 94: 756: 1128: 749: 316:(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. 2074: 742: 104: 2055: 1121: 2089: 1781: 280: 1528: 1523: 1995: 1175: 1114: 970: 53: 2094: 1253: 343:
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
75: 1817: 1672: 1424: 1812: 1687: 1165: 1046: 287:. C/AL is a Database specific programming language, and is primarily used for retrieving, inserting and modifying records in a 1429: 1409: 1180: 852: 797: 119: 2048: 1807: 1377: 1365: 1263: 1076: 857: 782: 765: 292: 228: 1397: 1776: 1720: 846: 812: 2084: 1868: 1802: 1692: 1677: 1444: 1000: 162: 46: 40: 1725: 1580: 1070: 1041: 134: 20: 1906: 1848: 1715: 1682: 1434: 1221: 985: 57: 2079: 2041: 1732: 1493: 1201: 1010: 284: 141: 1974: 1152: 1382: 1957: 1843: 1488: 1355: 1310: 990: 975: 897: 693: 288: 276: 194: 482:
Looping over a recordset and modifying the individual records is achieved with only a few lines of code.
1901: 1558: 1518: 1342: 1295: 1275: 148: 2021: 1758: 1737: 1628: 1585: 774: 189: 1873: 1280: 1268: 309: 130: 1771: 1766: 1710: 1498: 1290: 1216: 1160: 1028: 995: 871: 211: 729: 1962: 1667: 1643: 1590: 1360: 1258: 842: 807: 2025: 1838: 1655: 1231: 1094: 933: 892: 313: 1979: 1573: 1347: 1285: 1196: 201: 1942: 1508: 1454: 913: 2068: 1833: 1702: 1638: 1563: 1439: 1170: 1020: 923: 877: 792: 787: 734: 155: 1932: 1623: 1618: 1449: 1300: 1005: 928: 918: 1402: 948: 713: 295:
on which it is based. The original C/AL compiler was written by Michael Nielsen.
1633: 1553: 938: 867: 817: 93: 2013: 1503: 1478: 1466: 1461: 1236: 1106: 980: 943: 882: 1937: 1916: 1662: 1392: 862: 216: 1387: 1891: 1483: 1370: 1211: 1088: 1082: 1064: 827: 1896: 1650: 1613: 1568: 1513: 1471: 1320: 1315: 1226: 887: 802: 1911: 1248: 1241: 1952: 1947: 1595: 1419: 1305: 1206: 1058: 1786: 1605: 1110: 738: 1967: 962: 283:
up until (and including) version 14. It has been replaced by
87: 25: 255:
anguage) was the programming language used within C/SIDE the
2029: 115: 1925: 1882: 1861: 1826: 1795: 1757: 1750: 1701: 1604: 1546: 1537: 1335: 1189: 1151: 1142: 1019: 961: 906: 835: 826: 773: 222: 210: 200: 188: 111: 2049: 1122: 750: 8: 347:is assumed to be a variable of type Record. 183: 120:introducing citations to additional sources 2056: 2042: 1754: 1543: 1148: 1129: 1115: 1107: 832: 757: 743: 735: 182: 76:Learn how and when to remove this message 1782:Business Intelligence Development Studio 279:(Formerly known as Navision Attain) and 110:Relevant discussion may be found on the 39:This article includes a list of general 714:Programming Microsoft Dynamics NAV 2009 705: 281:Microsoft Dynamics 365 Business Central 7: 2010: 2008: 730:Microsoft Dynamics NAV Official Site 2075:Pascal programming language family 2028:. You can help Knowledge (XXG) by 45:it lacks sufficient corresponding 14: 2012: 1991: 1990: 103:relies largely or entirely on a 92: 30: 2090:Microsoft programming languages 1874:Team Foundation Version Control 1047:Comparison of Pascal and Delphi 339:Filtering and retrieving record 1: 478:Looping and data manipulation 291:database. C/AL resembles the 1137:Microsoft development tools 766:Pascal programming language 2111: 2095:Computer programming stubs 2007: 1042:Comparison of Pascal and C 388:'Item name is: %1' 21:CAL (programming language) 18: 1988: 1849:Extensible Storage Engine 1254:Robotics Developer Studio 1037: 227: 1673:Communication Foundation 1011:Visual Component Library 484: 349: 318: 19:Not to be confused with 1975:Windows Package Manager 1688:Presentation Foundation 327:'hello, world!' 60:more precise citations. 2024:-related article is a 1958:Web Platform Installer 1844:Access Database Engine 1311:Native Image Generator 1176:Tools for Applications 991:Object Windows Library 694:Microsoft Dynamics NAV 277:Microsoft Dynamics NAV 2022:computer-programming 1586:Xbox Development Kit 1171:Team System Profiler 712:Studebaker, David, " 308:This is the classic 116:improve this article 16:Programming language 1693:Workflow Foundation 1678:Identity Foundation 1264:SharePoint Designer 312:example. Since the 185: 2085:Microsoft Dynamics 1291:Windows App Studio 1029:Pascal MicroEngine 367:'31260210' 2037: 2036: 2002: 2001: 1963:Windows Installer 1869:Visual SourceSafe 1857: 1856: 1777:Management Studio 1746: 1745: 1591:Windows Installer 1331: 1330: 1104: 1103: 957: 956: 808:Concurrent Pascal 234: 233: 181: 180: 166: 86: 85: 78: 2102: 2058: 2051: 2044: 2016: 2009: 1994: 1993: 1839:Microsoft Access 1755: 1656:Entity Framework 1544: 1181:Tools for Office 1149: 1131: 1124: 1117: 1108: 1095:Component Pascal 1055: 934:Microsoft Pascal 893:Pic Micro Pascal 833: 759: 752: 745: 736: 717: 710: 683: 680: 677: 674: 671: 668: 665: 662: 659: 656: 653: 650: 647: 644: 641: 638: 635: 632: 629: 626: 623: 620: 617: 614: 611: 608: 605: 602: 599: 596: 593: 590: 587: 584: 581: 578: 575: 572: 569: 566: 563: 560: 557: 554: 551: 548: 545: 542: 539: 536: 533: 530: 527: 524: 521: 518: 515: 512: 509: 506: 503: 500: 497: 494: 491: 488: 473: 470: 467: 464: 461: 458: 455: 452: 449: 446: 443: 440: 437: 434: 431: 428: 425: 422: 419: 416: 413: 410: 407: 404: 401: 398: 395: 392: 389: 386: 383: 380: 377: 374: 371: 368: 365: 362: 359: 356: 353: 334: 331: 328: 325: 322: 202:Designed by 186: 176: 173: 167: 165: 124: 96: 88: 81: 74: 70: 67: 61: 56:this article by 47:inline citations 34: 33: 26: 2110: 2109: 2105: 2104: 2103: 2101: 2100: 2099: 2080:Query languages 2065: 2064: 2063: 2062: 2005: 2003: 1998: 1984: 1980:Microsoft Store 1921: 1907:Script Debugger 1884: 1878: 1853: 1822: 1791: 1742: 1697: 1600: 1574:Managed DirectX 1539: 1533: 1327: 1286:Windows App SDK 1222:Macro Assembler 1185: 1144: 1138: 1135: 1105: 1100: 1053: 1033: 1015: 953: 902: 822: 769: 763: 726: 721: 720: 711: 707: 702: 690: 685: 684: 681: 678: 675: 672: 669: 666: 663: 660: 657: 654: 651: 648: 645: 642: 639: 636: 633: 630: 627: 624: 621: 618: 615: 612: 609: 606: 603: 600: 597: 594: 591: 588: 585: 582: 579: 576: 573: 570: 567: 564: 561: 558: 555: 552: 549: 546: 543: 540: 537: 534: 531: 528: 525: 522: 519: 516: 513: 510: 507: 504: 501: 498: 495: 492: 489: 486: 480: 475: 474: 471: 468: 465: 462: 459: 456: 453: 450: 447: 444: 441: 438: 435: 432: 429: 426: 423: 420: 417: 414: 411: 408: 405: 402: 399: 396: 393: 390: 387: 384: 381: 378: 375: 372: 369: 366: 363: 360: 357: 354: 351: 341: 336: 335: 332: 329: 326: 323: 320: 306: 301: 293:Pascal language 206:Michael Nielsen 177: 171: 168: 125: 123: 109: 97: 82: 71: 65: 62: 52:Please help to 51: 35: 31: 24: 17: 12: 11: 5: 2108: 2106: 2098: 2097: 2092: 2087: 2082: 2077: 2067: 2066: 2061: 2060: 2053: 2046: 2038: 2035: 2034: 2017: 2000: 1999: 1989: 1986: 1985: 1983: 1982: 1977: 1972: 1971: 1970: 1960: 1955: 1950: 1945: 1940: 1935: 1929: 1927: 1923: 1922: 1920: 1919: 1914: 1909: 1904: 1899: 1894: 1888: 1886: 1880: 1879: 1877: 1876: 1871: 1865: 1863: 1862:Source control 1859: 1858: 1855: 1854: 1852: 1851: 1846: 1841: 1836: 1830: 1828: 1824: 1823: 1821: 1820: 1815: 1810: 1805: 1799: 1797: 1793: 1792: 1790: 1789: 1784: 1779: 1774: 1769: 1763: 1761: 1752: 1748: 1747: 1744: 1743: 1741: 1740: 1735: 1730: 1729: 1728: 1723: 1713: 1707: 1705: 1703:Device drivers 1699: 1698: 1696: 1695: 1690: 1685: 1680: 1675: 1670: 1665: 1660: 1659: 1658: 1648: 1647: 1646: 1641: 1636: 1631: 1626: 1621: 1610: 1608: 1602: 1601: 1599: 1598: 1593: 1588: 1583: 1578: 1577: 1576: 1566: 1561: 1556: 1550: 1548: 1541: 1535: 1534: 1532: 1531: 1526: 1521: 1516: 1511: 1509:Project Verona 1506: 1501: 1496: 1491: 1486: 1481: 1476: 1475: 1474: 1469: 1459: 1458: 1457: 1452: 1442: 1437: 1432: 1427: 1422: 1417: 1412: 1407: 1406: 1405: 1400: 1395: 1390: 1380: 1375: 1374: 1373: 1368: 1363: 1358: 1350: 1345: 1339: 1337: 1333: 1332: 1329: 1328: 1326: 1325: 1324: 1323: 1318: 1313: 1308: 1303: 1293: 1288: 1283: 1278: 1273: 1272: 1271: 1261: 1256: 1251: 1246: 1245: 1244: 1234: 1229: 1224: 1219: 1214: 1209: 1204: 1202:Expression Web 1199: 1193: 1191: 1187: 1186: 1184: 1183: 1178: 1173: 1168: 1163: 1157: 1155: 1146: 1140: 1139: 1136: 1134: 1133: 1126: 1119: 1111: 1102: 1101: 1099: 1098: 1092: 1086: 1080: 1074: 1068: 1062: 1056: 1050: 1049: 1044: 1038: 1035: 1034: 1032: 1031: 1025: 1023: 1017: 1016: 1014: 1013: 1008: 1003: 998: 993: 988: 983: 978: 973: 967: 965: 959: 958: 955: 954: 952: 951: 946: 941: 936: 931: 926: 921: 916: 914:Virtual Pascal 910: 908: 904: 903: 901: 900: 895: 890: 885: 880: 875: 865: 860: 855: 850: 839: 837: 830: 824: 823: 821: 820: 815: 810: 805: 800: 795: 790: 785: 779: 777: 771: 770: 764: 762: 761: 754: 747: 739: 733: 732: 725: 724:External links 722: 719: 718: 716:," p. 8 (2009) 704: 703: 701: 698: 697: 696: 689: 686: 485: 479: 476: 350: 340: 337: 319: 305: 302: 300: 297: 275:nvironment in 232: 231: 225: 224: 220: 219: 214: 208: 207: 204: 198: 197: 192: 179: 178: 114:. Please help 100: 98: 91: 84: 83: 38: 36: 29: 15: 13: 10: 9: 6: 4: 3: 2: 2107: 2096: 2093: 2091: 2088: 2086: 2083: 2081: 2078: 2076: 2073: 2072: 2070: 2059: 2054: 2052: 2047: 2045: 2040: 2039: 2033: 2031: 2027: 2023: 2018: 2015: 2011: 2006: 1997: 1987: 1981: 1978: 1976: 1973: 1969: 1966: 1965: 1964: 1961: 1959: 1956: 1954: 1951: 1949: 1946: 1944: 1941: 1939: 1936: 1934: 1931: 1930: 1928: 1924: 1918: 1915: 1913: 1910: 1908: 1905: 1903: 1900: 1898: 1895: 1893: 1890: 1889: 1887: 1881: 1875: 1872: 1870: 1867: 1866: 1864: 1860: 1850: 1847: 1845: 1842: 1840: 1837: 1835: 1834:Visual FoxPro 1832: 1831: 1829: 1825: 1819: 1816: 1814: 1811: 1809: 1806: 1804: 1801: 1800: 1798: 1794: 1788: 1785: 1783: 1780: 1778: 1775: 1773: 1770: 1768: 1765: 1764: 1762: 1760: 1756: 1753: 1749: 1739: 1736: 1734: 1731: 1727: 1724: 1722: 1719: 1718: 1717: 1714: 1712: 1709: 1708: 1706: 1704: 1700: 1694: 1691: 1689: 1686: 1684: 1681: 1679: 1676: 1674: 1671: 1669: 1666: 1664: 1661: 1657: 1654: 1653: 1652: 1649: 1645: 1642: 1640: 1637: 1635: 1632: 1630: 1627: 1625: 1622: 1620: 1617: 1616: 1615: 1612: 1611: 1609: 1607: 1603: 1597: 1594: 1592: 1589: 1587: 1584: 1582: 1579: 1575: 1572: 1571: 1570: 1567: 1565: 1562: 1560: 1557: 1555: 1552: 1551: 1549: 1545: 1542: 1536: 1530: 1527: 1525: 1522: 1520: 1517: 1515: 1512: 1510: 1507: 1505: 1502: 1500: 1497: 1495: 1492: 1490: 1487: 1485: 1482: 1480: 1477: 1473: 1470: 1468: 1465: 1464: 1463: 1460: 1456: 1453: 1451: 1448: 1447: 1446: 1443: 1441: 1440:Visual FoxPro 1438: 1436: 1433: 1431: 1428: 1426: 1423: 1421: 1418: 1416: 1413: 1411: 1408: 1404: 1401: 1399: 1396: 1394: 1391: 1389: 1386: 1385: 1384: 1381: 1379: 1376: 1372: 1369: 1367: 1364: 1362: 1359: 1357: 1354: 1353: 1352:Visual Basic 1351: 1349: 1346: 1344: 1341: 1340: 1338: 1334: 1322: 1319: 1317: 1314: 1312: 1309: 1307: 1304: 1302: 1299: 1298: 1297: 1294: 1292: 1289: 1287: 1284: 1282: 1279: 1277: 1274: 1270: 1267: 1266: 1265: 1262: 1260: 1257: 1255: 1252: 1250: 1247: 1243: 1240: 1239: 1238: 1235: 1233: 1230: 1228: 1225: 1223: 1220: 1218: 1215: 1213: 1210: 1208: 1205: 1203: 1200: 1198: 1195: 1194: 1192: 1188: 1182: 1179: 1177: 1174: 1172: 1169: 1167: 1164: 1162: 1159: 1158: 1156: 1154: 1153:Visual Studio 1150: 1147: 1141: 1132: 1127: 1125: 1120: 1118: 1113: 1112: 1109: 1096: 1093: 1090: 1087: 1084: 1081: 1078: 1075: 1072: 1069: 1066: 1063: 1060: 1057: 1052: 1051: 1048: 1045: 1043: 1040: 1039: 1036: 1030: 1027: 1026: 1024: 1022: 1021:Microcomputer 1018: 1012: 1009: 1007: 1004: 1002: 999: 997: 994: 992: 989: 987: 984: 982: 979: 977: 974: 972: 969: 968: 966: 964: 960: 950: 947: 945: 942: 940: 937: 935: 932: 930: 927: 925: 924:Borland Kylix 922: 920: 917: 915: 912: 911: 909: 905: 899: 896: 894: 891: 889: 886: 884: 881: 879: 878:PascalABC.NET 876: 873: 869: 866: 864: 861: 859: 856: 854: 851: 848: 844: 841: 840: 838: 834: 831: 829: 825: 819: 816: 814: 811: 809: 806: 804: 801: 799: 796: 794: 793:Pascal Script 791: 789: 788:Object Pascal 786: 784: 781: 780: 778: 776: 772: 767: 760: 755: 753: 748: 746: 741: 740: 737: 731: 728: 727: 723: 715: 709: 706: 699: 695: 692: 691: 687: 483: 477: 348: 346: 338: 317: 315: 311: 303: 298: 296: 294: 290: 286: 282: 278: 274: 270: 266: 262: 258: 254: 250: 246: 242: 238: 230: 226: 223:Influenced by 221: 218: 215: 213: 209: 205: 203: 199: 196: 193: 191: 187: 175: 164: 161: 157: 154: 150: 147: 143: 140: 136: 133: –  132: 128: 127:Find sources: 121: 117: 113: 107: 106: 105:single source 101:This article 99: 95: 90: 89: 80: 77: 69: 66:December 2009 59: 55: 49: 48: 42: 37: 28: 27: 22: 2030:expanding it 2019: 2004: 1933:Active Setup 1818:Notification 1796:SQL services 1629:Dynamic Data 1414: 1301:CLR Profiler 1145:environments 1006:Turbo Vision 929:Turbo Pascal 919:Apple Pascal 907:Discontinued 708: 481: 344: 342: 307: 272: 268: 264: 260: 256: 252: 248: 244: 240: 236: 235: 169: 159: 152: 145: 138: 126: 102: 72: 63: 44: 1883:Testing and 1813:Integration 1733:Windows HLK 1559:Silverlight 1554:Windows API 1519:Small Basic 1398:Managed C++ 1343:Dynamics AX 1296:Windows SDK 1276:Small Basic 1143:Development 939:UCSD Pascal 868:Free Pascal 818:SuperPascal 400:Description 310:Hello World 304:Hello World 271:evelopment 251:pplication 58:introducing 2069:Categories 1902:Playwright 1759:SQL Server 1540:frameworks 1504:PowerShell 1479:IronPython 1467:TypeScript 1462:JavaScript 1383:Visual C++ 1237:QuickBASIC 1054:Related to 981:FireMonkey 949:Pascal/MT+ 944:JRT Pascal 883:GNU Pascal 858:VSI Pascal 700:References 382:STRSUBSTNO 267:ntegrated 195:Imperative 172:March 2024 142:newspapers 41:references 1938:ClickOnce 1917:xUnit.net 1885:debugging 1808:Reporting 1668:CardSpace 1644:Web Forms 1425:Dexterity 1403:C++/WinRT 1336:Languages 1281:WebMatrix 1269:FrontPage 863:IP Pascal 828:Compilers 658:MODIFYALL 217:Microsoft 212:Developer 112:talk page 1996:Category 1926:Delivery 1892:CodeView 1803:Analysis 1751:Database 1538:APIs and 1499:Power Fx 1484:IronRuby 1371:VBScript 1217:MACRO-80 1212:GW-BASIC 1089:Oberon-2 1083:Modula-3 1065:Modula-2 996:OpenWire 775:Dialects 688:See also 505:SETRANGE 469:FINDLAST 448:FromItem 427:SETRANGE 299:Examples 289:Navision 190:Paradigm 1897:OneFuzz 1772:Compact 1767:Express 1651:ADO.NET 1614:ASP.NET 1569:DirectX 1472:JScript 1393:C++/CLI 1321:XAMLPad 1316:WinDiff 1227:MSBuild 1166:Express 888:Turbo51 872:Lazarus 853:Oxygene 847:history 836:Current 803:Clascal 798:Oxygene 667:Blocked 592:%" 565:%" 541:FINDSET 514:Blocked 376:MESSAGE 321:MESSAGE 247:server 156:scholar 54:improve 1912:WinDbg 1547:Native 1388:C++/CX 1378:Bosque 1361:VB.NET 1356:legacy 1259:Roslyn 1249:QuickC 1242:QBasic 1232:Pascal 1190:Others 1097:(1991) 1091:(1991) 1085:(1988) 1079:(1986) 1077:Oberon 1073:(1983) 1067:(1977) 1061:(1958) 843:Delphi 783:Pascal 768:family 670:" 664:" 610:MODIFY 589:Profit 586:" 562:Profit 559:" 547:REPEAT 517:" 511:" 454:ToItem 442:" 433:" 314:C/SIDE 263:erver 229:Pascal 158:  151:  144:  137:  131:"C/AL" 129:  43:, but 2020:This 1953:vcpkg 1948:NuGet 1827:Other 1639:Razor 1596:WinUI 1420:Dafny 1348:BASIC 1306:ILAsm 1207:FxCop 1197:Blend 1059:ALGOL 813:Joyce 676:FALSE 631:UNTIL 577:BEGIN 493:RESET 415:RESET 259:lient 243:lient 163:JSTOR 149:books 2026:stub 1787:MSDE 1726:UMDF 1721:KMDF 1683:LINQ 1663:MAUI 1624:AJAX 1619:Core 1606:.NET 1529:XAML 1489:Lean 1445:Java 1415:C/AL 1161:Code 652:Item 640:NEXT 634:Item 616:TRUE 604:Item 580:Item 574:THEN 568:< 553:Item 544:THEN 535:Item 523:TRUE 499:Item 487:Item 463:Item 421:Item 409:Item 394:Item 373:THEN 355:Item 345:Item 237:C/AL 184:C/AL 135:news 1968:WiX 1943:npm 1738:WDM 1716:WDF 1711:WDK 1634:MVC 1581:UWP 1564:XNA 1524:VPL 1450:J++ 1366:VBA 1071:Ada 1001:RTL 986:LCL 976:FCL 971:CLX 963:API 898:ACK 625:END 361:GET 118:by 2071:: 1514:Q# 1455:J# 1435:F* 1430:F# 1410:C# 598:20 595::= 571:20 550:IF 532:IF 436:No 403:)) 352:IF 285:AL 261:/S 2057:e 2050:t 2043:v 2032:. 1494:P 1130:e 1123:t 1116:v 874:) 870:( 849:) 845:( 758:e 751:t 744:v 682:; 679:) 673:, 661:( 655:. 649:; 646:0 643:= 637:. 628:; 622:; 619:) 613:( 607:. 601:; 583:. 556:. 538:. 529:; 526:) 520:, 508:( 502:. 496:; 490:. 472:; 466:. 460:; 457:) 451:, 445:, 439:. 430:( 424:. 418:; 412:. 406:; 397:. 391:, 385:( 379:( 370:) 364:( 358:. 333:; 330:) 324:( 273:E 269:D 265:I 257:C 253:L 249:A 245:/ 241:C 239:( 174:) 170:( 160:· 153:· 146:· 139:· 122:. 108:. 79:) 73:( 68:) 64:( 50:. 23:.

Index

CAL (programming language)
references
inline citations
improve
introducing
Learn how and when to remove this message

single source
talk page
improve this article
introducing citations to additional sources
"C/AL"
news
newspapers
books
scholar
JSTOR
Paradigm
Imperative
Designed by
Developer
Microsoft
Pascal
Microsoft Dynamics NAV
Microsoft Dynamics 365 Business Central
AL
Navision
Pascal language
Hello World
C/SIDE

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.