| FORMS 6I: UPDATE PROBLEM [message #81496] |
Mon, 24 February 2003 01:27  |
dona
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
I am having problem with updation of primary key
of master block if there are foreign keys in the detail
block. Do I need to code trigger ON_Update for this?
|
|
|
|
| Re: FORMS 6I: UPDATE PROBLEM [message #81499 is a reply to message #81496] |
Mon, 24 February 2003 05:37  |
Venky
Messages: 52
Registered: October 2001
|
Member |
|
|
|
You are not supposed to update primary key values. The general logic is either the whole row would be deleted and re-inserted again with modified values. But nowhere in the application the primary key would be updated and that too if it has child records updating the primary key is like violating the rules.
|
|
|
|
| Re: FORMS 6I: UPDATE PROBLEM [message #81541 is a reply to message #81499] |
Fri, 28 February 2003 06:02 |
Praveen Kumar
Messages: 21
Registered: December 2001
|
Junior Member |
|
|
|
Eventhough, you have Foreign key in Detail Block, for that primary key, no child records are available, then you can update primary key. Except this any other condition, voilates the Database rules.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
