This content has been marked as final. Show 7 replies
Alexandra,1 person found this helpful
You're going to get that error when creating a tabular form off of a complex view because of the validations APEX creates for you, not because of your trigger. Delete those validations and try again.
Of course, you're going to want to add the where clause to your trigger, or you'll find that you're updating many more rows than you want...
Do you not need to include the reference to the unique ID in your 'doc_info' table? Namely:1 person found this helpful
p.s. does the trigger compile? :-)
update doc_info set approval_req = :n.approval_req where DOC_INFO_ID = :n.DOC_INFO_ID;
Thanks, David! I had done that last week and guess I need another cup of coffee...without truly reading the error again this morning I was remembering I had done somthing with the trigger. I'll delete the validations and proceed.
Thank you, Joel! I was wondering how I could get a where clause in there defining the page. Excellent. I'll come back right after I implement for an update and hopefully close this right away.
Okay - David and Joel -
Now I get no error, but my select yes/no is still not submitting. Default on it is No, I change to Yes and hit submit and it's not updating. Any ideas?
In the ApplyMRU wizard I changed the table name from the view name to the table I wanted to update.
Yippe yie yay! Thanks for direction my attention to the right places!
Have a great week, both of you!
Great help with both responses. Thanks.