Identify which field has been modify in table

vijay_g

Hi
can any body help me out in finding the paticular modified field in table.(i.e if i modify UOM then changed field (i.e unit of measure )is reflect on modify trigger.)

MBerger

there are 2 ways : you can check Currfieldno, this has the number of the field the USER changed. it is NOT filled when changing something via code. teh other way is comparing every field in Rec with the same in xRec in the OnModify trigger

vijay_g

How it will work..?
i have just put message('%1',CurrFieldNo) on modify trigger of item table and at run time i am modifying to description then system returns 0 why? ](*,)

MBerger

vijay_g wrote:

How it will work..?
i have just put message('%1',CurrFieldNo) on modify trigger of item table and at run time i am modifying to description then system returns 0 why? ](*,)

Like i stated, CurrfieldNo only has the value of the (originally) changed field when it is done by a user via a form. look it up in the helpfile !

vijay_g

it has solved thxxxx