Modify a Record from a RequestPage

MelekBoujelbene

Hello NAV experts,

Is it possible to modify a Record from a RequestPage ?
Here is a code example that generates an Error "ID=0"

dataset
{
        dataitem(CalculLoyerEntete; "Calcul Loyer Entete")
        {
          DataItemTableView = SORTING("ID");
          column(Name;Name) { }
          column(DateMail;FORMAT("Creation Date Last Mail",0,'<Day,2> <Month Text> <Year4>')){ }
        }
}

requestpage
{
        layout
        {
            area(content)
            {
              trigger OnOpenPage();
              begin
                 CalculLoyerEntete.Validate("Creation Date Last Mail",Today);
                 CalculLoyerEntete.Modify;
             end;
           }
        }
}

I think "CalculLoyerEntete.Modify;" is causing this Error.


Thanks in advance.

DenSter

when you get to the request page, the object has not read any data. You are issuing a Modify command on an empty record.

MelekBoujelbene

So does this mean that it is impossible to modify a Record from a RequestPage ?

I am using NAV2018.


Thanks.

DenSter

it means that in order to modify a record, you first need to read it. Maybe if you explain what you are trying to do there we can help you put the code together

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

RockWithNAV

As Daniel Said you don't have the record in memory on Request Page Trigger so Modifying here wont work.