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.

asked 05 Oct '12, 02:52

Michiel%20A's gravatar image

Michiel A
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... ♦♦

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.


answered 05 Oct '12, 05:14

Michiel%20A's gravatar image

Michiel A
accept rate: 13%

Your answer
toggle preview

Follow this question

By Email:

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



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



Asked: 05 Oct '12, 02:52

Seen: 1,832 times

Last updated: 05 Oct '12, 05:14

Related questions

© Copyright Gerger 2017