fglprofile.std

fglprofile.std is a Lycia configuration file that allows configuring database interfaces as well as setting certain global defaults for Lycia applications.

Querix Package Manager doesn't create fglprofile.std.

By default, Lycia comes with these settings:

• oid is set for the ROWID emulation for PostgreSQL databases,

• none is set for the ROWID emulation for Oracle databases,

• temporary tables are dealt as native with Oracle databases,

• default escape clauses for LIKE are forbidden with Oracle databases

• BYTE fields are bound to the Oracle's BLOB data type
• TEXT fields are bound to the Oracle's CLOB data type

If you want to changes these or set other database configurations and global defaults for Lycia applications, you can be done by means of fglprofile.std.

How to create fglprofile.std

To create custom fglprofile.std, please follow these steps:

Step 1. Open your favorite text editor.

Step 2. Copy the template given below to a new text file.

Step 3. Uncomment variables and/or options you need and chose one of their available values.

Variables and options are described below – in the Structure section.

Step 4. Name this file fglprofile.std and save it.

We recommend using these folders to save your custom configuration files:

C:\Program Files\Querix\Lycia\etc

/opt/Querix/Lycia/etc

If this default folder doesn't suit your development and production needs, you can store your custom configuration files in any other location.

If you to want to store your fglprofile.std separately from other configuration files, you can specify this location by setting the FGLPROFILE environment variable:

FGLPROFILE=C:\Program Files\Querix\my_configs\fglprofile.std

If you want to store your fglprofile.std together with your other configuration files but in a non-default folder, you must set this non-default folder in LYCIA_CONFIG_PATH.

Once created, you can edit and delete your fglprofile.std as any other file on your machine.

Template for your fglprofile.std

Click here to see the template.

########################################

# Environment

########################################

# You can specify the master environment here.

# NOTE: This will override any settings in the process environment

#

# system.environment.dbdate = "mdy4/"

# system.environment.dbformat = "$:,:.:"

# system.environment.dbmoney = "$,"

# system.environment.dbcentury =

# system.environment.dbtemp = "/tmp"

# system.environment.dbdelimiter = "|"

########################################

# GUI Layout options

########################################

# When sending a form to the client, the runtime will split strings based

# on the amount of whitespace encountered, or key characters.

#

# This is to allow rational positioning of form objects when working with

# proportional fonts.

# These characters will force the creation of a new string

# gui.layout.break.start = "*=+-"

# These characters will terminate the current string

# gui.layout.break.end = ":"

# This is the maximum length of whitespace allowed in a string

# gui.layout.break.max_spaces = 1

#########################################

# Database Interfaces (Postgres)

#########################################

# Rowid emulation:

# dbi.postgresql.rowid = oid | emulate | none

#########################################

# Database Interfaces (Oracle)

#########################################

# Rowid emulation:

# dbi.oracle.rowid = emulate | none

#

# Temporary tables:

# dbi.oracle.temp = native | emulate

#

# Default Escape clauses for like

# dbi.oracle.like.default_escape = true | false

#

# Bind BYTE fields as Oracle long or blob types

# dbi.oracle.byte_binding_type = long | blob

# Bind TEXT fields as Oracle long or clob or nclob types

# dbi.oracle.long_binding = long | clob | nclob

#########################################

# GUI

#########################################

# Enables an additional top menu item named Window and showing

# all the child applications running at the moment

#gui.menu.window = false

#gui.menu.window.newchild = false

#gui.size.dimension = "qch"

#gui.doubleclick.action = accept

Stucture of fglprofile.std

Below we explain all the variables and options that are included in the template above and can be set in fglprofile.std.

Environment

system.environment.<name> allows setting values for environment variables in fglprofile.std so that they will be used globally

system.environment.dbdate allows setting the value of DBDATE to specify the end-user format for DATE values

system.environment.dbformat allows setting the value of DBFORMAT to specify the input and display formats for numeric values

system.environment.dbmoney allows setting the value of DBMONEY to define currency symbols and decimal separators used for inputting and displaying numeric values

system.environment.dbcentury allows setting the value of DBCENTURY to specify how to expand DATE and DATETIME values when abbreviated to one or two digits

system.environment.dbtemp allows setting the value of DBTEMP to define the folder to store temporary files created by the runtime system

system.environment.dbdelimiter allows setting the value of DBDELIMITER to specify the symbol that separates loaded and unloaded files in the LOAD and UNLOAD statements

GUI layout options

gui.layout.break.start specifies the character starting with which string is split in the Informix® compatibility mode (is equivalent to QXBREAKCH_START)

gui.layout.break.end specifies the character after that string is split in the Informix® compatibility mode (is equivalent to QXBREAKCH_END)

gui.layout.break.max_spaces specifies the maximum number of spaces any string can have (in a row) not to be split in the Informix® compatibility mode (is equivalent to QXREP_SPACES)

Database interfaces

dbi.postgresql.rowid enables the ROWID emulation for PostgreSQL databases - can be oid, emulate, or none

dbi.oracle.rowid enables the ROWID emulation for Oracle databases - can be emulate or none

dbi.oracle.temp specifies how the temporary tables are dealt with Oracle databases - can be native or emulate

dbi.oracle.like.default_escape specifies the default escape clauses for LIKE (Oracle databases) - can be true or false

dbi.oracle.byte_binding_type specifies whether the BYTE fields are bound to the Oracle's LONG or BLOB data type - can be long or blob

dbi.oracle.long_binding specifies whether the TEXT fields are bound to the Oracle's LONG, CLOB, or NCLOB data type - can be long, clob, or nclob

GUI

gui.menu.window adds an new item to the top menu item - Window - that shows all the applications currently running in the MDI mode  (is equivalent to QX_MENU_WINDOW)

gui.menu.window.newchild adds an new item to the Window menu group - New application - that opens a LyciaDesktop connection dialog to launch other applications in the MDI mode  (is equivalent to QX_MENU_WINDOW_NEW_CHILD)

gui.size.dimension specifies the default measurement unit for the size of an object (e.g., window or form) - can be qch (recommended) or other

gui.doubleclick.action allows or forbids double clicks in GUI