Is it possible to do any calculation on DFF or KFF or these are informative fields, and How do you search for specific DFF or KFF?

  • Interview Candidate
  • 1
  • 3530

Editorial / Best Answer

rams.regalla  

  • Member Since Jun-2007 | Jun 20th, 2007

Hi,
Its possible to do calculations on KFF or DFF columns.

But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.

Calculations coding should be done in 'PRE-INSERT' or 'WHEN-VALIDATE-RECORD' triggers.

eg: In PRE-INSERT trigger

:M_RECEIPTS.ATTRIBUTE3=:M_RECEIPTS.ATTRIBUTE1+:M_RECEIPTS.ATTRIBUTE2

hope it helps

Showing Answers 1 - 1 of 1 Answers

rams.regalla

  • Jun 20th, 2007
 

Hi,
Its possible to do calculations on KFF or DFF columns.

But calculations on KFF or DFF columns are not effective in WHEN-NEW-ITEM-INSTANCE' or 'WHEN-VALIDATE-ITEM' triggers.

Calculations coding should be done in 'PRE-INSERT' or 'WHEN-VALIDATE-RECORD' triggers.

eg: In PRE-INSERT trigger

:M_RECEIPTS.ATTRIBUTE3=:M_RECEIPTS.ATTRIBUTE1+:M_RECEIPTS.ATTRIBUTE2

hope it helps

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions