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:



Method Summary
  Options Name Purpose
  CHARACTER ColumnValue (character)
  CreateQuery ()
  CHARACTER CurrentQuery ()
  CHARACTER DefaultQuery ()
  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)

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 ()

Returns CHARACTER
 
Top

CHARACTER DefaultQuery ()

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)

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