You must enable javascript in order to view this page or you can go
here
to view the webhelp.
Genero BDL Tutorial 3.00
Content
Search
Index
Keywords:
Loading, please wait ...
Genero BDL Tutorial Summary
Testing the Example Programs
Tutorial Chapters
Tutorial Chapter 1: Overview
Overview
The BDL Language
The BDL Tutorial
The Example Database (custdemo)
The Sample Data
Tutorial Chapter 2: Using BDL
A simple BDL program
Compiling and Executing the Program
Debugging a BDL Program
The "Connect to database" Program
Example: connectdb.4gl
Tutorial Chapter 3: Displaying Data (Windows/Forms)
Application Overview
The .4gl File - Opening Windows and Forms
The .4gl File - Interacting with the User
The .4gl File - Retrieving and Displaying Data
Example: dispcust.4gl (function query_cust)
The Form Specification File
Example: Form Specification File custform.per
Compiling the Program and Form
Tutorial Chapter 4: Query by Example
Implementing Query-by-Example
Steps for implementing Query-by-Example
Using CONSTRUCT and STRING variables
Preparing the SQL Statement
Allowing the User to Cancel the Query Operation
Predefined Actions (accept/cancel)
DEFER INTERRUPT and the INT_FLAG
Conditional Logic
The IF statement
The CASE statement
The Query program
Example: Module custmain.4gl
Example: Module custquery.4gl
Example: custquery.4gl (Function get_cust_cnt)
Retrieving data from the Database
Using Cursors
The SQLCA.SQLCODE
Example custquery.4gl (function cust_select)
Example: custquery.4gl (function fetch_cust)
Example: custquery.4gl (function fetch_rel_cust)
Example: custquery.4gl (function display_cust)
Compiling and Linking the Program
Modifying the Program to Handle Errors
The WHENEVER ERROR statement
Negative SQLCA.SQLCODE
SQLERRMESSAGE
Close and Free the Cursor
Error if Cursor is not Open
Tutorial Chapter 5: Enhancing the Form
Adding a Toolbar
Example: (in custform.per)
Adding a Topmenu
Example ( in custform.per)
Adding a COMBOBOX form item
Changing the Window Appearance
Example: (in custform.per)
Example: (in custmain.4gl)
Managing Actions
Disable/Enable Actions
The Close Action
Example: (custmain.4gl)
Action Defaults
MENU/Action Defaults Interaction
Images
Tutorial Chapter 6: Add, Update and Delete
Entering data on a form: INPUT statement
UNBUFFERED attribute
WITHOUT DEFAULTS attribute
Updating Database Tables
SQL transactions
Concurrency and Consistency
Adding a new row
INPUT Statement Control blocks
Example: add a new row to the customer table
Module custmain.4gl
Module custquery.4gl (function inpupd_cust)
Module custquery.4gl (function insert_cust)
Updating an existing Row
Using a work record
SELECT ... FOR UPDATE
SCROLL CURSOR WITH HOLD
Example: Updating a Row in the customer table
Module custquery.4gl
Deleting a Row
Using a dialog Menu to prompt for validation
Example: Deleting a Row
Tutorial Chapter 7: Array Display
Defining the Form
Screen Arrays
TABLE Containers
The INSTRUCTIONS section
Form example: manycust.per
Creating the Function
Program Arrays
Loading the Array: the FOREACH Statement
The DISPLAY ARRAY Statement
The COUNT attribute
The ARR_CURR function
Example Library module: cust_lib.4gl
Paged Mode of DISPLAY ARRAY
What is the Paged mode?
AFTER DISPLAY block
Example of paged mode
Compiling and using a Library
Example: cust_stub.4gl
Tutorial Chapter 8: Array Input
The INPUT ARRAY statement
WITHOUT DEFAULTS clause
The UNBUFFERED attribute
COUNT and MAXCOUNT attributes
Control Blocks
Built-in Functions - ARR_CURR
Predefined actions
Example: Using a Screen Array to modify Data
The Form Specification File
The Main block
Function load_custall
Function inparr_custall
Function store_num_ok
Function insert_cust
Function update_cust
Function delete_cust
Tutorial Chapter 9: Reports
BDL Reports
The Report Driver
The Report Definition
The DEFINE section
The OUTPUT section (optional)
The ORDER BY section (optional)
The FORMAT section
Two-pass reports
Example: Customer Report
The Report Driver
The Report Definition
Interrupting a Report
The interrupt action view
Refreshing the Display
Using a ProgressBar
Example: Interruption Handling
The Form Specification File
Modifications to custreports.4gl
The cust_report function
Tutorial Chapter 10: Localization
Localization Support
Localized Strings
Programming Steps
Strings in Sources
Extracting Strings
Compiling String Source Files (fglmkstr)
Deploying String Files
Example: Localization
form.per - the form specification file
prog.4gl - the program module
Compiling the program
Tutorial Chapter 11: Master/Detail
The Master-Detail sample
The Makefile
The Customer List Module
The Stock List Module
The Master-Detail Form Specification File
The Orders Program orders.4gl
The MAIN program block
Function setup_actions
Function order_new
Function order_insert
Function order_query
Function order_fetch
Function order_select
Function order_fetch_rel
Function order_total
Function order_close
Function items_fetch
Function items_show
Function items_inpupd
Function items_line_total
Function item_insert
Function item_update
Function item_delete
Function get_stock_info
Tutorial Chapter 12: Changing the User Interface Dynamically
Built-in Classes
Working with Forms
Hiding Form Items
Adding toolbars, topmenus, and action defaults
Specifying a Function to Initialize all Forms
Loading a ComboBox List
Using the Dialog class in Interactive Statements
Hiding Default Action Views
Enabling and Disabling Fields
Using the Interface Class
Tutorial Chapter 13: Master/Detail using Multiple Dialogs
The Master-Detail sample
The Customer List Form
The Customer List Module
The Orders Form
The Orders Program orders.4gl
Module variables of orders.4gl
Function orditems_dialog
Function order_update
Function order_new
Function order_validate
Function order_query
aggregate - reports
AVG
[1]
MAX
[1]
MIN
[1]
PERCENT
[1]
SUM
[1]
Android apps (GMA)
directory structure
[1]
app
client-server
[1]
connected
[1]
partially-connected
[1]
standalone
[1]
app types
[1]
assignment
LET instruction
[1]
attributes
action defaults (.4ad)
[1]
actions
[1]
automatic startup
front-end
[1]
basics
Genero web services
[1]
user interface
[1]
block
MAIN
[1]
REPORT
[1]
boolean expressions
in form files
[1]
built-in class
base.SqlHandle
[1]
om.DomDocument
[1]
om.DomNode
[1]
om.SaxAttributes
[1]
om.SaxDocumentHandler
[1]
om.XmlReader
[1]
om.XmlWriter
[1]
ui.Dialog
[1]
ui.Form
[1]
ui.Window
[1]
built-in function
arg_val()
[1]
arr_count()
[1]
arr_curr()
[1]
fgl_buffertouched()
[1]
fgl_decimal_exp()
[1]
fgl_decimal_logn()
[1]
fgl_decimal_power()
[1]
fgl_decimal_sqrt()
[1]
fgl_decimal_truncate()
[1]
fgl_dialog_getbuffer()
[1]
fgl_dialog_getcursor()
[1]
fgl_dialog_getkeylabel()
[1]
fgl_dialog_getselectionend()
[1]
fgl_dialog_setbuffer()
[1]
fgl_dialog_setcursor()
[1]
fgl_dialog_setkeylabel()
[1]
fgl_dialog_setselection()
[1]
fgl_evenloop()
[1]
fgl_getfile()
[1]
fgl_getkeylabel()
[1]
fgl_getresource()
[1]
fgl_putfile()
[1]
fgl_setkeylabel()
[1]
fgl_set_arr_curr()
[1]
num_args()
[1]
scr_line()
[1]
set_count()
[1]
BY NAME
dialog programming
[1]
c-extensions
importing
[1]
camera
mobile front call
[1]
takeVideo front call
[1]
canceling
SQL statement
[1]
character set
application locale
[1]
Classes
OOP
[1]
colors
presentation styles
[1]
command reference
fglcomp
[1]
fgldbsch
[1]
fglform
[1]
fgllink
[1]
fglrun
[1]
compiling
build information
[1]
COMPLETER
dialog programming
[1]
concept
abstract user interface tree
[1]
arrays
[1]
c-extensions
[1]
constants
[1]
data types
[1]
database connections
[1]
database schema
[1]
database transaction
[1]
debugger
[1]
default action views
[1]
dialog actions
[1]
DIALOG class
[1]
dialogs
[1]
dynamic user interface
[1]
editable list (INPUT ARRAY)
[1]
exceptions
[1]
expressions
[1]
flow control
[1]
form files
[1]
form rendering
[1]
functions
[1]
Genero Web Services
[1]
grid-based layout
[1]
GWS
[1]
images usage
[1]
interactive instruction
[1]
java interface
[1]
literals
[1]
localization
[1]
localized strings
[1]
message files
[1]
model-view-controller
[1]
multiple dialogs
[1]
Object Oriented Programming
[1]
parallel dialogs
[1]
positionned updates/delete
[1]
preprocessor
[1]
presentation styles
[1]
profiler
[1]
prompt values (PROMPT)
[1]
Query By Example (CONSTRUCT)
[1]
read-only list (DISPLAY ARRAY)
[1]
record input (INPUT)
[1]
records
[1]
report driver
[1]
reports
[1]
result set
[1]
ring menus (MENU)
[1]
runtime stack
[1]
split views
[1]
stack-based layout
[1]
start menus
[1]
static display
[1]
Static SQL
[1]
structured variables (RECORD)
[1]
table views
[1]
toolbars
[1]
topmenus
[1]
tree views
[1]
two-pass report
[1]
type conversions
[1]
user defined types
[1]
user interface modes
[1]
user interruption
[1]
variables
[1]
Web Components
[1]
web services
Stateful web services
[1]
window containers
[1]
windows and forms
[1]
XML support
[1]
concept - form file
BUTTON item type
[1]
BUTTONEDIT item type
[1]
CHECKBOX item type
[1]
COMBOBOX item type
[1]
DATEEDIT item type
[1]
DATETIMEEDIT item type
[1]
EDIT item type
[1]
FOLDER item type
[1]
GRID item type
[1]
GROUP item type
[1]
IMAGE item type
[1]
LABEL item type
[1]
PAGE item type
[1]
PROGRESSBAR item type
[1]
RADIOGROUP item type
[1]
SCROLLGRID item type
[1]
SLIDER item type
[1]
SPINEDIT item type
[1]
TABLE item type
[1]
TEXTEDIT item type
[1]
TIMEEDIT item type
[1]
TREE item type
[1]
WEBCOMPONENT item type
[1]
concept - form files
action views
[1]
aggregate fields
[1]
database column fields
[1]
form fields
[1]
form item types
[1]
form items
[1]
formonly fields
[1]
hbox tags
[1]
item tags
[1]
layout items
[1]
layout tags
[1]
phantom fields
[1]
satellite items
[1]
screen records
[1]
stack items
[1]
static items
[1]
conditionnal block
IF statement
[1]
WHILE loop
[1]
configuration
database client
[1]
front-end target
[1]
length semantics
[1]
locale
[1]
Ming Guo date format
[1]
reports
[1]
terminal
[1]
control block
AFTER DELETE
[1]
AFTER DISPLAY
[1]
AFTER FIELD
[1]
AFTER INPUT
[1]
AFTER INSERT
[1]
AFTER ROW
[1]
BEFORE DELETE
[1]
BEFORE DISPLAY
[1]
BEFORE FIELD
[1]
BEFORE INPUT
[1]
BEFORE INSERT
[1]
BEFORE ROW
[1]
ON CHANGE
[1]
ON ROW CHANGE
[1]
data block
ON COLLAPSE
[1]
ON EXPAND
[1]
data type
BIGINT
[1]
BOOLEAN
[1]
BYTE
[1]
CHAR
[1]
DATE
[1]
DATETIME
[1]
DECIMAL
[1]
FLOAT
[1]
INTEGER
[1]
INTERVAL
[1]
MONEY
[1]
SMALLFLOAT
[1]
SMALLINT
[1]
STRING
[1]
TEXT
[1]
TINYINT
[1]
VARCHAR
[1]
database
Microsoft SQL Server adaptation guide
[1]
SAP Sybase ASE adaptation guide
[1]
date/time formatting
[1]
debugging
SQL statements
[1]
default action views
Android default decoration
[1]
Android rendering - action bar
[1]
Android rendering - FAB
[1]
iOS default decoration
[1]
iOS rendering
[1]
DEFAULT SAMPLE
in form file
[1]
DELIMITERS
in form file
[1]
deploying
mobile apps
[1]
deploying mobile apps
Android (GMA)
[1]
iOS (GMI)
[1]
mobile apps on server
[1]
dialog programming
action deactivation
[1]
action handlers (ON ACTION)
[1]
action hiding
[1]
action view binding
[1]
action views
[1]
actions
[1]
autocompletion
[1]
close action
[1]
data validation
[1]
dynamic dialogs
[1]
field actions
[1]
field changes
[1]
field initialization
[1]
field modification flag
[1]
focus detection
[1]
form validation rules
[1]
generic code
[1]
INCLUDE
[1]
input started
[1]
interaction triggers
[1]
NOT NULL
[1]
predefined actions
[1]
REQUIRED
[1]
setting focus
[1]
sub-dialog identification
[1]
tabbing order
[1]
unbuffered mode
[1]
variable to field binding
[1]
dialog programming SCROLL
dialog programming
[1]
field input length
[1]
dialog types
modal dialog
[1]
parallel dialog
[1]
dialogtouched
dialog programming
[1]
direct specification
database
[1]
DISPLAY ARRAY
controlling number of rows
[1]
documenting
sources and programs
[1]
DOM
[1]
DOUBLECLICK
dialog programming
[1]
environment variable
DBCENTURY
[1]
DBDATE
[1]
DBEDIT
[1]
DBFORMAT
[1]
DBMONEY
[1]
DBPATH
[1]
DBPRINT
[1]
DBTEMP
[1]
FGLAPPDIR
[1]
FGLDIR
[1]
FGLGUI
[1]
FGLIMAGEPATH
[1]
FGLLDPATH
[1]
FGLPROFILE
[1]
FGLRESOURCEPATH
[1]
FGLSERVER
[1]
FGLSOURCEPATH
[1]
FGLSQLDEBUG
[1]
FGL_LENGTH_SEMANTICS
[1]
INFORMIXTERM
[1]
TERM
[1]
TERMCAP
[1]
TERMINFO
[1]
TMPDIR / TEMP / TMP
[1]
error handling
exceptions
[1]
errors
overflow
[1]
type conversion
[1]
execution
programs
[1]
expressions
boolean
[1]
date
[1]
datetime
[1]
integer
[1]
string
[1]
extension class
util.Datetime
[1]
extension class - http
com.HTTPResponse
[1]
extension class - web services
com.HTTPServiceRequest
[1]
com.WebServiceEngine
[1]
com.WebServices
[1]
extension class - XML
xml.DomDocument
[1]
xml.Serializer
[1]
xml.StaxWriter
[1]
feInfo - options
dataDirectory
[1]
deviceId
[1]
deviceModel
[1]
dictionariesDirectory
[1]
feName
[1]
fePath
[1]
freeStorageSpace
[1]
iccid
[1]
imei
[1]
ip
[1]
numScreens
[1]
osType
[1]
osVersion
[1]
outputMap
[1]
ppi
[1]
screenResolution
[1]
target
[1]
windowSize
[1]
FGLPROFILE
[1]
aggregateZero
[1]
dialog configuration
[1]
FGLSERVER
description
[1]
FGLSQLDEBUG
[1]
FIELD ORDER FORM
dialog programming
[1]
FIELD_TOUCHED()
dialog programming
[1]
file format - database schema
column functional attributes (.val)
[1]
column video attributes (.att)
[1]
focus
dialog programming
[1]
font
fontFamily
[1]
fontSize
[1]
fontStyle
[1]
fontWeight
[1]
formatting
DATE
[1]
DATETIME
[1]
numeric
[1]
front call - mobile
choosePhoto
[1]
chooseVideo
[1]
runOnServer
[1]
takePhoto
[1]
takeVideo
[1]
front call - standard
feInfo
[1]
launchURL
[1]
setWebComponentPath
[1]
front call - webcomponent
call
[1]
frontCallAPIVersion
[1]
getTitle
[1]
front call module
web component
[1]
function
calling a function
[1]
returning values
[1]
General terms
[1]
getCurrentItem()
dialog programming
[1]
getFieldTouched()
dialog programming
[1]
graphical mode
[1]
grid-based layout
empty grid cell size
[1]
widget position and size
[1]
IBM DB2 UDB
CHAR / VARCHAR
[1]
GRAPHIC / VARGRAPHIC
[1]
IBM Netezza
CHAR / VARCHAR
[1]
NCHAR / NVARCHAR
[1]
image resources
FGLIMAGEPATH
[1]
FontAwesome
[1]
icon color
[1]
image URLs
[1]
image2font
[1]
TTF
[1]
importing
modules
[1]
indirect specification
database
[1]
initialization
variables
[1]
INPUT ARRAY
controlling number of rows
[1]
installation
[1]
instruction
dialog instructions reference
[1]
EXIT PROGRAM
[1]
instruction - arrays
ARRAY [size]
[1]
DYNAMIC ARRAY
[1]
instruction - C Extensions
IMPORT
[1]
instruction - DIALOG
ACCEPT DIALOG
[1]
CONTINUE DIALOG
[1]
EXIT DIALOG
[1]
NEXT FIELD
[1]
instruction - dialogs
DIALOG (declarative)
[1]
DISPLAY ARRAY
[1]
INPUT
[1]
INPUT ARRAY
[1]
MENU
[1]
START DIALOG
[1]
TERMINATE DIALOG
[1]
instruction - display
DISPLAY (to stdout)
[1]
DISPLAY BY NAME
[1]
DISPLAY TO
[1]
ERROR
[1]
MESSAGE
[1]
instruction - DISPLAY ARRAY
ACCEPT DISPLAY
[1]
CONTINUE DISPLAY
[1]
EXIT DISPLAY
[1]
instruction - exceptions
TRY / CATCH
[1]
WHENEVER
[1]
instruction - flow control
CALL
[1]
EXIT CONSTRUCT
[1]
EXIT DIALOG
[1]
EXIT DISPLAY
[1]
EXIT FOR
[1]
EXIT FOREACH
[1]
EXIT INPUT
[1]
EXIT MENU
[1]
EXIT REPORT
[1]
EXIT WHILE
[1]
GOTO
[1]
IF
[1]
LABEL
[1]
RETURN
[1]
WHILE
[1]
instruction - forms
CLOSE FORM
[1]
DISPLAY FORM
[1]
OPEN FORM
[1]
instruction - INPUT ARRAY
ACCEPT INPUT
[1]
CANCEL DELETE
[1]
CANCEL INSERT
[1]
EXIT INPUT
[1]
instruction - java
IMPORT JAVA
[1]
instruction - modules
IMPORT FGL
[1]
instruction - programs
RUN
[1]
instruction - reports
EXIT REPORT
[1]
NEED
[1]
PRINT
[1]
PRINTX
[1]
SKIP
[1]
instruction - SQL
CLOSE (result set cursor)
[1]
DECLARE (result set)
[1]
FETCH (result set cursor)
[1]
FOREACH
[1]
FREE (result set cursor)
[1]
OPEN (result set cursor)
[1]
SELECT
[1]
instruction - variables
DEFINE
[1]
FREE (TEXT/BYTE)
[1]
LET
[1]
LOCATE
[1]
VALIDATE
[1]
instruction - windows
CLOSE WINDOW
[1]
CURRENT WINDOW
[1]
OPEN WINDOW
[1]
interaction block
AFTER CONSTRUCT
[1]
BEFORE CONSTRUCT
[1]
ON ACTION
[1]
ON APPEND
[1]
ON DELETE
[1]
ON INSERT
[1]
ON UPDATE
[1]
interaction block - DIALOG
COMMAND "option"
[1]
internationalization
application locale
[1]
localized strings
[1]
INT_FLAG
interruption
[1]
iOS apps (GMI)
directory structure
[1]
Java classes
importing
[1]
java interface
BDL types in java code
[1]
IMPORT JAVA class
[1]
using BDL records in java code
[1]
using CAST operator
[1]
using INSTANCEOF operator
[1]
using java arrays
[1]
label
goto
[1]
layout
images
[1]
linking
libraries (fgllink)
[1]
programs (fgllink)
[1]
literals
datetime literals
[1]
integer literals
[1]
interval literals
[1]
text literals
[1]
loop
SQL result set
[1]
MDI
window containers
[1]
methods - base.Application
getProgramDir()
[1]
methods - base.SqlHandle
getResultType()
[1]
methods - com.HTTPRequest
beginXmlRequest()
[1]
doDataRequest()
[1]
doFormEncodedRequest()
[1]
doRequest()
[1]
doTextRequest()
[1]
doXmlRequest()
[1]
endXmlRequest()
[1]
getAsyncResponse()
[1]
getResponse()
[1]
setCharset()
[1]
setConnectionTimeOut()
[1]
setTimeOut()
[1]
methods - com.HTTPResponse
getFileResponse()
[1]
methods - com.WebService
CreateStatefulWebService()
[1]
registerInputHTTPVariable()
[1]
registerOutputHTTPVariable()
[1]
methods - com.WebServiceEngine
Flush()
[1]
GetHTTPServiceRequest()
[1]
HandleRequest()
[1]
ProcessServices()
[1]
methods - DYNAMIC ARRAY
appendElement()
[1]
clear()
[1]
deleteElement()
[1]
getLength()
[1]
insertElement()
[1]
sort()
[1]
methods - Java Array
create()
[1]
getLength()
[1]
methods - om.DomDocument
createChars()
[1]
methods - om.DomNode
getAttribute()
[1]
getAttributeInteger()
[1]
getAttributeString()
[1]
setAttribute()
[1]
methods - om.SaxDocumentHandler
characters()
[1]
createForName()
[1]
endDocument()
[1]
endElement()
[1]
processingInstruction()
[1]
skippedEntity()
[1]
startDocument()
[1]
startElement()
[1]
methods - om.XmlReader
createFileReader()
[1]
getAttributes()
[1]
getCharacters()
[1]
read()
[1]
methods - om.XmlWriter
createFileWriter()
[1]
createPipeWriter()
[1]
createSocketWriter()
[1]
methods - os.Path
exists()
[1]
makeTempName()
[1]
pwd()
[1]
methods - security.Digest
CreateDigest()
[1]
methods - STRING
trim()
[1]
methods - ui.ComboBox
setDefaultInitializer()
[1]
methods - ui.Dialog
addTrigger()
[1]
appendNode()
[1]
appendRow()
[1]
createConstructByName()
[1]
createDisplayArrayTo()
[1]
createInputByName()
[1]
deleteAllRows()
[1]
deleteNode()
[1]
deleteRow()
[1]
getArrayLength()
[1]
getCurrentItem()
[1]
getCurrentRow()
[1]
getFieldBuffer()
[1]
getFieldTouched()
[1]
getFieldValue()
[1]
getForm()
[1]
getQueryFromField()
[1]
insertNode()
[1]
insertRow()
[1]
isRowSelected()
[1]
nextEvent()
[1]
nextField()
[1]
setActionActive()
[1]
setActionHidden()
[1]
setArrayAttributes()
[1]
setArrayLength()
[1]
setCellAttributes()
[1]
setCompleterItems()
[1]
setCurrentRow()
[1]
setDefaultUnbuffereds()
[1]
setFieldActive()
[1]
setFieldTouched()
[1]
setFieldValue()
[1]
setSelectionMode()
[1]
setSelectionRange()
[1]
validate()
[1]
methods - ui.Form
ensureElementVisible()
[1]
ensureFieldVisible()
[1]
setElementHidden()
[1]
methods - ui.Interface
filenameToURI()
[1]
loadStartMenu()
[1]
loadToolBar()
[1]
loadTopMenu()
[1]
refresh()
[1]
setImage()
[1]
setName()
[1]
setText()
[1]
methods - ui.Window
createForm()
[1]
getForm()
[1]
setImage()
[1]
setText()
[1]
methods - util.Datetime
format()
[1]
parse()
[1]
Microsoft SQL Server
CHAR / VARCHAR
[1]
MATCHES / LIKE
[1]
NCHAR / NVARCHAR
[1]
module
importing
[1]
NEXT FIELD
dialog programming
[1]
nextField()
dialog programming
[1]
ON ACTION close
dialog programming
[1]
ON ACTION INFIELD
dialog programming
[1]
ON CHANGE
dialog programming
[1]
operator
AND
[1]
CAST
[1]
CLIPPED
[1]
COLUMN
[1]
CURRENT
[1]
DATE()
[1]
DAY()
[1]
expr , expr
[1]
expr == expr
[1]
expr || expr
[1]
EXTEND()
[1]
FIELD_TOUCHED()
[1]
GET_FLDBUF()
[1]
INSTANCEOF
[1]
IS NULL
[1]
LIKE
[1]
MATCHES
[1]
MDY()
[1]
MONTH()
[1]
NVL()
[1]
OR
[1]
SQLERRMESSAGE
[1]
SQLSTATE
[1]
TIME()
[1]
TODAY
[1]
UNITS
[1]
USING
[1]
variable := expr
[1]
WEEKDAY()
[1]
YEAR()
[1]
operator - reports
WORDWRAP
[1]
operators
date and time
[1]
Oracle DB
CHAR / VARCHAR
[1]
Empty strings
[1]
NCHAR / NVARCHAR
[1]
Oracle MySQL/MariaDB
CHAR / VARCHAR
[1]
NCHAR / NVARCHAR / TEXT
[1]
parallel dialogs
split views
[1]
parameters
database connection
[1]
picture
mobile front call
[1]
takePhoto front call
[1]
PostgreSQL
CHAR / VARCHAR
[1]
TEXT
[1]
program execution
fglrun
[1]
programming
Web Component (gICAPI)
[1]
Web Component (URL)
[1]
pseudo selectors
[1]
reference
Exceptions
[1]
Genero BDL errors
[1]
Genero BDL library
[1]
keyboard accelerators
[1]
remote execution
mobile front call
[1]
rendering actions
mobile devices
[1]
report routine
instructions
[1]
runOnServer
[1]
runtime
localized strings
[1]
SAP Sybase ASE
CHAR / VARCHAR
[1]
NCHAR / NVARCHAR
[1]
UNICHAR / UNIVARCHAR
[1]
SAX
[1]
Scrollable cursors
SQL performances
[1]
security
web services
HTTPS configuration
[1]
X.509
[1]
setActionActive()
dialog programming
[1]
setActionHidden()
dialog programming
[1]
source
database
[1]
SQL
portability
[1]
SQL CHAR/VARCHAR portability
database character set for UTF-8
[1]
SQL diagnostics
[1]
SQL interruption
[1]
SQL portability
CREATE DATABASE
[1]
MATCHES vs LIKE
[1]
Scrollable cursors
[1]
SQLCA
record members
[1]
SQLite
CHAR / VARCHAR
[1]
NCHAR / NVARCHAR
[1]
stack-based layout
group rendering
[1]
status bar
presentation styles
[1]
string resources
[1]
style attribute (common)
backgroundColor
[1]
border
[1]
fontFamily
[1]
fontSize
[1]
fontStyle
[1]
fontWeight
[1]
imageCache
[1]
localAccelerators
[1]
showAcceleratorInToolTip
[1]
textColor
[1]
textDecoration
[1]
style attribute - button
buttonType
[1]
scaleIcon
[1]
style attribute - buttonedit
scaleIcon
[1]
style attribute - checkbox
iosCheckBoxOnTintColor
[1]
style attribute - dateedit
buttonIcon
[1]
dateedit
[1]
daysOff
[1]
firstDayOfWeek
[1]
showCurrentMonthOnly
[1]
showGrid
[1]
showWeekNumber
[1]
style attribute - default action view
androidActionPosition
[1]
androidActionWithIcon
[1]
androidActionWithText
[1]
scaleIcon
[1]
style attribute - edit
dateTypeHint
[1]
style attribute - image
alignment
[1]
imageContainerType
[1]
textFormat
[1]
style attribute - message
position
[1]
textFormat
[1]
style attribute - progressbar
percentageVisible
[1]
style attribute - radiogroup
autoSelectionStart
[1]
completionTimeout
[1]
style attribute - table
allowWebSelection
[1]
forceDefaultSettings
[1]
headerAlignment
[1]
headerHidden
[1]
highlightColor
[1]
highlightCurrentCell
[1]
highlightCurrentRow
[1]
highlightTextColor
[1]
leftFrozenColumns
[1]
resizeFillsEmptySpace
[1]
rightFrozenColumns
[1]
showGrid
[1]
summaryLineAlwaysAtBottom
[1]
tableType
[1]
style attribute - textedit
customWidget
[1]
integratedSearch
[1]
showEditToolBox
[1]
spellCheck
[1]
textFormat
[1]
wrapPolicy
[1]
style attribute - toolbar
iosSeparatorStretch
[1]
scaleIcon
[1]
toolBarTextPosition
[1]
style attribute - userinterface
androidKeepForeground
[1]
browserMultiPage
[1]
reverse
[1]
style attributes
TTY attributes
[1]
style attributes - combobox
autoSelectionStart
[1]
comboboxCompleter
[1]
completionTimeout
[1]
style atttribute - window
actionPanelButtonSize
[1]
actionPanelButtonSpace
[1]
actionPanelButtonTextAlign
[1]
actionPanelButtonTextHidden
[1]
actionPanelDecoration
[1]
actionPanelHAlign
[1]
actionPanelPosition
[1]
actionPanelScroll
[1]
actionPanelScrollStep
[1]
border
[1]
commentPosition
[1]
defaultTTFColor
[1]
errorMessagePosition
[1]
forceDefaultSettings
[1]
formScroll
[1]
ignoreMinimizeSetting
[1]
iosNavigationBarTextColor
[1]
iosNavigationBarTintColor
[1]
iosRenderSystemActions
[1]
iosTabBarTintColor
[1]
iosTabBarUnselectedColor
[1]
iosTintColor
[1]
iosToolBarTintColor
[1]
materialFABActionList
[1]
materialFABType
[1]
menuPopupPosition
[1]
messagePosition
[1]
position
[1]
ringMenuButtonSize
[1]
ringMenuButtonSpace
[1]
ringMenuButtonTextAlign
[1]
ringMenuButtonTextHidden
[1]
ringMenuDecoration
[1]
ringMenuHAlign
[1]
ringMenuPosition
[1]
ringMenuScroll
[1]
ringMenuScrollStep
[1]
sizable
[1]
startMenuAccelerator
[1]
startMenuExecShortcut2
[1]
startMenuPosition
[1]
startMenuShortcut
[1]
startMenuSize
[1]
statusBarType
[1]
tabbedContainer
[1]
tabbedContainerCloseMethod
[1]
thinScrollbarDisplayTime
[1]
toolBarDocking
[1]
toolBarPosition
[1]
windowMenu
[1]
windowOptionClose
[1]
windowOptionMaximize
[1]
windowOptionMinimize
[1]
windowState
[1]
windowSystemMenu
[1]
windowType
[1]
styles
presentation styles
[1]
syntax - action attributes
ACCELERATOR
[1]
ACCELERATOR2
[1]
ACCELERATOR3
[1]
ACCELERATOR4
[1]
COMMENT
[1]
CONTEXTMENU
[1]
DEFAULTVIEW
[1]
IMAGE
[1]
TEXT
[1]
VALIDATE
[1]
syntax - basics
identifiers
[1]
syntax - form file
ACCELERATOR attribute
[1]
ACCELERATOR2 attribute
[1]
ACCELERATOR3 attribute
[1]
ACCELERATOR4 attribute
[1]
ACTION attribute
[1]
ACTION DEFAULTS section
[1]
AGGREGATETEXT attribute
[1]
AGGREGATETYPE attribute
[1]
AGGRGATE item definition
[1]
ATTRIBUTES section
[1]
AUTONEXT attribute
[1]
AUTOSCALE attribute
[1]
BUTTON item definition
[1]
BUTTON stack item
[1]
BUTTONEDIT attribute
[1]
BUTTONEDIT item definition
[1]
BUTTONEDIT stack item
[1]
CENTURY attribute
[1]
CHECKBOX item definition
[1]
CHECKBOX stack item
[1]
COLOR attribute
[1]
COLOR WHERE attribute
[1]
COMBOBOX item definition
[1]
COMBOBOX stack item
[1]
COMMENT attribute
[1]
COMPLETER attribute
[1]
COMPONENTTYPE attribute
[1]
CONTEXTMENU attribute
[1]
DATEEDIT item definition
[1]
DATEEDIT stack item
[1]
DATETIMEEDIT item definition
[1]
DATETIMEEDIT stack item
[1]
DEFAULT attribute
[1]
DEFAULTVIEW attribute
[1]
DISCLOSUREINDICATOR attribute
[1]
DISPLAY LIKE attribute
[1]
DOUBLECLICK attribute
[1]
DOWNSHIFT attribute
[1]
EDIT item definition
[1]
EDIT stack item
[1]
EXPANDEDCOLUMN attribute
[1]
FOLDER container
[1]
FOLDER stack item
[1]
FONTPITCH attribute
[1]
FORM clause
[1]
form file structure
[1]
FORMAT attribute
[1]
GRID container
[1]
GRIDCHILDRENINPARENT attribute
[1]
GROUP container
[1]
GROUP item definition
[1]
GROUP stack item
[1]
HBOX container
[1]
HEIGHT attribute
[1]
HIDDEN attribute
[1]
IDCOLUMN attribute
[1]
IMAGE attribute
[1]
IMAGE item definition
[1]
IMAGE stack item
[1]
IMAGECOLLAPSED attribute
[1]
IMAGECOLUMN attribute
[1]
IMAGEEXPANDED attribute
[1]
IMAGELEAF attribute
[1]
INCLUDE attribute
[1]
INITIALIZER attribute
[1]
INSTRUCTIONS section
[1]
INVISIBLE attribute
[1]
ISNODECOLUMN attribute
[1]
ITEMS attribute
[1]
JUSTIFY attribute
[1]
KEY attribute
[1]
KEYBOARDHINT attribute
[1]
KEYS section
[1]
LABEL item definition
[1]
LABEL stack item
[1]
LAYOUT section
[1]
MINHEIGHT attribute
[1]
MINWIDTH attribute
[1]
NOENTRY attribute
[1]
NOT NULL attribute
[1]
NOTEDITABLE attribute
[1]
ORIENTATION attribute
[1]
PAGE container
[1]
PAGE stack item
[1]
PARENTIDCOLUMN attribute
[1]
PHANTOM item definition
[1]
PHANTOM stack item
[1]
PICTURE attribute
[1]
PROGRAM attribute
[1]
PROGRESSBAR item definition
[1]
PROGRESSBAR stack item
[1]
PROPERTIES attribute
[1]
QUERYEDITABLE attribute
[1]
RADIOGROUP item definition
[1]
RADIOGROUP stack item
[1]
REQUIRED attribute
[1]
REVERSE attribute
[1]
SAMPLE attribute
[1]
SCHEMA section
[1]
SCREEN section
[1]
SCROLL attribute
[1]
SCROLLBARS attribute
[1]
SCROLLGRID container
[1]
SCROLLGRID item definition
[1]
SIZEPOLICY attribute
[1]
SLIDER item definition
[1]
SLIDER stack item
[1]
SPACING attribute
[1]
SPINEDIT item definition
[1]
SPINEDIT stack item
[1]
SPLITTER attribute
[1]
STACK container
[1]
STEP attribute
[1]
STRETCH attribute
[1]
STYLE attribute
[1]
TABINDEX attribute
[1]
TABLE container
[1]
TABLE item definition
[1]
TABLE stack item
[1]
TABLES section
[1]
TAG attribute
[1]
TEXT attribute
[1]
TEXTEDIT item definition
[1]
TEXTEDIT stack item
[1]
TIMEEDIT item definition
[1]
TIMEEDIT stack item
[1]
TITLE attribute
[1]
TOOLBAR section
[1]
TOPMENU section
[1]
TREE container
[1]
TREE item definition
[1]
UNHIDABLE attribute
[1]
UNHIDABLECOLUMNS attribute
[1]
UNMOVABLE attribute
[1]
UNMOVABLECOLUMNS attribute
[1]
UNSIZABLE attribute
[1]
UNSIZABLECOLUMNS attribute
[1]
UNSORTABLE attribute
[1]
UNSORTABLECOLUMNS attribute
[1]
UPSHIFT attribute
[1]
VALIDATE attribute
[1]
VALIDATE LIKE attribute
[1]
VALUECHECKED attribute
[1]
VALUEMAX attribute
[1]
VALUEMIN attribute
[1]
VALUEUNCHECKED attribute
[1]
VBOX container
[1]
VERIFY attribute
[1]
VERSION attribute
[1]
WANTFIXEDPAGESIZE attribute
[1]
WANTNORETURNS attribute
[1]
WANTTABS attribute
[1]
WEBCOMPONENT item definition
[1]
WEBCOMPONENT stack item
[1]
WIDTH attribute
[1]
WINDOWSTYLE attribute
[1]
syntax - registers
INT_FLAG
[1]
QUIT_FLAG
[1]
STATUS
[1]
syntax - reports
AFTER GROUP OF
[1]
BEFORE GROUP OF
[1]
DEFINE in REPORT
[1]
FINISH REPORT
[1]
FIRST PAGE HEADER
[1]
FORMAT section
[1]
ON EVERY ROW
[1]
ON LAST ROW
[1]
ORDER BY section
[1]
OUTPUT section
[1]
OUTPUT TO REPORT
[1]
PAGE HEADER
[1]
PAGE TRAILER
[1]
START REPORT
[1]
TERMINATE REPORT
[1]
TABINDEX
dialog programming
[1]
tap
on a mobile device
[1]
TERM
terminal defintion
[1]
traditional mode
[1]
TTY attributes
[1]
UNBUFFERED
dialog programming
[1]
upgrading
upgrade notes
[1]
usage
DIALOG (multiple dialogs)
[1]
dynamic arrays
[1]
static arrays
[1]
usage - web services
Error -15553
[1]
exception handling
[1]
interruption handling
[1]
INT_FLAG
[1]
STATUS
[1]
TRY / CATCH
[1]
XML serialization attributes
[1]
VALIDATE
dialog programming
[1]
version
upgrade notes
[1]
web services
platform notes
GMA / Android
[1]
V1.3 API
fgl_ws_server_getOption
[1]
fgl_ws_server_publishFunction
[1]
fgl_ws_server_setOption
[1]
fgl_ws_server_start
[1]
V1.3 API options
http_invoketimeout
[1]
soap_ignoretimezone
[1]
soap_usetypedefinition
[1]
tcp_connectiontimeout
[1]
wsdl_arraysize
[1]
wsdl_decimalsize
[1]
wsdl_stringsize
[1]
XML facet constraint
Attributes list
[1]
XML facet constraint attributes
XSDAnySimpleType
[1]
XSDEnumeration
[1]
XSDFractionDigits
[1]
XSDMaxExclusive
[1]
XSDMaxInclusive
[1]
XSDMaxLength
[1]
XSDMinExclusive
[1]
XSDMinInclusive
[1]
XSDMinLength
[1]
XSDPattern
[1]
XSDTotalDigits
[1]
XSDWhiteSpace
[1]
WITHOUT DEFAULTS
dialog programming
[1]
XML output
reports
[1]
<p>Your browser does not support iframes.</p>
