Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 29 JUN 2023 04:49:52AM Barry Stevens wrote:

On the Applicaton Setting for the account there is a setting for default form backcolor', where is this value stored. I cant see it in fld 53 of the ENV_<appid> record. (Equ ENV_WIN_BACKCOLOR_VALUES$ to 53) A colour is showing in the Applicaton Setting form display. </QUOTE> —- === At 29 JUN 2023 05:39PM Barry Stevens wrote: === <QUOTE> <QUOTE>On the Applicaton Setting for the account there is a setting for default form backcolor', where is this value stored.

I cant see it in fld 53 of the ENV_<appid> record. (Equ ENV_WIN_BACKCOLOR_VALUES$ to 53)

A colour is showing in the Applicaton Setting form display.

using:

EnvironColours	= Get_Env(ENV_WIN_BACKCOLOR_VALUES$)

</QUOTE>


At 29 JUN 2023 06:38PM Carl Pates wrote:

All Application (not Database Environment) Settings are stored in the application's SYSAPPS record.

SYSAPPS records are encrypted - use the Get_App_Info stored procedure to access their contents.

Equates for SYSAPPS are found in REPOSITORY_EQUATES.

Carl Pates


At 29 JUN 2023 06:55PM Barry Stevens wrote:

All Application (not Database Environment) Settings are stored in the application's SYSAPPS record.

SYSAPPS records are encrypted - use the Get_App_Info stored procedure to access their contents.

Equates for SYSAPPS are found in REPOSITORY_EQUATES.

Carl Pates

Thank you.

Is there a document somewhere on all the compatibilty changes required.


At 29 JUN 2023 07:07PM Donald Bakke wrote:

On the Applicaton Setting for the account there is a setting for default form backcolor', where is this value stored. I cant see it in fld 53 of the ENV_<appid> record. (Equ ENV_WIN_BACKCOLOR_VALUES$ to 53) A colour is showing in the Applicaton Setting form display.</QUOTE> using: <code> EnvironColours = Get_Env(ENV_WIN_BACKCOLOR_VALUES$) </code> </QUOTE> Oddly enough we just ran into this with a migration we are currently working on. The original code pulled the default backcolor from the environment record and used the value to update the color scheme in areas not updated by OI automatically. In OI 10 these colors were coming out as black yet the OI forms were still getting their custom background colors. We quickly figured out that OI 10 relocated the location of the background colors but did not realize that <53> was cleared out as a result of the migration. This resulted in the code using a color that is essentially 0 (i.e., Black). Don Bakke SRP Computer Solutions, Inc. </QUOTE> —- === At 29 JUN 2023 11:01PM Barry Stevens wrote: === <QUOTE> <QUOTE> <QUOTE> <QUOTE>On the Applicaton Setting for the account there is a setting for default form backcolor', where is this value stored.

I cant see it in fld 53 of the ENV_<appid> record. (Equ ENV_WIN_BACKCOLOR_VALUES$ to 53)

A colour is showing in the Applicaton Setting form display.

using:

EnvironColours	= Get_Env(ENV_WIN_BACKCOLOR_VALUES$)

Oddly enough we just ran into this with a migration we are currently working on. The original code pulled the default backcolor from the environment record and used the value to update the color scheme in areas not updated by OI automatically. In OI 10 these colors were coming out as black yet the OI forms were still getting their custom background colors. We quickly figured out that OI 10 relocated the location of the background colors but did not realize that <53> was cleared out as a result of the migration. This resulted in the code using a color that is essentially 0 (i.e., Black).

Don Bakke

SRP Computer Solutions, Inc.

@DonBakke

I have posted in beta issues that the migration should move them to the new positions.

</QUOTE>


At 29 JUN 2023 11:41PM Barry Stevens wrote:

On the Applicaton Setting for the account there is a setting for ''default form backcolor', where is this value stored.

I cant see it in fld 53 of the ENV_<appid> record. (Equ ENV_WIN_BACKCOLOR_VALUES$ to 53)

A colour is showing in the Applicaton Setting form display.

using:

EnvironColours	= Get_Env(ENV_WIN_BACKCOLOR_VALUES$)

Oddly enough we just ran into this with a migration we are currently working on. The original code pulled the default backcolor from the environment record and used the value to update the color scheme in areas not updated by OI automatically. In OI 10 these colors were coming out as black yet the OI forms were still getting their custom background colors. We quickly figured out that OI 10 relocated the location of the background colors but did not realize that <53> was cleared out as a result of the migration. This resulted in the code using a color that is essentially 0 (i.e., Black).

Don Bakke

SRP Computer Solutions, Inc.

@DonBakke

I have posted in beta issues that the migration should move them to the new positions.

@CarlPates

Sorry Carl, I have emailed you with screenshots.

Your advise is not working for me.


At 30 JUN 2023 04:56AM Carl Pates wrote:

Get_App_Info requires the ID of the application record to extract:

   appRec = get_app_info( @appid<1>, FALSE$ )



   bkFrom = appRec<SYSAPPS_FORM_BKCOLOR_FROM$>

   bkTo   = appRec<SYSAPPS_FORM_BKCOLOR_TO$>

Carl Pates


At 30 JUN 2023 04:59AM Carl Pates wrote:

»I have posted in beta issues that the migration should move them to the new positions.

It does (Don has confirmed above).

Carl Pates


At 30 JUN 2023 04:15PM Barry Stevens wrote:

»I have posted in beta issues that the migration should move them to the new positions.

It does (Don has confirmed above).

Carl Pates

Just replied now on beta issues.

I should probably say now it is the other edittable colours that dont come accross.


At 06 JUL 2023 07:49AM Carl Pates wrote:

OK - there isn't a true 1-1 correspondence with all of the edit table colors so I've mapped the following in the migration proc - the update is in v10.2.1

            equ env_FOCUSCELL_FONT$            to 58 ; // Not supported

            equ env_FOCUSCELL_FGCOLOR$         to 59 ; // <-- SYSAPPS_FOCUSFGCOLOR$

            equ env_FOCUSCELL_BGCOLOR$         to 60 ; // <-- SYSAPPS_FOCUSBKCOLOR$

            equ env_FOCUSCELL_SELECT_FGCOLOR$  to 61 ; // Not supported

            equ env_FOCUSCELL_SELECT_BGCOLOR$  to 62 ; // Not supported

            equ env_FOCUSCELL_RECTSTYLE$       to 63 ; // <-- SYSAPPS_CELLFOCUSRECTSTYLE$

            equ env_FOCUSCELL_RECTWEIGHT$      to 64 ; // <-- SYSAPPS_CELLFOCUSRECTWEIGHT$

            equ env_FOCUSCELL_RECTCOLOR$       to 65 ; // <-- SYSAPPS_CELLFOCUSRECTCOLOR$

Note also that the Focus colors apply to all controls - not just edit table cells in v10 (See the SYSTEM FOCUSSTYLES property)

Carl Pates

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/9cfc5b760419a3499bf85896cd31b91c.txt
  • Last modified: 2024/12/10 16:16
  • by 127.0.0.1