show fields changed

[shu745]

Hi All,

I know there is a way but I don't know how to do it...
When users make updates to rows in a database, how can you tell exactly which fields were changed?

Thanks in advance!

 

[HimanB]

Hi,
For a Complete record you may make use of :System.Record_Status.
As for Item is concerned make use of built-in
Get_Item_Property('Blockname.Item_name',Database_value)

Also take a look at Get_item_property('Blockname.Item_name',Update_column) proertiy in Form builder Help.

HTH
Regards
Himanshu

 

[sem]

If you mean database, not form, you may compare :new and ld values in database trigger.

Regards, Dima

http://seminihin.narod.ru