Home » Developer & Programmer » Forms » how can I find out only changed records (Forms 6i)
how can I find out only changed records [message #611814] Wed, 09 April 2014 03:54 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13967
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 21 15:08:52 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.