fglprofile.std

How to create fglprofile.std

Template for your fglprofile.std

Stucture of 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:

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.

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

Template for your fglprofile.std

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

 

Contact Us

Privacy Policy

Copyright © 2024 Querix, (UK) Ltd.