updation on primary key ?????

[KULJEET]

the default property of block level of updation
is
Update Changed Columns Only property=NO
it means when u will update only one field in form.
and oracle will update all column of table
ALSO UPDATE PRIMARY KEY (OH NOOOOOOOOOOO)
IT MEANS IT WILL LOCK ON CHILD TABLES ;

IS THIS BEHAIVOUR IS OK IN LARGE APPLICATION???????????????
PLZ GUIDE

THANKS
kuljeet pal singh

[Daniel Morgan]

KULJEET wrote: the default property of block level of updation is Update Changed Columns Only property=NO it means when u will update only one field in form. and oracle will update all column of table ALSO UPDATE PRIMARY KEY (OH NOOOOOOOOOOO) IT MEANS IT WILL LOCK ON CHILD TABLES ; IS THIS BEHAIVOUR IS OK IN LARGE APPLICATION??????????????? PLZ GUIDE THANKS kuljeet pal singh

This behavior is one that should ALWAYS be changed.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Neil Emery]

> > Update Changed Columns Only property=NO it means when u will update only one field in form. and oracle will update all column of table
This behavior is one that should ALWAYS be changed. -- Daniel Morgan

Dan,

Just Curious.

Why do you say this, as it contradicts the help in the forms
documentation?

i have considered this for a forms 6i OLTP(primarily) application
running over the web to
reduce network traffic (we dont use longs or images in the database)

Cheers,

Neil

[Daniel Morgan]

Neil Emery wrote:
Update Changed Columns Only property=NOit means when u will update only one field in form.and oracle will update all column of tableThis behavior is one that should ALWAYS be changed.--Daniel Morgan Dan, Just Curious. Why do you say this, as it contradicts the help in the forms documentation? i have considered this for a forms 6i OLTP(primarily) application running over the web to reduce network traffic (we dont use longs or images in the database) Cheers, Neil

For just the reason the OP stated ... it updates the primary key.
Consider the implication with respect to locking and overhead. There is
no value from updating fields that were not modified ... and a very
heavy cost.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)