OraFAQ Forum: Forms » HOw to update only one item , if datablock update propery is false

Home » Developer & Programmer » Forms » HOw to update only one item , if datablock update propery is false

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOw to update only one item , if datablock update propery is false [message #87685]

Tue, 01 February 2005 02:29

gaurav dantre
Messages: 24
Registered: June 2004

Junior Member

Hello Friends
I have got the one problem .
due to some reason , i have to set the datablock update property false on when-new-record-instance.
but , i want to allow only one item , we can update .
how can be do this ???
datablock have a lot of item .
plz help me .
it's ursent .

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87686 is a reply to message #87685]

Tue, 01 February 2005 02:43

SANDY
Messages: 60
Registered: April 1998

Member

Hi,
U can do this by using update command on update button.

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87690 is a reply to message #87686]

Tue, 01 February 2005 04:14

gaurav dantre
Messages: 24
Registered: June 2004

Junior Member

thanks for reply,
but , i m not getting , what do u want to say ??
my problem is that . when i fetch the record from the database by pressing F8 key from the form .
that time when-new-record-instance trigger fire , So my block in not updatable . now i want to upadte
one text item .
what should i do ???
data block has a lot of item
plz help me

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87692 is a reply to message #87690]

Tue, 01 February 2005 04:44

SANDY
Messages: 60
Registered: April 1998

Member

Hi Friend,
ust do one thing, place Set_Block_Property('blockname',update_ALLOWED,PROPERTY_true); in pre-text-item and
Set_Block_Property('blockname',update_ALLOWED,PROPERTY_false); in post-text-item.
Cheers
Sandy

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87707 is a reply to message #87685]

Wed, 02 February 2005 20:46

Ritesh
Messages: 38
Registered: November 2001

Member

u can use set_item_instance_property built in.
see example from form Builder help.

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87719 is a reply to message #87692]

Thu, 03 February 2005 10:41

SANDY
Messages: 60
Registered: April 1998

Member

Hi,
u can also use SET_ITEM_INSTANCE_PROPERTY
to do so.
Cheers
Sandy

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87726 is a reply to message #87690]

Fri, 04 February 2005 01:44

SANDY
Messages: 60
Registered: April 1998

Member

Hi,
u can also use SET_ITEM_INSTANCE_PROPERTY
to do so.
Cheers
Sandy

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87742 is a reply to message #87690]

Sun, 06 February 2005 21:19

fanni
Messages: 96
Registered: March 2004

Member

One Method of Doing this can be
-------------------------------

simply use this code in the post query
set_item_property('Item1',update_allowed,property_false);
for all items other than the item u want to update.

Play with this property. it will solve your this problem.
Farhan

Report message to a moderator

Re: HOw to update only one item , if datablock update propery is false [message #87752 is a reply to message #87742]

Mon, 07 February 2005 04:13

gaurav dantre
Messages: 24
Registered: June 2004

Junior Member

Hi , sorry to say that ,
we can not apply this solution
because , datablock has 100 items
that's why we want to use another solution
Regards
Gaurav Dantre

Report message to a moderator

Previous Topic:	File required
Next Topic:	hi

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 05 22:31:50 CST 2025