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; } } } }
yes that's it !!
thank you !
Did you try
rec.Init();
rec.Validate("Item No.", '115915');
rec."Quantity (base)" := 10;
rec.Insert();
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156