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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
nav4 modify rec in ondelete trigger
wertis
Member Posts: 3
Hello,
My goal is: ondelete trigger modify some rec field (not key) and continue to delete it.
Reason: to log deleted record throw after delete trigger in sql.
If I add some code in ondelete trigger, all modifications are ignored without error raising.
My goal is: ondelete trigger modify some rec field (not key) and continue to delete it.
Reason: to log deleted record throw after delete trigger in sql.
If I add some code in ondelete trigger, all modifications are ignored without error raising.
0
Best Answer
-
Options
Jan_Veenendaal
Member Posts: 206
Modifying a field in Rec during the OnDelete trigger will have no effect in SQL, since that change is never sent to the database server (that would require a MODIFY - don't do that from OnDelete of the same record).
It is not clear to me what you would like to accomplish here?Jan Veenendaal5
Answers
It is not clear to me what you would like to accomplish here?