OraFAQ Forum: Forms » how to disable the item in the canvas, not display the values in that item

Home » Developer & Programmer » Forms » how to disable the item in the canvas, not display the values in that item

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

how to disable the item in the canvas, not display the values in that item [message #605905]

Thu, 16 January 2014 03:33

mist598
Messages: 1195
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
/forum/fa/11631/0/

/forum/fa/11631/0/

Thank You

Attachment: image1.png
(Size: 0.68KB, Downloaded 1319 times)

Report message to a moderator

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

Littlefoot
Messages: 21808
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".

Report message to a moderator

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

mist598
Messages: 1195
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.
/forum/fa/11632/0/

/forum/fa/11632/0/

Thank You

Attachment: image1.png
(Size: 0.60KB, Downloaded 1214 times)

Report message to a moderator

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

Littlefoot
Messages: 21808
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?

Report message to a moderator

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

mist598
Messages: 1195
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

Report message to a moderator

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

cookiemonster
Messages: 13920
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.

Report message to a moderator

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

mist598
Messages: 1195
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

Report message to a moderator

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

Littlefoot
Messages: 21808
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 ... /forum/fa/1580/0/

/forum/fa/1580/0/

Report message to a moderator

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

mist598
Messages: 1195
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.
/forum/fa/11633/0/

/forum/fa/11633/0/

Thank You

Attachment: image1.png
(Size: 2.54KB, Downloaded 1253 times)

Report message to a moderator

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

Littlefoot
Messages: 21808
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).

Report message to a moderator

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

mist598
Messages: 1195
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

Report message to a moderator

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

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

Senior Member

So disable it then.

Report message to a moderator

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

mist598
Messages: 1195
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?

Report message to a moderator

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

Littlefoot
Messages: 21808
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?

Report message to a moderator

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

mist598
Messages: 1195
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

Smile

Report message to a moderator

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

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

Senior Member

So does that mean that the item you thought wasn't disabled, actually is disabled?

Report message to a moderator

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

mist598
Messages: 1195
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

Report message to a moderator

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

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

mist598
Messages: 1195
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

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

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

mist598
Messages: 1195
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

Report message to a moderator

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

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

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thank You very much to helped me more, Thank You Littlefoot & cookiemonste Smile

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:06:41 CDT 2024