OraFAQ Forum: Forms » A different color each record

Home » Developer & Programmer » Forms » A different color each record

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

A different color each record [message #360356]

Thu, 20 November 2008 11:01

MMA_EG_CAIRO
Messages: 25
Registered: August 2008

Junior Member

How can I make each record as the value of a particular color on one color fields of the table???

I hope the consideration of the attached files

Attachment: MODULE1.fmb
(Size: 248.00KB, Downloaded 1196 times)

Report message to a moderator

Re: A different color each record [message #360358 is a reply to message #360356]

Thu, 20 November 2008 11:03

MMA_EG_CAIRO
Messages: 25
Registered: August 2008

Junior Member

This Code

Attachment: Code.sql
(Size: 0.43KB, Downloaded 1294 times)

Report message to a moderator

Re: A different color each record [message #360381 is a reply to message #360358]

Thu, 20 November 2008 14:52

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

Senior Member
Account Moderator

SET_ITEM_INSTANCE_PROPERTY is what you should look for. This is one topic that shows how to do that; search for the rest, if you wish.

Report message to a moderator

Re: A different color each record [message #360421 is a reply to message #360356]

Thu, 20 November 2008 22:47

MMA_EG_CAIRO
Messages: 25
Registered: August 2008

Junior Member

It is clear that you were not considered example to, I mean that the subject be open, I mean, if we have a record of 100, each record contains a different color on the Register, the other in a particular field, Ertdja the same color on the Register.

I Bstkhaddm SET_ITEM_INSTANCE_PROPERTY, but when I try to modify the color of the Virtual Attr Ofujo that all records have the same capacity, to me to woo the previous period Mdokhne

See Code:

SET_VA_PROPERTY('VA',BACKGROUND_COLOR,:BALANCEDS.BALANCEDS_COLOR);
SET_ITEM_INSTANCE_PROPERTY('BALANCEDS.BALANCEDS_COLOR',CURRENT_RECORD,VISUAL_ATTRIBUTE,'VA');

Where you modify the color of the Virtual Attr based on field BALANCEDS.BALANCEDS_COLOR, and then sent to the VA current Register!!!

To see the picture attached, and you may imagine that each make a valuable Color Virtual Attr, even tried to make a programmatically using this Create_VA, but unfortunately are not there primarily

I wish you could have understood my

And I wish you could find a solution to this problem

Thanks

Attachment: Palete.JPG
(Size: 25.80KB, Downloaded 702 times)

[Updated on: Thu, 20 November 2008 22:54]

Report message to a moderator

Re: A different color each record [message #360440 is a reply to message #360421]

Fri, 21 November 2008 00:25

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

Senior Member
Account Moderator

Quote:

Ertdja the same color on the Register.

I Bstkhaddm SET_ITEM_INSTANCE_PROPERTY, but when I try to modify the color of the Virtual Attr Ofujo that all records have the same capacity, to me to woo the previous period Mdokhne

Quote:

I wish you could have understood my

I'm afraid that your wish will remain exactly that: a wish. Because, I have no idea what you are talking about /forum/fa/3314/0/

Report message to a moderator

Re: A different color each record [message #360482 is a reply to message #360356]

Fri, 21 November 2008 02:42

MMA_EG_CAIRO
Messages: 25
Registered: August 2008

Junior Member

My question is stupid for this class!!!

I'm sorry your group, but I am hard you VB6.0 programmer and I making all this, but now I do not know the solution to this problem.

Is not reasonable to make a 100 or 200 or more of the Virtual Attr, letter and color every time the appropriate value as listed.

I will have to shorten hard-to 20 color or 30 color Othbthm, but I was open Aizha

If there is no overall solution will have to use this method

Thanks

Report message to a moderator

Re: A different color each record [message #360495 is a reply to message #360482]

Fri, 21 November 2008 03:05

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

Senior Member
Account Moderator

What is the purpose of painting every record into its own color? As far as I'm concerned, two different colors should be enough. However, if you still want to create such a colorful form, I wouldn't know the other way, different from what I've already said.

Report message to a moderator

Re: A different color each record [message #360518 is a reply to message #360356]

Fri, 21 November 2008 04:36

MMA_EG_CAIRO
Messages: 25
Registered: August 2008

Junior Member

The main purpose of this question is that I designed a program for hotel bookings, I would like to offer rooms reserved and reserved rooms so that others Omisahm some.

Making the two colors, the first sign of the seizure, the second indication of the lack of custody.

But I want to include color unique to the non-attachment, and the rooms reserved acquire a distinctive color by the user, so that the process of discrimination.

Ommmmmmmmmm

But regardless of the objective, there may be some time requirement for this.

Thanks

Report message to a moderator

Re: A different color each record [message #363128 is a reply to message #360518]

Fri, 05 December 2008 02:56

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

hi,

while developing Hotel boooking application (exactly your requirement) it was made possible when creating pages through apex 3.1.2 oracle XE. sorry for belated reply.

Report message to a moderator

Re: A different color each record [message #382318 is a reply to message #360381]

Wed, 21 January 2009 23:02

amdabd
Messages: 91
Registered: November 2007
Location: My Computer

Member

hi all
actually

Littlefoot wrote on Thu, 20 November 2008 14:52

SET_ITEM_INSTANCE_PROPERTY is what you should look for. This is one topic that shows how to do that; search for the rest, if you wish.

is the answer that you seek for.

for the rest of your question, you need to use "If Condition" to select the appropriate V. Attribute.
for example

  if :sal <0 then
      set_item_instance_property('empno', current_record, visual_attribute, 'va1');
      set_item_instance_property('ename', current_record, visual_attribute, 'va1');
  else if :sal =0 then
      set_item_instance_property('empno', current_record, visual_attribute, 'va0');
      set_item_instance_property('ename', current_record, visual_attribute, 'va0');
  else if :sal >0 then
      set_item_instance_property('empno', current_record, visual_attribute, 'va2');
      set_item_instance_property('ename', current_record, visual_attribute, 'va2');
 end if;
 .
 .
 .;

where va0, va1, va2, .... your V. Attributes

always, thank you Littlefoot Smile

Report message to a moderator

Previous Topic:	Unable to access table from forms which is accessble using sql*plus.
Next Topic:	I am unable to insert image file while using BLOB Data type with the following code:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 26 10:28:03 CDT 2026