OraFAQ Forum: Forms » how can I find out only changed records

Home » Developer & Programmer » Forms » how can I find out only changed records (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can I find out only changed records [message #611814]

Wed, 09 April 2014 03:54

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

how can I find out only changed records
(Qty changed) in form when I use :System.record_status='CHANGED' it show all records in detail block

Report message to a moderator

Re: how can I find out only changed records [message #611816 is a reply to message #611814]

Wed, 09 April 2014 04:00

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

how can I find out only changed records
(Qty changed) in form when I use :System.record_status='CHANGED' in on update trigger it show all records in detail block

Report message to a moderator

Re: how can I find out only changed records [message #611817 is a reply to message #611816]

Wed, 09 April 2014 04:04

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

:System.record_status will only be CHANGED for changed records.
So either all the records are changed, or your code to check it is wrong.
Since you've supplied no details about what you are doing we can't say which is true.

Report message to a moderator

Re: how can I find out only changed records [message #611818 is a reply to message #611817]

Wed, 09 April 2014 04:08

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Dear Sir For Example a detail block have 25 rows and i am going to change only one or two rows i want trigger move table data into new table only record has been changed

Report message to a moderator

Previous Topic:	Passing DATA_PARAMETER in Oracle Reports 10g from Oracle Forms using RUN_REPORT_OBJECT
Next Topic:	How to refresh calling form (Parent form) when called form is closed.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 04 17:42:15 CST 2026