List of utility functions

Table 1. Utility functions
Function	Description
FGL_WINBUTTON( `title` STRING, `text` STRING, `default` STRING, `buttons` STRING, `icon` STRING, `danger` SMALLINT ) RETURNING `result` STRING	Displays an interactive message box containing multiple choices, in a popup window.
FGL_WINMESSAGE( `title` STRING, `text` STRING, `icon` STRING )	Displays an interactive message box containing text, in a separate window.
FGL_WINPROMPT( `x` INTEGER, `y` INTEGER, `text` STRING, `default` STRING, `length` INTEGER, `type` INTEGER ) RETURNING `value` STRING	Displays a dialog box containing a field that accepts a value.
FGL_WINQUESTION( `title` STRING, `text` STRING, `default` STRING, `buttons` STRING, `icon` STRING, `danger` SMALLINT ) RETURNING `value` STRING	Displays an interactive message box containing Yes, No, and Cancel buttons, in a popup window.
FGL_WINWAIT( `text` STRING )	Displays an interactive message box and waits for user validation.

Table 2. Database utility functions
Function	Description
DB_GET_DATABASE_TYPE() RETURNING `result` STRING	Returns the database type for the current connection.
DB_GET_SEQUENCE( `id` STRING ) RETURNING `result` BIGINT	Generates a new sequence for a given identifier.
DB_START_TRANSACTION() RETURNING `result` INTEGER	Starts a transaction level.
DB_FINISH_TRANSACTION( `commit` INTEGER ) RETURNING `result` INTEGER	Terminates a transaction level.
DB_IS_TRANSACTION_STARTED() RETURNING `result` INTEGER	Indicates whether a transaction is started with the transaction management functions.

Table 3. Front End functions (use ui.Interface.frontCall() instead)
Function	Description
WINOPENDIR( `dirname` STRING, `caption` STRING ) RETURNING `result` STRING	Opens a dialog window to get a directory path on the front-end workstation.
WINOPENFILE( `dirname` STRING, `typename` STRING, `extlist` STRING, `caption` STRING ) RETURNING `result` STRING	Opens a dialog window to get a file to be read on the front-end workstation.
WINSAVEFILE( `dirname` STRING, `typename` STRING, `extlist` STRING, `caption` STRING ) RETURNING `result` STRING	Opens a dialog window to get a file path to save data on the front-end workstation.

Table 3. Front End functions (use ui.Interface.frontCall() instead)

Function

Description

WINOPENDIR(
   dirname STRING,
   caption STRING )
  RETURNING result STRING

Opens a dialog window to get a directory path on the front-end workstation.

WINOPENFILE(
   dirname STRING,
   typename STRING,
   extlist STRING,
   caption STRING )
  RETURNING result STRING

Opens a dialog window to get a file to be read on the front-end workstation.

WINSAVEFILE(
   dirname STRING,
   typename STRING,
   extlist STRING,
   caption STRING )
  RETURNING result STRING

Opens a dialog window to get a file path to save data on the front-end workstation.

Table 4. Microsoft™ Windows™ Client Specific functions (use ui.Interface.frontCall() instead)
Function	Description
WINEXEC( `command` STRING ) RETURNING `result` INTEGER	Executes a program on the workstation where the Windows front end runs and returns immediately.
WINEXECWAIT( `command` STRING ) RETURNING `result` INTEGER	Executes a program on the workstation where the Windows front-end runs and waits for termination.
WINSHELLEXEC( `filename` STRING ) RETURNING `result` INTEGER	Opens a document on the workstation where the Windows front end runs.