Namespace: OpenEdge.DataAdmin.DataAccess
Type: 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