Download Entire Document
Introduction
ELS-QB GUI
Integrated Query Builder GUI
Connections pane
Opening a Connection
Main Toolbar
Relations and other panes
Columns pane
SQL pane
Creating a Database Connection
Data Browser
Creating and Saving a Query
Defining Relations and Joins
Selecting Fields and Defining Criteria
Using SQL functions
SQL Functions Reference
Concatenation To String
Masking Concatenated Fields
Aggregate functions
String functions
Numeric functions
Date Part functions
Date Name functions
Conversion To Char
Conversion To Number
Conversion To Date
Null Case function
Simple Case function
Defining SQL Manually
Running Query and the Result tab
Export and Printing
Storage and File Processing Support
Transferring Data Between Connections
Visual C++ Programmer's Reference
Methods
GetConnectionName
SetConnectionName
NewDBConnection
OpenDBConnection
GetConnection
SetConnection
OpenConnection
CloseConnection
SaveConnection
RemoveConnection
GetQueryName
SetQueryName
NewQuery
SaveQuery
GetSQLText
SetQueryText
OpenQuery
CloseQuery
OpenSelectedQuery
RemoveQuery
ShowQueryFilename
CheckSQLSyntax
ShowToolButton
ShowPane
SetStoragePath
GetStoragePath
IsPaneVisible
UpdatePane
SetFontType
DoCommand
QueryStatus
GetModified
CanExecute
Execute
Stop
IsRunning
SetMessageBoxTitle
ConnectionEdit
GetDetailMItem
CancelExecute
Import
GetRecordsetObj
GetConnectionObj
SetQueryTimeout
GetQueryTimeout
ShowColumnsToolbar
GetRecCount
ShowRecCount
GetCharLinePos
GetCharColPos
GetQueryTitle
GetActiveTab
SetSQLEditiorFont
SetGridFont
GetQueryText
SetSQLText
DoPageSetup
Doldle
SetResultEditMode
GetResultEditMode
SetRegistryKey
GetOverStrike
GenerateHTMLString
SetDBConnection
GetDBConnection
Events
PreExecute
PostExecute
Constants
Command IDs
Pane IDs
ToolbarButton IDs
Visual Basic Programmer's Reference
Methods
GetConnectionName
SetConnectionName
NewDBConnection
OpenDBConnection
GetConnection
SetConnection
OpenConnection
CloseConnection
SaveConnection
RemoveConnection
GetQueryName
SetQueryName
NewQuery
SaveQuery
GetSQLText
SetQueryText
OpenQuery
CloseQuery
OpenSelectedQuery
RemoveQuery
ShowQueryFilename
CheckSQLSyntax
ShowToolButton
ShowPane
SetStoragePath
GetStoragePath
IsPaneVisible
UpdatePane
SetFontType
DoCommand
QueryStatus
GetModified
CanExecute
Execute
Stop
IsRunning
SetMessageBoxTitle
ConnectionEdit
GetDetailMItem
CancelExecute
Import
GetRecordsetObj
GetConnectionObj
SetQueryTimeout
GetQueryTimeout
ShowColumnsToolbar
GetRecCount
ShowRecCount
GetCharLinePos
GetCharColPos
GetQueryTitle
GetActiveTab
SetSQLEditiorFont
SetGridFont
GetQueryText
SetSQLText
DoPageSetup
Doldle
SetResultEditMode
GetResultEditMode
SetRegistryKey
GetOverStrike
GenerateHTMLString
SetDBConnection
GetDBConnection
Events
PreExecute
PostExecute
Constants
EQBCommandType
EQBPane
EShowHidePanes
Technical Support