I agree it can be confusing, particularly for those of us translating between PB and JSON.

From what I've seen, JSON encodes an RGB color value like this: #RRGGBB, or as a 32-bit integer in hexadecimal, 0x00RRGGBB. You can see this in the following link:

https://github.com/bahamas10/css-color-names/blob/master/css-color-names.json

The byte ordering is reversed from what we know and expect in PB, where an RGB color value is represented in a 32-bit integer in hexadecimal as 0x00BBGGRR.

Look at the color value for Red in that web page: #ff0000, or 0x00FF0000, In PB, Red is 0x000000FF.

 Thus, Rene is correct in that you must re-order the RR, GG, BB bytes in a JSON color value to be able to properly translate them to a value that PB understands.

René Ullrich

Agreed.   My code for conversion

Function of_torgb(value string as_value, ref long al_red, ref long al_green, ref long al_blue)

Long		al_value

al_value = of_tolong(as_value)

al_blue = al_value / 65536
al_value = Mod (al_value, 65536)
al_green = al_value / 256
al_red = Mod (al_value, 256)

Return


Function of_tolong(value string as_hex)

String 		ls_hex	
Integer 	li_loop,li_length
Long 		ll_result = 0

li_length 	= len(as_hex)
ls_hex 		= Upper(as_hex)

FOR li_loop = 1 to li_length																
   ll_result += ( Pos ( '123456789ABCDEF', mid ( ls_hex, li_loop, 1 ) ) * &
						( 16 ^  ( li_length - li_loop ) ) )
NEXT

RETURN ll_result
																			

1.  For #C8D3DF,  I get RGB(223, 211, 200) from the above code, but the site https://www.rapidtables.com/convert/color/hex-to-rgb.html give RGB(200, 211, 223).   Which one is correct?

2.  Setting background color for Window & StaticText object gives two different colors for values #C8D3DF and RGB(223, 211, 200)  or 13161439.  Why ?

Probably somewhere either the code is wrong and the website link is wrong in the conversion.  And / Or the color settings in Powerbuilder for window and static field may also be wrong.  

RGB function converts RGB-values into a long value in this way (see help for RGB function):

Thanks René Ullrich

I've sent modified project with theme settings.

In the theme.json file I've set the window background color to #C8D3DF, which reflects in Window as Greyish color.

for the two static text field, I've set 

This.Backcolor = RGB(223, 211, 200)   And
This.backcolor = 13161439

Which is not greyish.

Any thing wrong I'm doing?

RGB(200, 211, 223) = 14668744 = #DFD3C8

RGB(223, 211, 200) = 13161439 = #C8D3DF

I've attached a test application, developed in PB 2019 R3

Thanks John Fauss

Yes, a hexadecimal value to long should do.   I've Chris code [STD Framework] to convert that and it works fine.

The issue is we get different colors on different method of assignment.   

Hex value:  #C8D3DF
To Long:     13161439
To RGB:     RGB(200, 211, 223)

The code

This.BackColor = RGB(200, 211, 223)
This.Backcolor = 13161439

Both the above code gives two different colors.  

What wrong I'm doing?  

Happiness Always
BKR Sivaprakash

Are you asking how to convert a hexadecimal value in string form to a PB Long datatype?