Home » Developer & Programmer » Forms » how to disable the item in the canvas, not display the values in that item
how to disable the item in the canvas, not display the values in that item [message #605905] Thu, 16 January 2014 03:33 Go to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

I want to disable the item , for this i set the properties of insert allowed, updated allowed as "NO", so it is working fine for me , but here org_code is the 1st item in the canvas & i don't want to show like below i image
./fa/11631/0/

Thank You
  • Attachment: image1.png
    (Size: 0.68KB, Downloaded 131 times)
Re: how to disable the item in the canvas, not display the values in that item [message #605908 is a reply to message #605905] Thu, 16 January 2014 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you want to DISABLE an item, why do you modify its INSERT and UPDATE properties? There's the ENABLED property which should be set to "No".
Re: how to disable the item in the canvas, not display the values in that item [message #605914 is a reply to message #605908] Thu, 16 January 2014 04:31 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Littlefoot,

Thank You for reply, I set the ENABLED Property as "NO" , it works for some records only.It disabled the item at some records only see below image & the record(value) displays with disabled mode.
./fa/11632/0/

Thank You
  • Attachment: image1.png
    (Size: 0.60KB, Downloaded 113 times)
Re: how to disable the item in the canvas, not display the values in that item [message #605915 is a reply to message #605914] Thu, 16 January 2014 04:41 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

it works for some records only


I just can't believe that.

Image you posted says that "Org.Code" item is disabled. You can't type anything in there.

Maybe "disabled" means something different to you? Could you explain it?
Re: how to disable the item in the canvas, not display the values in that item [message #605918 is a reply to message #605915] Thu, 16 January 2014 04:49 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Image you posted says that "Org.Code" item is disabled. You can't type anything in there

Yes.

Quote:
Image you posted says that "Org.Code" item is disabled. You can't type anything in there


Actually the data comes from the 2 different tables,means that copied from a to b &c to b, it is worked for a to b tables only . Disabled mode worked for 1 table records only and not for the 2nd table records.

Thank You
Re: how to disable the item in the canvas, not display the values in that item [message #605920 is a reply to message #605918] Thu, 16 January 2014 05:03 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
That just confuses things further. Database items are linked to a single column in a single table. So I have no idea what you mean.
Re: how to disable the item in the canvas, not display the values in that item [message #605921 is a reply to message #605920] Thu, 16 January 2014 05:08 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
That just confuses things further. Database items are linked to a single column in a single table. So I have no idea what you mean.


In my 3 tables same column names no relation between columns , i copied 2 tables 1 table.Is there any another properties for this please suggest me ?

Thank You
Re: how to disable the item in the canvas, not display the values in that item [message #605923 is a reply to message #605921] Thu, 16 January 2014 05:21 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I have no idea what you are saying.

mist598

In my 3 tables same column names no relation between columns , i copied 2 tables 1 table

3 tables, 2 tables, 1 table ... ./fa/1580/0/
Re: how to disable the item in the canvas, not display the values in that item [message #605924 is a reply to message #605923] Thu, 16 January 2014 05:28 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
1)Copied From Budget to Forecast Table
2)Copied From Sales to Forecast Table --> Worked for this only
Please see the image.
./fa/11633/0/

Thank You
  • Attachment: image1.png
    (Size: 2.54KB, Downloaded 103 times)
Re: how to disable the item in the canvas, not display the values in that item [message #605926 is a reply to message #605924] Thu, 16 January 2014 05:36 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does it mean that you
insert into forecast select * from budget;
insert into forecast select * from sales;

Then, you created a form which is based on the FORECAST table. You also set "Org.Code" item's ENABLED property to "No". As far as I'm concerned, that item is disabled for all records in the FORECAST table, regardless their origin. Unless, of course, you used SET_ITEM_PROPERTY and did some modifications; however, as you didn't mention that, I suppose you didn't do it).
Re: how to disable the item in the canvas, not display the values in that item [message #605927 is a reply to message #605926] Thu, 16 January 2014 05:55 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Then, you created a form which is based on the FORECAST table. You also set "Org.Code" item's ENABLED property to "No". As far as I'm concerned, that item is disabled for all records in the FORECAST table, regardless their origin


insert into forecast select * from sales, Data comes from sales table, in sales form the org_code is in the disabled mode.

insert into forecast select * from budget; --> Here the org_code is enabled in the budget table
Re: how to disable the item in the canvas, not display the values in that item [message #605930 is a reply to message #605927] Thu, 16 January 2014 06:10 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
So disable it then.
Re: how to disable the item in the canvas, not display the values in that item [message #605931 is a reply to message #605930] Thu, 16 January 2014 06:15 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
So disable it then.


So what is use of Enabled "NO"?, used for disabled right? then why not working here?
Re: how to disable the item in the canvas, not display the values in that item [message #605933 is a reply to message #605931] Thu, 16 January 2014 06:19 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you describe "why not working here"?

You posted a screenshot, but it doesn't show what you mean by saying that.

Can you click into that item and enter values?
Re: how to disable the item in the canvas, not display the values in that item [message #605934 is a reply to message #605933] Thu, 16 January 2014 06:26 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Can you click into that item and enter values?


No,not possible both are in the disabled mode.
Thank You for helped.. Smile
Re: how to disable the item in the canvas, not display the values in that item [message #605935 is a reply to message #605934] Thu, 16 January 2014 06:39 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
So does that mean that the item you thought wasn't disabled, actually is disabled?
Re: how to disable the item in the canvas, not display the values in that item [message #605936 is a reply to message #605935] Thu, 16 January 2014 06:48 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
So does that mean that the item you thought wasn't disabled, actually is disabled?


Yes. Why the value comes in disabled mode in the org_code as "CU1" , please see #605914.The use of property Enabled yes/no is either enabled or disabled mode, why it is not shown all the records in the disabled mode?

Thank You
Re: how to disable the item in the canvas, not display the values in that item [message #605938 is a reply to message #605936] Thu, 16 January 2014 06:54 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ENABLED property doesn't mean that you will (or will not) see a value in an item. Read about it in Forms Help.

Reason that fetches (or not) a value into that item depends on you. Check (in SQL*Plus) how that record looks like - I suspect that "Org.Code" is empty (i.e. NULL) for some records. Therefore, you can't expect to see something that doesn't exist.
icon13.gif  Re: how to disable the item in the canvas, not display the values in that item [message #605939 is a reply to message #605938] Thu, 16 January 2014 07:02 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
I got it now , yes, in sales table the org_code is null , that are records copied to sales table.If the record is available then only it shows in the disabled right? i mean not even insert , update to that column value..


insert into forecast select * from budget; --> org_code are having values
insert into forecast select * from sales; --> org_code are not having values

Thank You.. Smile

[Updated on: Thu, 16 January 2014 07:05]

Report message to a moderator

Re: how to disable the item in the canvas, not display the values in that item [message #605940 is a reply to message #605939] Thu, 16 January 2014 07:08 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ENABLED = NO (i.e. "disabled") means that you can only watch what's in there - you can't navigate to a disabled item, you can't modify its value, ... nothing. It is DISABLED.

Item's ENABLED state doesn't depend on column's value. NULL in it won't cause an item to become enabled or disabled.
Re: how to disable the item in the canvas, not display the values in that item [message #605945 is a reply to message #605940] Thu, 16 January 2014 07:17 Go to previous messageGo to next message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
ENABLED = NO (i.e. "disabled") means that you can only watch what's in there - you can't navigate to a disabled item, you can't modify its value, ... nothing. It is DISABLED.


Ok,if the records are there in that tables column, it shows in the disabled mode right?, if the records are null in that column it not shows only disable mode, right?

But in my forecast table , the org_code column having data na..

SQL> select distinct organization_code, fiscal_year from hope_forecast_data
  2  /

ORGANIZATION_CODE              FISCAL_YEAR
------------------------------ -----------
DET                                   2007
CU1                                   2008
CU1                                   2011
BRW                                   2011



Re: how to disable the item in the canvas, not display the values in that item [message #605946 is a reply to message #605945] Thu, 16 January 2014 07:26 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that I can't express myself clearly, sorry about that. I'll try once more:

If you set an item to be DISABLED, then it is DISABLED. No "if ...". It is just DISABLED. Full stop.
Re: how to disable the item in the canvas, not display the values in that item [message #605947 is a reply to message #605946] Thu, 16 January 2014 07:34 Go to previous message
mist598
Messages: 905
Registered: February 2013
Location: Hyderabad
Senior Member
Thank You very much to helped me more, Thank You Littlefoot & cookiemonste Smile


[EDITED by LF: removed huge font formatting]

[Updated on: Thu, 16 January 2014 07:38] by Moderator

Report message to a moderator

Previous Topic: oracle block item value copied
Next Topic: NEED ONLINE FREE TUTORIAL FOR ORACLE FORMS/REPORTS
Goto Forum:
  


Current Time: Sat Aug 30 02:10:23 CDT 2014

Total time taken to generate the page: 0.11935 seconds