OnInsertRecord

sabzam
sabzam Member Posts: 1,149
edited 2007-10-16 in NAV/Navision Classic Client
Dear All,

I need to retain the user from inserting any new records in a table if a certain condition is satisfied. In which trigger should this be done and what is the exact code to stop the insertion from taking place?

Answers

  • Waldo
    Waldo Member Posts: 3,412
    OnInsert trigger of the table... :-k . If you place an ERROR, the transaction will roll back.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • sabzam
    sabzam Member Posts: 1,149
    Hi,

    it has worked perfectly thanks for your help. By the way just to let you know it can work on either form or the table the only difference is that when the coding is done on the table the form won't realise that the insertion has not been done if there happens to be any coding on the on insert trigger

Categories