Namespace: OpenEdge.DataAdmin.DataSource
Class
DBQuery
Parent classes:
Progress.Lang.Object
OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
OpenEdge.DataAdmin.DataSource.DBQuery

Inherits: OpenEdge.DataAdmin.Binding.Query.DataAdminQuery

Purpose: DBQuery
Parameters: pcTables - Buffer names.
pcPhysicalTables - Physical names.
Notes:




Method Summary
Options Name Purpose
HANDLE CloneQuery (handle) /* We may clone this query in order to get row keys from a result without causing the 'real' query to reposition. This may be used when performing multi-select operations in the UI, where we don't want to move off the current record. Note that these actions may be expensive, because of the cost of creating, opening, etc the query. */
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER ColumnValue (character)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CreateQuery ()
Overrides OpenEdge.DataAdmin.Binding.Query.DataAdminQuery:CreateQuery ()
CHARACTER CurrentQuery () Return the current query for query manipulation and prepare. returns the default if not yet prepared. ------------------------------------------------------------------------------*/
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER DefaultQuery () Return the BaseQuery or build a default query. ------------------------------------------------------------------------------*/
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
DefineSource () /* hook for sub classes that uses empty constructor to postpone definitions The implementation must define Tables, PhysicalTables. BaseQuery or BaseQueryTemplate and BaseTableExpression should then typically also be defined here, since they need to match the tables/physicaltables. Undefined should be set to false since this may be checked in more than one place */
DeleteQuery () /* delete the handles */
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
HANDLE GetBufferHandles ()
Overrides OpenEdge.DataAdmin.Binding.Query.DataAdminQuery:GetBufferHandles ()
CHARACTER GetCurrentRowKey ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER GetPosition () /* order neutral position that is safe if tables changes order passed back to setPosition note that one need all rowids when the unique table is not the first */
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
LOGICAL Prepare ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
RemoveQueryBuffers (handle)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
LOGICAL ResetQuery ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
LOGICAL SetPosition (character)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
LOGICAL SetPosition (character[]) /* set position as returned from GetPosition */
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
LOGICAL SetPosition (rowid[]) /* set position as returned from GetPosition */
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
HANDLE SingleExtent (handle)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER TrimQuery (character) /* remove for or preselect from query - duplicated in DataAdminContext - belongs in utility */
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery

Constructor Summary
Options Name Purpose
DBQuery () /* empty constructor to allow definitions to be done later (Added to support requests for lazy one-to-one relations ) - requires override of defineSource that sets table, physicaltable and BaseQuery* property(ies) */
DBQuery (character) /* constructor to allow definitions to be done later (Added to support requests for lazy one-to-one relations ) - requires override of defineSource that sets table, physicaltable and BaseQuery* property(ies) */
DBQuery (character, character)
DBQuery (character, character, character)
DBQuery (character, character, character, handle) /* add temp source at end */
DBQuery (handle, character, character, character)

Property Summary
Options Name Purpose
CHARACTER BaseQuery
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER BaseQueryTemplate
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER BaseTableExpression
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER KeyFields
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER PhysicalTables
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
HANDLE QueryHandle
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER QueryLock
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER QueryMode
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER Table
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
CHARACTER Tables
Overrides OpenEdge.DataAdmin.Binding.Query.DataAdminQuery:Tables
HANDLE TempSourceBuffer
LOGICAL UseRowid
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery


Method Detail
Top

