You must enable javascript in order to view this page or you can go
here
to view the webhelp.
Genero Business Development Language User Guide 3.20
Content
Search Results
Index
Loading, please wait ...
Genero BDL User Guide
What's new in 3.20
General
Documentation conventions
Syntax diagrams
Warnings, notes and tips
Code examples
Enhancement references
General terms used in this documentation
Other source of information
Introduction to Genero BDL programming
Overview of Genero BDL
Separation of business logic and user interface
Portability - write once, deploy anywhere
Genero BDL concepts
Genero programs
Integrated SQL support
XML support
The user interface
Language library
Windows and forms
Interactive instructions
Responding to user actions
Producing reports
Internationalization
Web services support
Extending the language
Programming tools
Compiling a program
Deploying application program files
Installation
Resources for upgrades
Software requirements
Supported operating systems
System packages
Database client software
C compiler for C extensions
Java runtime environment
IPv6 support with Genero
Installing Genero BDL
Upgrading Genero BDL
Install Genero Mobile for Android™
Install Genero Mobile for iOS (single version)
Install Genero Mobile for iOS (multiple versions)
Platform specific notes
HP-UX configuration notes
IBM® AIX® configuration notes
Mac® OS X® configuration notes
Microsoft™ Windows® configuration notes
Web Services platform notes
SUSE® Linux Enterprise
Debian / Ubuntu Linux
Red Hat Enterprise Linux
Upgrading
New features of Genero BDL
BDL 3.20 new features
BDL 3.10 new features
BDL 3.00 new features
BDL 2.51 new features
BDL 2.50 new features
BDL 2.41 new features
BDL 2.40 new features
BDL 2.32 new features
BDL 2.30 new features
BDL 2.21 new features
BDL 2.20 new features
BDL 2.11 new features
BDL 2.10 new features
BDL 2.02 new features
BDL 2.01 new features
BDL 2.00 new features
BDL 1.33 new features
BDL 1.32 new features
BDL 1.31 new features
BDL 1.30 new features
BDL 1.20 new features
BDL 1.10 new features
Upgrade Guides for Genero BDL
General BDL upgrade guide
Runtime system and front-end compatibility
P-Code compatibility across versions
BDL 3.20 upgrade guide
Web Services changes
Genero Mobile for Android™ (GMA) 1.40 changes
Genero Mobile for iOS (GMI) 1.40 changes
Presentation styles changes
Front calls changes
Web components changes
Database drivers changes
DATETIME SQL type mappings
FreeTDS 1.00 for SQL Server
SQL Server drivers performance
Performances with SQL interruption
Sharing GLOBALS with C Extensions
Dynamic array assignment with .* notation
Record copy with .* notation
Circular dependency with IMPORT FGL
BDL 3.10 upgrade guide
Web Services changes
Genero Mobile for Android™ (GMA) 1.30 changes
Genero Mobile for iOS (GMI) 1.30 changes
C Extension changes
Java Inteface changes
Presentation styles changes
Front calls changes
Web components changes
Database drivers changes
(GDC) Local Actions
Microsoft ODBC Driver for SQL Server
Unique TABINDEXes in a form
Optional SCREEN RECORD size for lists
Type checking with fglcomp compiler
Oracle DB Proxy Authentication
Temp table emulation with Oracle DB
Oracle® MySQL 5.7 and 8.0 support
fglhint_* in SQL comments
SCROLLGRID content is checked by fglform
Default resource file search path
Using os.Path.pathType() on Windows
New localStorage frontcalls
Wide Char mode of SNC driver
MariaDB 10.2 support
Fatal runtime error message
BUTTONEDIT and ON ACTION INFIELD
BDL 3.00 upgrade guide
Web Services changes
Form definitions for mobile applications
Database drivers changes
Oracle DB NUMBER type
Oracle DB scroll cursor emulation removal
MySQL VARCHAR size limit
MySQL DATETIME fractional seconds
PostgreSQL DATETIME type mapping change
MariaDB support
FreeTDS driver supports SQL Server 2008, 2012, 2014
FGL_GETVERSION() built-in function
Built-in front-end icons desupport
Presentation styles changes
Modifications in front calls
SERIAL emulation with SQL Server
Improved compilation time
Preprocessor changes
Current system time in UTC
Structured ARRAYs in list dialogs
BDL 2.51 upgrade guide
Database drivers changes
New database driver name specification
The FIELD form item type and .val schema file
TRY/CATCH and ERROR LOG
DATETIME types with SQLite
Desupport of C-Extension API functions
BDL 2.50 upgrade guide
Web Services changes
Database drivers changes
TEXT/BYTE support with FTM/ESM database drivers
Presentation styles changes
Floating point to string conversion
Implicit creation of certificates for HTTPS
PostgreSQL schema extraction needs namespace
Client stubs managing multipart changes
BDL 2.41 upgrade guide
BDL 2.40 upgrade guide
Web Services changes
Database drivers changes
Program size option removal (fglrun -s)
Informix® SERIAL emulation with SQL Server
SIZEPOLICY attribute removal for containers
The LVARCHAR type in IBM® Informix® databases
Right-trim collation for character types in SQLite
Message files support now 4-bytes integer message numbers
MySQL client library version change in MySQL 5.5.11
New compiler warning to avoid action shadowing
Runtime error raised when report dimensions are invalid
Linker checks all referenced functions
BDL 2.32 upgrade guide
Front-end protocol compression disabled
SQLite driver no longer needs libiconv on Windows®
Need for Informix® CSDK to compile C extensions
FESQLC tool removal
BDL 2.30 upgrade guide
GUI server auto start
Form compiler is more strict
ORACLE and INTERVAL columns
DIALOG.setCurrentRow() changes row selection flags
Schema extractor needs table owner
Windows™ installation for all users only
MenuAction close no longer created by default
Emulated scrollable cursor temp files in DBTEMP
Modifying tree view data during dialog execution
Presentation styles changes
BDL 2.21 upgrade guide
Web Services changes
PostgreSQL 8.4 and INTERVAL type
fglcomp --build-rdd compiles the module
Unique and primary key constraint violation
IMPORT with list of C-Extensions
Initializing dynamic arrays to null
Strict screen record definition for tables
BDL 2.20 upgrade guide
Web Services changes
Sort is now possible during INPUT ARRAY
Cell attributes and buffered mode
Field methods are more strict
Strict variable identification in SQL statements
SQL Warnings with non-Informix databases
SERIALREG table for 64-bit serial emulation
Extracting the database schema with fgldbsch
Database driver internal error changed from -768 to -6319
Searching for image files on the application server
Strict action identification in dialog methods
Strict field identification in dialog methods
Form compiler checking invalid layout definition
Database schema compatibility
Predefined actions get automatically disabled depending on the context
BEFORE ROW no longer executed when array is empty
Controlling INPUT ARRAY temporary row creation
BDL 2.11 upgrade guide
Writing timestamp information in p-code modules
BDL 2.10 upgrade guide
XML declaration added automatically
Using SQL Server 2008 date/time types
BDL 2.02 upgrade guide
Automatic HBox/VBox
BDL 2.01 upgrade guide
BDL 2.00 upgrade guide
Web Services changes
Runner creation is no longer needed
Desupported Informix® client environments
Database drivers changes
fglmkrtm tool removed
fglinstall tool removed
Linking the utility functions library
Dynamic C extensions
WANTCOLUMNSANCHORED is desupported
PIXELWIDTH / PIXELHEIGHT are deprecated
Prefetch parameters with Oracle
Preprocessor directive syntax changed
Static SQL cache is removed
SQL directive set removed
Connection database schema specification
Schema extraction tool changes
Global and module variables using the same name
Connection parameters in FGLPROFILE when using Informix®
Inconsistent USING clauses
Usage of RUN IN FORM MODE
TTY and COLOR WHERE attribute
BDL 1.33 upgrade guide
Database drivers changes
BDL 1.32 upgrade guide
BDL 1.31 upgrade guide
BDL 1.30 upgrade guide
Action and field activation
Using HBox tags in forms
Width of ButtonEdit/DateEdit/ComboBox
Form fields default sample
Size policy for ComboBoxes
Action defaults at form level
Compiled string files (.42s)
BDL 1.20 upgrade guide
BDL 1.10 upgrade guide
Planned desupport
Migrating from IBM® Informix® 4GL to Genero BDL
Introduction to I4GL migration
IBM® Informix® 4GL and Genero BDL products
IBM® Informix® 4GL reference version
Installation and setup topics
Using C extensions
Localization support in Genero
Database schema extractor
Compiling 4GL to C
User interface topics
Smooth migration with traditional UI mode
Refreshing the user interface
SCREEN versus LAYOUT section
Migrating screen arrays to tables
Review TUI specific features for GUI display
The default SCREEN window
Specifying WINDOW position and size
Right justified field labels
Reduce multiple text screens
Review application ergonomics
Subscripted form fields are not supported
WORDWRAP field attribute
Ignored form definition attributes
4GL programming topics
Dynamic arrays
Debugger command syntax
Mismatching global variable definitions
Strict function signature checking
STRING versus CHAR/VARCHAR
Review user-made C routines
Web Services support
File I/O statements and APIs
OPEN USING followed by FOREACH
ARG_VAL() returns NULL if no argument
Checking function parameters/returns
Migrating from Four Js BDS to Genero BDL
Installation and setup topics
License controller
Runner linking is no longer needed
Localization support
Database schema extractor
C-Code compilation is desupported
Desupported environment variables
Desupported FGLPROFILE entries
User interface topics
Smooth migration with traditional UI mode
Front-end compatibility
FGLGUI is 1 by default
FGLPROFILE: GUI configuration
Key labels versus action defaults
Migrating form field WIDGET="type"
SCREEN versus LAYOUT section
Migrating screen arrays to tables
Review TUI specific features
The default SCREEN window
Specifying WINDOW position and size
Front-end configuration tools
Function key mapping
Activating form items with DISPLAY
Defining keys for WIDGET fields
BEFORE DISPLAY / BEFORE ROW execution order
4GL Programming topics
FGLPROFILE: VM configuration
The fgl_init4gl() function
Static versus Dynamic Arrays
Debugger syntax changed
fgl_system() function
The Channel:: methods
The Dialog:: methods
STRING versus CHAR/VARCHAR
Review user-made C routines
Variable identification in SQL statements
Default action of WHENEVER ANY ERROR
Database driver features
Frequently Asked Questions
FAQ001: Why do I have a different display with Genero than with BDS V3?
FAQ002: Why does an empty window always appear?
FAQ003: Why do some COMMAND KEY buttons no longer appear?
FAQ004: Why aren't the elements of my forms aligned properly?
FAQ005: Why doesn't the ESC key validate my input?
FAQ006: Why doesn't the Ctrl-C key cancel my input?
FAQ007: Why do the gui.* FGLPROFILE entries have no effect?
FAQ008: Why do I get invalid characters in my form?
FAQ009: Why do large static arrays raise a stack overflow?
FAQ010: Why do I get error -6366 "Could not load database driver
drivername
"?
Configuration
The FGLPROFILE file(s)
Understanding FGLPROFILE
Syntax of FGLPROFILE entries
FGLPROFILE entries for core language
FGLPROFILE files selection
FGLPROFILE encoding
The default FGLPROFILE
FGLPROFILE for mobile apps
Reading FGLPROFILE entries
Environment variables
Setting environment variables on UNIX™
Setting environment variables on Windows™
Setting environment variables in FGLPROFILE (mobile)
Operating system environment variables
LC_ALL (or LANG)
LD_LIBRARY_PATH
PATH
TERM
TERMCAP
TERMINFO
TMPDIR, TMP, TEMP
Database client environment variables
Genero environment variables
DBCENTURY
DBDATE
DBDELIMITER
DBEDIT
DBFORMAT
DBMONEY
DBPATH
DBPRINT
DBSCREENDUMP
DBSCREENOUT
DBTEMP
FGL_LENGTH_SEMANTICS
FGLAPPDIR
FGLAPPSERVER
FGLCOV
FGLDBPATH
FGLDIR
FGLGBCDIR
FGLGUI
FGLGUIDEBUG
FGLIMAGEPATH
FGLLDPATH
FGLPROFILE
FGLRESOURCEPATH
FGLSERVER
FGLSOURCEPATH
FGLSQLDEBUG
FGLTRACE_FUNCTIONS
FGLTRACE_EXCLUDE
FGLWRTUMASK
FGLWSDEBUG
GMIDIR
INFORMIXTERM
Front-end connection
Database server connections
Language basics
Syntax features
Lettercase insensitivity
Whitespace separators
Quotation marks
Escape symbol
Statement terminator
Source comments
Identifiers
Preprocessor directives
Primitive Data types
BIGINT
BYTE
BOOLEAN
CHAR(size)
DATE
DATETIME qual1 TO qual2
DECIMAL(p,s)
FLOAT
INTEGER
INTERVAL qual1 TO qual2
MONEY(p,s)
SMALLFLOAT
SMALLINT
STRING
TINYINT
TEXT
VARCHAR(size)
Type conversions
When does type conversion occur?
Data type conversion reference
Handling type conversion errors
Formatting data
Formatting numeric values
Formatting DATE values
Formatting DATETIME values
Formatting INTERVAL values
Literals
Integer literals
Numeric literals
Text literals
MDY(m,d,y) literals
Datetime literals
Interval literals
Expressions
Understanding expressions
Boolean expressions
Integer expressions
Numeric expressions
String expressions
Date expressions
Datetime expressions
Interval expressions
Operators
Order of precedence
Operator usage context
List of expression elements
Comparison operators
IS NULL
LIKE
MATCHES
Equal to (==)
Different from (!=)
Lower (<)
Lower or equal (<=)
Greater (>)
Greater or equal (>=)
NVL()
IIF()
Boolean operators
NOT
AND
OR
Arithmetic operators
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
Exponentiation (**)
MOD
Character string operators
ASCII()
COLUMN
Concatenate (||)
Append (,)
Substring ([s,e])
USING
CLIPPED
ORD()
SPACES
LSTR()
SFMT()
Associative syntax operators
Parentheses:
()
Membership (object.member)
Variable parameter list:
[ ]
SQL related operators
SQLSTATE
SQLERRMESSAGE
Data type operators
CAST
INSTANCEOF
Assignment operators
Assignment (:=)
Date and time operators
CURRENT
EXTEND()
DATE()
TIME()
TODAY
YEAR()
MONTH()
DAY()
WEEKDAY()
MDY()
UNITS
Dialog handling operators
GET_FLDBUF()
INFIELD()
FIELD_TOUCHED()
Flow control
CALL
RETURN
CASE
CONTINUE
block-name
EXIT
block-name
FOR
GOTO
IF
LABEL
SLEEP
WHILE
Variables
Understanding variables
DEFINE
Declaration context
Structured variables
Database column types
User defined types
Variable default values
Variable initializers
Definition attributes
INITIALIZE
LOCATE (for TEXT/BYTE)
FREE (for TEXT/BYTE)
LET
VALIDATE
Examples
Example 1: Local function variables
Example 2: PRIVATE module variables
Example 3: PUBLIC module variables
Example 4: Global variables
Constants
Understanding constants
CONSTANT
Examples
Example 1: Defining and using constants
Records
Understanding records
RECORD
Record initializers
Record definition attributes
Accessing record members
Copying records
Comparing records
Records as function parameters
THRU/THROUGH
Examples
Example 1: Defining a record with explicit member types
Example 2: Defining a record with a database table structure
Example 3: Assigning an comparing records
Arrays
Understanding arrays
ARRAY
Static arrays
Controlling out of bound in static arrays
Dynamic arrays
Array methods
Copying and assigning arrays
Examples
Example 1: Using static and dynamic arrays
Example 2: Filling a dynamic array with rows
Dictionaries
Understanding dictionaries
DICTIONARY
DICTIONARY in action
Dictionary methods
Examples
Example 1: Simple DICTIONARY usage
Types
Understanding type definition
TYPE
Using types in programs
Examples
Example 1: Defining a type with a record structure
Example 2: Defining a type an using it in another module
Example 3: Defining a type with a function type
Functions
Understanding functions
FUNCTION definitions
Scope of a function
Local symbol definition
Calling functions
Function parameters
Returning values
Function references
FUNCTION
func-spec
Methods
Function attributes
Examples
Example 1: Function fetching customer number
Example 2: Private function definition
Example 3: Using function references
Example 4: Defining methods
Interfaces
Understanding interfaces
INTERFACE
INTERFACE usage
Examples
Example 1: Simple INTERFACE usage
Advanced features
Program modules
Structure of a program
Structure of a module
The MAIN block / function
Database schema
Understanding database schemas
SCHEMA
Structure of database schema files
Column Definition File (.sch)
Column Validation File (.val)
Column Video Attributes File (.att)
Database schema extractor options
Specifying the database source
Specifying the database driver
Passing database user login and password
Data type conversion control
Skip unsupported table definitions
Specifying the table owner
Force extraction of system tables
Specifying the output file name
Extracting definition of a single table
Controlling the character case
Using the verbose mode
IBM® Informix® synonym tables
IBM® Informix® shadow columns
Running schema extractor in old mode
Importing modules
IMPORT
C-Extension
IMPORT FGL
module
IMPORT JAVA
classname
Program execution
Executing programs
RUN
EXIT PROGRAM
BREAKPOINT
Runtime stack
Passing simple typed values as parameter
Passing a record as parameter
Passing a static array as parameter
Passing a dynamic array as parameter
Passing a dictionary as parameter
Passing objects as parameter
Passing a TEXT/BYTE as parameter
Returning simple typed values from functions
Returning dynamic arrays from functions
Returning dictionaries from functions
Returning TEXT/BYTE values from functions
Implicit data type conversion on the stack
Exceptions
Understanding exceptions
Exception classes
Exception actions
WHENEVER instruction
TRY - CATCH block
Tracing exceptions
Default exception handling
Non-trappable errors
Examples
Example 1: Defining a error handler function
Example 2: SQL error handling with WHENEVER
Example 3: Typical TRY / CATCH block
Example 4: TRY / CATCH in conjunction with WHENEVER
Example 5: WHENEVER RAISE exception propagation
Localization
Application locale
Understanding locale settings
Quickstart guide for locale settings
Locale and character set basics
Why do I need to care about the locale and character set?
Characters, code points, character sets, glyphs and fonts
The ASCII character set
Single-byte character sets (SBCS)
Double-byte character sets (DBCS)
Multibyte character sets (MBCS)
Character size unit and length semantics
The UNICODE Standard
When do I need a UNICODE character set?
What is the standard for UNICODE encoding?
What is my current character set?
Defining the application locale
Language and character set settings
Length semantics settings
Collation ordering settings
Numeric and currency locale settings
Date and time locale settings
Database client settings
Front-end locale configuration
Locale matters when writing programs
Runtime system messages
Using the charmap.alias file
Date, numeric and monetary formats
Using the Ming Guo date format
User's preferred language
Right-to-left languages support
Troubleshooting locale issues
Locale settings (LANG) corrupted on Microsoft™ platforms
A form is displayed with invalid characters
Checking the locale configuration on UNIX™ platforms
Verifying if the locale is properly supported by the runtime system
How to retrieve the list of available locales on the system
How to retrieve the list of available codesets on the system
Localized strings
Steps for application internationalization
Creating source string files
Localized strings in program sources
Localized strings in XML resource files
Extracting strings from sources
Organizing string resources
Compiling string resource files (.str)
Loading localized strings at runtime
Predefined application strings
Best practices for localized strings
Example
Globals
Understanding global blocks
GLOBALS
Rules for globals usage
Database schema in globals
Content of a globals file
Examples
Example 1: Multiple GLOBALS file
Predefined constants
NULL
TRUE
FALSE
NOTFOUND
Configuration options
OPTIONS (Compilation)
Controlling semantics of AND / OR operators
OPTIONS (Runtime)
Defining the position of reserved lines
Defining default TTY attributes
Defining the field input loop
Defining field tabbing order method
Application termination
Front-end termination
Defining the message file
Defining control keys
Setting default screen modes for sub-programs
Enabling/disabling SQL interruption
Runtime configuration in FGLPROFILE
Responding to CTRL_LOGOFF_EVENT
DEFER INTERRUPT / QUIT
Program registers
STATUS
INT_FLAG
QUIT_FLAG
OOP support
Understanding classes and objects
DEFINE ...
package.class
Distinguish class and object methods
Working with objects
What class packages exist?
XML support
DOM and SAX standards
DOM and SAX built-in classes
Limitations of XML built-in classes
Exception handling with XML classes
Controlling the UI with XML classes
JSON support
What is JSON?
JSON utility classes
BDL/JSON conversion basics
BDL names and JSON element names
NULLs and empty structures
BDL to JSON type conversion rules
JSON to BDL type conversion rules
Front calls
Understanding front calls
ui.Interface.frontCall
User-defined front calls
Optimization
Runtime system basics
Dynamic module loading
Elements shared by multiple programs
Elements shared by multiple modules
Objects private to a program
Check runtime system memory leaks
Optimize your programs
Finding program bottlenecks
Optimizing SQL statements
Passing CHAR parameters to functions
Passing records by reference to functions
Compiler removes unused variables
Saving memory by splitting modules
Saving memory by using STRING variables
Saving memory by using dynamic arrays
SQL support
SQL programming
SQL basics
Database and application locales
SQL execution diagnostics
The SQLCA diagnostic record
SQL error identification
Cursors and connections
Concurrent data access
Database transactions
Using SQL interruption
Implicit database connection
Debugging SQL statements
The database utility library
SQL security
Authenticating DB users
Avoiding SQL injection
SQL portability
Database entities
Database users and security
Creating a database from programs
Handling nested transactions
Transaction blocks across connections
Transaction savepoints
Data definition statements
Using portable data types
Data manipulation statements
CHAR and VARCHAR types
Byte or Character Length semantics?
SQL character type for Unicode/UTF-8
Empty strings and NULLs
Trailing blanks in CHAR/VARCHAR
What should you do?
Scrollable cursors
Optimistic locking
Auto-incremented columns (serials)
Solution 1: Use database specific serial generators
Solution 2: Generate serial numbers from your own sequence table
Solution 3: Use native SEQUENCE database objects
IBM® Informix® SQL ANSI Mode
Positioned UPDATE/DELETE
Cursors WITH HOLD
Insert cursors
String literals in SQL statements
Date/time literals in SQL statements
Naming database objects
DB object name syntax
Case-sensitivity
Size of identifiers
LOAD and UNLOAD instructions
Temporary tables
Outer joins
Substring expressions
Using ROWID columns
MATCHES and LIKE operators
GROUP BY clause
The LENGTH() function in SQL
Large OBjects (LOBs) data types
Stored procedures
Specifying input and output parameters
Stored procedures returning a result set
Calling stored procedures with supported databases
Stored procedure call with IBM® Informix®
Stored functions returning values
Stored functions defined with output parameters
Stored functions returning a result set
Stored procedure call with Oracle DB
Stored procedures with output parameters
Stored functions with a return value
Stored procedures with result set
Stored procedure call with IBM® DB2®
Stored procedures with output parameters
Stored procedures with result set
Stored procedures with output parameters and result set
Stored procedure call with Microsoft™ SQL Server
Stored procedures with output parameters
Stored procedures with result set
Stored procedures returning a cursor as output parameter
Stored procedures with return code
Stored procedures with output parameters, return code and result set
Stored procedure call with PostgreSQL
Stored functions with output parameters
Stored functions with result set
Stored functions with output parameters and result set
Stored procedure call with Oracle MySQL / MariaDB
Stored procedures with output parameters
Stored functions returning values
Stored procedures with result set
Stored procedure call with SAP ASE
Stored procedures with output parameters
Stored procedures with result set
Stored procedures with output parameters, return code and result set
Stored procedure call with SAP HANA®
Stored procedures with output parameters
Stored procedures with result set
Stored procedures with output parameters and result set
SQL performance
Performance with dynamic SQL
Performance with transactions
Avoiding long transactions
Declaring prepared statements
Saving SQL resources
Optimizing scrollable cursors
Database connections
Understanding database connections
Opening a database connection
Database client environment
IBM® DB2 LUW™
IBM® Informix® Dynamic Server
Oracle® MySQL
MariaDB
Oracle database
PostgreSQL
Microsoft™ SQL Server
SQLite
SAP ASE
SAP HANA
Connection parameters
Database source specification (source)
Database driver specification (driver)
Default database driver
User name and password (username/password)
Connection parameters in database specification
Direct database specification method
Indirect database specification method
IBM® Informix® emulation parameters in FGLPROFILE
Database type specific parameters in FGLPROFILE
IBM® DB2® specific FGLPROFILE parameters
Oracle DB specific FGLPROFILE parameters
Oracle® MySQL specific FGLPROFILE parameters
MariaDB specific FGLPROFILE parameters
PostgreSQL specific FGLPROFILE parameters
SQL Server (MS ODBC) specific FGLPROFILE parameters
SQL Server (FreeTDS driver) specific FGLPROFILE parameters
SQL Server (Easysoft driver) specific FGLPROFILE parameters
SAP ASE specific FGLPROFILE parameters
SAP HANA® specific FGLPROFILE parameters
SQL connection identifier
Database user authentication
Specifying a user name and password with CONNECT
Specifying a user name and password with DATABASE
User authentication callback function
Order of precedence for database user specification
Unique session mode connection instructions
DATABASE
CLOSE DATABASE
Multi-session mode connection instructions
CONNECT TO
SET CONNECTION
SET SESSION AUTHORIZATION
DISCONNECT
Miscellaneous SQL statements
SET EXPLAIN
UPDATE STATISTICS
Database transactions
Understanding database transactions
BEGIN WORK
SAVEPOINT
COMMIT WORK
ROLLBACK WORK
RELEASE SAVEPOINT
SET ISOLATION
SET LOCK MODE
Static SQL statements
Understanding static SQL statements
Using program variables in static SQL
Table and column names in static SQL
SQL texts generated by the compiler
INSERT
UPDATE
DELETE
SELECT
SQL ... END SQL
CREATE SEQUENCE
ALTER SEQUENCE
DROP SEQUENCE
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
CREATE SYNONYM
DROP SYNONYM
RECOVER TABLE
RENAME
Dynamic SQL management
Understanding dynamic SQL
PREPARE (SQL statement)
EXECUTE (SQL statement)
FREE (SQL statement)
EXECUTE IMMEDIATE
The base.SQLHandle built-in class
fglhint_* SQL comments
Result set processing
Understanding database result sets
DECLARE (result set cursor)
OPEN (result set cursor)
FETCH (result set cursor)
CLOSE (result set cursor)
FREE (result set cursor)
FOREACH (result set cursor)
Positioned updates/deletes
Understanding positioned update or delete
DECLARE (SELECT … FOR UPDATE)
UPDATE … WHERE CURRENT OF
DELETE … WHERE CURRENT OF
Examples
Example 1: Positioned UPDATE statement
SQL insert cursors
Understanding SQL insert cursors
DECLARE (insert cursor)
OPEN (insert cursor)
PUT (insert cursor)
FLUSH (insert cursor)
CLOSE (insert cursor)
FREE (insert cursor)
Examples
Example 1: Insert Cursor declared with a Static INSERT
Example 2: Insert Cursor declared with an SQL text
Example 3: Insert Cursor declared with 'hold' option
SQL LOAD and UNLOAD
LOAD
UNLOAD
SQL database guides
IBM® Informix® Dynamic Server
Purpose of the Informix® SQL guide
Installation (Runtime Configuration)
Supported IBM® Informix® server and CSDK versions
Install IBM® Informix® and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Fully supported IBM® Informix® SQL features
What are the supported IBM® Informix® SQL features?
Partially supported IBM® Informix® SQL features
The BIGSERIAL / SERIAL8 data types
The NCHAR / NVARCHAR data types
The LVARCHAR data type
DISTINCT data types
Stored Procedures
Database Triggers
Optimizer directives
XML publishing support
DataBlade® modules
Specific CREATE INDEX clauses
Other SQL instructions
Unsupported IBM® Informix® SQL features
CLOB and BLOB data types
The LIST data type
The MULTISET data type
The SET data type
The ROW data types
OPAQUE data types
The :: cast operator
Table inheritance
IBM® DB2® Linux-Unix-Windows
Installation (Runtime Configuration)
Install IBM® DB2® and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Data storage concepts
Concurrency management
Transactions handling
Database users
Setting privileges
Data dictionary
Data type conversion table: Informix to DB2
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
ROWID columns
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
String delimiters
Single row SELECT
MATCHES and LIKE
SELECT * (asterisk)
The LENGTH() function
BDL programming
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
SQL parameters limitation
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
Connecting to DB2® OS/400®
DB2® Architecture on OS/400®
Login to the AS/400® server
Collection (Schema) Creation
Source Physical File Creation
Trigger Creation
Permission Definition
Relational DB Directory Entry Creation
DB2® Client Configuration on Windows™
Differences Between DB2® UNIX™ & DB2® OS/400®
Naming Conventions
IBM® Netezza®
Installation (Runtime Configuration)
Install IBM® Netezza® and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Concurrency management
Transactions handling
Database users
Data dictionary
Data type conversion table: Informix to Netezza
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
ROWID columns
Indexes
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
The LENGTH() function
Name resolution of SQL objects
String delimiters
MATCHES and LIKE
BDL programming
UPDATE limitations in Netezza
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
Microsoft™ SQL Server
Installation (Runtime Configuration)
Install Microsoft™ SQL Server and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Data storage concepts
Concurrency management
Transactions handling
Database users
Setting privileges
Data dictionary
Data type conversion table: Informix to SQL Server
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
SQL Server UNIQUEIDENTIFIER data type
SQL Server ROWVERSION data type
ROWID columns
Case sensitivity
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
String delimiters
Single row SELECT
MATCHES and LIKE
The LENGTH() function
String concatenation operator
BDL programming
SQL errors on PREPARE
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
Oracle® MySQL / MariaDB
Installation (Runtime Configuration)
Install Oracle® MySQL/MariaDB and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Data storage concepts
Concurrency management
Transactions handling
Database users
Data dictionary
Data type conversion table: Informix to MySQL
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data type
ROWID columns
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
The LENGTH() function
MATCHES and LIKE
BDL programming
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
Oracle® Database
Installation (Runtime Configuration)
Install Oracle and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Data storage concepts
Concurrency management
Transactions handling
Database users
Setting privileges
Data dictionary
Data type conversion table: Informix to Oracle
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
ROWID columns
The RAW data type
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
NULLs in indexed columns
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Using the default temporary table emulation
Using the global temporary table emulation
Using the private temporary table emulation
Substrings in SQL
The LENGTH() function
Empty character strings
String delimiters
Single row SELECT
MATCHES and LIKE
SELECT * (asterisk)
BDL programming
SQL errors on PREPARE
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
PostgreSQL
Installation (Runtime Configuration)
Install PostgreSQL and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Data storage concepts
Concurrency management
Transactions handling
Database users
Setting privileges
Data dictionary
Data type conversion table: Informix to PostgreSQL
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
ROWID columns
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
String delimiters
MATCHES and LIKE
The LENGTH() function
BDL programming
SQL errors on PREPARE
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
SQLite
Installation (Runtime Configuration)
Install SQLite and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Concurrency management
Transactions handling
Database users
Data dictionary
Data type conversion table: Informix to SQLite
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
ROWID columns
Foreign key support
TEXT and BYTE (LOB) types
Data manipulation
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
MATCHES and LIKE
The LENGTH() function
BDL programming
INSERT cursors
SELECT … FOR UPDATE
Cursors WITH HOLD
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
Modifying many rows in a table
Optimizing database file usage
SAP® ASE
Installation (Runtime Configuration)
Install SAP ASE and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Concurrency management
Transactions handling
Database users
Setting privileges
Data dictionary
Data type conversion table: Informix to SAP ASE
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data type
ROWID columns
Case sensitivity
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
String delimiters
Single row SELECT
MATCHES and LIKE
The LENGTH() function
BDL programming
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
UPDATE/DELETE … WHERE CURRENT OF
LOAD and UNLOAD
SQL Interruption
Scrollable cursors
SAP HANA®
Installation (Runtime Configuration)
Install SAP HANA® and create a database - database configuration/design tasks
Prepare the runtime environment - connecting to the database
Database concepts
Database concepts
Data storage concepts
Concurrency management
Transactions handling
Database users
Setting privileges
Data dictionary
Data type conversion table: Informix to SAP HANA
BOOLEAN data type
CHAR and VARCHAR data types
NUMERIC data types
DATE and DATETIME data types
INTERVAL data type
SERIAL and BIGSERIAL data types
ROWID columns
TEXT and BYTE (LOB) types
Table constraints
Name resolution of SQL objects
Data manipulation
Reserved words
Outer joins
Transactions handling
Temporary tables
Substrings in SQL
String delimiters
Single row SELECT
MATCHES and LIKE
The LENGTH() function
BDL programming
INSERT cursors
Cursors WITH HOLD
SELECT … FOR UPDATE
LOAD and UNLOAD
UPDATE/DELETE … WHERE CURRENT OF
SQL Interruption
Scrollable Cursors
User interface
User interface basics
The dynamic user interface
The abstract user interface tree
What does the abstract user interface tree contain?
Manipulating the abstract user interface tree
XML node types and attribute names
Actions in the abstract user interface tree
Inspecting the AUI tree of a front-end
Genero user interface modes
Text mode rendering
Graphical mode rendering
Graphical mode with Native Rendering
Graphical mode with Universal Rendering
Graphical mode with Traditional Display
GUI front-end connection
Connecting with a front-end
The front-end protocol
Front-end identification
GUI connection timeout
Wait for front-end ping timeout
GUI protocol compression
Front-end protocol errors
Debugging the front-end protocol
Front-end protocol logging
Automatic front-end startup
Using a text terminal
TERMINFO terminal capabilities
TERMCAP terminal capabilities
Termcap syntax
Genero-specific termcap definitions
Text mode screen dump
Form definitions
Windows and forms
OPEN WINDOW
OPEN WINDOW attributes
WITH FORM clause
Window TYPE attribute
CLOSE WINDOW
CURRENT WINDOW
CLEAR WINDOW
OPEN FORM
DISPLAY FORM
CLOSE FORM
CLEAR SCREEN
DISPLAY AT
Using windows and forms
Understanding windows and forms
The window concept
The form concept
Configuring windows with styles
Defining the window title
Defining the window icon
Window container interfaces
Position and size of a window
Using images
Image handling basics
Controlling the image layout
Providing the image resource
Static images
Runtime images
Accessibility guidelines
Keyboard access
Form description for screen readers
Usability and ergonomics
Message files
Understanding message files
Syntax of message files (.msg)
Compiling message files (.msg)
Using message files at runtime
Examples
Example 1: Help message file used in a MENU
Action defaults files
Understanding action defaults files
Syntax of action defaults files (.4ad)
Action default attributes reference (.4ad)
Using action defaults files
Examples
Example 1: Loading a global action defaults file
Presentation styles
Understanding presentation styles
Syntax of presentation styles file (.4st)
Using presentation styles
Defining a style
Pseudo selectors
Using a style
Order of precedence
Combining styles
Style attribute inheritance
Presentation styles in the AUI tree
Loading presentation styles
Combining TTY and style attributes
Element types
Predefined attribute values
Colors
GDC System Colors
GBC System Colors
Fonts
Font families
Font sizes
Font styles
Font weights
Statusbar types
Style attributes reference
Common style attributes
Button style attributes
ButtonEdit style attributes
CheckBox style attributes
ComboBox style attributes
DateEdit style attributes
Default action view style attributes
Edit style attributes
Folder style attributes
Form style attributes
Group style attributes
HBox style attributes
Image style attributes
Label style attributes
Menu style attributes
Message style attributes
ProgressBar style attributes
RadioGroup style attributes
ScrollGrid style attributes
Row and cell highlighting in SCROLLGRID
Table style attributes
Row and cell highlighting in TABLE
Tree style attributes
Row highlighting in TREE
TextEdit style attributes
Rich Text Editing in TEXTEDIT
ToolBar style attributes
ToolBarSeparator style attributes
UserInterface style attributes
Window style attributes
Examples
Example 1: Defining styles for grid elements
Example 2: Defining styles for table rows
Form specification files
Understanding form files
Form file concepts
Form items
Satellite items
Static items
Layout items
Stack items
Action views
Form fields
Database column fields
Formonly fields
Phantom fields
Aggregate fields
Identifying form items
Screen records / arrays
Form tags
Layout tags
Item tags
Hbox tags
External form inclusion
Boolean expressions in forms
Form item types
BUTTON item type
BUTTONEDIT item type
CHECKBOX item type
COMBOBOX item type
DATEEDIT item type
DATETIMEEDIT item type
EDIT item type
FOLDER item type
GRID item type
GROUP item type
HBOX item type
IMAGE item type
LABEL item type
PAGE item type
PROGRESSBAR item type
RADIOGROUP item type
SCROLLGRID item type
SLIDER item type
SPINEDIT item type
TABLE item type
TEXTEDIT item type
TIMEEDIT item type
TREE item type
VBOX item type
WEBCOMPONENT item type
Form file structure
SCHEMA section
ACTION DEFAULTS section
TOPMENU section
TOOLBAR section
SCREEN section
LAYOUT section
FORM clause
HBOX container
VBOX container
GROUP container
FOLDER container
PAGE container
GRID container
STACK container
BUTTON stack item
BUTTONEDIT stack item
CHECKBOX stack item
COMBOBOX stack item
DATEEDIT stack item
DATETIMEEDIT stack item
EDIT stack item
FOLDER stack item
GROUP stack item
IMAGE stack item
LABEL stack item
PAGE stack item
PHANTOM stack item
PROGRESSBAR stack item
RADIOGROUP stack item
SLIDER stack item
SPINEDIT stack item
TABLE stack item
TEXTEDIT stack item
TIMEEDIT stack item
WEBCOMPONENT stack item
SCROLLGRID container
TABLE container
TREE container
TABLES section
ATTRIBUTES section
AGGREGATE item definition
PHANTOM item definition
BUTTON item definition
BUTTONEDIT item definition
CANVAS item definition
CHECKBOX item definition
COMBOBOX item definition
DATEEDIT item definition
DATETIMEEDIT item definition
EDIT item definition
GROUP item definition
IMAGE item definition
LABEL item definition
PROGRESSBAR item definition
RADIOGROUP item definition
SCROLLGRID item definition
SLIDER item definition
SPINEDIT item definition
TABLE item definition
TEXTEDIT item definition
TIMEEDIT item definition
TREE item definition
WEBCOMPONENT item definition
INSTRUCTIONS section
KEYS section
Form item attributes
ACCELERATOR attribute
ACCELERATOR2 attribute
ACCELERATOR3 attribute
ACCELERATOR4 attribute
ACTION attribute
AGGREGATETEXT attribute
AGGREGATETYPE attribute
AUTOSCALE attribute
AUTONEXT attribute
BUTTONTEXTHIDDEN attribute
CENTURY attribute
CLASS attribute
COLOR attribute
COLOR WHERE Attribute
CONFIG Attribute
CONTEXTMENU attribute
COMMENT attribute
COMPLETER attribute
COMPONENTTYPE attribute
DEFAULT attribute
DEFAULTVIEW attribute
DISPLAY LIKE attribute
DISCLOSUREINDICATOR attribute
DOUBLECLICK attribute
DOWNSHIFT attribute
EXPANDEDCOLUMN attribute
FONTPITCH attribute
FORMAT attribute
GRIDCHILDRENINPARENT attribute
HEIGHT attribute
HIDDEN attribute
IDCOLUMN attribute
IMAGE attribute
IMAGECOLUMN attribute
IMAGECOLLAPSED attribute
IMAGEEXPANDED attribute
IMAGELEAF attribute
INCLUDE attribute
INITIALIZER attribute
INITIALPAGESIZE attribute
INVISIBLE attribute
ISNODECOLUMN attribute
ITEMS attribute
JUSTIFY attribute
KEY attribute
KEYBOARDHINT attribute
MINHEIGHT attribute
MINWIDTH attribute
NOENTRY attribute
NOT NULL attribute
NOTEDITABLE attribute
OPTIONS attribute
ORIENTATION attribute
PARENTIDCOLUMN attribute
PICTURE attribute
PLACEHOLDER attribute
PROGRAM attribute
PROPERTIES attribute
QUERYEDITABLE attribute
REQUIRED attribute
REVERSE attribute
SAMPLE attribute
SCROLL attribute
SCROLLBARS attribute
SIZEPOLICY attribute
SPACING attribute
SPLITTER attribute
STEP attribute
STRETCH attribute
STYLE attribute
TABINDEX attribute
TAG attribute
TEXT attribute
TITLE attribute
UNHIDABLE attribute
UNHIDABLECOLUMNS attribute
UNMOVABLE attribute
UNMOVABLECOLUMNS attribute
UNSIZABLE attribute
UNSIZABLECOLUMNS attribute
UNSORTABLE attribute
UNSORTABLECOLUMNS attribute
UPSHIFT attribute
VALIDATE attribute
VALIDATE LIKE attribute
VALUEMIN attribute
VALUEMAX attribute
VALUECHECKED attribute
VALUEUNCHECKED attribute
VERIFY attribute
VERSION attribute
WANTFIXEDPAGESIZE attribute
WANTNORETURNS attribute
WANTTABS attribute
WIDGET attribute
WIDTH attribute
WINDOWSTYLE attribute
WORDWRAP Attribute
Examples
Example 1: Grid-based layout form
Example 2: Stack-based layout form
Form rendering
Form rendering basics
Character set usage
Adapting to viewport changes
Front-end stored settings
Grid-based layout
Packed and unpacked grids
Automatic HBoxes and VBoxes
Widget position and size in grid
Form item dependencies in grids
Complex grid layout example
Using hbox tags to align form items
Defining hbox tags in grids
Spacer items in hbox tags
Widget size within hbox tags
Stack-based layout
Label internationalization
Stacked group rendering
Toolbars
Understanding toolbars
Defining toolbars in the form file
Syntax of a toolbar file (.4tb)
Loading a toolbar from an XML file
Loading a default toolbar from an XML file
Creating the toolbar manually with DOM
Toolbars on mobile devices
Examples
Example 1: Toolbar in XML format
Example 2: Toolbar created dynamically
Example 3: Toolbar section in form file
Topmenus
Understanding topmenus
Defining the topmenu in a form file
Syntax of a topmenu file (.4tm)
Loading a topmenu from an XML file
Loading a default topmenu from an XML file
Creating the topmenu dynamically
Topmenus on mobile devices
Examples
Example 1: Topmenu in XML format
Example 2: Topmenu section in form file
Dialog instructions
Static display (DISPLAY/ERROR/MESSAGE/CLEAR)
Display of data and messages
DISPLAY (to stdout)
MESSAGE
ERROR
DISPLAY TO
DISPLAY BY NAME
CLEAR FORM
CLEAR SCREEN ARRAY
CLEAR
field-list
SCROLL
Prompt for values (PROMPT)
Understanding the PROMPT instruction
Syntax of PROMPT instruction
PROMPT programming steps
Using simple prompt inputs
PROMPT instruction configuration
Default actions in PROMPT
Interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON TIMER block
Examples
Example 1: Simple PROMPT statements
Example 2: Simple PROMPT with Interrupt Checking
Example 3: PROMPT with ATTRIBUTES and ON ACTION handlers
Ring menus (MENU)
Understanding ring menus
Syntax of the MENU instruction
MENU programming steps
Using ring menus
Rendering modes of a menu
Binding action views to menu options
MENU instruction configuration
Default actions in MENU
MENU control blocks
BEFORE MENU block
MENU interaction blocks
COMMAND [KEY()] "option" block
COMMAND KEY() block
ON ACTION block
ON IDLE block
ON TIMER block
MENU control instructions
SHOW/HIDE OPTION instruction
EXIT MENU instruction
CONTINUE MENU instruction
Examples
Example 1: MENU with abstract action options
Example 2: MENU with text-mode options
Example 3: MENU with STYLE="dialog"
Record input (INPUT)
Understanding the INPUT instruction
Syntax of the INPUT instruction
INPUT programming steps
Using simple record inputs
Variable binding in INPUT
INPUT instruction configuration
Default actions in INPUT
INPUT control blocks
INPUT control blocks execution order
BEFORE INPUT block
AFTER INPUT block
BEFORE FIELD block
ON CHANGE block
AFTER FIELD block
INPUT interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON TIMER block
INPUT control instructions
ACCEPT INPUT instruction
CONTINUE INPUT instruction
EXIT INPUT instruction
CLEAR instruction in dialogs
NEXT FIELD instruction
Examples
Example 1: INPUT with binding by field position
Example 2: INPUT with binding by field name
Record list (DISPLAY ARRAY)
Understanding the DISPLAY ARRAY instruction
Syntax of DISPLAY ARRAY instruction
DISPLAY ARRAY programming steps
Using record lists
Variable binding in DISPLAY ARRAY
DISPLAY ARRAY instruction configuration
Default actions in DISPLAY ARRAY
DISPLAY ARRAY data blocks
ON FILL BUFFER block
ON EXPAND block
ON COLLAPSE block
DISPLAY ARRAY control blocks
DISPLAY ARRAY control blocks execution order
BEFORE DISPLAY block
AFTER DISPLAY block
BEFORE ROW block
AFTER ROW block
BEFORE FIELD block
AFTER FIELD block
DISPLAY ARRAY interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON TIMER block
ON APPEND block
ON INSERT block
ON UPDATE block
ON DELETE block
ON SELECTION CHANGE block
ON SORT block
ON DRAG_START block
ON DRAG_FINISHED block
ON DRAG_ENTER block
ON DRAG_OVER block
ON DROP block
DISPLAY ARRAY control instructions
CONTINUE DISPLAY instruction
EXIT DISPLAY instruction
ACCEPT DISPLAY instruction
Examples
Example 1: DISPLAY ARRAY using full list mode
Example 2: DISPLAY ARRAY using paged mode
Example 3: DISPLAY ARRAY using modification triggers
Example 4: DISPLAY ARRAY with structured array
Editable record list (INPUT ARRAY)
Understanding the INPUT ARRAY instruction
Syntax of INPUT ARRAY instruction
INPUT ARRAY programming steps
Using editable record lists
Variable binding in INPUT ARRAY
INPUT ARRAY instruction configuration
Default actions in INPUT ARRAY
INPUT ARRAY control blocks
INPUT ARRAY control blocks execution order
BEFORE INPUT block
AFTER INPUT block
BEFORE ROW block
ON ROW CHANGE block
AFTER ROW block
BEFORE INSERT block
AFTER INSERT block
BEFORE DELETE block
AFTER DELETE block
BEFORE FIELD block
ON CHANGE block
AFTER FIELD block
INPUT ARRAY interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON SORT block
ON TIMER block
INPUT ARRAY control instructions
ACCEPT INPUT instruction
EXIT INPUT instruction
CANCEL DELETE instruction
CANCEL INSERT instruction
CONTINUE INPUT instruction
NEXT FIELD instruction
CLEAR instruction in dialogs
Examples
Example 1: INPUT ARRAY with empty record list
Example 2: INPUT ARRAY using a static array
Example 3: INPUT ARRAY using a dynamic array
Example 4: INPUT ARRAY updating the database table
Query by example (CONSTRUCT)
Understanding the CONSTRUCT instruction
Syntax of CONSTRUCT instruction
CONSTRUCT programming steps
Using query by example
Form field specification in CONSTRUCT
Query operators in CONSTRUCT
CONSTRUCT instruction configuration
Default actions IN CONSTRUCT
CONSTRUCT control blocks
CONSTRUCT control blocks execution order
BEFORE CONSTRUCT block
AFTER CONSTRUCT block
BEFORE FIELD block
ON CHANGE block
AFTER FIELD block
CONSTRUCT interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON TIMER block
CONSTRUCT control instructions
ACCEPT CONSTRUCT instruction
CONTINUE CONSTRUCT instruction
EXIT CONSTRUCT instruction
NEXT FIELD instruction
CLEAR instruction in dialogs
Examples
Example 1: CONSTRUCT with binding by field position
Example 2: CONSTRUCT with binding by field name
Multiple dialogs (DIALOG - inside functions)
Understanding multiple dialogs
Syntax of the procedural DIALOG instruction
Procedural dialog programming steps
Using multiple dialogs
Identifying sub-dialogs in procedural DIALOG
Structure of a procedural DIALOG block
The INPUT sub-dialog
The CONSTRUCT sub-dialog
The DISPLAY ARRAY sub-dialog
The INPUT ARRAY sub-dialog
The SUBDIALOG clause
Procedural DIALOG block configuration
DIALOG ATTRIBUTES clause
INPUT ATTRIBUTES clause
DISPLAY ARRAY ATTRIBUTES clause
INPUT ARRAY ATTRIBUTES clause
CONSTRUCT ATTRIBUTES clause
Default actions created by a DIALOG block
DIALOG data blocks
ON FILL BUFFER block
ON EXPAND block
ON COLLAPSE block
DIALOG control blocks
Control block execution order in multiple dialogs
BEFORE DIALOG block
AFTER DIALOG block
BEFORE FIELD block
AFTER FIELD block
ON CHANGE block
BEFORE INPUT block
AFTER INPUT block
BEFORE CONSTRUCT block
AFTER CONSTRUCT block
BEFORE DISPLAY block
AFTER DISPLAY block
BEFORE ROW block
ON ROW CHANGE block
AFTER ROW block
BEFORE INSERT block
AFTER INSERT block
BEFORE DELETE block
AFTER DELETE block
DIALOG interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON TIMER block
COMMAND [KEY] block
ON APPEND block
ON INSERT block
ON UPDATE block
ON DELETE block
ON SELECTION CHANGE block
ON SORT block
ON DRAG_START block
ON DRAG_FINISHED block
ON DRAG_ENTER block
ON DRAG_OVER block
ON DROP block
DIALOG control instructions
NEXT FIELD instruction
CLEAR instruction in dialogs
DISPLAY TO / BY NAME instruction
CONTINUE DIALOG instruction
EXIT DIALOG instruction
ACCEPT DIALOG instruction
CANCEL DIALOG instruction
CANCEL DELETE instruction
CANCEL INSERT instruction
Examples
Example 1: DIALOG controlling two lists
Example 2: DIALOG with CONSTRUCT and DISPLAY ARRAY
Example 3: DIALOG with SUBDIALOG
Declarative dialogs (DIALOG - at module level)
Understanding declarative dialogs
Syntax of the declarative DIALOG block
Declarative dialog programming steps
Using declarative dialogs
Structure of a declarative DIALOG block
The DEFINE clause
The MENU sub-dialog
The INPUT sub-dialog
The CONSTRUCT sub-dialog
The DISPLAY ARRAY sub-dialog
The INPUT ARRAY sub-dialog
Declarative DIALOG block configuration
INPUT ATTRIBUTES clause
DISPLAY ARRAY ATTRIBUTES clause
INPUT ARRAY ATTRIBUTES clause
CONSTRUCT ATTRIBUTES clause
Default actions created by a DIALOG block
DIALOG data blocks
ON FILL BUFFER block
ON EXPAND block
ON COLLAPSE block
DIALOG control blocks
Control block execution order with declarative dialogs
BEFORE FIELD block
AFTER FIELD block
ON CHANGE block
BEFORE INPUT block
AFTER INPUT block
BEFORE CONSTRUCT block
AFTER CONSTRUCT block
BEFORE DISPLAY block
AFTER DISPLAY block
BEFORE ROW block
ON ROW CHANGE block
AFTER ROW block
BEFORE INSERT block
AFTER INSERT block
BEFORE DELETE block
AFTER DELETE block
BEFORE MENU block
DIALOG interaction blocks
ON ACTION block
ON IDLE block
ON KEY block
ON TIMER block
ON APPEND block
ON INSERT block
ON UPDATE block
ON DELETE block
ON SELECTION CHANGE block
ON SORT block
ON DRAG_START block
ON DRAG_FINISHED block
ON DRAG_ENTER block
ON DRAG_OVER block
ON DROP block
DIALOG control instructions
NEXT FIELD instruction
CLEAR instruction in dialogs
DISPLAY TO / BY NAME instruction
CONTINUE DIALOG instruction
EXIT DIALOG instruction
ACCEPT DIALOG instruction
CANCEL DIALOG instruction
CANCEL DELETE instruction
CANCEL INSERT instruction
Examples
Example 1: Simple input
Example 2: Simple list
Parallel dialogs (START DIALOG)
Understanding parallel dialogs
Syntax of the START DIALOG instruction
Syntax of the TERMINATE DIALOG instruction
Parallel dialog programming steps
Using parallel dialogs
Examples
Example 1: Two independent record lists
User interface programming
Dialog programming basics
The model-view-controller paradigm
What are dialog controllers?
Dialog configuration with FGLPROFILE
The DIALOG control class
Dialog control functions
Refreshing the display when processing
User interruption handling
Get program control if user is inactive
Get program control on a regular (timed) basis
Front-End function calls
Input fields
Field data type
Binding variables to form fields
Input length of form fields
Field configuration and decoration
The buffered and unbuffered modes
Form field initialization
Input field modification flag
Reacting to field value changes
Immediate detection of user changes
Form-level validation rules
Form field deactivation
Identifying sub-dialogs in procedural DIALOG
Defining the tabbing order
Which form item has the focus?
Giving the focus to a form element
Detection of focus changes
Enabling autocompletion
Filling a COMBOBOX item list
Field-anchored windows
Dialog actions
Action handling basics
Predefined actions
Overwriting predefined actions with ON ACTION
Predefined actions enabled depending on the context
Binding action views to predefined actions
List of predefined actions
List of local actions (GDC only)
Default action views
Configuring actions
Action attributes context usage
Using attributes of action defaults
Dialog action handler attributes
Configuring default action views dynamically
Text attribute shows default action view
Defining keyboard accelerators for actions
Action attributes list
ACCELERATOR action attribute
ACCELERATOR2 action attribute
ACCELERATOR3 action attribute
ACCELERATOR4 action attribute
COMMENT action attribute
CONTEXTMENU action attribute
DEFAULTVIEW action attribute
DISCLOSUREINDICATOR action attribute
IMAGE action attribute
ROWBOUND action attribute
TEXT action attribute
VALIDATE action attribute
Defining action views in forms
Implementing dialog action handlers
Binding action views to action handlers
Data validation at action invocation
Enabling and disabling actions
Hiding and showing default action views
Sub-dialog actions in procedural DIALOG blocks
Field-specific actions (INFIELD clause)
Multilevel action conflicts
Action views with GBC
Action display in the context menu
Implementing the close action
Keyboard accelerator names
ON KEY Virtual keys
Accelerator key names
Accelerator key modifiers
Setting action key labels
Action views on mobile devices
Overview of action views on mobile devices
iOS navigation controller and toolbar pane
iOS default action views decoration
Android™ action bar
Android™ floating action button
Android™ default action views decoration
List dialogs
Understanding list dialogs
Array binding in list controllers
Controlling the number of rows
Handling the current row
Defining the action for a row choice
Field-level focus in DISPLAY ARRAY
Actions bound to the current row
Populating a DISPLAY ARRAY
Full list mode of DISPLAY ARRAY
Paged mode of DISPLAY ARRAY
INPUT ARRAY row modifications
Appending rows in INPUT ARRAY
DISPLAY ARRAY modification triggers
Cell color attributes
Multiple row selection
Table views
Understanding tables views
Defining tables in the layout
Binding tables to arrays in dialogs
Controlling table rendering
Displaying column images
Image columns firing actions
Built-in table features
Columns layout
List ordering
Find function
Keyboard seek
Reduce filter
Summary lines in tables
Defining the action for a row choice
Using tables on mobile devices
Unsupported table features
Two-column display
Full and Embedded list views
The DOUBLECLICK (tap) action
Rowbound actions
Close, accept and cancel actions
Row configuration on iOS devices
Examples
Example 1: Simple list view
Scrollgrid views
Understanding scrollgrid views
Defining scrollgrid in the layout
Binding scrollgrids to arrays in dialogs
Controlling scrollgrid rendering
Built-in scrollgrid features
Unsupported features
Supported features
Defining the action for a row choice
Using scrollgrid on mobile devices
Unsupported scrollgrid features
Supported scrollgrid features
Examples
Example 1: Simple scrollgrid view
Tree views
Understanding tree-views
Defining a TREE container
Defining the program array for tree-views
Filling the program array with rows
Controlling a tree-view with DISPLAY ARRAY
Modifying the tree during dialog execution
Using regular DISPLAY ARRAY control blocks
Dynamic filling of very large trees
Built-in sort and tree-views
Multi-row selection and tree-views
Drag and drop in tree-views
Examples
Example 1: Static tree view (filled before dialog starts)
Example 2: Dynamic tree view (filled on demand)
Split views
Understanding split views
Creating split view windows
Parallel dialogs for split views
Refreshing a parallel dialog
One or two panes
Switching between panes
Navigator pane
Rendering an HBox as a splitview
Examples
Example 1: Single split view application
Example 2: Multiple split views with navigation bar
Example 3: Split view using an HBox
Drag & drop
Understanding drag & drop
Syntax of drag & drop interaction blocks
Default drag & drop operation
Control block execution order
Handle drag & drop data with MIME types
Examples
Example 1: Two lists side-by-side with drag & drop
Web components
Understanding web components
WEBCOMPONENT item type
Controlling the web component layout
Web component in a grid-based layout
Web component in stack-based layout
Web component HTML layout
Debugging a web component
Using a URL-based web component
Defining a URL-based web component in forms
Specifying the URL source of a web component
Controlling the URL web component in programs
Examples
Example 1: URL-based web component using Google maps
Using a gICAPI web component
HTML document and JavaScript for the gICAPI object
The gICAPI web component interface script
gICAPI.Action()
gICAPI.onData()
gICAPI.onFlushData()
gICAPI.onFocus()
gICAPI.onProperty()
gICAPI.onStateChanged()
gICAPI.SetData()
gICAPI.SetFocus()
Deploying the gICAPI web component files
Deploying gICAPI assets in direct mode
Deploying gICAPI assets with GAS
Deploying gICAPI assets on mobile
Defining a gICAPI web component in forms
Controlling the gICAPI web component in programs
Using image resources with the gICAPI web component
Examples
Example 1: Calling a JavaScript function
Example 2: Simple text input
Example 3: Application images
Example 4: Color picker
Built-in Web Components
Understanding built-in web components
Built-in web components reference
The fglrichtext web component
Examples
Example 1: Simple INPUT with fglrichtext
The fglgallery web component
Examples
Example 1: Simple fglgallery example using free pictures from the web
The fglsvgcanvas web component
Examples
Example 1: Analog clock with fglsvgcanvas
Example 2: Basic SVG shapes with fglsvgcanvas
Dynamic Dialogs
Understanding dynamic dialogs
Create forms dynamically
Instantiate a dynamic dialog
Defining dialog triggers
Controlling field values
Ending dynamic dialogs
Dynamic multiple dialog
Using dynamic cursors
Additional features
Canvases
Understanding canvases
CANVAS item definition
Syntax of canvas nodes
Canvas drawing area
Canvas drawing functions
Examples
Example 1: Simple canvas
Start menus
Understanding start menus
Syntax of start menu files (.4sm)
Loading a start menu from an XML file
Creating the start menu dynamically
Rendering of a start menu
Examples
Example 1: Start menu in XML format
Example 2: Start menu created dynamically
Window containers (WCI)
Understanding the Window Container Interface
Configuration of WCI parent programs
Configuration of WCI child programs
Implement tabbed WCI containers
Reports
Understanding reports
XML output for reports
Writing an XML report driver and routine
Structure of XML report output
Conditional statements in XML output
Examples
Example 1: Nested XML report
The report driver
START REPORT
OUTPUT TO REPORT
FINISH REPORT
TERMINATE REPORT
The report routine
The report prototype
DEFINE section in REPORT
OUTPUT section in REPORT
ORDER BY section in REPORT
FORMAT section in REPORT
FORMAT EVERY ROW
FIRST PAGE HEADER
PAGE HEADER
PAGE TRAILER
BEFORE/AFTER GROUP OF
ON EVERY ROW
ON LAST ROW
Prohibited report routine statements
Two-pass reports
Report instructions
EXIT REPORT
PRINT
PRINTX
NEED
PAUSE
SKIP
Report operators
LINENO
PAGENO
SPACES
WORDWRAP
Report aggregate functions
COUNT
PERCENT
SUM
AVG
MIN
MAX
Report engine configuration
Programming tools
Command reference
fglrun
fglform
fgl2p
fglcomp
fgllink
fglmkmsg
fglmkext
fgldb
fgldbsch
fglmkstr
fglwsdl
fglrestful
fglpass
fglWrt
fglgar
fpi
gmabuildtool
gmibuildtool
Compiling source files
Compiling form specification files (.per)
Compiling message files (.msg)
Compiling string resource files (.str)
Compiling program code files (.4gl)
Importing modules
Linking libraries
Linking programs
Using makefiles
42m module information
Source code edition
Choosing the correct locale
Avoid Tab characters in screen layouts
Configure VIM for Genero BDL
Source documentation
Understanding source code documentation
Prerequisites to produce documentation
Source documentation structure
Adding comments to sources
Commenting a module constant
Commenting a module variable
Commenting a module type
Commenting a function
Commenting a report
Commenting a module
Commenting a package
Commenting a project
Run the documentation generator
Source preprocessor
Understanding the preprocessor
Compilers command line options
File inclusion
Simple macro definition
Function macro definition
Stringification operator
Concatenation operator
Predefined macros
Undefining a macro
Conditional compilation
Integrated debugger
Understanding the debugger
Prerequisites to run the debugger
Starting fglrun in debug mode
Attaching to a running program
Debugging on a mobile device
Stack frames in the debugger
Setting a breakpoint programmatically
Expressions in debugger commands
Debugger commands
backtrace / where
break
call
clear
continue
delete
detach
disable
display
down
echo
enable
finish
frame
help
ignore
info
list
next
output
print
ptype
quit
run
set
source
signal
step
tbreak
tty
undisplay
until
up
watch
whatis
Program profiler
Understanding the profiler
Syntax of the program profiler
Profiler output: Flat profile
Profiler output: Call graph
Example
Source code coverage
Understanding the code coverage tool
Syntax of the code coverage tool
Code coverage tool usage
Execution trace
Understanding the program execution trace
Syntax of the program execution trace
Using the program execution trace
Source code beautifier
Understanding the code beautifier tool
Syntax of the code beautifier tool
Code beautifier tool usage
Packaging web applications
Introducing the GAS and JGAS
Understanding packaging with GAS
Deploying applications on GAS
Packaging war files
Running applications from a war file
Examples
Logging options
Extending the language
The Java interface
Prerequisites and installation
Learn about Java and OOP
Java software requirements
How to set up Java
Platform-specific notes for the JVM
Getting started with the Java interface
Import a Java class
Define an object reference variable
Instantiate a Java class
Calling a method of a class
Calling a method of an object
Advanced programming
Using JVM options
Case sensitivity with Java
Method overloading in Java
Passing Java objects to functions
Garbage collection of unused objects
Using the method return as an object
Ignorable return of Java methods
Static fields of Java classes
Mapping native and Java data types
Using the DATE type
Using the DATETIME type
Using the DECIMAL type
Using the TEXT type
Using the BYTE type
Using the INTERVAL type
Identifying Genero data types in Java code
Using Genero records
Formatting data in Java code
Character set mapping
Using Java arrays
Passing variable arguments (varargs)
The CAST operator
The INSTANCEOF operator
Java exception handling
Executing Java code with GMA
Standard Java and Android library usage
Implement Java user extensions in GMA
Implement Android™ activities in GMA
Packaging custom Java extensions for GMA
Custom GMA binary archive build
Examples
Example 1: Using the regex package
Example 2: Using the Apache POI framework
Example 3: Using Java on Android™
C-Extensions
Understanding C-Extensions
Header files for ESQL/C typedefs
Creating C-Extensions
Creating Informix® ESQL/C Extensions
The C interface file
Linking programs using C-Extensions
Loading C-Extensions at runtime
Runtime stack functions
Data types and structures
NULL handing
Calling C functions from programs
Calling program functions from C
Simple C-Extension example
Implementing C-Extensions for GMI
User-defined front calls
Implement front call modules for GDC
Implement front call modules for GMA
Implement front call modules for GMI
Implement front call modules for GBC
Web Components
Library reference
Built-in functions
Built-in functions
arg_val()
arr_count()
arr_curr()
downshift()
scr_line()
num_args()
err_get()
err_print()
err_quit()
errorlog()
fgl_buffertouched()
fgl_db_driver_type()
fgl_decimal_truncate()
fgl_decimal_sqrt()
fgl_decimal_exp()
fgl_decimal_logn()
fgl_decimal_power()
fgl_dialog_getbuffer()
fgl_dialog_setbuffer()
fgl_dialog_getfieldname()
fgl_dialog_infield()
fgl_dialog_setcursor()
fgl_dialog_setfieldorder()
fgl_dialog_setcurrline()
fgl_dialog_getbufferstart()
fgl_dialog_getbufferlength()
fgl_dialog_getcursor() / fgl_getcursor()
fgl_dialog_getkeylabel()
fgl_dialog_getselectionend()
fgl_dialog_setkeylabel()
fgl_dialog_setselection()
fgl_drawbox()
fgl_drawline()
fgl_eventloop()
fgl_getenv()
fgl_gethelp()
fgl_getpid()
fgl_getfile()
fgl_getkey()
fgl_getkeylabel()
fgl_getresource()
fgl_getversion()
fgl_getwin_height()
fgl_getwin_width()
fgl_getwin_x()
fgl_getwin_y()
fgl_keyval()
fgl_lastkey()
fgl_mblen()
fgl_putfile()
fgl_report_print_binary_file()
fgl_report_set_document_handler()
fgl_setkeylabel()
fgl_scr_size()
fgl_setsize()
fgl_settitle()
fgl_setenv()
fgl_set_arr_curr()
fgl_sqldebug()
fgl_system()
fgl_width()
fgl_window_getoption()
length()
set_count()
showhelp()
startlog()
upshift()
List of desupported built-in functions
The key code table
Utility modules
fgldialog: Common dialog functions
fgl_winbutton()
fgl_winmessage()
fgl_winprompt()
fgl_winquestion()
fgl_winwait()
fgldbutl: Database utility module
db_get_database_type()
db_get_last_serial()
db_get_sequence()
db_start_transaction()
db_finish_transaction()
db_is_transaction_started()
fglwinexec: Front-end dialogs module
winopendir()
winopenfile()
winsavefile()
winexec() MS Windows® FE Only!
winexecwait() MS Windows® FE Only!
winshellexec() MS Windows® FE Only!
VCard: VCF file format module
VCAddress type
VCName type
VCPerson type
format_person()
scan_address()
scan_email()
scan_name()
scan_person()
scan_phone()
fglgallery: Image gallery module
t_struct_value type
addImage()
clean()
create()
deleteImages()
destroy()
display()
finalize()
flush()
getImageCount()
getPath()
getTitle()
initialize()
setMultipleSelection()
setAspectRatio()
fglsvgcanvas: SVG drawing module
t_svg_rect type
SVGATT_ constants
animateTransform()
circle()
clean()
clipPath_rect()
color_shade()
color_tint()
create()
createChars()
createElement()
defs()
destroy()
display()
ellipse()
filter()
finalize()
g()
getBBox()
getItemid()
image()
initialize()
line()
linearGradient()
marker()
mask()
nl_to_tspan()
path()
pattern()
polygon()
polyline()
radialGradient()
rect()
removeElement()
setAttributes()
setCurrent()
setRootSVGAttributes()
stop()
styleAttributeList()
styleDefinition()
styleList()
svg()
text()
text_path()
text_tref()
title()
tspan()
url()
use()
Built-in packages
BDL data types package
BYTE data type as class
BYTE data type methods
BYTE.readFile
BYTE.writeFile
STRING data type as class
STRING data type methods
STRING.append
STRING.equals
STRING.equalsIgnoreCase
STRING.getCharAt
STRING.getIndexOf
STRING.getLength
STRING.subString
STRING.toLowerCase
STRING.toUpperCase
STRING.trim
STRING.trimWhiteSpace
STRING.trimLeft
STRING.trimLeftWhiteSpace
STRING.trimRight
STRING.trimRightWhiteSpace
TEXT data type as class
TEXT data type methods
TEXT.getLength
TEXT.readFile
TEXT.writeFile
DYNAMIC ARRAY as class
DYNAMIC ARRAY methods
DYNAMIC ARRAY.appendElement
DYNAMIC ARRAY.clear
DYNAMIC ARRAY.copyTo
DYNAMIC ARRAY.deleteElement
DYNAMIC ARRAY.getLength
DYNAMIC ARRAY.insertElement
DYNAMIC ARRAY.search
DYNAMIC ARRAY.searchRange
DYNAMIC ARRAY.sort
DICTIONARY as class
DICTIONARY methods
DICTIONARY.clear
DICTIONARY.contains
DICTIONARY.copyTo
DICTIONARY.getLength
DICTIONARY.getKeys
DICTIONARY.remove
Java Array type as class
Java Array type methods
java-array-type
.create
java-array
.getLength
The base package
The Application class
base.Application methods
base.Application.getArgument
base.Application.getArgumentCount
base.Application.getFglDir
base.Application.getProgramDir
base.Application.getProgramName
base.Application.getResourceEntry
base.Application.getStackTrace
base.Application.isMobile
base.Application.reloadResources
The Channel class
base.Channel methods
base.Channel.create
base.Channel.close
base.Channel.dataAvailable
base.Channel.isEof
base.Channel.openClientSocket
base.Channel.openFile
base.Channel.openPipe
base.Channel.openServerSocket
base.Channel.read
base.Channel.readLine
base.Channel.readOctets
base.Channel.setDelimiter
base.Channel.write
base.Channel.writeLine
base.Channel.writeNoNL
Usage
Read and write record data
Read and write text lines
Line terminators on Windows and UNIX
Character string encoding
BYTE data serialization
Handle channel exceptions
Setup a TCP socket channel
Examples
Example 1: Using record-formatted data file
Example 2: Executing the ls UNIX™ command
Example 3: Reading lines from a text file
Example 4: Communicating with an HTTP server
Example 5: Writing to STDERR
The SqlHandle class
base.SqlHandle methods
base.SqlHandle.create
base.SqlHandle.close
base.SqlHandle.execute
base.SqlHandle.fetch
base.SqlHandle.fetchAbsolute
base.SqlHandle.fetchFirst
base.SqlHandle.fetchLast
base.SqlHandle.fetchPrevious
base.SqlHandle.fetchRelative
base.SqlHandle.flush
base.SqlHandle.getResultCount
base.SqlHandle.getResultName
base.SqlHandle.getResultType
base.SqlHandle.getResultValue
base.SqlHandle.open
base.SqlHandle.openScrollCursor
base.SqlHandle.prepare
base.SqlHandle.put
base.SqlHandle.setParameter
Usage
Examples
Example 1: SqlHandle with simple SQL
Example 2: SqlHandle with result set SQL
Example 3: SqlHandle with insert cursor
Example 4: SqlHandle with scroll cursor
The StringBuffer class
base.StringBuffer methods
base.StringBuffer.create
base.StringBuffer.append
base.StringBuffer.clear
base.StringBuffer.equals
base.StringBuffer.equalsIgnoreCase
base.StringBuffer.getCharAt
base.StringBuffer.getIndexOf
base.StringBuffer.getLength
base.StringBuffer.insertAt
base.StringBuffer.replace
base.StringBuffer.replaceAt
base.StringBuffer.subString
base.StringBuffer.toLowerCase
base.StringBuffer.toString
base.StringBuffer.toUpperCase
base.StringBuffer.trim
base.StringBuffer.trimWhiteSpace
base.StringBuffer.trimLeft
base.StringBuffer.trimLeftWhiteSpace
base.StringBuffer.trimRight
base.StringBuffer.trimRightWhiteSpace
Examples
Example 1: Add strings to a StringBuffer
Example 2: Modify a StringBuffer with a function
The StringTokenizer class
base.StringTokenizer methods
base.StringTokenizer.create
base.StringTokenizer.createExt
base.StringTokenizer.countTokens
base.StringTokenizer.hasMoreTokens
base.StringTokenizer.nextToken
Examples
Example 1: Split a UNIX™ directory path
Example 2: Escaped delimiters and NULL tokens
Example 3: Specify a backslash as a delimiter
The TypeInfo class
base.TypeInfo methods
base.TypeInfo.create()
base.TypeInfo.describe()
The MessageServer class
base.MessageServer methods
base.MessageServer.connect
base.MessageServer.send
Examples
Example 1: Simple MessageServer usage
The ui package
The Interface class
ui.Interface methods
ui.Interface.frontCall
ui.Interface.filenameToURI
ui.Interface.getChildCount
ui.Interface.getChildInstances
ui.Interface.getContainer
ui.Interface.getDocument
ui.Interface.getFrontEndName
ui.Interface.getFrontEndVersion
ui.Interface.getImage
ui.Interface.getName
ui.Interface.getRootNode
ui.Interface.getText
ui.Interface.getType
ui.Interface.getUniversalClientName
ui.Interface.getUniversalClientVersion
ui.Interface.loadActionDefaults
ui.Interface.loadStartMenu
ui.Interface.loadStyles
ui.Interface.loadToolBar
ui.Interface.loadTopMenu
ui.Interface.refresh
ui.Interface.setContainer
ui.Interface.setImage
ui.Interface.setName
ui.Interface.setSize
ui.Interface.setText
ui.Interface.setType
Examples
Example 1: Get the type and version of the front-end
Example 2: Get the AUI root node and save it to a file in XML format
Example 3: Using the Window Container Interface
Example 4: Loading custom resources
The Window class
ui.Window methods
ui.Window.forName
ui.Window.createForm
ui.Window.getCurrent
ui.Window.getForm
ui.Window.getNode
ui.Window.findNode
ui.Window.getImage
ui.Window.getText
ui.Window.setImage
ui.Window.setText
Examples
Example 1: Get a window by name and change the title
Example 2: Get a the current form and hide a groupbox
The Form class
ui.Form methods
ui.Form.setDefaultInitializer
ui.Form.displayTo
ui.Form.ensureElementVisible
ui.Form.ensureFieldVisible
ui.Form.getNode
ui.Form.findNode
ui.Form.loadActionDefaults
ui.Form.loadToolBar
ui.Form.loadTopMenu
ui.Form.setElementHidden
ui.Form.setElementImage
ui.Form.setElementStyle
ui.Form.setElementText
ui.Form.setFieldHidden
ui.Form.setFieldStyle
Examples
Example 1: Implement a global form initialization function
Example 2: Hide form elements dynamically
Example 3: Change the title of table column headers
The Dialog class
ui.Dialog methods
ui.Dialog.createConstructByName
ui.Dialog.createDisplayArrayTo
ui.Dialog.createInputArrayFrom
ui.Dialog.createInputByName
ui.Dialog.createMultipleDialog
ui.Dialog.getCurrent
ui.Dialog.setDefaultUnbuffered
ui.Dialog.accept
ui.Dialog.addConstructByName
ui.Dialog.addDisplayArrayTo
ui.Dialog.addInputArrayFrom
ui.Dialog.addInputByName
ui.Dialog.addTrigger
ui.Dialog.appendRow
ui.Dialog.appendNode
ui.Dialog.arrayToVisualIndex
ui.Dialog.cancel
ui.Dialog.close
ui.Dialog.deleteAllRows
ui.Dialog.deleteNode
ui.Dialog.deleteRow
ui.Dialog.getArrayLength
ui.Dialog.getCurrentItem
ui.Dialog.getCurrentRow
ui.Dialog.getFieldBuffer
ui.Dialog.getFieldTouched
ui.Dialog.getFieldValue
ui.Dialog.getForm
ui.Dialog.getQueryFromField
ui.Dialog.getSortKey
ui.Dialog.insertNode
ui.Dialog.insertRow
ui.Dialog.isRowSelected
ui.Dialog.isSortReverse
ui.Dialog.nextEvent
ui.Dialog.nextField
ui.Dialog.selectionToString
ui.Dialog.setActionActive
ui.Dialog.setActionComment
ui.Dialog.setActionHidden
ui.Dialog.setActionImage
ui.Dialog.setActionText
ui.Dialog.setArrayAttributes
ui.Dialog.setArrayLength
ui.Dialog.setCellAttributes
ui.Dialog.setCompleterItems
ui.Dialog.setCurrentRow
ui.Dialog.setFieldActive
ui.Dialog.setFieldTouched
ui.Dialog.setFieldValue
ui.Dialog.setSelectionMode
ui.Dialog.setSelectionRange
ui.Dialog.validate
ui.Dialog.visualToArrayIndex
Usage
Referencing the current dialog
Passing a dialog reference to functions
Identifying actions in dialog methods
Identifying fields in dialog methods
Identifying screen-arrays in dialog methods
Field definition for Dynamic Dialogs
Examples
Example 1: Disable fields dynamically
Example 2: Get the form and hide fields
Example 3: Pass a dialog object to a function
Example 4: Set display attributes for cells
The ComboBox class
ui.ComboBox methods
ui.ComboBox.setDefaultInitializer
ui.ComboBox.forName
ui.ComboBox.addItem
ui.ComboBox.clear
ui.ComboBox.getColumnName
ui.ComboBox.getIndexOf
ui.ComboBox.getItemCount
ui.ComboBox.getItemName
ui.ComboBox.getItemText
ui.ComboBox.getTableName
ui.ComboBox.getTag
ui.ComboBox.getTextOf
ui.ComboBox.removeItem
Examples
Example Get a ComboBox form field view and fill the item list
Example Using the INITIALIZER attribute in the form file
The DragDrop class
ui.DragDrop methods
ui.DragDrop.addPossibleOperation
ui.DragDrop.dropInternal
ui.DragDrop.getBuffer
ui.DragDrop.getLocationParent
ui.DragDrop.getLocationRow
ui.DragDrop.getSelectedMimeType
ui.DragDrop.getOperation
ui.DragDrop.selectMimeType
ui.DragDrop.setBuffer
ui.DragDrop.setFeedback
ui.DragDrop.setMimeType
ui.DragDrop.setOperation
The om package
The DomDocument class
om.DomDocument methods
om.DomDocument.create
om.DomDocument.createFromString
om.DomDocument.createFromXmlFile
om.DomDocument.getDocumentElement
om.DomDocument.getElementById
om.DomDocument.createChars
om.DomDocument.createElement
om.DomDocument.createEntity
om.DomDocument.copy
om.DomDocument.removeElement
Examples
Example 1: Creating a DOM document
The DomNode class
om.DomNode methods
om.DomNode.appendChild
om.DomNode.createChild
om.DomNode.insertBefore
om.DomNode.loadXml
om.DomNode.parse
om.DomNode.getAttribute
om.DomNode.getAttributeInteger
om.DomNode.getAttributesCount
om.DomNode.getAttributeString
om.DomNode.getAttributeName
om.DomNode.getAttributeValue
om.DomNode.getChildByIndex
om.DomNode.getChildCount
om.DomNode.getFirstChild
om.DomNode.getId
om.DomNode.getLastChild
om.DomNode.getNext
om.DomNode.getParent
om.DomNode.getPrevious
om.DomNode.getTagName
om.DomNode.removeAttribute
om.DomNode.removeChild
om.DomNode.replaceChild
om.DomNode.selectByPath
om.DomNode.selectByTagName
om.DomNode.setAttribute
om.DomNode.toString
om.DomNode.write
om.DomNode.writeXml
Examples
Example 1: Creating a DOM tree
Example 2: Displaying a DOM tree recursively
Example 3: Writing a DOM tree to a SAX handler
The NodeList class
om.NodeList methods
om.NodeList.getLength
om.NodeList.item
Examples
Example 1: Search nodes by tag name
Example 2: Search nodes by XPath
The SaxAttributes class
om.SaxAttributes methods
om.SaxAttributes.addAttribute
om.SaxAttributes.copy
om.SaxAttributes.create
om.SaxAttributes.clear
om.SaxAttributes.getLength
om.SaxAttributes.getName
om.SaxAttributes.getValue
om.SaxAttributes.getValueByIndex
om.SaxAttributes.removeAttribute
om.SaxAttributes.setAttributes
Examples
Example 1: Displaying SAX attributes of an XML node
Example 2: Creating a SAX attributes object
The SaxDocumentHandler class
om.SaxDocumentHandler methods
om.SaxDocumentHandler.createForName
om.SaxDocumentHandler.characters
om.SaxDocumentHandler.endDocument
om.SaxDocumentHandler.endElement
om.SaxDocumentHandler.processingInstruction
om.SaxDocumentHandler.readXmlFile
om.SaxDocumentHandler.setIndent
om.SaxDocumentHandler.startDocument
om.SaxDocumentHandler.startElement
om.SaxDocumentHandler.skippedEntity
Examples
Example 1: Extracting phone numbers from a directory
Example 2: Producing an XML file with om.SaxDocumentHandler
The XmlReader class
om.XmlReader methods
om.XmlReader.createFileReader
om.XmlReader.getAttributes
om.XmlReader.getCharacters
om.XmlReader.getTagName
om.XmlReader.read
om.XmlReader.skippedEntity
Examples
Example 1: Parsing an XML file
The XmlWriter class
om.XmlWriter methods
om.XmlWriter.createChannelWriter
om.XmlWriter.createFileWriter
om.XmlWriter.createPipeWriter
om.XmlWriter.createSocketWriter
Examples
Example 1: Writing XML to a file
Built-in front calls
Built-in front calls summary
Standard front calls
cbAdd
cbClear
cbGet
cbPaste
cbSet
clearFileCache
execute
feInfo
getEnv
getWindowId
hardCopy
launchURL
mdClose
openDir
openFile
openFiles
playSound
saveFile
setReportFont
setReportPrinter
setWebComponentPath
shellExec
Web component front calls
call
frontCallAPIVersion
getTitle
Genero Desktop Client front calls
GDC Monitor Front Calls
update
Windows DDE Support
Using the WinDDE API
WINDDE API front calls
DDEConnect
DDEExecute
DDEFinish
DDEFinishAll
DDEError
DDEPeek
DDEPoke
WinDDE example
Windows™ COM Support
Using the WinCOM API
WINCOM API front calls
CreateInstance
CallMethod
GetProperty
SetProperty
GetError
ReleaseInstance
WinCOM examples
Wincom and Excel example
Wincom and Word example
Wincom and Outlook example
Wincom and Internet Explorer example
Windows Mail extension
WinMail API front calls
Init
Close
SetBody
SetSubject
AddTo
AddCC
AddBCC
AddAttachment
SendMailSMTP
SendMailMAPI
GetError
SetSmtp
SetFrom
WinMail examples
Mail using MAPI
Mail using SMTP server
Theme front calls
setTheme
getCurrentTheme
listThemes
Local storage front calls
setItem
getItem
removeItem
keys
clear
Genero Mobile common front calls
chooseContact
choosePhoto
chooseVideo
composeMail
composeSMS
connectivity
getGeolocation
getRemoteNotifications
importContact
isForeground
registerForRemoteNotifications
runOnServer
scanBarCode
takePhoto
takeVideo
unregisterFromRemoteNotifications
Genero Mobile Android™ front calls
askForPermission (Android™)
showAbout (Android™)
showSettings (Android™)
startActivity (Android™)
startActivityForResult (Android™)
Genero Mobile iOS front calls
getBadgeNumber (iOS)
newContact (iOS)
setBadgeNumber (iOS)
Cordova plugin front calls
call
callWithoutWaiting
getAllCallbackData
getCallbackDataCount
getCallbackData
getPluginInfo
listPlugins
Extension packages
The util package
The util.Date class
util.Date methods
util.Date.parse
util.Date.isLeapYear
The util.Datetime class
util.Datetime methods
util.Datetime.format
util.Datetime.fromSecondsSinceEpoch
util.Datetime.getCurrentAsUTC
util.Datetime.parse
util.Datetime.toLocalTime
util.Datetime.toSecondsSinceEpoch
util.Datetime.toUTC
The util.Integer class
util.Integer methods
util.Integer.abs
util.Integer.and
util.Integer.andNot
util.Integer.clearBit
util.Integer.not
util.Integer.or
util.Integer.parseHexString
util.Integer.parseBinaryString
util.Integer.setBit
util.Integer.shiftLeft
util.Integer.shiftRight
util.Integer.testBit
util.Integer.toHexString
util.Integer.toBinaryString
util.Integer.xor
The util.Interval class
util.Interval methods
util.Interval.format
util.Interval.parse
The util.Strings class
util.Strings methods
util.Strings.base64Decode
util.Strings.base64Encode
util.Strings.base64DecodeToHexString
util.Strings.base64DecodeToString
util.Strings.base64EncodeFromHexString
util.Strings.base64EncodeFromString
util.Strings.urlDecode
util.Strings.urlEncode
The util.Math class
util.Math methods
util.Math.acos
util.Math.asin
util.Math.atan
util.Math.cos
util.Math.exp
util.Math.pi
util.Math.pow
util.Math.rand
util.Math.sin
util.Math.sqrt
util.Math.srand
util.Math.tan
util.Math.log
util.Math.toDegrees
util.Math.toRadians
The util.JSON class
util.JSON methods
util.JSON.format
util.JSON.parse
util.JSON.proposeType
util.JSON.stringify
util.JSON.stringifyOmitNulls
Examples
Example 1: Reading a JSON file
The util.JSONObject class
util.JSONObject methods
util.JSONObject.create
util.JSONObject.fromFGL
util.JSONObject.parse
util.JSONObject.get
util.JSONObject.getLength
util.JSONObject.getType
util.JSONObject.has
util.JSONObject.name
util.JSONObject.put
util.JSONObject.remove
util.JSONObject.toFGL
util.JSONObject.toString
The util.JSONArray class
util.JSONArray methods
util.JSONArray.create
util.JSONArray.fromFGL
util.JSONArray.parse
util.JSONArray.get
util.JSONArray.getLength
util.JSONArray.getType
util.JSONArray.put
util.JSONArray.remove
util.JSONArray.toFGL
util.JSONArray.toString
The os package
The os.Path class
os.Path methods
os.Path.atime
os.Path.baseName
os.Path.copy
os.Path.chDir
os.Path.chRwx
os.Path.chOwn
os.Path.chVolume
os.Path.delete
os.Path.dirClose
os.Path.dirFMask
os.Path.dirName
os.Path.dirNext
os.Path.dirOpen
os.Path.dirSort
os.Path.executable
os.Path.exists
os.Path.extension
os.Path.fullPath
os.Path.gid
os.Path.homeDir
os.Path.isDirectory
os.Path.isFile
os.Path.isHidden
os.Path.isLink
os.Path.isRoot
os.Path.join
os.Path.makeTempName
os.Path.mtime
os.Path.mkDir
os.Path.pathSeparator
os.Path.pathType
os.Path.pwd
os.Path.readable
os.Path.rename
os.Path.separator
os.Path.size
os.Path.rootDir
os.Path.rootName
os.Path.rwx
os.Path.type
os.Path.uid
os.Path.volumes
os.Path.writable
Examples
Example 1: Extracting the parts of a file name
Example 2: Browsing directories
The com package
Web services classes
The WebService class
WebServices methods
createFault
createHeader
CreateWebService
CreateStatefulWebService
generateWSDL
publishOperation
registerInputHTTPVariable
registerInputRequestHandler
registerOutputHTTPVariable
registerOutputRequestHandler
registerWSDLHandler
saveWSDL
setComment
setFeature
The WebOperation class
WebOperation methods
addFault
addInputHeader
addOutputHeader
CreateDOCStyle
CreateRPCStyle
CreateOneWayDOCStyle
CreateOneWayRPCStyle
initiateSession
setComment
setInputAction
setInputEncoded
setOutputAction
setOutputEncoded
The WebServiceEngine class
WebServiceEngine methods
Flush
GetHTTPServiceRequest
GetOption
HandleRequest
ProcessServices
RegisterService
RegisterRestService
SetFaultCode
SetFaultDetail
SetFaultString
SetOption
SetRestError
Start
WSDL generation options notes
WebServiceEngine options
Error codes of com.WebServicesEngine
The HTTPServiceRequest class
HTTPServiceRequest methods
addResponsePart
beginXmlRequest
beginXmlResponse
endXmlRequest
endXmlResponse
findRequestCookie
getMethod
getRequestVersion
getRequestHeader
getRequestHeaderCount
getRequestHeaderName
getRequestHeaderValue
getRequestMultipartType
getRequestPart
getRequestPartCount
getRequestPartFromID
getURL
getURLHost
getURLPath
getURLPort
getURLQuery
hasRequestKeepConnection
readDataRequest
readFileRequest
readFormEncodedRequest
readTextRequest
readXmlRequest
sendDataResponse
sendFileResponse
sendResponse
sendTextResponse
sendXmlResponse
setResponseCharset
setResponseCookies
setResponseHeader
setResponseMultipartType
setResponseVersion
Examples (HTTPServiceRequest)
HTTP classes
The HTTPRequest class
HTTPRequest methods
addPart
beginXmlRequest
clearAuthentication
clearHeaders
Create
doDataRequest
doFileRequest
doFormEncodedRequest
doRequest
doTextRequest
doXmlRequest
endXmlRequest
getAsyncResponse
getResponse
removeHeader
setAuthentication
setAutoCookies
setAutoReply
setCharset
setConnectionTimeOut
setHeader
setKeepConnection
setMaximumResponseLength
setMethod
setMultipartType
setProxy
setProxyAuthentication
setTimeOut
setVersion
Examples (HTTPRequest)
The HTTPResponse class
HTTPResponse methods
beginXmlResponse
endXmlResponse
getDataResponse
getFileResponse
getHeader
getHeaderCount
getHeaderName
getHeaderValue
getMultipartType
getPartCount
getPart
getPartFromID
getServerCookies
getStatusCode
getStatusDescription
getTextResponse
getXmlResponse
Examples (HTTPResponse)
The HTTPPart class
HTTPPart methods
CreateFromString
CreateFromDomDocument
CreateFromData
CreateAttachment
clearHeaders
getAttachment
getContentAsData
getContentAsDomDocument
getContentAsString
getHeader
removeHeader
setHeader
Examples (HTTPPart)
TCP classes
The TCPRequest class
TCPRequest methods
beginXmlRequest
Create
doDataRequest
doRequest
doXmlRequest
doTextRequest
endXmlRequest
getResponse
getAsyncResponse
setTimeOut
setConnectionTimeOut
setKeepConnection
setMaximumResponseLength
The TCPResponse class
TCPResponse methods
beginXmlResponse
endXmlResponse
getDataResponse
getTextResponse
getXmlResponse
Helper classes
The Util class
Util methods
UniqueApplicationInstance
Specific classes
The APNS class
APNs SSL/TLS certificate
APNS methods
DecodeError
DecodeFeedback
EncodeMessage
APNs examples
APNs push provider
APNs feedback handler
The xml package
The Document Object Modeling (DOM) classes
The DomDocument class
xml.DomDocument methods
xml.DomDocument.appendDocumentNode
xml.DomDocument.clone
xml.DomDocument.create
xml.DomDocument.createAttribute
xml.DomDocument.createAttributeNS
xml.DomDocument.createCDATASection
xml.DomDocument.createComment
xml.DomDocument.createDocument
xml.DomDocument.createDocumentFragment
xml.DomDocument.createDocumentNS
xml.DomDocument.createDocumentType
xml.DomDocument.createElement
xml.DomDocument.createElementNS
xml.DomDocument.createEntityReference
xml.DomDocument.createNode
xml.DomDocument.createProcessingInstruction
xml.DomDocument.createTextNode
xml.DomDocument.declareNamespace
xml.DomDocument.getDocumentElement
xml.DomDocument.getDocumentNodesCount
xml.DomDocument.getDocumentNodeItem
xml.DomDocument.getElementById
xml.DomDocument.getElementsByTagName
xml.DomDocument.getElementsByTagNameNS
xml.DomDocument.getErrorDescription
xml.DomDocument.getErrorsCount
xml.DomDocument.getFirstDocumentNode
xml.DomDocument.getFeature
xml.DomDocument.getLastDocumentNode
xml.DomDocument.getXmlEncoding
xml.DomDocument.getXmlVersion
xml.DomDocument.importNode
xml.DomDocument.insertBeforeDocumentNode
xml.DomDocument.insertAfterDocumentNode
xml.DomDocument.isXmlStandalone
xml.DomDocument.load
xml.DomDocument.loadFromPipe
xml.DomDocument.loadFromString
xml.DomDocument.normalize
xml.DomDocument.prependDocumentNode
xml.DomDocument.removeDocumentNode
xml.DomDocument.save
xml.DomDocument.saveToPipe
xml.DomDocument.saveToString
xml.DomDocument.selectByXPath
xml.DomDocument.setFeature
xml.DomDocument.setXmlEncoding
xml.DomDocument.setXmlStandalone
xml.DomDocument.validate
xml.DomDocument.validateOneElement
Navigation methods usage examples
Node creation methods usage examples
HTML document usage example
Load and save methods usage examples
Cautions
DomDocument Features
Examples
Example 1 : Create a namespace qualified document with processing instructions
Example 2 : Validating a document against XML schemas or a DTD
The DomNode class
xml.DomNode methods
xml.DomNode.addPreviousSibling
xml.DomNode.addNextSibling
xml.DomNode.appendChild
xml.DomNode.appendChildElement
xml.DomNode.appendChildElementNS
xml.DomNode.clone
xml.DomNode.getAttribute
xml.DomNode.getAttributeNode
xml.DomNode.getAttributeNodeItem
xml.DomNode.getAttributeNodeNS
xml.DomNode.getAttributeNS
xml.DomNode.getAttributesCount
xml.DomNode.getChildNodeItem
xml.DomNode.getChildrenCount
xml.DomNode.getElementsByTagName
xml.DomNode.getElementsByTagNameNS
xml.DomNode.getFirstChild
xml.DomNode.getFirstChildElement
xml.DomNode.getLastChild
xml.DomNode.getLastChildElement
xml.DomNode.getLocalName
xml.DomNode.getNamespaceURI
xml.DomNode.getNextSibling
xml.DomNode.getNextSiblingElement
xml.DomNode.getNodeName
xml.DomNode.getNodeType
xml.DomNode.getNodeValue
xml.DomNode.getOwnerDocument
xml.DomNode.getParentNode
xml.DomNode.getPrefix
xml.DomNode.getPreviousSibling
xml.DomNode.getPreviousSiblingElement
xml.DomNode.hasAttribute
xml.DomNode.hasAttributeNS
xml.DomNode.hasAttributes
xml.DomNode.hasChildNodes
xml.DomNode.insertAfterChild
xml.DomNode.insertBeforeChild
xml.DomNode.isAttached
xml.DomNode.isDefaultNamespace
xml.DomNode.lookupNamespaceURI
xml.DomNode.lookupPrefix
xml.DomNode.prependChild
xml.DomNode.prependChildElement
xml.DomNode.prependChildElementNS
xml.DomNode.removeAllChildren
xml.DomNode.removeAttribute
xml.DomNode.removeAttributeNS
xml.DomNode.removeChild
xml.DomNode.replaceChild
xml.DomNode.selectByXPath
xml.DomNode.setAttribute
xml.DomNode.setAttributeNode
xml.DomNode.setAttributeNodeNS
xml.DomNode.setAttributeNS
xml.DomNode.setIdAttribute
xml.DomNode.setIdAttributeNS
xml.DomNode.setNodeValue
xml.DomNode.setPrefix
xml.DomNode.toString
DomNode types
Examples
Example Counting the number of nodes in an XML document
The DomNodeList class
xml.DomNodeList methods
xml.DomNodeList.getCount
xml.DomNodeList.getItem
The streaming API for XML (StAX) classes
The StaxWriter class
xml.StaxWriter methods
xml.StaxWriter.attribute
xml.StaxWriter.attributeNS
xml.StaxWriter.cdata
xml.StaxWriter.characters
xml.StaxWriter.close
xml.StaxWriter.comment
xml.StaxWriter.create
xml.StaxWriter.declareDefaultNamespace
xml.StaxWriter.declareNamespace
xml.StaxWriter.dtd
xml.StaxWriter.emptyElement
xml.StaxWriter.emptyElementNS
xml.StaxWriter.endDocument
xml.StaxWriter.endElement
xml.StaxWriter.entityRef
xml.StaxWriter.getFeature
xml.StaxWriter.processingInstruction
xml.StaxWriter.setDefaultNamespace
xml.StaxWriter.setFeature
xml.StaxWriter.setPrefix
xml.StaxWriter.startDocument
xml.StaxWriter.startElement
xml.StaxWriter.startElementNS
xml.StaxWriter.writeTo
xml.StaxWriter.writeToDocument
xml.StaxWriter.writeToPipe
xml.StaxWriter.writeToText
StaxWriter Features
Example
The StaxReader class
xml.StaxReader methods
xml.StaxReader.close
xml.StaxReader.Create
xml.StaxReader.findAttributeValue
xml.StaxReader.getAttributeCount
xml.StaxReader.getAttributeLocalName
xml.StaxReader.getAttributeNamespace
xml.StaxReader.getAttributePrefix
xml.StaxReader.getAttributeValue
xml.StaxReader.getEncoding
xml.StaxReader.getEventType
xml.StaxReader.getFeature
xml.StaxReader.getLocalName
xml.StaxReader.getName
xml.StaxReader.getNamespace
xml.StaxReader.getNamespaceCount
xml.StaxReader.getNamespacePrefix
xml.StaxReader.getNamespaceURI
xml.StaxReader.getPIData
xml.StaxReader.getPITarget
xml.StaxReader.getPrefix
xml.StaxReader.getText
xml.StaxReader.getVersion
xml.StaxReader.hasName
xml.StaxReader.hasNext
xml.StaxReader.hasText
xml.StaxReader.isCharacters
xml.StaxReader.isEmptyElement
xml.StaxReader.isEndElement
xml.StaxReader.isIgnorableWhitespace
xml.StaxReader.isStandalone
xml.StaxReader.isStartElement
xml.StaxReader.lookupNamespace
xml.StaxReader.lookupPrefix
xml.StaxReader.next
xml.StaxReader.nextSibling
xml.StaxReader.nextTag
xml.StaxReader.readFrom
xml.StaxReader.readFromDocument
xml.StaxReader.readFromPipe
xml.StaxReader.readFromText
xml.StaxReader.setFeature
xml.StaxReader.standaloneSet
StaxReader Features
StaxReader Event Types
Example
XML serialization classes
The Serializer class
xml.Serializer methods
xml.Serializer.CreateXmlSchemas
xml.Serializer.DomToStax
xml.Serializer.DomToVariable
xml.Serializer.getOption
xml.Serializer.OptimizedDomToVariable
xml.Serializer.OptimizedSoapSection5ToVariable
xml.Serializer.OptimizedStaxToVariable
xml.Serializer.OptimizedVariableToDom
xml.Serializer.OptimizedVariableToSoapSection5
xml.Serializer.OptimizedVariableToStax
xml.Serializer.SetOption
xml.Serializer.SoapSection5ToVariable
xml.Serializer.StaxToDom
xml.Serializer.StaxToVariable
xml.Serializer.VariableToDom
xml.Serializer.VariableToSoapSection5
xml.Serializer.VariableToStax
Serialization option flags
XML security classes
The CryptoKey class
CryptoKey methods
compareTo
computeKey
Create
CreateDerivedKey
CreateFromNode
deriveKey
generateKey
getFeature
getSHA1
getSize
getType
getUrl
getUsage
loadBIN
loadDER
loadFromString
loadPEM
loadPrivate
loadPublic
loadPublicFromString
savePrivate
savePublic
savePublicToString
saveToString
setFeature
setKey
Supported kind of keys
Derived keys
CryptoKey Features
Examples
Loading an asymmetric RSA key
Generating a symmetric AES256 key
Setting a HMAC key
Deriving a HMAC key
Computing the shared secret with Diffie-Hellman
The CryptoX509 class
CryptoX509 methods
Create
CreateFromNode
createPublicKey
getFeature
getIdentifier
getThumbprintSHA1
load
loadDER
loadFromString
loadPEM
save
saveToString
setFeature
CryptoX509 Features
Examples
Loading a certificate from a PEM file
Creating a public key for signature verification from a certificate
Saving the subjectName of a certificate in XML
The Signature class
Signature methods
appendObjectData
appendReferenceTransformation
compute
Create
CreateFromNode
createObject
createReference
getCanonicalization
getDocument
getID
getObjectCount
getObjectId
getReferenceCount
getReferenceDigest
getReferenceID
getReferenceTransformation
getReferenceTransformationCount
getReferenceURI
getSignatureMethod
getType
RetrieveObjectDataListFromSignatureNode
setCanonicalization
setCertificate
setID
setKey
setObjectID
setReferenceID
signString
verify
verifyString
XML Signature concepts
Sign and verify with a common shared HMAC key
Sign with the originator private RSA or DSA key, and verify with the originator public RSA or DSA key
Sign with the originator private RSA or DSA key, and verify with a RSA or DSA retrieval method
Sign with the originator private RSA or DSA key, and verify with the originator X509 certificate associated to the private RSA or DSA key
Sign with the originator private RSA or DSA key, and verify with trusted X509 certificates
Sign with the originator private RSA or DSA key, and verify with a X509 certificate retrieval method and trusted X509 certificates
Sign with a named key and verify using the keystore
Digest identifier
Transformation identifier
Examples
Create a detached signature using a HMAC key
Verify a detached signature using a HMAC key
Create an enveloping signature using a DSA key
Verify an enveloping signature using a X509 certificate
Create an enveloped signature using a RSA key
Verify an enveloped signature using a RSA key
The Encryption class
Encryption methods
Create
decryptElement
decryptElementContent
decryptElementContentDetached
decryptElementDetached
decryptKey
DecryptString
encryptElement
encryptElementContent
encryptElementContentDetached
encryptElementDetached
encryptKey
EncryptString
getEmbeddedKey
RSADecrypt
RSAEncrypt
setCertificate
setKey
setKeyEncryptionKey
Examples
Encrypt a XML node with a symmetric AES128 key
Decrypt a XML node with a symmetric AES128 key
Encrypt a XML node with a generated symmetric key protected with the public RSA key within a X509 certificate
Decrypt a XML node encrypted with a symmetric key protected with a private RSA key
The KeyStore class
KeyStore methods
AddCertificate
AddKey
AddTrustedCertificate
XML transformation classes
The XSLTtransformer class
XSLTtransformer methods
clearParameters
CreateFromDocument
doTransform
getErrorDescription
getErrorsCount
setParameter
getParameter
Example
OM to XML Migration
OM - XML Mapping
The security package
The RandomGenerator class
RandomGenerator methods
CreateRandomNumber
CreateRandomString
CreateUUIDString
The Base64 class
Base64 methods
FromByte
FromHexBinary
FromString
FromStringWithCharset
LoadBinary
SaveBinary
ToHexBinary
ToByte
ToString
ToStringWithCharset
Xor
The HexBinary class
HexBinary methods
FromBase64
FromByte
FromString
FromStringWithCharset
LoadBinary
SaveBinary
ToBase64
ToByte
ToString
ToStringWithCharset
Xor
The Digest class
Digest methods
AddData
AddBase64Data
AddHexBinaryData
AddStringData
AddStringDataWithCharset
CreateDigest
CreateDigestString
DoBase64Digest
DoHexBinaryDigest
Example
The PBKDF2 class
PBKDF2 methods
GenerateKey
CheckKey
PBKDF2 example
The BCrypt class
BCrypt methods
GenerateSalt
HashPassword
CheckPassword
BCrypt example
File extensions
Genero BDL errors
Web services
General
Introduction to Web services
Service Oriented Architecture (SOA)
Migrating to SOA and Web services
Planning a Web service
Genero Web Services extension
Web services standards
XML
JSON
XML schema
SOAP
REST
WSDL
HTTP
Web services style options
GWS demos and examples
Debugging
Platform-specific notes
Web Services on IBM® AIX®
Web Services on GMI (iOS)
Web Services on GMA (Android™)
Known issues
Legal Notices
Concepts
Web Services APIs
SOAP Web services APIs
High-level and low-level APIs
When to use high-level APIs
When to use low-level APIs
REST Web services
High-level and low-level
When to use high-level
When to use low-level APIs
SOAP features
SOAP 1.1 and 1.2
SOAP Fault
Server side
Client side
Stateful SOAP Web services
Concept
WS-Addressing 1.0 stateful services
Server side
Step 1: Declare a W3CEndpointReference record
Step 2: Create a stateful WS-Addressing enabled Web service
Step 3: Publish a Web service operation
Step 4: Create the BDL session initiator function
Step 5: Restore the session
Client side
Step 1: Generate the client stub
Step 2: Create the MAIN application
Step 3: Instantiate a new session
Step 4: Call any web service operation
Stateful services based on HTTP cookies
Server side
Step 1: Declare a BDL simple variable
Step 2: Create a stateful Web service
Step 3: Publish a Web service operation
Step 4: Create the BDL session initiator function
Step 5: Restore the session
Step 6: Deployment recommendation
Client side
Step 1: Generate the client stub
Step 2: Create the MAIN application
Step 3: Instantiate a new session
Step 4: Call any Web service operation
Step 5: Troubleshooting
Encryption, BASE64 and password agent with fglpass tool
The fglpass tool
Encrypt password in FGLPROFILE file
Encrypt password for Windows key store
Use the password agent
Encrypt a password from RSA key
Decrypt a password from BASE64
Encode a file in BASE64 form
Decode a file encoded in BASE64 form
HTTP compression in SOAP
Compression and a Web services client
Compression and a Web services server
SOAP multipart style requests in GWS
MTOM
swaRef
Security
Encryption and authentication
Accessing secured services
HTTPS configuration
Configure a WS client to access an HTTPS server
Create the client certificate
Configure for the client certificate
Configure for the certificate authority list
Add configuration entries in your FGLPROFILE file
Enable OCSP
Troubleshoot certificate issues
Error: Peer certificate is issued by a company not in our CA list
Missing certificates
Certificates in practice
The OpenSSL (openssl) tool
Create a root certificate authority
Create a certificate authority
Create a certificate
Create a certificate authority list
Import a certificate and its private key into the Windows® key store
Import a certificate authority into the Windows® key store
View a certificate
Examining certificates
Check the server certificate using FireFox
Check the server certificate using Internet Explorer
Selecting the certificate to add
Troubleshoot common issues
HTTP 401 error message
The Diffie-Hellman key agreement algorithm
SOAP Web Services
Writing a Web Services client application
Steps to write a WS client
Obtaining the WSDL information
Calling a web service
Step 1: Import the COM library of the GWS package
Step 2: Specify the globals file
Step 3: Write the MAIN program block
Setting a time period for the response
Handling GWS server errors
Compiling the client application
Change WS client behavior at runtime
Global Endpoint type definition
WS-Addressing 1.0 Global Endpoint type definition
Change server location
Change the HTTP protocol version
Set an HTTP cookie
Set the connection timeout for a service
Set the read and write timeout for a service
Access HTTP request and response headers for a service
WS client stubs and handlers
Generating stub files for a GWS Client
Handling GWS server errors
Global Endpoint user-defined type definition
The generated functions
The generated callback handlers
Handler definition
Example output
Multipart in the client stub
Using the generated functions
Using logical names for service locations
FGLPROFILE entry
Logical reference in the client application
Logical reference in the URL
Configure a WS client to access an HTTPS server
Create the client certificate
Configure for the client certificate
Configure for the certificate authority list
Add configuration entries in your FGLPROFILE file
Configure a WS client to connect via an HTTP Proxy
Configure a WS client to use IPv6
Authenticate the WS client to a server
Authenticate the WS client to a proxy
Writing a Web Services server application
Writing a Web services server function
Define the input parameters
Define the output parameters
Write the BDL function
Create and publish the Web services operation
WS server stubs and handlers
Generating files for a GWS server
Server handlers
Example output
Writing your functions
Writing a Web server application
Including the web services library
Example 1: Writing the entire server application
Step 1: Define input and output records
Step 2: Write a BDL function for each service operation
Step 3: Create the service and operations
Step 4: Register the service
Step 5: Start the GWS server and process requests
Example 2: Writing a server using third-party WSDL (the fglwsdl tool)
Step 1: Get the WSDL description and generate files
Step 2: Write a BDL function for your service operation
Step 3: Create service, start server and process requests
Enabling MTOM on the server side
Compiling GWS server applications
Testing the GWS service in stand-alone mode
Configuring the GAS for the GWS Application
Making the GWS service available
Get HTTP headers information at WS server side
Choosing a web services style
How Do I ... ?
Fix Genero 2.10 to 2.11 WSDL generation issue
How to handle WS security
Introduction
Server side
Client side
SOAP security standards
Security bindings
SOAP message security options
SignedParts
EncryptedParts
Useful links
How to migrate I4GL web service to Genero
Migrate an I4GL web service provider to Genero
Step 1: Use the I4GL function and the I4GL .4cf configuration file
Step 2: Create a BDL RECORD for the input parameters
Step 3: Create a BDL RECORD for the output parameters
Step 4: Create a BDL wrapper function
Step 5: Publish the wrapper function as a Genero web service
Step 6: Create the server
Step 7: Configure the database
Step 8: Compile and run the Genero service
Migrate an I4GL web service consumer to Genero
Step 1: Generate the Genero web service stub from an I4GL WSDL
Step 2: Modify the Genero .inc stubs to fix wrong I4GL WSDL
Step 3: Include the generated stub in your I4GL application
Step 4: Modify the I4GL web service function call
Step 5: Handle Genero Web Services errors
Step 6: Compile and run the Genero client
Standalone Axis server is buggy
REST Web services
Designing REST Web services
RESTful Web services with high-level framework
Steps to writing a REST server application
Getting started with REST high-level
Define functions in a module
Define your resource operation
Get resource data with WSGet
Create a resource with WSPost
Update a resource with WSPut
Delete a resource with WSDelete
Set resource path with WSParam and WSPath
Set query, header, or cookie parameters
Set a request body
Set response header and/or body
Retrieve HTTP headers
File attachments (requests or responses)
Download file as attachment or in response body
Upload file as attachment or in request body
Set data format with WSMedia
Multipart requests or responses
Download a file (response)
Upload a file (request)
Handling application level errors
With WSThrows
Unexpected errors
Handling security
Set security with WSScope
Provide service information
Publish a REST service
Generate service description
Steps to writing a REST client application
Obtain the RESTful service information
Calling a web service function
Write the MAIN program code block
Call the stub functions
Handle REST server errors
Change REST client behavior at runtime
Global Endpoint type definition
Set sever endpoint
RESTful Web services with low-level APIs
Writing a Web services client application
Step 1: Obtain information about resources
Step 2: Import extension packages (com, xml, util)
Step 3: Define the records
Step 4: Build the HTTP request
Step 5: Process the HTTP response
Configure a WS client to access an HTTPS server
Create the client certificate
Configure for the client certificate
Configure for the certificate authority list
Add configuration entries in your FGLPROFILE file
Configure a WS client to connect via an HTTP Proxy
Configure a WS client to use IPv6
Authenticate the WS client to a server
Authenticate the WS client to a proxy
Writing a Web Services server application
Step 1: Import extension packages
Step 2: Listen for requests
Step 3: Parse the request
Step 4: Process the request
Step 5: Send response
Step 6: Provide information about your service
The RESTful calculator demo source
Calculator server source
Calculator client source
Comparing the client to the server
How Do I ... ?
Call Java APIs from Genero in a SOA environment
Recommendation
Prerequisites
Using the barcode library
Calling Java from Genero
Step 1: Write a new java class
Step 2: Transform the Java class in a Web service
Step 3: Start the service
Step 4: Generate BDL stub to access the Java library
Step 5: Modify your BDL application
Example program
Conclusion
Call .NET APIs from Genero in a SOA environment
Prerequisites
Using the barcode library
Calling .NET from Genero
Step 1: Create an ASP.NET Web Service Application
Step 2: Rename the generated files
Step 3: Add the barcode library as a reference
Step 4: Add the buildImage method
Step 5: Publish the service
Step 6: Generate .4gl stub to access the .NET library
Step 7: Modify your BDL application
Example BDL program
Conclusion
Compute a hash value from a BDL string
Deploy a Web Service
Web services server program deployment
Configuring the Apache Web server for HTTPS
Step 1: Create the root certificate authority
Step 2: Create the server's certificate and private key
Step 3: Create the server's certificate authority list
Step 4: Register the server as a Web service in the GAS
Step 5: Configure Apache for HTTPS
Step 6 : Configure Apache for HTTP basic authentication
Reference
High-level RESTful Web service attributes
Resource operation attributes
WSDelete
WSGet
WSPost
WSPut
Path templating attributes
WSParam
WSPath
Parameter attributes
WSQuery
WSHeader
WSCookie
WSAttachment
WSDescription
WSRetCode
WSMedia
WSContext
WSName
WSOptional
Error handling attributes
WSError
WSThrows
WSInfo
WSScope
Web Services FGLPROFILE configuration
FGLPROFILE entries for Web Services
HTTPS and password encryption
Basic or digest HTTP authentication
Proxy configuration
IPv6 configuration
Server configuration
XML configuration
HTTP configuration
Examples
Windows® BAT script for private key password
UNIX™ shell script for private key password
FGLPROFILE: HTTP(S) Proxy Authentication
FGLPROFILE: XML cryptography
FGLPROFILE: Server URL patterns
XML to BDL serialization options
WSHelper library
WSHelper variables and records
WSHelper APIs
FindQueryStringValue
SplitQueryString
SplitUrl
Attributes to customize XML serialization
BDL to/from XML type mappings
Default BDL/XML mapping
Type mapping attributes
XSDAnySimpleType
XSDAnyType
XSDAnyURI
XSDBase64binary
XSDBoolean
XSDByte
XSDDate
XSDDateTime
XSDDecimal
XSDDouble
XSDDuration
XSDEntities
XSDEntity
XSDFloat
XSDGDay
XSDGMonth
XSDGMonthDay
XSDGYear
XSDGYearMonth
XSDHexBinary
XSDID
XSDIDREF
XSDIDREFS
XSDInt
XSDInteger
XSDLanguage
XSDLong
XSDNCName
XSDName
XSDNegativeInteger
XSDNMTOKEN
XSDNMTOKENS
XSDNonNegativeInteger
XSDNonPositiveInteger
XSDNormalizedString
XSDnotation
XSDPositiveInteger
XSDQName
XSDShort
XSDString
XSDTime
XSDToken
XSDUnsignedByte
XSDUnsignedInt
XSDUnsignedLong
XSDUnsignedShort
XML facet constraint attributes
XSDLength
XSDMinLength
XSDMaxLength
XSDEnumeration
XSDWhiteSpace
XSDPattern
XSDMinInclusive
XSDMaxInclusive
XSDMinExclusive
XSDMaxExclusive
XSDTotalDigits
XSDFractionDigits
Customizing XML serialization
XMLOptional
XMLNillable
XMLElement (Optional)
XMLElementNillable
XMLAttribute
XMLBase
XMLAll
XMLChoice
XMLSequence (Optional)
XMLSimpleContent
XSComplexType
XMLList
XMLSelector
XMLAny
XMLAnyAttribute
XMLName
XMLNamespace
XMLType
XMLTypenamespace
XSTypename
XSTypenamespace
XMLElementNamespace
XMLAttributeNamespace
XMLOptimizedContent
Error handling in GWS calls (STATUS)
Interruption handling in GWS calls (INT_FLAG)
Server API functions - version 1.3 only
fgl_ws_server_setNamespace() (version 1.3)
fgl_ws_server_start() (version 1.3)
fgl_ws_server_publishFunction() (version 1.3)
fgl_ws_server_generateWSDL() (version 1.3)
fgl_ws_server_process() (version 1.3)
fgl_ws_server_setFault() (version 1.3)
fgl_ws_server_getFault() (version 1.3)
Configuration API functions - version 1.3 only
fgl_ws_setOption()
fgl_ws_getOption()
Option flags
WSDL generation option notes
Using fglwsdl to generate code from WSDL or XSD schemas
Generate TYPE definitions from global XML elements or attributes
Mobile applications
Types of Genero Mobile apps
Mobile development mode
Genero mobile development client for Android™
Genero mobile development client for iOS
Language limitations
Environment variables
App localization
App execution
Mobile app execution modes
Background/foreground modes
App user interface
Images and icons
Action rendering
Toolbar rendering
Topmenu rendering
Keyboard type
List views
Split views
Front call support
Color and theming
Screen orientation
Decorate iOS UI elements
Database support on mobile devices
Using SQLite database in mobile apps
Accessing device functions
Web Services on mobile devices
Debugging a mobile app
Deploying mobile apps
Deploying mobile apps on Android™ devices
Directory structure for GMA apps
Building Android™ apps with Genero
gmabuildtool
Deploying mobile apps on iOS devices
Directory structure for GMI apps
Building iOS apps with Genero
gmibuildtool
Running mobile apps on an application server
Push notifications
Firebase Cloud Messaging (FCM)
Apple Push Notification Service (APNs)
Implementing a token maintainer
Handling notifications in the mobile app
Cordova plugins
Understanding Cordova plugins
Installing Cordova plugins
Using a Cordova plugin API
Embed Cordova plugins in a GMA app
Embed Cordova plugins in a GMI app
Copyrights and Trademarks
Your browser does not support iframes.