Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Displaying temp data on list

(1) ShareShare
ReportReport
Posted on by 20

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

        }
    }
}

  • TiamaT Profile Picture
    TiamaT 20 on at
    RE: Displaying temp data on list

    yes that's it !!

    thank you !

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,194 Super User 2024 Season 2 on at
    RE: Displaying temp data on list

    Did you try

                       rec.Init();

                       rec.Validate("Item No.", '115915');

                       rec."Quantity (base)" := 10;

                       rec.Insert();

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans