Update in DB through other tools not reflected in Servoy

Classic Servoy
1

Hi,

I’ve got a problem when my sollution has a form open with data from a database. Afte opening the form, some of the data is updated in the database through another tool (not Servoy), for example a database manager tool.

How do I get Servoy so far as to refresh the data?

If I trigger a method with a loadAllRecords, still the old info is shown.

Where am I going wrong???

2

Currently, it’s not possible to invalidate the client’s cache of the data (Servoy Developer also uses the client code to display the data).

In an upcoming version - you will be able to flush the client cache from the HTTP interface of the application server.

It’s on the list of things to add in the Methods editor as well.

Bob Cusick

3

OK, any idea when we can see this (beta or final version)

4

bcusick:
Currently, it’s not possible to invalidate the client’s cache of the data (Servoy Developer also uses the client code to display the data).

Yeah, I’m trying to use Servoy as a workgroup interface for some online systems. Being able to refresh client data from the MySQL tables is really important.

5

Servoy 1.2 final admin page will have client cache flush functionality

6

Cool… when can we see this final 1.2? this month?

7

Yes, likely end of this week.

8

One of the first replies on this subject was from Bob Cusick. he said it was on the list to add the requery function (as I call it) to the method editor as well. Any idea when we can see this in a beta or final?

Paul

9

No, we cannot provide such a function, because it whould break working over the web.

10

Why is that? If I would open a new screen in the client, the underlying database tables also have to be queried, so query-ing the database happens. Why would requery-ing the allready available data break the working over the web?

For the financial part of my application I have to know for sure that I have the latest version of the data, before I update something. So, I want to do the following:
requery
start transaction
start lock
update data
commit transaction
release lock

since the data is not only updated through Servoy clients, but also other processed, the specific foundset the user is going to updata needs to be re-evaluated. a complete flush of all data, with is now available trhough the Admin page is a bit overdone for this.

Paul

11

Ah now I understand, you don’t want to flush all client cache but only requery local record… that whould be possible

12

Yeah! :D

Sorry for my miscommunication…

So, offcourse then I have to ask… when? :)

13

Servoy 1.2 final will have:
databaseManager.refreshRecordFromDatabase(,);
examples:
databaseManager.refreshRecordFromDatabase(foundset,2);
databaseManager.refreshRecordFromDatabase(order_to_orderdetails,1);

14

thanks!