BBritain
VIP Member
Hey Gang,
I recently posted a problem about table trigger TK values not populating - specifically the key TK values. I opened an issue with PeopleSoft, and was able to have a conference call with a Senior Technical Consultant.
Currently table triggers populate the TK values based upon the SELECT.....FOR UPDATE sql statement. If a business function does not include the key fields for update, then they cannot be seen in the table trigger events. In a similar problem, Table IO - Deletes can also result in TK key values not being populated. If the Delete is preceded by a related Select (and I would assume FetchNext), then the TK values are populated.
We are currently asking for an Enhancement SAR to populate the TK values with key fields as well as items from the WHERE clause (which are not currently populating).
But for now, I just want TT developers to be aware that events can be triggered when the keys are unknown, and developers should code accordingly.
Ben again
I recently posted a problem about table trigger TK values not populating - specifically the key TK values. I opened an issue with PeopleSoft, and was able to have a conference call with a Senior Technical Consultant.
Currently table triggers populate the TK values based upon the SELECT.....FOR UPDATE sql statement. If a business function does not include the key fields for update, then they cannot be seen in the table trigger events. In a similar problem, Table IO - Deletes can also result in TK key values not being populated. If the Delete is preceded by a related Select (and I would assume FetchNext), then the TK values are populated.
We are currently asking for an Enhancement SAR to populate the TK values with key fields as well as items from the WHERE clause (which are not currently populating).
But for now, I just want TT developers to be aware that events can be triggered when the keys are unknown, and developers should code accordingly.
Ben again