Language Reference Guide
1. Introduction
About This Guide
Intended Audience
Conventions
Database-related Examples
Syntax
User Input Examples
Path Notation in This Guide
Your Support Options
2. Language Elements
Introduction
OpenROAD Names
Dynamic Names
Name Resolution
Dynamic Frame and Procedure Name Resolution
Variables
Simple Variables
How You Can Declare Simple Variables
How You Can Use Simple Variables
Reference Variables
How You Can Declare Reference Variables
How You Can Use Reference Variables
Null Reference Variables
How You Can Create Objects for Reference Variables
Dynamic Array Variables
How You Can Declare Dynamic Array Variables
How You Can Reference Dynamic Array Variables
Field and Menu Item Variables
How You Can Initialize Variables
Data Types
Character Data Types
Char Data Types
Varchar Data Types
Long Varchar Data Types
Unicode Data Types
Numeric Data Types
Integer Data Types
Decimal Data Types
Floating Point Data Types
Date/Time Data Types
Date/Time Input Formats
Date Data Type
Date(Ingresdate) Data Types
Coercion Between Date/Time Data Types
Abstract Data Types
Money Data Type
Numeric String Data Type
Logical Key Data Type
Storage Formats of Data Types
Nulls
Nulls and Comparisons
Nulls and Aggregate Functions
Nulls and Integrity Constraints
Expressions
Literals
Unicode Literals
String Literals
Numeric Literals
Named Constants
System Variables
Operators
Arithmetic Operators
String Operator
Logical Operators
Comparison (Boolean) Operators
SQL Operators
SQL Operations
Like Operator and Pattern Matching
Is [Not] Null Operator
Variables in Expressions
Procedures in Expressions
Methods in Expressions
Nulls in Expressions
Expressions in SQL Statements
System-defined Functions
SQL Functions
Scalar Functions
Aggregate Functions
IFNULL Function
Dbmsinfo Function
Field Function
Comments
Predicates in SQL
Comparison Predicate
LIKE Predicate
BETWEEN Predicate
IN Predicate
Any-or-All Predicate
EXISTS Predicate
IS NULL Predicate
Search Conditions in SQL Statements
Subqueries
Subqueries in the WHERE Clause
Subqueries in the FROM Clause (Derived Tables)
Derived Table Syntax
3. Statements
Commonly Used Elements in Statements
BeginEndBlock
Condition
DeclareBlock
DeclareBlockWithProcedures
LocalProcedureDeclaration
LocalVariableDeclaration
NamedParameterList
NamedParameterListDefinition
NamedParameterListWithoutByref
StatementList
Type
TypeWithoutDefault
UnnamedParameterList
WithClause
OpenROAD Language Statements
Assignment Statement
Parameters--Assignment Statement
Simple Assignment Statements
Reference Assignment Statements
Examples--Assignment Statement
Call Statement
Parameters--Call Statement
Flag Parameters
Subsystem Types
Call Application Statement
Examples--Call Statement
Call System Statement
Parameters--Call System Statement
Example--Call System Statement
Callframe Statement
Parameters--Callframe Statement
Examples--Callframe Statement
Callproc Statement
Parameters--Callproc Statement
Example--Callproc Statement
Case Statement
Parameters--Case Statement
Examples--Case Statement
Continue Statement
Parameters--Continue Statement
Examples--Continue Statement
Endloop Statement
Parameters--Endloop Statement
Examples--Endloop Statement
Exit Statement
For Statement
Breaking Out of For Loops
Parameters--For Statement
Example--For Statement
Gotoframe Statement
Parameters--Gotoframe Statement
Example--Gotoframe Statement
If-Then-Else Statement
Parameters--If-Then-Else Statement
Variants--If-Then-Else Statement
Examples--If-Then-Else Statement
Initialize Statement
Parameters--Initialize Statement
Examples--Initialize Statement
User Class Constructors
Message Statement
Parameters--Message Statement
Example--Message Statement
Method Statement
Parameters--Method Statement
Example--Method Statement
Method Invocation Statement
Parameters--Method Invocation Statement
Examples--Method Invocation Statement
Nextcase Statement
On Statement
Parameters--On Statement
Sending User-named Parameters with Userevents
Examples--On Statement
Openframe Statement
Parameters--Openframe Statement
Examples--Openframe Statement
Procedure Statement
Parameters--Procedure Statement
Examples--Procedure Statement
Prompt Statement
Parameters--Prompt Statement
Examples--Prompt Statement
Resume Statement
Examples--Resume Statement
Return Statement
Parameters--Return Statement
Example--Return Statement
Sleep Statement
Parameters--Sleep Statement
Example--Sleep Statement
While Statement
Parameters--While Statement
Breaking Out of While Loops
Examples--While Statement
OpenROAD SQL Statements
Distributed Ingres (Ingres STAR) Statements
Enterprise Access OpenSQL Statements
Alter Group Statement
Parameters--Alter Group Statement
Permissions
Locking
Related Statements
Examples--Alter Group Statement
Alter Role Statement
Parameters--Alter Role Statement
Permissions
Locking
Related Statements
Examples--Alter Role Statement
Close Statement
Parameters--Close Statement
Example--Close Statement
Commit Statement
Examples--Commit Statement
Copy Statement
Parameters--Copy Statement
Unformatted Copying
Formatted Copying
Bulk Copying
Column Formats for Copy
Filename Specification for Copy
With Clause for Copy
Permissions
Locking
Restrictions and Considerations
Related Statements
Examples--Copy Statement
Create Dbevent Statement
Parameters--Create Dbevent Statement
Permissions: All Users
Create Dbevent Locking
Create Dbevent Related Statements
Create Group Statement
Parameters--Create Group Statement
Create Group Permissions
Create Group Locking
Create Group Related Statements
Examples--Create Group Statement
Create Index Statement
Parameters--Create Index Statement
Create Index Description
Index Storage Structure
Unique Indexes
Effect of the Unique_Scope Option on Updates
Index Location
Create Index Permissions
Create Index Locking
Create Index Related Statements
Examples--Create Index Statement
Create Integrity Statement
Parameters--Create Integrity Statement
Create Integrity Locking
Create Integrity Performance
Permissions: Own the table
Create Integrity Related Statements
Examples--Create Integrity Statement
Create Role Statement
Parameters--Create Role Statement
Create Role Permissions
Create Role Locking
Create Role Related Statements
Examples--Create Role Statement
Create Table Statement
Parameters--Create Table Statement
Create Table Description
Column Specification--Define Column Characteristics
With|Not Null and With|Not Default Combinations
Using Create Table...As Select
With_Clause for Create Table
With_Clause for Create Table...As Select
Create Table Permissions
Create Table Locking
Create Table Related Statements
Examples--Create Table Statement
Create View Statement
Parameters--Create View Statement
Create View Description
With Check Option Clause
Create View Permissions
Create View Locking
Create View Related Statements
Examples--Create View Statement
Declare Global Temporary Table Statement
Restrictions on Temporary Tables
Examples--Declare Global Temporary Table Statement
Delete Statement
Non-cursor Version
Cursor Version
Parameters--Delete Statement
Examples--Delete Statement
Direct Execute Immediate Statement
Parameters--Direct Execute Immediate Statement
Drop Statement
Parameters--Drop Statement
Drop Description
Drop Permissions
Drop Locking
Drop Related Statements
Examples--Drop Statement
Drop Dbevent Statement
Parameters--Drop Dbevent Statement
Drop Dbevent Permissions
Drop Dbevent Related Statements
Examples--Drop Dbevent Statement
Drop Group Statement
Parameters--Drop Group Statement
Drop Group Permissions
Drop Group Locking
Drop Group Related Statements
Examples--Drop Group Statement
Drop Integrity Statement
Parameters--Drop Integrity Statement
Drop Integrity Permissions
Drop Integrity Related Statements
Examples--Drop Integrity Statement
Drop Role Statement
Parameters--Drop Role Statement
Drop Role Permissions
Drop Role Locking
Drop Role Related Statements
Examples--Drop Role Statement
Drop Rule Statement
Parameters--Drop Rule Statement
Drop Rule Permissions
Examples--Drop Rule Statement
Execute Immediate Statement
Parameters--Execute Immediate Statement
Execute Immediate Description
Permissions: All Users
Execute Immediate Locking
Examples--Execute Immediate Statement
Execute Procedure Statement
Parameters--Execute Procedure Statement
Execute Procedure Permissions
Execute Procedure Locking
Execute Procedure Performance
Execute Procedure Related Statements
Examples--Execute Procedure Statement
Example--Exit Statement
Fetch Statement
Parameters--Fetch Statement
Examples--Fetch Statement
Grant (privilege) Statement
Parameters--Grant (privilege) Statement
Object Privileges
Privilege Defaults
Grant All Privileges Option
Grant (privilege) Permissions
Grant (privilege) Locking
Grant (privilege) Related Statements
Examples--Grant (privilege) Statement
Inquire_sql Statement
Parameters--Inquire_sql Statement
Example--Inquire_sql Statement
Insert Statement
Parameters--Insert Statement
Values Clause and Subselect
Examples--Insert Statement
Modify Statement
Parameters--Modify Statement
Modify Description
Syntax for Modify Operations
Storage Structure Specification
Modify...to Reconstruct
Modify...to Merge
Modify...to Relocate
Modify...to Reorganize
Modify...to Truncated
Modify...to Add_extend
Modify...with Blob_extend
Modify...to Phys_consistent|Phys_inconsistent
Modify...to Log_consistent|Log_inconsistent
Modify...to Table_recovery_allowed|Table_recovery_disallowed
Modify…to [No]Readonly
With Clause Options for Modify
Modify Permissions
Modify Locking
Modify Related Statements
Examples--Modify Statement
Open Statement
Parameters--Open Statement
How You Can Define the Cursor Mode
Examples--Open Statement
Raise Dbevent Statement
Parameters--Raise Dbevent Statement
Raise Dbevent Description
Raise Dbevent Permissions
Raise Dbevent Related Statements
Register Dbevent Statement
Parameters--Register Dbevent Statement
Register Dbevent Permissions
Register Dbevent Related Statements
Register Table Statement
Parameters--Register Table Statement
Register Table Description
Security Log File Format
Register Table Permissions
Register Table Locking
Related Statements
Examples--Register Table Statement
Relocate Statement
Parameters--Relocate Statement
Examples--Relocate Statement
Remove Dbevent Statement
Parameters--Remove Dbevent Statement
Remove Table Statement
Parameters--Remove Table Statement
Remove Table Permissions
Remove Table Locking
Remove Table Related Statements
Examples--Remove Table Statement
Revoke Statement
Parameters--Revoke Statement
Revoke Permissions
Revoke Locking
Revoke Related Statements
Examples--Revoke Statement
Rollback Statement
Parameters--Rollback Statement
Permissions: All Users
Rollback Locking
Rollback Performance
Example--Rollback Statement
Save Statement
Parameters--Save Statement
Permissions: Own the table
Save Locking
Examples--Save Statement
Savepoint Statement
Parameters--Savepoint Statement
Permissions: All Users
Savepoint Related Statements
Examples--Savepoint Statement
Select Statement
Parameters--Select Statement
Union Clause
Outer Joins
Where Clause
Order By Clause
Using a Select Loop
Examples--Select Statement
Set Statement
Parameters--Set Statement
Set Permissions
Autocommit
[No]Batch_Copy_Optim
[No]Cache_dynamic
[No]Cardinality_check
Cpufactor
Date_format
Decimal
[No]Flatten
[No]Hash
[No]Io_trace
Joinop [No]Timeout
Joinop Timeoutabort
Joinop [No]Greedy
[No]Journaling
Lockmode
[No]Lock_Trace
[No]Logdbevents
[No]Logging
[No]Log_trace
[No]Maxconnect
[No]Maxcost
[No]Maxcpu
[No]Maxidle
[No]Maxio
[No]Maxpage
[No]Maxquery
[No]Maxrow
Money_format
Money_prec
[No]Ojflatten
[No]Optimizeonly
[No]Parallel
[No]Printdbevents
[No]Printqry
[No]Printrules
[No]Qep
Random_seed
Result_Structure
Role
[No]Rules
Session With On_error
Session With On_user_error
Session Authorization
Session [No]Cache_Dynamic
[No]Statistics table_name
[No]Trace Output
[No]Trace Point
Transaction Access Mode
Transaction Isolation Level
[No]Unicode_substitution
Update_Rowcount
Examples--Set Statement
Update Statement
Parameters--Update Statement
Set Clause
Where Clause
Update Mode
Examples--Update Statement
EXEC 4GL Statements for 3GL
Clear Array Statement
Describe Statement
Get Attribute Statement
Get Global/Set Global Statement
GetRow Statement
Inquire_4gl Statement
Insertrow Statement
Removerow Statement
Send Userevent Statement
Set Attribute Statement
Set_4gl Statement
Setrow Statement
Setrow Deleted Statement
4. System Classes
Inheritance: Subclasses and Superclasses
Saved Object Classes
How You Can Use This Chapter
Attribute Abbreviations
ActiveField Class
Declared Attribute
DragObject Attribute
DropObject Attribute
FocusBehavior Attribute
IsDragSource Attribute
IsPropOptInherited Attribute
OutlineColor Attribute
OutlineStyle Attribute
OutlineWidth Attribute
PropertyOptMenu Attribute
TabSeqNum Attribute
WidgetID Attribute
CheckFailedMandatory Method
DeclareData Method
SetToDefault Method
UndeclareData Method
UpdField Method
AnalogField Class
MaxValue Attribute
MinValue Attribute
AppFlag Class
FlagValues Attribute
Name Attribute
AppSource Class
TaggedValues Attribute
WindowIcon Attribute
ExportApp Method
FetchComponent Method
FetchTaggedValue Method
FindTag Method
GetTaggedValues Method
GetTagText Method
GetTagValue Method
ImportComp Method
RemoveTaggedValue Method
SetTaggedValue Method
Array Class
Row_Class Attribute
ArrayObject Class
_RowSelected Attribute
_RowState Attribute
AllRows Attribute
ClientInteger Attribute
FirstRow Attribute
LastRow Attribute
SortCasesensitive Attribute
AllRows Method
Clear Method
Find Method
FirstRow Method
InsertRow Method
LastRow Method
RemoveRow Method
SetRowDeleted Method
Sort Method
AttributeObject Class
DataType Attribute
DefaultString Attribute
DefaultValue Attribute
IsArray Attribute
IsNullable Attribute
IsPrivate Attribute
Name Attribute
TaggedValues Attribute
FetchTaggedValue Method
FindTag Method
GetTaggedValues Method
GetTagText Method
GetTagValue Method
RemoveTaggedValue Method
SetTaggedValue Method
BarField Class
FgBitmap Attribute
FgPattern Attribute
GrowFrom Attribute
UpdForeground Method
BitmapObject Class
DBHandle Attribute
ErrorStatus Attribute
FileHandle Attribute
HeightPixels Attribute
ImageIndex Attribute
Marker Attribute
Picture Attribute
WidthPixels Attribute
BlankBitmap Method
CaptureBitmap Method
ComposeBitmap Method
CornerBitmap Method
DeleteFromDB Method
Elements Method
ExtractBitmap Method
FillBitmap Method
FormatBitmap Method
GetDisplayedElement Method
GetPixelColor Method
GradientBitmap Method
InsertIntoDB Method
LoadLong Method
LocateBitmap Method
OrientBitmap Method
ReplaceBitmap Method
ReplaceTransparency Method
ResizeBitmap Method
SetPixelColor Method
UpdateInDB Method
WriteToFile Method
BoxTrim Class
BreakSpec Class
ColumnIndex Attribute
FormatString Attribute
Level Attribute
ButtonField Class
BitmapLabel Attribute
BmpDisplayBehavior Attribute
ButtonStyle Attribute
IsAutoSized Attribute
IsBold Attribute
IsItalic Attribute
IsPlain Attribute
IsUnderlined Attribute
TextAlignment Attribute
TextDisplayBehavior Attribute
TextLabel Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
CellAttribute Class
BgBitmap Attribute
BgColor Attribute
BgPattern Attribute
Cursor Attribute
FgBitmap Attribute
FgColor Attribute
FgPattern Attribute
FormatString Attribute
HasDataChanged Attribute
IsBold Attribute
IsItalic Attribute
IsPlain Attribute
IsReverse Attribute
IsUnderlined Attribute
OutlineColor Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
UpdBackground Method
UpdForeground Method
ChoiceBitmap Class
EnumBitmap Attribute
ChoiceDetail Class
EnumSubText Attribute
ImageIndex Attribute
ChoiceField Class
CurEnumDisplay Attribute
CurEnumIndex Attribute
CurEnumText Attribute
CurEnumValue Attribute
ValueList Attribute
UpdChoiceList Method
ChoiceItem Class
EnumDisplay Attribute
EnumText Attribute
EnumValue Attribute
IsSelected Attribute
ToolTipText Attribute
ChoiceList Class
AddBitmapItem Method
AddItem Method
AddTextItem Method
BitmapByDisplay Method
BitmapByIndex Method
BitmapByText Method
BitmapByValue Method
ChoiceItems Attribute
DisplayByBitmap Method
DisplayByIndex Method
DisplayByText Method
DisplayByValue Method
IndexByBitmap Method
IndexByDisplay Method
IndexByText Method
IndexByValue Method
TextByBitmap Method
TextByDisplay Method
TextByIndex Method
TextByValue Method
ValueByBitmap Method
ValueByDisplay Method
ValueByIndex Method
ValueByText Method
Class Class
Create Method
ClassSource Class
Attributes Attribute
Methods Attribute
SuperClass Attribute
CreateClass Method
ColumnCross Class
ColumnField Class
ColumnNumber Attribute
HasCellAttributes Attribute
HasSingleCharFind Attribute
ParentTable Attribute
ProtoField Attribute
Title Attribute
TitleTrim Attribute
CellAttribute Method
CompositeField Class
ChildFields Attribute
GroupBoxLabel Attribute
IsMoveBounded Attribute
IsResizeBounded Attribute
FieldByName Method
FieldsByProperty Method
IsAncestorOf Method
SelectAll Method
CompSource Class
AlterBy Attribute
AlterCount Attribute
AlterDate Attribute
AssistantProc Attribute
Compile_Errors Attribute
CreateDate Attribute
Creator Attribute
DataType Attribute
EntityID Attribute
IsNullable Attribute
IsStale Attribute
Name Attribute
ObjectShortRemarks Attribute
ParentApplication Attribute
Queries Attribute
Script Attribute
TaggedValues Attribute
VersionNumber Attribute
VersShortRemarks Attribute
ExportComp Method
FetchTaggedValue Method
FindTag Method
GetTaggedValues Method
GetTagText Method
GetTagValue Method
RemoveTaggedValue Method
SetTaggedValue Method
ControlButton Class
CrossTable Class
AcrossValues Attribute
Aggregate Attribute
CrossColumn Attribute
CursorBitmap Class
SysCursor Attribute
CursorObject Class
DBSession Attribute
RowCount Attribute
State Attribute
DataStream Class
Breaks Attribute
ClientInteger Attribute
Columns Attribute
CurBreakLevel Attribute
CurRow Attribute
ErrorNo Attribute
IsDBError Attribute
MaxRow Attribute
Name Attribute
NextBreakLevel Attribute
QueryMode Attribute
Scope Attribute
State Attribute
SuppressErrorTrace Attribute
TargetArray Attribute
TargetPrefix Attribute
AddBreak Method
ClearBreaks Method
Close Method
FetchRow Method
Load Method
NextRow Method
Open Method
PrevRow Method
SetCols Method
DateObject Class
Value Attribute
DBEventObject Class
DBEventDatabase Attribute
DBEventName Attribute
DBEventOwner Attribute
DBEventText Attribute
DBEventTime Attribute
DBSessionObject Class
Database Attribute
DBMSError Attribute
ErrorNumber Attribute
Flags Attribute
Ingres Attribute
PreFetchRows Attribute
RowCount Attribute
ServerClass Attribute
ServerType Attribute
SessionID Attribute
State Attribute
CommitWork Method
Connect Method
Disconnect Method
NewDBComponent Method
OpenNewConnection Method
RaiseDBEvent Method
RegisterDBEvent Method
RemoveDBEvent Method
RollbackWork Method
SequenceValue Method
SetAutoCommit Method
WriteDBComponent Method
DecimalObject Class
Precision Attribute
Scale Attribute
Value Attribute
DisplayForm Class
DragInfo Class
KeyState Attribute
Source Attribute
Target Attribute
X Attribute
Y Attribute
DynExpr Class
Assign Method
GetField Method
GetValue Method
SetValue Method
StringValue Method
EllipseShape Class
EntryField Class
BufferString Attribute
BufferText Attribute
CharsPerLine Attribute
CurMarkedText Attribute
CursorPosition Attribute
ExactWidth Attribute
ExitBehavior Attribute
FirstMarked Attribute
ForceCase Attribute
FormatString Attribute
HasHorizontalScrollBar Attribute
HasScrollBar Attribute
InputMasking Attribute
IsBold Attribute
IsItalic Attribute
IsMandatory Attribute
IsMultiLine Attribute
IsPassword Attribute
IsPlain Attribute
IsUnderlined Attribute
LastMarked Attribute
Lines Attribute
MaxCharacters Attribute
StringValue Attribute
TextLength Attribute
TextValue Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
UseWidestCharacter Attribute
WidestCharacterWidth Attribute
MarkAllText Method
MarkSubText Method
SetInnerMargins Method
UnmarkAllText Method
EnumField Class
ExactWidth Attribute
IsBold Attribute
IsItalic Attribute
IsPlain Attribute
IsUnderlined Attribute
MinimumWidth Attribute
TypeFace Attribute (EnumField)
TypeFaceName Attribute
TypeSize Attribute
Event Class
EventName Attribute
MessageErrorCode Attribute
MessageFloat Attribute
MessageInteger Attribute
MessageObject Attribute
MessageVarchar Attribute
ExtenPropObject Class
TagDefinitions Attribute
ValueDefinitions Attribute
UserTagDefinitions Attribute
UserValueDefinitions Attribute
ExtObject Class
ExtObjField Class
InsertObject Method
FieldObject Class
BgColor Attribute
BottomInnerMargin Attribute
ClientText Attribute
ControlField Attribute
DataType Attribute
DefaultString Attribute
DefaultValue Attribute
FgColor Attribute
FullName Attribute
HasDataChanged Attribute
IsNullable Attribute
LeftInnerMargin Attribute
Name Attribute
ParentExec Attribute
RightInnerMargin Attribute
Script Attribute
TaggedValues Attribute
TopInnerMargin Attribute
FetchTaggedValue Method
FindTag Method
GetFieldValue Method
GetTaggedValues Method
GetTagText Method
GetTagValue Method
IsDescendantOf Method
RemoveTaggedValue Method
SetFieldValue Method
SetTaggedValue Method
UpdValue Method
WhichTableField Method
FlexibleForm Class
FloatObject Class
Value Attribute
FormField Class
AbsXLeft Attribute
AbsXRight Attribute
AbsYBottom Attribute
AbsYTop Attribute
AllBias Attribute
AnchorPoint Attribute
BgBitmap Attribute
BgDisplayPolicy Attribute
BgPattern Attribute
CurBias Attribute
Cursor Attribute
Gravity Attribute
HasFieldChanged Attribute
Height Attribute
IsCurField Attribute
IsReverse Attribute
IsSelected Attribute
LayerSequence Attribute
MouseDownText Attribute
MouseMoveText Attribute
OuterHeight Attribute
OuterWidth Attribute
ParentField Attribute
QueryBias Attribute
ReadBias Attribute
RequireRealField Attribute
ToolTipText Attribute
UpdateBias Attribute
UpdBackground Method
User1Bias Attribute
User2Bias Attribute
User3Bias Attribute
Width Attribute
XAnchorPoint Attribute
XLeft Attribute
XRight Attribute
YAnchorPoint Attribute
YBottom Attribute
YTop Attribute
FrameExec Class
AutoUpdField Attribute
BgBitmap Attribute
BgColor Attribute
BgPattern Attribute
CurMode Attribute
DefaultButton Attribute
GridX Attribute
GridY Attribute
FrameHeight Attribute
FrameWidth Attribute
HasScrollBars Attribute
HasStatusBar Attribute
HeightConstrained Attribute
InputFocusField Attribute
IsAutoSized Attribute
IsBordered Attribute
IsClosable Attribute
IsGridOn Attribute
IsLassoActive Attribute
IsMaximizable Attribute
IsMaximized Attribute
How to Change the IsMaximized Setting at Runtime
How to Change the IsMaximized Setting While a Frame is Invisible
How to Execute an Openframe Using a With Clause to Set the IsMaximized Attribute
IsMinimizable Attribute
IsPopup Attribute
IsResizeable Attribute
IsTitled Attribute
IsToolWindow Attribute
IsTopmost Attribute
MainBarBottom Attribute
MainBarLeft Attribute
MainBarRight Attribute
MainBarTop Attribute
NextTargetField Attribute
OriginatorField Attribute
PortletBlocking Attribute
PreviousField Attribute
ReasonCode Attribute
SelectedList Attribute
StartMenu Attribute
StatusText Attribute
TargetField Attribute
TopForm Attribute
TriggerField Attribute
WidgetID Attribute
WidthConstrained Attribute
WindowHeight Attribute
WindowPlacement Attribute
WindowTitle Attribute
WindowVisibility Attribute
WindowWidth Attribute
WindowXLeft Attribute
WindowYTop Attribute
XAbsClick Attribute
XClick Attribute
XEnd Attribute
XStart Attribute
YAbsClick Attribute
YClick Attribute
YEnd Attribute
YStart Attribute
Activate Method
BringToFront Method
FieldByName Method
SendToBack Method
SetWindowIcon Method
SnapToGrid Method
UpdBackground Method
FrameForm Class
TransparentColor Attribute
FieldByFullName Method
FrameSource Class
BgBitmap Attribute
BgColor Attribute
BgPattern Attribute
CurMode Attribute
HasScrollBars Attribute
HasStatusBar Attribute
IsAutoSized Attribute
IsBordered Attribute
IsClosable Attribute
IsGridOn Attribute
IsMaximizable Attribute
IsMaximized Attribute
IsMinimizable Attribute
IsPopup Attribute
IsResizeable Attribute
IsTitled Attribute
IsToolWindow Attribute
IsTopmost Attribute
MainBarBottom Attribute
MainBarLeft Attribute
MainBarRight Attribute
MainBarTop Attribute
StartMenu Attribute
StatusText Attribute
TopForm Attribute
WindowHeight Attribute
WindowIcon Attribute
WindowPlacement Attribute
WindowTitle Attribute
WindowWidth Attribute
WindowXLeft Attribute
WindowYTop Attribute
FreeTrim Class
GhostExec Class
DBEvent Attribute
EventName Attribute
EventType Attribute
MessageErrorCode Attribute
MessageFloat Attribute
MessageInteger Attribute
MessageObject Attribute
MessageVarchar Attribute
ParentFrame Attribute
PurgeDBEvent Method
PurgeUserEvent Method
RegisterUserEvent Method
SendUserEvent Method
Terminate Method
UnRegisterUserEvent Method
GhostSource Class
HashTable Class
AllowSubclassObjects Attribute
AutoResizeThreshold Attribute
CompareKeyFunction Attribute
Entries Attribute
HashKeyFunction Attribute
ObjectClass Attribute
ObjectCount Attribute
Size Attribute
UniqueKey Attribute
GetEntries Method
LoadEntries Method
HashTableEntry Class
HashValue Attribute
Key Attribute
Object Attribute
IconFile Class
Count Attribute
ErrorStatus Attribute
FileHandle Attribute
GetBitmap Method
ImageField Class
BmpDisplayBehavior Attribute
DisplayPolicy Attribute
ImageTrim Class
Image Attribute
InputEvent Class
Action Attribute
FieldID Attribute
FieldX Attribute
FieldY Attribute
FrameID Attribute
ModifierKeys Attribute
MouseButton Attribute
ScreenX Attribute
ScreenY Attribute
Sprite Attribute
Tick Attribute
VirtualKey Attribute
ActivateFields Method
EventKey Method
LastInputAction Method
LoadEventBehavior Method
Responsetype
QueueResponse Method
RemoveEventBehavior Method
Response Method
StopEventBehavior Method
TriggerEventBehavior Method
IntegerHashTable Class
Clear Method
Contains Method
Find Method
FindAll Method
InsertObject Method
RemoveObject Method
Setup Method
IntegerHashTable Examples
IntegerObject Class
Value Attribute
BitAnd Method
BitAndNot Method
BitClear Method
BitFlip Method
BitNot Method
BitOr Method
BitSet Method
BitShift Method
BitTest Method
BitXor Method
JsonArray Class
Items Attribute
JsonBoolean Class
Value Attribute
JsonHandler Class
AlwaysAddClassName Attribute
Errortext Attribute
GenMixedCaseMemberNames Attribute
IgnoreUnknownAttributes Attribute
IndentChar Attribute
IndentCharCount Attribute
MaxNestingLevel Attribute
JsonObject2Object Method
JsonRpcRequest Method
NewJsonValue Method
Object2JsonValue Method
Parse Method
ParseFile Method
SetIndent Method
SetSerializableClassAttributes Method
Write Method
WriteFile Method
JsonNull Class
JsonNumber Class
TextValue Attribute
GetValue Method
SetValue Method
JsonObject Class
AddMember Method
GetMember Method
GetMemberNames Method
NewMember Method
RemoveMember Method
JsonString Class
Value Attribute
JsonValue Class
KeyDownData Class
CharacterValue Attribute
IsExtended Attribute
Modifiers Attribute
PreviousState Attribute
ScanCode Attribute
VirtualKey Attribute
KeyPressInfo Class
ANSICode Attribute
Character Attribute
ListField Class
HasSingleCharFind Attribute
SelectionType Attribute
VisibleRows Attribute
ListviewColAttr Class
ColumnWidth Attribute
HeaderText Attribute
TextAlignment Attribute
ListviewField Class
ColAttributes Attribute
DragItem Attribute
Drag_Row Attribute
Drop_Row Attribute
EditLabel Attribute
FullRowSelect Attribute
HasColumnHeaders Attribute
LargeImageHeight Attribute
LargeImageList Attribute
LargeImageWidth Attribute
SmallImageHeight Attribute
SmallImageList Attribute
SmallImageWidth Attribute
Style Attribute
TopRow Attribute
VisibleRows Attribute
Sort Method
LongByteObject Class
ErrorStatus Attribute
FileHandle Attribute
Length Attribute
Value Attribute
ConvertFromString Method
FetchFromDB Method
LoadValue Method
UpdateInDB Method
WriteToFile Method
LongVcharObject Class
ErrorStatus Attribute
FileEncoding Attribute
FileHandle Attribute
Length Attribute
Value Attribute
FetchFromDB Method
LoadString Method
UpdateInDB Method
WriteToFile Method
MainBar Class
MatrixField Class
ChildBottomMargin Attribute
ChildGravity Attribute
ChildLeftMargin Attribute
ChildRightMargin Attribute
ChildTopMargin Attribute
CollapsePolicy Attribute
Columns Attribute
Rows Attribute
SeparatorColor Attribute
SeparatorStyle Attribute
SeparatorWidth Attribute
FieldByPosition Method
InsertChild Method
WhichCell Method
MenuBar Class
HelpMenu Attribute
FieldByFullName Method
MenuButton Class
SpeedKey Attribute
TextLabel Attribute
MenuField Class
AllBias Attribute
CurBias Attribute
IsReverse Attribute
ParentMenuGroup Attribute
QueryBias Attribute
ReadBias Attribute
StatusText Attribute
UpdateBias Attribute
User1Bias Attribute
User2Bias Attribute
User3Bias Attribute
WidgetID Attribute
SetToDefault Method
MenuGroup Class
ChildMenuFields Attribute
TextLabel Attribute
FieldByName Method
UpdMenu Method
MenuItem Class
FocusBehavior Attribute
MenuList Class
CurEnumDisplay Attribute
CurEnumIndex Attribute
CurEnumText Attribute
CurEnumValue Attribute
ValueList Attribute
UpdChoiceList Method
MenuSeparator Class
MenuStack Class
MenuToggle Class
HasIndicator Attribute
OffTextLabel Attribute
OnTextLabel Attribute
MethodExec Class
SendSuperClass Method
MethodObject Class
DataType Attribute
IsArray Attribute
IsNullable Attribute
IsPrivate Attribute
Name Attribute
TaggedValues Attribute
FetchTaggedValue Method
FindTag Method
GetTaggedValues Method
GetTagText Method
GetTagValue Method
RemoveTaggedValue Method
SetTaggedValue Method
MoneyObject Class
Value Attribute
MouseData Class
CancelEvent Attribute
KeyModifiers Attribute
TimeStamp Attribute
WidgetID Attribute
XPixel Attribute
XPixelScreen Attribute
YPixel Attribute
YPixelScreen Attribute
Object Class
ClassName Attribute
ClientData Attribute
InstanceIdentifier Attribute
InstanceReferences Attribute
Duplicate Method
GetAttribute Method
IsA Method
SetAttribute Method
OptionField Class
InnerShadowWidth Attribute
Style Attribute
TextLabel Attribute
VisibleRows Attribute
OptionMenu Class
PaletteField Class
BmpDisplayBehavior Attribute
ButtonStyle Attribute
Columns Attribute
CurEnumBitmap Attribute
Orientation Attribute
PopupButton Class
OptionMenu Attribute
PopupAlignment Attribute
Proc4GLSource Class
ProcExec Class
BlocksFrames Attribute
DataEntryErrorHandler Attribute
DBSession Attribute
InInitialize Attribute
LineNumber Attribute
LocalScope Attribute
Name Attribute
ObjectSource Attribute
Parent Attribute
Queries Attribute
Scope Attribute
Beep Method
ChooseColor Method
ConfirmPopup Method
DeferConfigure Method
FilePopup Method
Using the reply parameter
Flush Method
InfoPopup Method
ReplyPopup Method
SetExitTrap Method
Trace Method
WaitFor Method
ProcHandle Class
Call Method
QueryCol Class
AsName Attribute
ClientInteger Attribute
ColumnName Attribute
DataType Attribute
DataTypeCode Attribute
DataTypeLength Attribute
DataTypeNullable Attribute
DataTypePrecision Attribute
Expression Attribute
FromTable Attribute
GroupBy Attribute
IsExpression Attribute
OrderBy Attribute
Targets Attribute
Value Attribute
DBIdentifier Method
QueryObject Class
DesignTimeWhere Attribute
HavingClause Attribute
IsDistinct Attribute
RunTimeWhere Attribute
Tables Attribute
CommitToCache Method
DBDelete Method
DBInsert Method
DBUpdate Method
QueryParm Class
CompiledExpression Attribute
CompiledResult Attribute
Expression Attribute
IsDBHandleField Attribute
IsDefault Attribute
IsDeleteWhere Attribute
IsFileHandleField Attribute
IsInsertTarget Attribute
IsSelectTarget Attribute
IsUpdateTarget Attribute
IsUpdateWhere Attribute
ResultAssignment Attribute
UsePrefix Attribute
QueryTable Class
ClientInteger Attribute
CorrName Attribute
OwnerName Attribute
TableName Attribute
RadioField Class
Columns Attribute
ColumnHeightCompressed Attribute
ColumnWidthCompressed Attribute
Orientation Attribute
RectangleShape Class
RemoteServer Class
Errorcode Attribute
Errortext Attribute
Flags Attribute
Image Attribute
Location Attribute
Routing Attribute
ServerType Attribute
Call4GL Method
Initiate Method
JsonRpcRequest Method
Release Method
RequestManager Class
ChoiceList Attribute
Item Attribute
Items Attribute
AllAttributes Method
AncestorByProperty Method
RespondToRequest Method
RowCross Class
ScalarField Class
Scope Class
CreateDynExpr Method (Scope)
GetProcHandle Method
ScrollBarField Class
ElevatorSize Attribute
Orientation Attribute
PageSize Attribute
StepSize Attribute
SegmentShape Class
Point1X Attribute
Point1Y Attribute
Point2X Attribute
Point2Y Attribute
SetEndPoints Method
SeparatorMoveInfo Class
SeparatorNumber Attribute
SeparatorPosition Attribute
SessionObject Class
AppFlags Attribute
CallSystemStatus Attribute
DBEventPollrate Attribute
DBMSErrorPrinting Attribute
DBMSMessagePrinting Attribute
DisplayCapability Attribute
ExitCode Attribute
ExternalError Attribute
JsonHandler Attribute
OperatingSystem Attribute
PixelScreenHeight Attribute
PixelScreenWidth Attribute
ProcessWait Attribute
ProcessWindow Attribute
Runtime Attribute
Scope Attribute
ScreenHeight Attribute
ScreenWidth Attribute
TimeZone Attribute
UserName Attribute
Version Attribute
WindowSystem Attribute
WorkingDirectory Attribute (SessionObject)
CheckFeature Method
ClearErrorFlag Method
CreateDirectory Method
DirectoryExists Method
FileExists Method
GenerateGUID Method
GetColorName Method
GetEnv Method
SetEnv Method
WinHelp Method
ShapeField Class
LineColor Attribute
LineStyle Attribute
LineWidth Attribute
SliderField Class
DisplayValues Attribute
IsBold Attribute
IsItalic Attribute
IsPlain Attribute
IsUnderlined Attribute
Orientation Attribute
PageSize Attribute
StepSize Attribute
Style Attribute
TickIntervals Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
SpriteDescriptor Class
Angle Attribute
DescriptorString Attribute
Flags Attribute
Flip Attribute
Gravity Attribute
Height Attribute
HeightUnit Attribute
Name Attribute
Opacity Attribute
PropertyString Attribute
Response Attribute
Sector Attribute
SpriteIndex Attribute
SpriteSource Attribute
SpriteSourceIndex Attribute
Width Attribute
WidthUnit Attribute
X Attribute
XUnit Attribute
Y Attribute
YUnit Attribute
ApplySectorMap Method
ApplySpriteMap Method
Populate Method
SpriteMap Method
SpriteImage Method
SpriteKey Method
WhichSprite Method
WhichSector Method
SQLSelect Class
DBSession Attribute
Query Attribute
QueryName Attribute
StackField Class
ChildBottomMargin Attribute
ChildGravity Attribute
ChildLeftMargin Attribute
ChildRightMargin Attribute
ChildTopMargin Attribute
Orientation Attribute
SeparatorColor Attribute
SeparatorMoving Attribute
SeparatorStyle Attribute
SeparatorWidth Attribute
InsertChild Method
StringHashTable Class
IgnoreCase Attribute
Clear Method
Contains Method
Find Method
FindAll Method
InsertObject Method
RemoveObject Method
Setup Method
StringHashTable Examples
StringObject Class
AllocateBufferExtra
AllocatedBufferSize
DBHandle Attribute
ErrorStatus Attribute
FileEncoding Attribute
FileHandle Attribute
Length Attribute
Value Attribute
AppendToFile Method
ConcatString Method
ConcatVarchar Method
ConvertFromBinary Method
DeleteFromDB Method
ExpandParm Method
ExtractString Method
InsertIntoDB Method
Join Method
LeftTruncate Method
LoadLong Method
LocateString Method
RightTruncate Method
Split Method
SubString Method
UpdateInDB Method
WriteToFile Method
SubForm Class
ChildBottomMargin Attribute
ChildLeftMargin Attribute
ChildRightMargin Attribute
ChildTopMargin Attribute
ChildGravity Attribute
IsBold Attribute
IsItalic Attribute
IsPlain Attribute
IsUnderlined Attribute
SizeToFit Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
TabBar Class
BarPosition Attribute
BitmapPosition Attribute
DisplayBitmap Attribute
DisplayText Attribute
IsBold Attribute
IsFixedWidth Attribute
IsItalic Attribute
IsPlain Attribute
IsUnderlined Attribute
MultiTabStyle Attribute
NormalTabColor Attribute
NormalTextColor Attribute
OutlineColor Attribute
SelectedIsBold Attribute
SelectedIsItalic Attribute
SelectedIsPlain Attribute
SelectedIsUnderlined Attribute
SelectedTabColor Attribute
SelectedTextColor Attribute
SelectedTypeFace Attribute
SelectedTypeFaceName Attribute
SelectedTypeSize Attribute
Separation Attribute
ShadowColor Attribute
TabBgColor Attribute
TabFieldArray Attribute
TabGap Attribute
TabJustification Attribute
TabShape Attribute
How to Implement Bitmapped Tabs
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
XMargin Attribute
YMargin Attribute
TabField Class
HasBitmap Attribute
HasTextLabel Attribute
NormalBitmap Attribute
SelectedBitmap Attribute
TextLabel Attribute
TabFolder Class
CurPageIndex Attribute
CurTabPage Attribute
IsShadowed Attribute
PrevPageIndex Attribute
TabBar Attribute
TabPageArray Attribute
TargetPageIndex Attribute
AddTabPage Method
DeleteTabPage Method
TableField Class
_RowSelected Attribute
ActiveRow Attribute
AlwaysHighlighted Attribute
ColSeparatorColor Attribute
ColSeparatorStyle Attribute
ColSeparatorWidth Attribute
ColumnResizable Attribute
ColumnsDisplayed Attribute
ControlButton Attribute
CurOps Attribute
CurRow Attribute
Drag_Row Attribute
Drop_Row Attribute
ExactHeight Attribute
ExactWidth Attribute
HasHeader Attribute
HasHeaderButtons Attribute
HasHorizontalScrollBar Attribute
HasScrollBar Attribute
IsHighlighted Attribute
NumVisibleRows Attribute
Orientation Attribute
QueryOps Attribute
ReadOps Attribute
RowSeparatorColor Attribute
RowSeparatorStyle Attribute
RowSeparatorWidth Attribute
ScrollingChangesSelection Attribute
SelectionType Attribute
TableBody Attribute
TableHeader Attribute
TargetRow Attribute
Title Attribute
TitleTrim Attribute
TopRow Attribute
UpdateOps Attribute
User1Ops Attribute
User2Ops Attribute
User3Ops Attribute
CopyToClipboard Method
DeleteColumn Method
InsertColumn Method
SetInputFocus Method
WhichRow Method
TabPage Class
DelayMkwidget Attribute
TabField Attribute
TagDefinition Class
AppliesTo Attribute
DefaultValue Attribute
Description Attribute
Multiplicity Attribute
Name Attribute
NewValuesAllowed Attribute
TagType Attribute
TagValues Attribute
TaggedValue Class
Availability Attribute
Name Attribute
Value Attribute
ToggleField Class
HasImageAndText Attribute
HasIndicator Attribute
OffBitmapLabel Attribute
OnBitmapLabel Attribute
OffTextLabel Attribute
OnTextLabel Attribute
Tree Class
CheckedNodes Attribute
Nodes Attribute
RootNode Attribute
AddNode Method
CopyNode Method
DeleteNode Method
MoveNode Method
NextNode Method
NodeByKey Method
NodeByName Method
SetBranchChecked Method
Sort Method
StartTraverse Method
StopTraverse Method
TreeNode Class
BgColor Attribute
BitmapLabelIndex Attribute
Children Attribute
Descendants Attribute
DragCopyCursor Attribute
DragMoveCursor Attribute
DropCursor Attribute
ExpandedBitmapLabelIndex Attribute
FgColor Attribute
FirstChild Attribute
HasChildren Attribute
Height Attribute
IsBold Attribute
IsChecked Attribute
IsDragNode Attribute
IsDropNode Attribute
IsExpanded Attribute
IsHidden Attribute
IsItalic Attribute
IsPlain Attribute
IsSelected Attribute
IsUnderlined Attribute
IsVisible Attribute
KeyLabel Attribute
LastChild Attribute
Level Attribute
NextSibling Attribute
ParentNode Attribute
PrevSibling Attribute
SelBgColor Attribute
SelectedBitmapLabelIndex Attribute
SelFgColor Attribute
SelIsBold Attribute
SelNoFocusBgColor Attribute
SelNoFocusFgColor Attribute
TextLabel Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
Width Attribute
XLeft Attribute
YTop Attribute
TreeviewField Class
AllowLabelEdit Attribute
CurNode Attribute
DragCopyCursor Attribute
DragMoveCursor Attribute
DropCursor Attribute
ExactNodeHeight Attribute
FullRowSelect Attribute
HasButtons Attribute
HasCheckboxes Attribute
HasHorizontalScrollBar Attribute
HasLines Attribute
HasRootLine Attribute
HasScrollBar Attribute
ImageList Attribute
Indent Attribute
IsBold Attribute
IsItalic Attribute
IsPlain Attribute
IsUnderlined Attribute
NodeHeight Attribute
RightClickBehavior Attribute
SelBgColor Attribute
SelFgColor Attribute
SelIsBold Attribute
SelNoFocusBgColor Attribute
SelNoFocusFgColor Attribute
ShowSelection Attribute
Style Attribute
TopNode Attribute
Tree Attribute
TreeHeight Attribute
TreeWidth Attribute
TriggerNode Attribute
TypeFace Attribute
TypeFaceName Attribute
TypeSize Attribute
EditLabel Method
ExpandAll Method
UserClassObject Class
UserObject Class
ValueDefinition Class
Description Attribute
Definition Attribute
Keyword Attribute
Label Attribute
Type Attribute
ViewportField Class
ClipHeight Attribute
ClipWidth Attribute
ScrollBarWidth Attribute
XOffset Attribute
YOffset Attribute
XMLAttribute Class
ClientInteger Attribute
ClientText Attribute
Name Attribute
Value Attribute
XMLCDATA Class
Value Attribute
XMLComment Class
Value Attribute
XMLDocument Class
ErrorText Attribute
ParsedXMLEncoding Attribute
ParsedXMLStandalone Attribute
ParsedXMLVersion Attribute
ParserCallbacks Attribute
RootElement Attribute
AbortWrite Method
IsValidXMLName Method
ParseString Method
ParseURL Method
WriteCDATA Method
WriteComment Method
WriteElement Method
WriteEndDocument Method
WriteEndElement Method
WriteProcessingInstruction Method
WriteStartDocument Method
WriteStartElement Method
WriteTextData Method
WriteToFile Method
XMLElement Class
Attributes Attribute
Children Attribute
Name Attribute
AddAttribute Method
AddChild Method
AddChildElement Method
GetAttributeValue Method
GetCharacterValue Method
GetChildElementCharacterValue Method
RemoveAttribute Method
RemoveChild Method
SetAttributeValue Method
XMLNode Class
ClientInteger Attribute
ClientText Attribute
ParentElement Attribute
XMLParserCallbacks Class
CurDocument Attribute
CurElement Attribute
EndDocumentHandler Attribute
EndElementHandler Attribute
ParseReturnValue Attribute
StartDocumentHandler Attribute
StartElementHandler Attribute
XMLPI Class
Target Attribute
Value Attribute
XMLSchemaCache Class
AddSchema Method
RemoveSchema Method
XMLText Class
Value Attribute
5. Events
BufferChanged Event
ChildBufferChanged Event
ChildClick Event
Event Block Execution
ChildClickPoint Event
ChildCollapsed Event
ChildDetails Event
ChildDoubleClick Event
ChildDragBox Event
ChildDragDrop Event
ChildDragLeave Event
ChildDragOver Event
ChildDragSegment Event
ChildEntry Event
ChildExit Event
ChildExpanded Event
ChildHeaderClick Event
ChildKeyDown Event
ChildKeyPress Event
ChildLabelChanged Event
ChildMouseDown Event
ChildMouseEnter Event
ChildMouseEnterNode Event
ChildMouseExit Event
ChildMouseExitNode Event
ChildMouseUp Event
ChildMoved Event
ChildPageActivated Event
ChildPageChanged Event
ChildPageDeactivated Event
ChildProperties Event
ChildResized Event
ChildScroll Event
ChildSelect Event
ChildSelectionChanged Event
ChildSeparatorMove Event
ChildSetValue Event
ChildSliderMove Event
ChildUnSelect Event
ChildValidate Event
Click Event
ClickPoint Event
Collapsed Event
DBEvent Event
Details Event
DoubleClick Event
DragBox Event
DragDrop Event
DragLeave Event
DragOver Event
DragSegment Event
Entry Event
Exit Event
Expanded Event
ExtClassEvent Event
FrameActivate Event
FrameDeactivate Event
HeaderClick Event
InsertRow Event
KeyDown Event
KeyPress Event
LabelChanged Event
MouseDown Event
MouseEnter Event
MouseEnterNode Event
MouseExit Event
MouseExitNode Event
MouseUp Event
Moved Event
PageActivated Event
PageChanged Event
PageDeactivated Event
Properties Event
Resized Event
Scroll Event
Select Event
SelectionChanged Event
SeparatorMove Event
SetValue Event
SliderMove Event
Terminate Event
UnSelect Event
UserEvent Event
Validate Event
WindowClose Event
WindowIcon Event
WindowMoved Event
WindowResized Event
WindowVisible Event
Events Table
6. Functions
Overview
Core Library Functions
AssignJsonRpcResponse2Vars Function
GetRGB Function
RGB Function
StdList Function
ToString Function
Finance Library Functions
CTERM Function
DDB Function
DEPR Function
FV Function
FVC Function
IPER Function
IPMT Function
IRATE Function
NPER Function
PC Function
PMT Function
PPMT Function
PV Function
SLN Function
SYD Function
Stat Library Functions
AVERAGE Function
LSQ Function
MAXIMUM Function
MEDIAN Function
MINIMUM Function
MODAL Function
STD Function
STDS Function
VAR Function
VARS Function
7. Preprocessing Your 4GL Code
Overview
Preprocessor
Include Scripts
The #include Statement
General Preprocessor Statement Rules
Comments in Preprocessor Statements
User-defined Macro Variables
Built-in Macro Variables
The #define Statement
Guidelines for Using the #define Statement
The #undef Statement
The #if - #endif Statement
Guidelines for Using the #if – #endif Statement
The #ifdef – #endif Statement
The #ifndef - #endif Statement
Error Processing
Example--Error Processing
A. System Constants and Keywords
Introduction
System Constants
Property Setting Prefixes
AnchorPoint Settings
Settings
BgDisplayPolicy Settings
Bitmap Display Behavior Settings for ButtonFields, ImageFields, and PaletteFields
Bitmap File Formats for BitmapObject
Bitmap Settings for BitmapObject
Button Style Settings for ButtonStyle
Boolean Settings
Character Codes for Printable Characters
Character Codes for Non-printable Characters
CollapsePolicy Settings for MatrixFields
Color Settings for Standard Palette
Color Settings for System Default Palette
Color Settings for OpenROAD Default Palette
Corner Settings
Cursor State Settings for CursorObject
DataEntryErrorHandler Return Codes
Database Session State Settings for DBSessionObject
DatatypeCode Settings
DBMSMessagePrinting and DBMSErrorPrinting Settings for SessionObject
DBMS Server Types for DBSessionObject
DefaultValue Settings
Display Capabilities Settings for SessionObject
DisplayPolicy Settings for ImageFields
Element Type Settings for BitmapObject
EmptyValueComparison Settings
Encoding Format
Enumerated Values for ChoiceList
Error Codes
Exit Behavior Settings for EntryFields
Export Format Settings for AppSource and CompSource
Field Alignment Settings for MatrixFields and StackFields
Field Bias Settings
FileEncoding Settings
FocusBehavior Settings for ActiveField, ControlButton, and MenuItem
Force Case Settings for EntryFields
Frame Modes
GrowFrom Settings for BarFields and BitmapObjects
Help Commands for SessionObject WinHelp Method
Input Event Settings
Justification Settings
Key State Settings
Line Style Settings
Line Width Settings
ListviewField Styles
Menu Biases
Message Error Codes for Event
Message Type Settings for Pop-ups
MouseButton Settings
Operating System Settings for SessionObject
OptionField Settings
Orientation Settings for TableField, StackField, SliderField, ScrollbarField, RadioField, and PaletteField
OutlineStyle Settings
Pattern Settings
Pop-up Reply Codes
PortletBlocking Settings
Position Settings
Query Modes
Query States
ReasonCode Settings for FrameExec
For the Click, ChildClick, Details, ChildDetails, ClickPoint, ChildClickPoint, Properties, ChildProperties, DoubleClick, and ChildDoubleClick Events
For the Exit, ChildExit, SetValue, ChildSetValue, Entry, ChildEntry, Validate, and ChildValidate Events
For the ChildMouseDown, MouseDown, ChildMouseUp, and MouseUp Events
For the DragSegment, ChildDragSegment, DragBox, ChildDragBox, Resized, ChildResized, Moved, and ChildMoved Events
For Select and ChildSelect Events
For UnSelect and ChildUnSelect Events
For the SelectionChanged Event
For the DeleteAllRow, InsertRow, DeleteRow, WindowClosed, WindowIcon, WindowMoved, WindowResized, and WindowVisible Events
Other Reason Codes Unassociated with any Particular Event
Relative Parameter Values for TreeNodes
RemoteServer Settings
Response Settings
RightClickBehavior Settings
RowState Settings
Runtime Settings
Selection Types
Separator Move Settings
SizeToFit Settings
SliderField Style Settings
SpeedKey Settings
System Defined Cursors Settings
TabBar Settings
TableField Operations Settings
Tagged Value Access Settings
Tagged Value Settings
Text Alignment Settings for ButtonFields and PopUpButtons
Text Display Behavior Settings for ButtonFields
Traverse Order
TreeviewField Settings
Typeface Settings
UseWidestCharacter Settings
Window Placement Settings
Window System Settings for SessionObject
Window Visibility Settings for FrameExec
XML Encoding Settings for XMLDocument
4GL Keywords
B. Dedicated User Classes for .INI File Support
Introduction
ProfileObject User Class
Contents Attribute
IniContent Attribute
Modified Attribute
GetLine Method
GetProfileVarchar Method
GetString Method
ReadProfile Method
SetProfileVarchar Method
SetString Method
WriteProfile Method
SectionObject User Class
Entries Attribute
Section Attribute
GetString Method
SetString Method
EntryObject User Class
Entry Attribute
Keyword Attribute
GetString Method
SetString Method
How You Can Use the INI File Facility
C. Generated User Classes
Introduction
_PictureField User Class
Bitmap Attribute
Handle Attribute
DeleteFromDB Method
InsertIntoDB Method
SetBitmapNull Method
SetDBHandle Method
SetDBHandles Method
SetFileHandle Method
SetFileHandles Method
_StringField User Class
DataChanged Attribute
Handle Attribute
String Attribute
DeleteFromDB Method
SetDBHandle Method
SetFileHandle Method
UpdateDB Method
UpdateFile Method
Calendar_Object User Class
DateValue Attribute
DefaultValue Attribute
Month Attribute
Month_Dwn Attribute
Month_Up Attribute
ScreenField Attribute
Year Attribute
Year_Dwn Attribute
Year_Up Attribute
UpdField Method
UserSetValue Method
Edit_Object User Class
OnEditCopy Method
OnEditCut Method
OnEditPaste Method
OnFileClose Method
OnFileNew Method
OnFileOpen Method
OnFileSave Method
OnFileSaveAs Method
Setup Method
Font_Object User Class
SetFont Method
Setup Method
TrackField Method
Indicator_Manager User Class
CurrentValue Attribute
DisplayForm Attribute
DivisionIndex Attribute
MaxValue Attribute
MetricType Attribute
MinValue Attribute
MoveDir Attribute
QuadHump Attribute
TheBox Attribute
InitDataForm Method
InitPhysicalForm Method
UpdateGaugeValue Method
Query_Control User Class
CloseQuery Method
FindRow Method
FirstRow Method
HandleSelect Method
LastRow Method
NextRow Method
OpenQuery Method
PrevRow Method
Setup Method
Spin_Object User Class
Display Attribute
Increment Attribute
Maximum Attribute
Minimum Attribute
Wrap Attribute
GetValue Method
HandleDn Method
HandleUp Method
Setup Method
SetValue Method
UpdField Method
Timer_Manager User Class
DisplayForm Attribute
pIconAlarm Attribute
pTimeDisplayBox Attribute
StartUp Method
UpdateTime Method
ValueDefinitionProxy User Class
ListTextValues Method
MapDefinition Method
D. Virtual Key Values
Language Reference Guide
D. Virtual Key Values
This site works best with JavaScript enabled