Hello
i want to populate a temp table and display it in a page, how can i do ?
here is my code
table 50999 TempProduit
{
TableType = Temporary;
fields
{
field(1; "Item No."; Code[20])
{
caption = 'Item No.';
TableRelation = Item."No.";
ValidateTableRelation = false;
trigger OnValidate()
var
recItem: Record item;
begin
recItem.Get("Item No.");
Description := recItem.Description;
end;
}
field(2; "Description"; Text[100])
{
Caption = 'Description';
}
field(3; "Quantity (base)"; Integer)
{
Caption = 'Quantity (Base)';
}
field(4; "Unit Price"; decimal)
{
Caption = 'Unit Price';
}
}
keys
{
key(key1; "Item No.")
{
}
}
}
and the page
page 50091 "auto order"
{
Caption = 'auto order';
PageType = list;
UsageCategory = Lists;
SourceTable = TempProduit;
SourceTableTemporary = true;
layout
{
area(content)
{
group(General)
{
}
repeater(Produit)
{
field("Item No."; "Item No.")
{
}
field(Descripion; Description)
{
}
field("Quantity (base)"; "Quantity (base)")
{
}
field("Unit Price"; "Unit Price")
{
}
}
}
}
actions
{
area(Processing)
{
action(Populate)
{
ApplicationArea = All;
Caption = 'Populate';
trigger OnAction()
var
recTempProduit: Record TempProduit;
begin
currpage.SetRecord(recTempProduit);
recTempProduit.Init();
recTempProduit.Validate("Item No.", '115915');
recTempProduit."Quantity (base)" := 10;
recTempProduit.Insert();
CurrPage.Update(false);
end;
}
}
}
}
