OraFAQ Forum: Forms » How to update record

Home » Developer & Programmer » Forms » How to update record (oracle forms 10g ,win xp pack 2)

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

How to update record [message #573643]

Tue, 01 January 2013 16:42

goldray
Messages: 108
Registered: December 2012

Senior Member

Hi ,
i want to update record when i press the boutton "update" but i don't have idea ,if i will create a new forms ,or new block or the update is made in the same form Shocked

s
Any ideas ??
thank you

Report message to a moderator

Re: How to update record [message #573645 is a reply to message #573643]

Tue, 01 January 2013 17:46

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why do you need a button? What's wrong with the forms default update functionality?

Report message to a moderator

Re: How to update record [message #573646 is a reply to message #573645]

Tue, 01 January 2013 18:03

goldray
Messages: 108
Registered: December 2012

Senior Member

how do I make default update functionality ??

[Updated on: Tue, 01 January 2013 18:11]

Report message to a moderator

Re: How to update record [message #573647 is a reply to message #573646]

Tue, 01 January 2013 20:41

goldray
Messages: 108
Registered: December 2012

Senior Member

hi ,
how to render not-editable item(its value unchanged) when i press a boutton ??

[Updated on: Tue, 01 January 2013 20:42]

Report message to a moderator

Re: How to update record [message #573653 is a reply to message #573647]

Wed, 02 January 2013 00:05

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You don't have to do anything to "make default update functionality". Both Cookiemonster and I told you what to do; how come you didn't follow these advices?

A non-editable item? Open its Property Palette and set its "Enabled" property to NO. Alternatively, you can modify "Insert Allowed" and "Update Allowed" properties.

Seriously, stop programming blindly. First read some documentation and save you (and us) from pain because - this isn't funny at all.

Report message to a moderator

Re: How to update record [message #573877 is a reply to message #573653]

Thu, 03 January 2013 15:11

goldray
Messages: 108
Registered: December 2012

Senior Member

Hi,
I consulted many documenatation but i don't found how to make item unchanged ...this item should be enabled to display value but it's should be locked !!!(it can not be changed )
best regards Smile

Report message to a moderator

Re: How to update record [message #573883 is a reply to message #573877]

Thu, 03 January 2013 17:00

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

And Littlefoot has just told you how to do that

Report message to a moderator

Re: How to update record [message #573886 is a reply to message #573883]

Thu, 03 January 2013 18:47

goldray
Messages: 108
Registered: December 2012

Senior Member

I will rephrase my question:
i want to change the type of item (text_item to display_text) using " set_item_property " in the trigger "when-new-form-instance "!!
it's possible ?

[Updated on: Thu, 03 January 2013 19:27]

Report message to a moderator

Re: How to update record [message #573896 is a reply to message #573886]

Fri, 04 January 2013 00:05

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Consult that many documentation again; I believe it describes which parameters SET_ITEM_PROPERTY accepts.

Anyway, it is impossible to change item's type. However, its ENABLED property can be set to FALSE (with SET_ITEM_PROPERTY) which would have the same effect.

[Updated on: Fri, 04 January 2013 00:05]

Report message to a moderator

Re: How to update record [message #573928 is a reply to message #573896]

Fri, 04 January 2013 05:51

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you actually looked at form builder online help at all?
Open form builder. Press F1 to bring up help.
Type set_item_property into the search box.
Select the topic that's displayed as a result.
Read.

It tells you exactly what it does with examples.

Report message to a moderator

Re: How to update record [message #573979 is a reply to message #573928]

Fri, 04 January 2013 12:50

goldray
Messages: 108
Registered: December 2012

Senior Member

thank you very much, and I am so sorry for the disturbance !!

Report message to a moderator

Previous Topic:	system time
Next Topic:	forms 10g error in writing to directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 22:45:28 CDT 2024