Does automatic data update work with batch changes?

Classic Servoy
21

Please file a case in our support system with a sample solution in which this can be reproduced + description how to reproduce it.

Paul

22

martinh:
Rich/Rich client same issue!

[snip]

So this looks to be a very serious problem!

That really sounds like one :| .

martinh:
I see in my database that a child record was added.
So now I have a child record without a parent in my database

That would have never happened when you would have put the referential integrity checks (foreign key constraints) not (only) in the application layer but in the database layer where it belongs. But that is another discussion altogether.

But please do what Paul is asking and file this test in the support system.

23

and please do post more info as you uncover it here, this is an important thread some of us are following, thanks!!

kazar

24

I submitted a case 223009 with a sample solution reproducing aspects of this problem on 6/30. The sample solution showed a foundset based on global relation failing to be updated correctly when a record was modified. This was all local in the same SC/WC, no batch process involved. The status of the case is still ‘new’ so I don’t think it’s been looked at yet. I’ve emailed Jan Blok and Paul Bakker asking that it be looked at soon. Thanks.

25

Update - I have just uploaded to case 22452 a sample solution which reproduces the problem exactly. It shows the server failing to broadcast updates a client-based foundset that is based on a global relation as records are modified by a batch process. Hopefully this will help Servoy resolve the problem.

26

Just received word from Servoy Support that this issue is fixed in release 5, beta 2. Here is an excerpt from the bug resolution report:

We have added support now for related foundsets to update when records are updated by another client.
This was working already, but only in the case that the client had loaded the record, since the new version it also works if the client has not loaded the record.

I’m not sure I’ll have a chance to test this fix in the beta release anytime soon but perhaps someone else following this thread can test it and let us know their results.

Thank you Servoy Support for addressing this problem.