Home » Developer & Programmer » Forms » How to Find Updated Rows in Oracle Forms 10 g (Windows)
How to Find Updated Rows in Oracle Forms 10 g [message #661143] Thu, 09 March 2017 01:06 Go to next message
qanita786
Messages: 227
Registered: May 2007
Location: PAKISTAN
Senior Member
How to Find Updated Rows in Oracle Forms 10 g for example i have a master & Detail Blocks Detail Block Have 10 rows
i will change only 1 row out of 10 how is it possible to find only 1 updated rows in forms 10g

Regards

Faheem
Re: How to Find Updated Rows in Oracle Forms 10 g [message #661155 is a reply to message #661143] Thu, 09 March 2017 03:48 Go to previous messageGo to next message
cookiemonster
Messages: 13870
Registered: September 2008
Location: Rainy Manchester
Senior Member
You'd need to loop through all the rows in the block and check their record_status.

Why do you need to know?
Re: How to Find Updated Rows in Oracle Forms 10 g [message #661158 is a reply to message #661155] Thu, 09 March 2017 04:40 Go to previous message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
And, of course, it (loop & record status) works in the current form instance. If you exit the form and run it again, you won't know which records you modified previously unless there's the indicator stored within the table, and that's doubtful too because - what would it be? 0/1? Out of (for example) seven 1's, how will you know which ones you modified recently? Date? How will you know which ones you modified the last time you did the modification? You might have done it in a quite large time span.

So, yes, why do you need to know?
Previous Topic: How to disable printscreen key in forms10
Next Topic: change records visual attribute depending on certain conditions
Goto Forum:
  


Current Time: Fri Apr 10 05:54:02 CDT 2020