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
No comments:
Post a Comment