Re: updation on primary key ?????
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 15 Jan 2004 08:38:36 -0800
Message-ID: <1074184639.923291_at_yasure>
>
>
>
>
> 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
Date: Thu, 15 Jan 2004 08:38:36 -0800
Message-ID: <1074184639.923291_at_yasure>
Neil Emery wrote:
>>>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
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_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Jan 15 2004 - 17:38:36 CET