Table Events

Classic Servoy
1

Hi All,

I’m using a global method with table event, ‘onRecordUpdate()’ to keep audit records of a table.
When I do a update for that table in foundset record level, it triggers the above global method and does what I want.
But when I do the same update with a foundset updater it does not trigger the above method.
Can someone tell me what is the reason for this.

Br,
Chamil.

2

I would say that the foundset updater goes directly to the database. So a table event is not fired.

3

Thanx for ur response.
So, is not there a way to trigger this method with a foundset updater?

Br,
Chamil.

4

I’d say no. If you really want to be sure, you need an answer from the Dev team.

5

dacrawinath:
Thanx for ur response.
So, is not there a way to trigger this method with a foundset updater?

Br,
Chamil.

If you update whole foundset (sample example 1) ), table event will not be fired, if you update part of foundset (sample example 2) ) table event will be fired.

6

lvostinar:
If you update whole foundset (sample example 1) ), table event will not be fired, if you update part of foundset (sample example 2) ) table event will be fired.

What about sample example 3, does it fire the table event?
Just curious ;-)

7

ptalbot:

lvostinar:
If you update whole foundset (sample example 1) ), table event will not be fired, if you update part of foundset (sample example 2) ) table event will be fired.

What about sample example 3, does it fire the table event?
Just curious ;-)

Yes, will also fire the event. The idea is , when updating the whole foundset will just use a query (for performance sake, I guess), but when updating parts of it will use the in memory objects we have , so the table event will be fired.

8

lvostinar:
The idea is , when updating the whole foundset will just use a query (for performance sake, I guess), but when updating parts of it will use the in memory objects we have , so the table event will be fired.

OK that’s clearer.
Thanks Laurian!