Get() a record using a temporary record

(4) Share

Report

Posted on by Rudylar

103

Hi,

In order to get a static list of records from a FindSet(), I did the following because this record has 7 PK of different types and I couldn't reference in a list:

var
PurchasePriceTemp: Record "Purchase Price" temporary;
begin
PurchasePriceL.SetRange("Vendor No.", inVendorNo);
if PurchasePriceL.FindSet() then begin
repeat
PurchasePriceTemp.Init();
PurchasePriceTemp := PurchasePriceL;
PurchasePriceTemp."Minimum Quantity" := 9999; // just as an identifier to make sure those temp records will not be saved on the real table
PurchasePriceTemp.Insert();
until PurchasePriceL.Next() = 0;
end;

if PurchasePriceTemp.FindSet() then begin
repeat
PurchasePriceL.Get(PurchasePriceTemp."Item No.", PurchasePriceTemp."Vendor No.", PurchasePriceTemp."Starting Date", PurchasePriceTemp."Currency Code", PurchasePriceTemp."Variant Code", PurchasePriceTemp."Unit of Measure Code", PurchasePriceTemp."Minimum Quantity");

And this is precisely when I try to Get() that exception is raised saying the record (temp) does not exist...

Any idea ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

YUN ZHU 93,153 Super User 2025 Season 2 on at

Like (2)

Report

Get() a record using a temporary record

Hi, it seems that PurchasePriceL and PurchasePriceTemp only differ in the value of "Minimum Quantity". Why don't you just add your processing directly after insert?

I personally don't think adding a second loop is necessary.

As for your question, change PurchasePriceTemp := PurchasePriceL; to assign a value to the field separately.
In addition, you can also add a message after if PurchasePriceTemp.FindSet() then begin
repeat
to check whether the value you are trying to get is empty.

If you think the key is too long, you can also try to obtain it using SystemId.

Dynamics 365 Business Central: How to get a record by its SystemId

https://yzhums.com/13242/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,312 Super User 2025 Season 2 on at

Like (3)

Report

Get() a record using a temporary record

For other helps: https://community.dynamics.com/forums/thread/details/?threadid=0f25bb0d-ba1a-f011-998a-00224833c1bb

Was this reply helpful? Yes No
Rudylar 103 on at

Like (3)

Report

Get() a record using a temporary record

I used the SystemId and it works great.

Thank you

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get() a record using a temporary record

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Get() a record using a temporary record

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates