Servoy Forum

Hi,

I have an Erp solution running on servoy server.

On the same servoy server there is a batchprocessor that will add records to tables that are also shown in the Erp solution.

I notice that when the table is shown on a form in the Erp solution, I still have to do " show all records" to make records added by
the batchprocessor visible.

Is it possible to see new records without the user having to push " show all records" ??

Maybe by catching the ondatabroadcast ?

Regards,

you could use the ondatabroadcast for that.
Also you could show a relation on the screen, that will then update itself

Besides that if you have a foundset that is fully loaded and doesn't have any find/where statements then i think we should also auto add the new row.

Hi have a similar issue with headless client.

From an option in my solution the SHC is invoked and adds some records to a table. After that the user goes to the option where those records can be treated and they are not there until he navigates to next record.

Thanks.

I have the opposite need: I'd like to turn off databroadcast when an HC performs some rows insert, is this possible? I'd like to avoid 100+ clients receiving the databroadcast notifications, especially the client that triggered the operation.

Thanks Guys,

@Johan : if a relation is used and the user has done a find - search on that related foundset, will the new record still become visible ?

If so, I wonder why there is a difference in behaviour between a non-related and a related foundset regarding databroadcast ??

Regards,

because for none related it can be anything.. you can have find criteria that are very hard to do.
For related it is a fixed set, that we quickly test and if we do think, ok this one could (and i stress here could we don't know it for sure!) we do a re query.
That is quite hard to do for a normal foundset then we constantly have to refresh them, quite a performance penalty

jcompagner wrote:That is quite hard to do for a normal foundset then we constantly have to refresh them, quite a performance penalty

This is really true. For updates the data broadcasting is working, and in some cases I would even like NOT to have data broadcasting.



Calculate the nr of hours that the system is refreshing.
As you can see that this refresh operation already has a very bad influence on the performance.
The avg time to refresh is significant higher than a normal operation.

I'm even going to rewrite some forms (forms based on datasets in stead of foundsets) to avoid this data broadcasting

ngervasi wrote:I have the opposite need: I'd like to turn off databroadcast when an HC performs some rows insert, is this possible? I'd like to avoid 100+ clients receiving the databroadcast notifications, especially the client that triggered the operation.

+1

I already asked that earlier, but it seemed to be very difficult.
Maybe the easiest way for Servoy would be a setting on table level if data broadcasting must be ignored.
In that case it would be system wide and perhaps easier to implement.