| how to know which record or records are changed in a form [message #277267] |
Mon, 29 October 2007 06:24  |
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 #277395 is a reply to message #277314] |
Mon, 29 October 2007 22:20  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
