Home » Developer & Programmer » Forms » how to know which record or records are changed in a form
how to know which record or records are changed in a form [message #277267] Mon, 29 October 2007 06:24 Go to next message
orarep
Messages: 56
Registered: September 2007
Member
Hello every one

i have oracle 8.1.7 and reports 6.0

i have two form form1 and form2 for two table tab1 and tab2 respectively. tab1 is parent table and have the following col

Class_no,name,father_name,address,status
Calss_no is primary key

and tab2 have the following cols

class_no,st1_mks,quiz1,quiz2,quiz3,TE
class_no is foreign key


now what i want is that in form1 on execute_query i display the whole reocrds or selection based records and now when user update some recods or a record so how i will know that which records are changed/updated i.e name or address is changed in form1 so i wnat to know whic is /are these records so i can write a update statement and update the same in tab2


plz help me as i really don't have any idea how to do it.




any help is always regarded

Re: how to know which record or records are changed in a form [message #277314 is a reply to message #277267] Mon, 29 October 2007 09:15 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

Try looking at SYSTEM.BLOCK_STATUS, that might be what you are looking for.
Re: how to know which record or records are changed in a form [message #277395 is a reply to message #277314] Mon, 29 October 2007 22:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No!! This is Oracle Forms not VB!! You don't need to worry about which record has been changed as YOU do not need to write 'insert', 'update', or 'delete' statements. They are all part of the native behaviour of Oracle Forms.

That's why you are using this tool. To save time and remove the need to write pages of code into which your subconscious mind will place bugs to train your conscious mind in how to program.

Just use the wizards provided by Forms and let it do the work for you.

David
Previous Topic: update and insert new records in a form
Next Topic: Difference between a Forms message and Forms Error
Goto Forum:
  


Current Time: Thu Dec 08 02:28:13 CST 2016

Total time taken to generate the page: 0.10111 seconds