Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Table Triggers
brucem
Member Posts: 86
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
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
0
Comments
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.
Is it possible to fire a code unit via automation from MS-Access? / VB?
Bruce
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.