Table Triggers

brucem
brucem Member Posts: 86
edited 2000-03-31 in Navision Financials
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

Comments

  • Otto_Dreyer
    Otto_Dreyer Member Posts: 16
    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
    brucem Member Posts: 86
    Another thought,

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

    Bruce
  • jbolks
    jbolks Member Posts: 17
    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.

Categories