Hello Reader, I would like to share with you an implementation of AL development following one of Microsoft's demo project. The Seminar project from earlier versions (2009 R2). We shall develop this project using AL extensions.
Please access the detail pdf spelling out the Seminar assignment in details. Click here to
view
We shall straight away start with the seminar room table as stated in the pdf you just read.
- First create an AL project.
- Edit the app.json file idRange to 50000 to 59999
- Edit your Launch.json accordingly
- Right click Helloworld.al file and select rename. SeminarExt.al
- You need to dowload symbols
- Delete everything from the file and paste there the code below
Here is the code;
table 50000 "Seminar Room"
{ fields
{
field(10;Code;Code[10])
{
NotBlank = true;
}
field(20;Name;Text[50])
{
}
field(30;Address;Text[50])
{
}
field(40;"Address 2";Text[50])
{
}
field(50;City;Text[30])
{
}
field(60;"Post Code";Code[20])
{
TableRelation = "Post Code".Code;// Table relation to post Code table
}
field(70;"Country/Region Code";Code[10])
{
TableRelation = "Country/Region".Code;
}
field(80;"Phone No.";Text[30])
{
ExtendedDatatype = PhoneNo;// The system will capture this text as a phone no.
}
field(90;"Fax No.";Text[30])
{
ExtendedDatatype = PhoneNo;
}
field(100;"Name 2";Text[50])
{
}
field(110;"Contact";Text[50])
{
}
field(120;"E-Mail";Text[80])
{
ExtendedDatatype = EMail;
}
field(130;"home Page";Text[90])
{
ExtendedDatatype = URL;
}
field(140;"Maximum Participants";Integer)
{
}
field(150;"Allocation";Decimal)
{
}
field(160;"Resource No.";Code[20])
{
TableRelation = Resource where (Type=const(Machine));
}
field(170;"Comment";Boolean)
{
}
field(180;"Internal/External";Option)
{
OptionMembers = "Internal;External";
}
field(190;"Contact No.";Code[20])
{
TableRelation = Contact."No.";
}
}
keys
{
key(PK;Code)
{
Clustered = true;
}
}
var
myInt : Integer;
trigger OnInsert();
begin
end;
trigger OnModify();
begin
end;
trigger OnDelete();
begin
end;
trigger OnRename();
begin
end;
}
Remember to save.
Please refer to
this article incase you don't know to create an al project
