fglprofile.std

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

By default, fglprofile.std has the following content (press » to see the default content):

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

# 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

dbi.postgresql.rowid = oid

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

# 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

dbi.oracle.rowid = none

dbi.oracle.temp = native

dbi.oracle.like.default_escape = false

dbi.oracle.byte_binding_type = blob

dbi.oracle.text_binding_type = clob

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

# 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

The table below contains variables and options that 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