striker
Member
Table trigger\'s
Using : XE on Oracle DB
Q: Is there a way to Disable Table triggers?
Background:
We use a table trigger on the F4101 table. In the code it deletes a corresponding tag file record.
The issue we are trying to solve is, when the delete is performed on the Item Master Form, the corresponding tag file record is deleted, along with an extra short item '0' record in the tag file.
There are 2 Delete's being done for the same record. (which is a bug) First, at the Item Master Browse form (Delete Button) and next at the F4101 trigger level.
At the F4101 trigger level, they are using a plain delete on the Item Tag file, instead of a Fetch and Delete. I believe this is the cause of the '0' Item being deleted in the Tag table.
What is strange is, the same code is working in PY ie., It deletes the Item tag record and is not deleting the Item '0' record in the Tag file.
On Debugging this in PY, I found that the table trigger code is not getting executed.
I have checked the code and the Delete on the Tag is present in the F4101 Trigger. For some reason its not reaching that place?
My manager mentioned that a solution was put in place in PY but he doesnt remember what it was.
regards
striker
Using : XE on Oracle DB
Q: Is there a way to Disable Table triggers?
Background:
We use a table trigger on the F4101 table. In the code it deletes a corresponding tag file record.
The issue we are trying to solve is, when the delete is performed on the Item Master Form, the corresponding tag file record is deleted, along with an extra short item '0' record in the tag file.
There are 2 Delete's being done for the same record. (which is a bug) First, at the Item Master Browse form (Delete Button) and next at the F4101 trigger level.
At the F4101 trigger level, they are using a plain delete on the Item Tag file, instead of a Fetch and Delete. I believe this is the cause of the '0' Item being deleted in the Tag table.
What is strange is, the same code is working in PY ie., It deletes the Item tag record and is not deleting the Item '0' record in the Tag file.
On Debugging this in PY, I found that the table trigger code is not getting executed.
I have checked the code and the Delete on the Tag is present in the F4101 Trigger. For some reason its not reaching that place?
My manager mentioned that a solution was put in place in PY but he doesnt remember what it was.
regards
striker