Dynamics Community Forum Thread Details

Displaying temp data on list

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;
            }

        }
    }
}

Categories:

Business Central

Quick Links

Leaderboard