API_DATASOURCE.REFRESHROW behaviour

Hi Formspider,

It looks like api_datasource.refreshrow does not execute a dtabase query to refresh the row if the row in the datasource is not in a changed state.

Case: I open the application in session 1. I open the application a second time in session 2. I open the same panel with grid in both sessions and query the same record. In session 1, i change a record column value and commit. In session 2, without changing anything to the record, i do api_datasource.refreshrow. I expected to see the changed row, but i dont see the changes from session 1. If in session 2 i change a column value, and then do api_datasource.refreshrow, i do see the changed row...

It looks like Formspider does not requery the row from the database when the row in the datasource is not in a changed state. I would expect the refreshrow to always refresh from the database.

Can you tell me if this behaviour is as designed, or if it is a bug?

Best regards,
Michiel A.

refreshrow

asked 05 Oct '12, 02:52

Michiel A
516●2●10●52
accept rate: 13%

Hi Michiel,

It seems like a bug. I tried to replicate it in a simple application that I build but it seems to work as you have expected, I guess that your case is more complicated than my simple application :). Can you provide more details please? Is there any filter applied on this datasource? Which fetch mode are you using for this datasource?

Thanks, Ibrahim

(05 Oct '12, 03:52) Ibrahim Sand... ♦♦

One Answer:

oldest newest most voted

Hi Ibrahim,

You are right, it was in my code. Before i refresh i query the rowstatus by calling api_datasource.getrowstatus (because i dont want to refresh if it is a new row) But if forgot to NVL the getrowstatus, because rowstatus returns null for unchanged records..

So it was a bug in my code,

Thanks, Michiel A.

link

answered 05 Oct '12, 05:14

Michiel A
516●2●10●52
accept rate: 13%

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

refreshrow ×2

Asked: 05 Oct '12, 02:52

Seen: 1,378 times

Last updated: 05 Oct '12, 05:14

API_DATASOURCE.REFRESHROW behaviour

Follow this question

Related questions