Local Record &Rec;
&Rec = CreateRecord(Record.LNT_EMPREC_970);
LNT_EMPREC_970.LNT_EMPLID_970 = &e;
LNT_EMPREC_970.LNT_DATE_970 = &bb.shift();
LNT_EMPREC_970.LNT_NAME1_970 = &bb.shift();
LNT_EMPREC_970.LNT_DEPARTMENT_970 = &bb.shift();
LNT_EMPREC_970.LNT_ADDRESS1_970 = &bb.shift();
LNT_EMPREC_970.LNT_PHONE1_970 = &bb.shift();
&Rec.Insert();
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Shouldn't this be,
Local Record &Rec;
&Rec = CreateRecord(Record.LNT_EMPREC_970);
&Rec.LNT_EMPLID_970 = &e;
&Rec.LNT_DATE_970 = &bb.shift();
&Rec.LNT_NAME1_970 = &bb.shift();
&Rec.LNT_DEPARTMENT_970 = &bb.shift();
&Rec.LNT_ADDRESS1_970 = &bb.shift();
&Rec.LNT_PHONE1_970 = &bb.shift();
&Rec.Insert();
&Rec is created as Standalone record.
So Code should be like below
Local Record &Rec;
&Rec = CreateRecord(Record.LNT_EMPREC_970);
&Rec.LNT_EMPLID_970 = &e;
&Rec.LNT_DATE_970 = &bb.shift();
&Rec.LNT_NAME1_970 = &bb.shift();
&Rec.LNT_DEPARTMENT_970 = &bb.shift();
&Rec.LNT_ADDRESS1_970 = &bb.shift();
&Rec.LNT_PHONE1_970 = &bb.shift();
&Rec.Insert();
Reason for using &Rec variable for accessing the fields.
The fields created by Create Record function are initialized to null values. Default processing is not performed. No data associated with the record definition’s SQL table is brought in: only the record definition.
Example for Usage of Standalone Record
In the following example, a free-standing record is created (&PSBATREPREQRES). Values are assigned to the fields associated with the record. Then a second record is created (&PUBHDR), and the values from the first record are used to populate the second record.
&PSBATREPREQRES = CreateRecord(RECORD.PSBATREPREQRES);
&PSBATREPREQRES.BATREPID.Value = &BATREPID;
&PSBATREPREQRES.PUBID.Value = &MSG.Pubid;
&PSBATREPREQRES.CHNLNAME.Value = &MSG.ChannelName;
&PSBATREPREQRES.PUBNODE.Value = &MSG.PubNodeName;
&PSBATREPREQRES.MSGNAME.Value = &MSG.Name;
&PUBHDR = CreateRecord(RECORD.PSAPMSGPUBHDR);
&PSBATREPREQRES.CopyFieldsTo(&PUBHDR);
awesome things here. I am very glad to see your article. Thanks a lot and i am looking forward to contact you. Will you please drop me a mail?
Do you have a spam problem on this site; I also am a blogger, and I was wanting to know your situation; many of us have developed some nice procedures and we are looking to exchange solutions with others, be sure to shoot me an e-mail if interested.