PROTECTED HANDLE CloneQuery (handle)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
/* We may clone this query in order to get row keys from a result without
causing the 'real' query to reposition. This may be used when performing
multi-select operations in the UI, where we don't want to move off the
current record. Note that these actions may be expensive, because of the
cost of creating, opening, etc the query.
Parameters:
phSource HANDLE
Returns HANDLE
Top

PUBLIC CHARACTER ColumnValue (character)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Parameters:
pcColumn CHARACTER
Returns CHARACTER
Top

PROTECTED CreateQuery ()
Overrides OpenEdge.DataAdmin.Binding.Query.DataAdminQuery:CreateQuery ()
Top

PROTECTED CHARACTER CurrentQuery ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Purpose: Return the current query for query manipulation and prepare.
returns the default if not yet prepared.
Returns CHARACTER
Top

PUBLIC CHARACTER DefaultQuery ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Purpose: Return the BaseQuery or build a default query.
Returns CHARACTER
Top

PROTECTED DefineSource ()
/* hook for sub classes that uses empty constructor to postpone definitions
The implementation must define Tables, PhysicalTables.
BaseQuery or BaseQueryTemplate and BaseTableExpression should then typically
also be defined here, since they need to match the tables/physicaltables.
Undefined should be set to false since this may be checked in more than
one place
Top

PROTECTED DeleteQuery ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
/* delete the handles
Top

PROTECTED HANDLE GetBufferHandles ()
Overrides OpenEdge.DataAdmin.Binding.Query.DataAdminQuery:GetBufferHandles ()
Returns HANDLE
Top

PUBLIC CHARACTER GetCurrentRowKey ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PUBLIC CHARACTER GetPosition ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
/* order neutral position that is safe if tables changes order
passed back to setPosition
note that one need all rowids when the unique table is not
the first
Returns CHARACTER
Top

PUBLIC LOGICAL Prepare ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns LOGICAL
Top

PROTECTED RemoveQueryBuffers (handle)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Parameters:
phQuery HANDLE
Top

PROTECTED LOGICAL ResetQuery ()
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns LOGICAL
Top

PUBLIC LOGICAL SetPosition (character)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Parameters:
pKeyWhere CHARACTER
Returns LOGICAL
Top

PUBLIC LOGICAL SetPosition (character[])
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
/* set position as returned from GetPosition
Parameters:
pcPosition CHARACTER
Returns LOGICAL
Top

PUBLIC LOGICAL SetPosition (rowid[])
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
/* set position as returned from GetPosition
Parameters:
prPosition ROWID
Returns LOGICAL
Top

PROTECTED HANDLE SingleExtent (handle)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Parameters:
ph HANDLE
Returns HANDLE
Top

PROTECTED CHARACTER TrimQuery (character)
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
/* remove for or preselect from query - duplicated in DataAdminContext - belongs in utility
Parameters:
pcQuery CHARACTER
Returns CHARACTER


Constructor Detail
Top

PUBLIC DBQuery ()
/* empty constructor to allow definitions to be done later
(Added to support requests for lazy one-to-one relations )
- requires override of defineSource that sets table, physicaltable
and BaseQuery* property(ies)
Top

PUBLIC DBQuery (character)
/* constructor to allow definitions to be done later
(Added to support requests for lazy one-to-one relations )
- requires override of defineSource that sets table, physicaltable
and BaseQuery* property(ies)
Parameters:
pcKeyFields CHARACTER
Top

PUBLIC DBQuery (character, character)
Parameters:
pcTables CHARACTER
pcKeyFields CHARACTER
Top

PUBLIC DBQuery (character, character, character)
Parameters:
pcTables CHARACTER
pcPhysicalTables CHARACTER
pcKeyFields CHARACTER
Top

PUBLIC DBQuery (character, character, character, handle)
/* add temp source at end
Parameters:
pcTables CHARACTER
pcPhysicalTables CHARACTER
pcKeyFields CHARACTER
phTempSource HANDLE
Top

PUBLIC DBQuery (handle, character, character, character)
Parameters:
phTempSource HANDLE
pcTables CHARACTER
pcPhysicalTables CHARACTER
pcKeyFields CHARACTER


Property Detail
Top

PUBLIC CHARACTER BaseQuery
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PROTECTED CHARACTER BaseQueryTemplate
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PROTECTED CHARACTER BaseTableExpression
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PUBLIC CHARACTER KeyFields
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PUBLIC CHARACTER PhysicalTables
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PROTECTED HANDLE QueryHandle
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns HANDLE
Top

PROTECTED CHARACTER QueryLock
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PROTECTED CHARACTER QueryMode
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PUBLIC CHARACTER Table
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns CHARACTER
Top

PUBLIC CHARACTER Tables
Overrides OpenEdge.DataAdmin.Binding.Query.DataAdminQuery:Tables
Returns CHARACTER
Top

PROTECTED HANDLE TempSourceBuffer
Returns HANDLE
Top

PUBLIC LOGICAL UseRowid
Inherited from OpenEdge.DataAdmin.Binding.Query.DataAdminQuery
Returns LOGICAL


Copyright © 2020 Progress Software Corporation. All rights Reserved.

Progress® OpenEdge® Release 12.2.0