Refreshing Page with Query causes The requested record cannot be located message

(2) Share

Report

Posted on by Dej

157

Hi There,

I have a Query to get list of Project lines . To display it , i am using a temporary table and populate that on OnOpenPage() (using the example here https://yzhums.com/4869/)

I have written some actions on that page, once it is done, I am manually refreshing the page to see the changes . But the page always shows "The requested record cannot be located" if i refresh or F5

Please note I am not using any filters on OnOpenPage while my query object only has some filters . I am not able to find what's going wrong. Is it not possible to refresh the page with temporary table ?

kindly help!

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mohamed Amine Mahmoudi 26,348 Super User 2025 Season 2 on at

Like (0)

Report

Refreshing Page with Query causes The requested record cannot be located message

Hi @Dej,

I hope this can help you and give you some hints.

https://stackoverflow.com/questions/78444732/how-to-reload-the-current-page-with-a-temporary-table-view-in-business-central

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Refreshing Page with Query causes The requested record cannot be located message

https://community.dynamics.com/forums/thread/details/?threadid=35460005-db7d-4fab-9df7-469239a55ef9

https://community.dynamics.com/forums/thread/details/?threadid=5b033777-410f-4d54-b2ae-09aa6e51d183

Was this reply helpful? Yes No
Suggested answer

Alexander Drogin 262 on at

Like (0)

Report

Refreshing Page with Query causes The requested record cannot be located message

It would be easier to answer your question if you could share your code. This error usually means that the record displayed in the page has been deleted.

By your description, I can only guess that some code deletes the source record from the temporary table, and since the refresh action does not invoke the OnOpenPage trigger, this record cannot be found anymore.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Refreshing Page with Query causes The requested record cannot be located message

Hi, I retried my code and did not encounter your problem. This is the version I tested

Version: W1 25.2 (Platform 25.2.28691.0 + Application 25.2.27733.28869)

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Dej 157 on at

Like (1)

Report

Refreshing Page with Query causes The requested record cannot be located message

Hi All,

Thank you for the responses. I found the issue!

The page first loads without any issues, It shows that msg only if refresh the browser

if Qry.Open() then begin
while Qry.Read() do begin
Rec.init();
Rec.RowNo := Rec.RowNo + 1;

This line Rec.RowNo:= Rec.RowNo +1
The Rec.RowNo is not set when i refresh the page...What’s strange here is that Rec.RowNo is available the first time the page loads, but it stops working after the page is refreshed.

I tried to give InitValue=0 in the temp table field, it is not working. So i initialized a int variable, increment it and assign it to RowNo field.
now the page reloads correctly.

But I want to have a Refresh action , to show the status changes in the repeater control
CurrPage.Update()

the repeater doesn't refresh, can anyone kindly let me know what is wrong with CurrPage.Update() for refreshing the repeater?

Thank you for helping!

Was this reply helpful? Yes No