How to handle in Nav/SQL ?

navuser1navuser1 Member Posts: 1,329
Hi All,

Our Client has a New Table and this table gets data from various sources like through Navision, through SQL etc and it display the data...

This table has a field Named Entry No. and it should be incremented when it collecting the data.

But when it gets data from Navision, the Table INSERT trigger fire (Entry No. incremented) but the Table INSERT triggers not fire (Entry No. Incremented) when it gets data from the other source.


Whatever the source I want that the Table Field (Entry No) should be incremented at time of collecting the data
:roll:
Now or Never

Comments

  • kinekine Member Posts: 12,562
    It depends on how the data are stored there. If you are filling the data from outside, the NAV Application code is not called. You cannot run NAV code outside NAV client or NAV Application server. You need to have NAV be the active one to fill the data and run the code... 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • navuser1navuser1 Member Posts: 1,329
    Thanks Kine ..
    Now or Never
Sign In or Register to comment.