Sql Server 2005 Triggers

Classic Servoy
1

I am using Update, and Insert triggers in a sql server 2005 database. How can I get the data that is added or inserted to show in my solution.

I have tried refreshRecordsfromDatabase and flushAllClientCache. I have read the posts on this subject, but still can’t get the trigger data to show in the solution without going out of the solution and back in. The solution requires that the data be shown immediately after it is updated or inserted.

Thanks

2

Could it be that if you use databaseManager.refreshRecordFromDatabase(foundset,-1) the data changed by the trigger is not visible yet?
If you update/insert another record is the data modified by the trigger of the first record visible?

Rob

3

Because those triggers were not handled by Servoy I can imagine that Servoy can’t see them.
If the records that were added by those triggers are committed, then you should be able to retrieve them by using databaseManager.getDataSetByQuery()

In general I would not use database triggers. I would use table events to insert/update additional rerords, to keep all logic within Servoy.
For deployment that is also easier. You remain database independent and you can’t forget to change the target database in case of a change or a new trigger.