OraFAQ Forum: Forms » CHANGE THE PROPERTY OF ITEM DYNAMICALLY

Home » Developer & Programmer » Forms » CHANGE THE PROPERTY OF ITEM DYNAMICALLY (Oracle Form Builder 10g, Win XP)

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

CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500362]

Sun, 20 March 2011 02:02

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

Can i change the property of item dynamically in pl sql coding. Actually i want that whenever the user press some button then that field(textbox) become non-database item of the database block. put some value in it and press another button to restore its property like before.

is there any built-in function for doing this???

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500363 is a reply to message #500362]

Sun, 20 March 2011 02:13

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

No built-in function.Try SET_ITEM_PROPERTY Built-in.

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500364 is a reply to message #500363]

Sun, 20 March 2011 02:15

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

yes i know about set_item_property but did not find any to make the item property Database Item to false. any other way doing this??

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500368 is a reply to message #500364]

Sun, 20 March 2011 03:29

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

Senior Member
Account Moderator

I don't think that you can change that property.

What problem are you trying to solve, anyway?

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500370 is a reply to message #500368]

Sun, 20 March 2011 04:27

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

well, its a long story. let me cut it short for you Razz

actually, i m doing manual search on the same block which is showing record. The field is also database item. The functions work properly but the user has to Answer NO when ever he entered the value in the field to search. Because it is a database item and oracle ask user either to save a new record in the database. I want to get rid of this message. thats why i am asking to make that field non database and then database when the result is shown.

Anyways, I have done it the other way around. I was clearing the block by clear_block but not clearing the record by clear_record. Now that message is not displaying and i am get rid of that.

Thank you all for trying to help me out and reading my problem Smile

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500377 is a reply to message #500370]

Sun, 20 March 2011 07:33

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

Senior Member

How are you doing this search? What is wrong with using enter-query mode?

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500397 is a reply to message #500377]

Sun, 20 March 2011 12:08

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

Senior Member
Account Moderator

Right; it seems that the OP doesn't use Forms' built-in querying features (but reinvents the wheel).

How to perform query:
- enter query mode
- enter search criteria (that would be "enter value into the item you are talking about")
- execute query

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500407 is a reply to message #500397]

Sun, 20 March 2011 23:32

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

I dont know why is the issue with the built-in functions like enter query mode, execute query mode and cancel query mode. As these functions are not working that why i used manual coding to perform this stuff. Now it is working fine and let the things as it is.

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500418 is a reply to message #500407]

Mon, 21 March 2011 02:03

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

Senior Member
Account Moderator

You must have done something "wrong". If you created data block using the Wizard, it would work perfectly well and all built-in functionalities would do their job. Therefore, it might be that you "improved" something that violated these features.

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500576 is a reply to message #500418]

Tue, 22 March 2011 05:24

new_oracle2011
Messages: 174
Registered: March 2011
Location: Qatar

Senior Member

yes it may be like this. Actually i was not the one who built the form. I am asked only to add this functionality as built-in functions are not working. rather going from the start, I started thinking to create new code. Finding bugs in coding is hell difficult rather than writing code from the start. And i come up with 6-7lines code and the functions are there.

Report message to a moderator

Re: CHANGE THE PROPERTY OF ITEM DYNAMICALLY [message #500577 is a reply to message #500576]

Tue, 22 March 2011 05:27

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

Senior Member
Account Moderator

As you use Forms 10g, perhaps you could have run it in debug mode so that you'd see what is going on (and easier find the culprit).

Report message to a moderator

Previous Topic:	Pivot table is inside group
Next Topic:	Sending Email thru Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:09:17 CDT 2024