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

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

PROTECTED CreateQuery ()
Top

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

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

PUBLIC CHARACTER GetCurrentRowKey ()
Returns CHARACTER
Top

PUBLIC 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

PROTECTED LOGICAL Prepare ()
Returns LOGICAL
Top

PROTECTED LOGICAL ResetQuery ()
Returns LOGICAL
Top

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

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

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


Constructor Detail
Top

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

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


Property Detail
Top

PUBLIC CHARACTER BaseQuery
Returns CHARACTER
Top

PUBLIC CHARACTER KeyFields
Returns CHARACTER
Top

PUBLIC CHARACTER PhysicalTables
Returns CHARACTER
Top

PROTECTED HANDLE QueryHandle
Returns HANDLE
Top

PUBLIC CHARACTER Tables
Returns CHARACTER
Top

PUBLIC LOGICAL UseRowid
Returns LOGICAL


Copyright © 2020 Progress Software Corporation. All rights Reserved.

Progress® OpenEdge® Release 12.2.0