Triggers when executed on the server in non desktop apps for virtual tables have no context. In other words there is no active record buffer, so you cannot access fields in it. Why? Because the...
Type: Posts; User: barrymavin
Triggers when executed on the server in non desktop apps for virtual tables have no context. In other words there is no active record buffer, so you cannot access fields in it. Why? Because the...
Hi Simon,
Rebuilding the database has nothing to do with triggers.
I cannot see any issues with table triggers. They are all working for me. Records are only updated if they contents have been...
Hi Simon,
I tested the table triggers with an oledb VT and they work as expected.
Hi Simon
The table triggers work fine. It’s because you are updating an oledb vt,
My understanding us that you want to update another table when an update is applied.
Why do you want to...
Hi Simon
of course the VTs will be in the database if you created them with the database open.
if not refresh the tables in the data workspace or rebuild the database from the same place.
I...
Hi Simon,
See the doc for event sequences
https://www.lianja.com/doc/index.php/Event_Delegate_Sequences
beforeupdate or afterupdate delegate
or alternatively you can write your own custom...