Namespace: OpenEdge.DataAdmin.DataAccess
Class
DBQuery
Parent classes:
Progress.Lang.Object
OpenEdge.DataAdmin.DataAccess.DBQuery

Inherits: Progress.Lang.Object

/* Copyright (c) 2011 by progress Software Corporation.
/*
/* all rights reserved. no part of this program or document
/* may be reproduced in any form or by any means without
/* permission in writing from progress Software Corporation.
Purpose: Base Query
Parameters: pcTables - Buffer names.
pcPhysicalTables - Physical names.
Notes:
/* Pretend properties (must be controlled)




Method Summary
Options Name Purpose
CHARACTER ColumnValue (character)
CreateQuery ()
CHARACTER CurrentQuery () Return the current query for query manipulation and prepare. returns the default if not yet prepared. ------------------------------------------------------------------------------*/
CHARACTER DefaultQuery () Return the BaseQuery or build a default query. ------------------------------------------------------------------------------*/
CHARACTER GetCurrentRowKey ()
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 */
LOGICAL Prepare ()
LOGICAL ResetQuery ()
LOGICAL SetPosition (character)
LOGICAL SetPosition (character[]) /* set position as returned from GetPosition */
LOGICAL SetPosition (rowid[]) /* set position as returned from GetPosition */

Constructor Summary
Options Name Purpose
DBQuery (character, character)
DBQuery (character, character, character) /* We operate on Tables, but have it as optional parameter ! */

Property Summary
Options Name Purpose
CHARACTER BaseQuery
CHARACTER KeyFields
CHARACTER PhysicalTables
HANDLE QueryHandle
CHARACTER Tables
LOGICAL UseRowid


Method Detail
Top

CHARACTER ColumnValue (character)
Parameters:
pcColumn CHARACTER
Returns CHARACTER
Top

CreateQuery ()
Top

CHARACTER CurrentQuery ()
Purpose: Return the current query for query manipulation and prepare.
returns the default if not yet prepared.
Returns CHARACTER
Top

CHARACTER DefaultQuery ()
Purpose: Return the BaseQuery or build a default query.
Returns CHARACTER
Top

CHARACTER GetCurrentRowKey ()
Returns CHARACTER
Top

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
Returns CHARACTER
Top

LOGICAL Prepare ()
Returns LOGICAL
Top

LOGICAL ResetQuery ()
Returns LOGICAL
Top

LOGICAL SetPosition (character)
Parameters:
pKeyWhere CHARACTER
Returns LOGICAL
Top

LOGICAL SetPosition (character[])
/* set position as returned from GetPosition
Parameters:
pcPosition CHARACTER
Returns LOGICAL
Top

LOGICAL SetPosition (rowid[])
/* set position as returned from GetPosition
Parameters:
prPosition ROWID
Returns LOGICAL


Constructor Detail
Top

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

DBQuery (character, character, character)
/* We operate on Tables, but have it as optional parameter !
Parameters:
pcPhysicalTables CHARACTER
pcTables CHARACTER
pcKeyFields CHARACTER


Property Detail
Top

CHARACTER BaseQuery
Returns CHARACTER
Top

CHARACTER KeyFields
Returns CHARACTER
Top

CHARACTER PhysicalTables
Returns CHARACTER
Top

HANDLE QueryHandle
Returns HANDLE
Top

CHARACTER Tables
Returns CHARACTER
Top

LOGICAL UseRowid
Returns LOGICAL


Copyright © 2022 Progress Software Corporation. All rights Reserved.

Progress® OpenEdge® Release 11.7.15