Table Triggers

brucem

Is table / field trigger actually run by the client or by the Navsision Server ?

I have put code behind a field on a table and then have written to the table via ODBC but the code does not appear to run. leaving me to suspect that the nav client runs the code.

Is it possible to get the server to run this code unit ?

Bruce

Otto_Dreyer

C/AL code is interpreted at the client.

If you are writing data thru ODBC and yo want validations to be executed then a solution could be:

- create buffer table and populate it via OBDC
- create batch job in C/AL that will transfer all the data from mentioned buffer table to necessary table, with validation

Best regards,

Otto Dreyer
NRG Ltd.

brucem

Another thought,

Is it possible to fire a code unit via automation from MS-Access? / VB?

Bruce

jbolks

Yes and no,
No, not directly via VB
Yes, you can design a form with a ontimer trigger which
scans a table for new records. (filled by VB)
In the ontimer trigger you can execute a codeunit depending on
the information(for example codeunit name) in the new record.