OraFAQ Forum: Forms » Color property to a particular record

Home » Developer & Programmer » Forms » Color property to a particular record

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

Color property to a particular record [message #627730]

Sat, 15 November 2014 08:13

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

Hai

How to assign a colour property to a particular record in a particular field in a column.

Regards.

Report message to a moderator

Re: Color property to a particular record [message #627734 is a reply to message #627730]

Sat, 15 November 2014 08:34

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

Senior Member
Account Moderator

Quote:

a particular record in a particular field in a column

This doesn't make much sense.

Anyway: do you use Oracle? If so, which version? Which tool do you use (SQL*Plus? I don't think so. Forms? Apex? Something else?). Could you describe what you are trying to do using more than a single incomprehensible statement? A screenshot (or even a drawing) could also help.

Report message to a moderator

Re: Color property to a particular record [message #627735 is a reply to message #627730]

Sat, 15 November 2014 08:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

avinash reddy wrote on Sat, 15 November 2014 06:13

Hai

How to assign a colour property to a particular record in a particular field in a column.

Regards.

MyWorld := BLUE;

Report message to a moderator

Re: Color property to a particular record [message #627736 is a reply to message #627735]

Sat, 15 November 2014 09:00

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

Hi little foot,
i need to change the colour of a selected field font.

Solomon Yakobson - deleted confidential data image.

[Updated on: Sat, 15 November 2014 11:06] by Moderator

Report message to a moderator

Re: Color property to a particular record [message #627737 is a reply to message #627736]

Sat, 15 November 2014 09:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: Color property to a particular record [message #627738 is a reply to message #627737]

Sat, 15 November 2014 09:08

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

can i write a query in this way
select CONCATENATED_ADDRESS from HZ_LOCATIONS where CONCATENATED_ADDRESS = '...'.

and here i have a problem that how can i assign a colout to '...'

[mod-edit: confidential information removed per original poster's request and replaced with ... by bb]

[Updated on: Mon, 17 November 2014 13:06] by Moderator

Report message to a moderator

Re: Color property to a particular record [message #627740 is a reply to message #627738]

Sat, 15 November 2014 09:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

We only know what you post.

So far I am not convinced that any Oracle database is involved.
Picture shows some GUI presenting some data.
Is GUI off the shelf software or proprietary application?
GUI controls how the data is presented to the user; regardless on the underlying data store like Oracle database.

Report message to a moderator

Re: Color property to a particular record [message #627741 is a reply to message #627736]

Sat, 15 November 2014 09:58

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

I hope that is not live customer data you just put on the internet for the entire world to see ....

Unfortunately, I googled a few of those entries, and it appears that you DID put live customer data on the internet for the entire world to see ... Shocked

You've got bigger problems than the color of a field on some unknown application ...

Report message to a moderator

Re: Color property to a particular record [message #627742 is a reply to message #627741]

Sat, 15 November 2014 10:11

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@OP, it is not clear whether you want to display the result set in some coloured format on an application or any GUI based client tool like SQL Developer, PL/SQL Developer, TOAD etc. Or for that matter even SQL*Plus. The prior depends on your application, the latter I don't know. Please clarify.

The worst case is that you are thinking to store the data itself in that way, if yes, then it makes no sense.

Edit :

Just to add, the data is not stored in the database the way we see it. The format is only for display for human beings to make it easy to see and understand.

Regarding storing data in a particular format(colour in your case), I can give an example of the myth about storing a date in particular format, however, Ed Stevens has already mastered it to explain beautifully. I see he has already posted a reply, so he would be a better person than me to explain this example(if required Wink

)

[Updated on: Sat, 15 November 2014 10:25]

Report message to a moderator

Re: Color property to a particular record [message #627744 is a reply to message #627741]

Sat, 15 November 2014 10:24

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

If u are a Moderator please delete the image attached.. Please Help..!!

Report message to a moderator

Re: Color property to a particular record [message #627745 is a reply to message #627744]

Sat, 15 November 2014 10:26

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

So you mean you did not read the forum posting guidelines, isn't it?

Anyway, can you please add an explanation to your request to remove your post please. I see Ed made you aware of something.

[Updated on: Sat, 15 November 2014 10:29]

Report message to a moderator

Re: Color property to a particular record [message #627746 is a reply to message #627745]

Sat, 15 November 2014 10:28

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

Unfortunately yes

Report message to a moderator

Re: Color property to a particular record [message #627747 is a reply to message #627746]

Sat, 15 November 2014 10:33

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I see you have already reported it too to moderators. If you don't mind, can you quote the line from our posting guidelines stating about removing a post on request by OP.

Report message to a moderator

Re: Color property to a particular record [message #627748 is a reply to message #627730]

Sat, 15 November 2014 10:49

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

avinash reddy wrote on Sat, 15 November 2014 08:13

Hai

Please remove this post as it contains confidential information on request by OP.

Regards.

Report message to a moderator

Re: Color property to a particular record [message #627749 is a reply to message #627730]

Sat, 15 November 2014 11:02

John Watson
Messages: 8930
Registered: January 2010
Location: Global Village

Senior Member

Just a note to other responders: OP is using EBS. HZ_LOCATIONS is table in the AR schema, and that screen shot looks like a standard EBS form.

Avinash, what are you trying to do? Design your own form? Design a report? Write a query that you'll run with SQL*Plus?

Report message to a moderator

Re: Color property to a particular record [message #627750 is a reply to message #627738]

Sat, 15 November 2014 11:36

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

avinash reddy wrote on Sat, 15 November 2014 09:08

can i write a query in this way
select CONCATENATED_ADDRESS from HZ_LOCATIONS where CONCATENATED_ADDRESS = '<redacted>'.

and here i have a problem that how can i assign a colout to '<redacted>'

YOu may have deleted the image, but you still left confidential information in text.

And just a note for the future .. coming back after the fact to remove confidential information may very well be too late. There are all kinds of web-crawlers out there constantly harvesting information from web sites. And once it is harvested, there is nothing you can do about it.

Report message to a moderator

Re: Color property to a particular record [message #627751 is a reply to message #627750]

Sat, 15 November 2014 11:41

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@Ed, +1.

Perhaps the content is removed from here, however, as we very well know about the plagiarism, not sure if it would be removed from those sites too.

Report message to a moderator

Re: Color property to a particular record [message #627763 is a reply to message #627751]

Sat, 15 November 2014 16:03

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

Senior Member
Account Moderator

EBS? That might be a form developed by Oracle Forms (didn't see the screenshot). If that's so, see whether SET_ITEM_PROPERTY with VISUAL_ATTRIBUTE does any good.

Report message to a moderator

Re: Color property to a particular record [message #627775 is a reply to message #627763]

Sun, 16 November 2014 04:54

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Yes Sir @Littlefoot is right VISUAL_ATTRIBUTE shall be the best option see in the screen shot

Attachment: highlighted_visual_attribute.PNG
(Size: 91.23KB, Downloaded 760 times)

Report message to a moderator

Re: Color property to a particular record [message #627776 is a reply to message #627775]

Sun, 16 November 2014 05:07

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

as far as concern particular field for that also same "VISUAL_ATTRIBUTEs"

Attachment: particular_field.PNG
(Size: 71.60KB, Downloaded 752 times)

Report message to a moderator

Re: Color property to a particular record [message #627874 is a reply to message #627776]

Mon, 17 November 2014 12:45

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

Hi all,
Here is my actual requirement that need to change color of customer addresses which is in Bill To but when i do it in the form personalisation it is affecting to both Bill To and Ship To Addresses. But, here i need only that the color would affected to Customer Bill To Addresses. And also the Addresses column has too many records.
Addresses column name is CONCATENATED_ADDRESS, Block name is ADDR and Table name is AR_ADDRESSES_V.
Well i have been done it in the OM -> Customers -> Standard Form.
Thanks in advance!

Report message to a moderator

Re: Color property to a particular record [message #627875 is a reply to message #627738]

Mon, 17 November 2014 12:47

avinash reddy
Messages: 8
Registered: November 2014

Junior Member

avinash reddy wrote on Sat, 15 November 2014 09:08

can i write a query in this way
select CONCATENATED_ADDRESS from HZ_LOCATIONS where CONCATENATED_ADDRESS = '....'

and here i have a problem that how can i assign a colout to '...'
please remove this query as soon as possible on request of OP.

[mod-edit: confidential information replaced with ... by bb]

[Updated on: Mon, 17 November 2014 13:11] by Moderator

Report message to a moderator

Re: Color property to a particular record [message #627880 is a reply to message #627874]

Mon, 17 November 2014 14:03

John Watson
Messages: 8930
Registered: January 2010
Location: Global Village

Senior Member

Avinash, it looks as though you are trying to customize EBS. Are you following the CEMLI standards, or are you just hacking? You might want to look up RICE and AIM as well. If you do not recognize those acronyms, you need to stop what you are doing right now, and research them. Customizing EBS is something that you should not do without following the standards or the long term results will be disastrous.

Report message to a moderator

Previous Topic:	How to Dynamically Populate a Poplist in the List item
Next Topic:	When I try to run a form I am getting the below error, FRM: 40735 When window activated trigger rais

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 22:02:28 CDT 2024