Table Triggers

[Lightning_McQueen]

Hi List.

I'm trying to capture deletes to records in a table for auditing purposes. The problem I am finding is that, although the record DOES get deleted, I can't seem to capture any variables in the table event rules. Ideally, I wanted to get the key variables but when I use M & D Debug, the values are blank/zero. I've tried passing the TK value into a custom variable and that doesn't work. Any ideas? Thanks.

Nick B.

JDE OneWorld B7332 SP19.1
ES: Windows2000
DS: WinNT
Database: SQL Server 7.0

 

[JDETECHIE]

Even iam facing same problem. did any body has answer?

 

[JulienW]

Well, it works fine here on Xe SP18.1 ... when code is placed in the event 'Before record is deleted' of course.

 

[WhippingBoy]

Have you put the code through debug in MSVC? What does it show you?

 

[DBohner-(db)]

Julien is most likely correct - can you verify that you have your code in the before deleted?

db

 

[JDETECHIE]

Yes i did write my code before delete, but still same problem.i found some solution.
I am deleteing this recod from grid, but i haven't selected all fields in the grid. When i delete record it will get the values which i selected from fields on the grid. But even i tried to get the full record by FETCH SINGLE(before delete trigger) but still it won't fetch whole record.
So i selected remaining fields and hide them.