Options

How can I run a trigger by pressing a button inside Navision

ernesternest Member Posts: 162
edited 2012-01-18 in Navision Financials
Hi all

I have created a trigger that I want to execute it every time I press a button in Navision.

Can anyone please tell me shortly how to accomplish that?

The trigger is created and also the button is created. I want on the click of this button to run the trigger which is on the database.
Please help me on this.

Thank you and best regards

Comments

  • Options
    matttraxmatttrax Member Posts: 2,309
    A SQL trigger? A Navision function? Please be specific about what you have done.
  • Options
    ernesternest Member Posts: 162
    Sorry for not specifying that.

    A sql trigger.

    Regards
  • Options
    kinekine Member Posts: 12,562
    If it is trigger, it is triggered when some event in SQL is fired. Depends on which event you want to fire from NAV... ;-) if it is trigger, which is fired when record is inserted into some table, just insert the record into the table... you can use ADO Automation to interact with the SQL. Search for examples how to run e.g. Stored Procedure.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.