Consultingwerk.OERA.Query.DSQueryStringProcedural

Namespace:

Consultingwerk.OERA.Query

Class

DSQueryStringProcedural

Parent classes:

Progress.Lang.Object

Consultingwerk.OERA.Query.QueryString

Consultingwerk.OERA.Query.DSQueryStringProcedural

Inherits:

Consultingwerk.OERA.Query.QueryString

Implements:

Consultingwerk.OERA.IDSQueryString, Consultingwerk.OERA.Query.IQueryMap, Consultingwerk.OERA.Query.IThrowsErrorsOnInvalidSourceMapping

USE-WIDGET-POOL

File:	DSQueryStringProcedural
Purpose:	Extends QueryString to provide query transformation
	for non OO utility procedure that manages multiple
	datasources as 4GL handles
Author(s):	Mike Fechner / Consultingwerk Ltd.
Created:	Wed Mar 03 08:24:02 CET 2010
Notes:	This is the version for the depricated procedural OERA
	backend code

Top Method Summary

Options	Name	Purpose
+	AddQueryWhere (character, character, character)	Inserts a new expression to query's prepare string for a specified buffer. Inherited from Consultingwerk.OERA.Query.QueryString
+	CHARACTER BuildQueryString (handle)	Builds the QueryString for the Query Inherited from Consultingwerk.OERA.Query.QueryString
+	CHARACTER CheckIndex (handle)	Returns the Index information of the query used for a buffer Inherited from Consultingwerk.OERA.Query.QueryString
#	ClearQuery ()	Clears the internal state to allow parsing another query string Inherited from Consultingwerk.OERA.Query.QueryString
+	CHARACTER ColumnSource (character)	Returns the name of the column from the source (database) column
+	Debug ()	Displays debug-information Inherited from Consultingwerk.OERA.Query.QueryString
+	CHARACTER DefaultQuery ()	Returns the default query string for the data source
#	CHARACTER EscapeKnownFunction (character)	Escapes the brackets around known ABL functions in the query string Inherited from Consultingwerk.OERA.Query.QueryString
+	LOGICAL InsertToQuery (handle)	Insert the QueryString into the query Inherited from Consultingwerk.OERA.Query.QueryString
#	ParseListQueryExpression (ListQueryExpression, integer, integer)	Parses a ListQueryExpression instance Inherited from Consultingwerk.OERA.Query.QueryString
#	ParseQuery (character)	Parses the logical buffer's target query and stores it for transformation to the datasource query. Inherited from Consultingwerk.OERA.Query.QueryString
#	ParseQuery (IQueryExpression, ListSortField)	Parses the logical buffer's target query and stores it for transformation to the datasource query. Inherited from Consultingwerk.OERA.Query.QueryString
#	ParseSortExpression (character)	Parses the Sort Expression Inherited from Consultingwerk.OERA.Query.QueryString

Top Constructor Summary

	Options	Name	Purpose
	+	DSQueryStringProcedural (character, handle, character)	Constructor for the DSQueryStringProcedural class
	+	DSQueryStringProcedural (character, handle, character, logical)	Constructor for the DSQueryStringProcedural class

Top Property Summary

	Options	Name	Purpose
	+	LOGICAL FilterUsingInnerJoin	Inherited from Consultingwerk.OERA.Query.QueryString
	+	LOGICAL ThrowErrorsOnInvalidSourceMapping	Inherited from Consultingwerk.OERA.Query.QueryString

Method Detail

Top

PUBLIC AddQueryWhere (character, character, character)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Inserts a new expression to query's prepare string for a
	specified buffer.
Notes:

Parameters:
pcBuffer	CHARACTER
	The name of the Buffer
pcExpression	CHARACTER
	The new expression
pcAndOr	CHARACTER
	Specifies what operator is used to add the new expression to existing expression(s), AND (default) / OR

Top

PUBLIC CHARACTER BuildQueryString (handle)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Builds the QueryString for the Query
Notes:

Parameters:
phQuery	HANDLE
	The HANDLE of the QUERY widget
Returns	CHARACTER
	The Query String

Top

PUBLIC CHARACTER CheckIndex (handle)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Returns the Index information of the query used for a buffer
Notes:	For debugging/logging purposes only

Parameters:
phBuffer	HANDLE
	The handle to the buffer to return index information for
Returns	CHARACTER
	The index information of the query used for the buffer handle

Top

PROTECTED ClearQuery ()

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Clears the internal state to allow parsing another query string
Notes:

Top

PUBLIC CHARACTER ColumnSource (character)

Purpose:	Returns the name of the column from the source (database) column
Notes:	Invokes the sourceColumn function in the data access object

Parameters:
pcColumn	CHARACTER
	The name of the temp-table column
Returns	CHARACTER
	The name of the source (database) column

Top

PUBLIC Debug ()

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Displays debug-information
Notes:

Top

PUBLIC CHARACTER DefaultQuery ()

Purpose:	Returns the default query string for the data source
Notes:	Invokes SourceDefaultQuery function in the data access object

Returns	CHARACTER
	The default query string

Top

PROTECTED CHARACTER EscapeKnownFunction (character)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Escapes the brackets around known ABL functions in the query string
Notes:	SCL-1201, workaround for parsing issues with RECID() or ROWID()
	function used in the query string

Parameters:
pcQueryString	CHARACTER
	The Query String to escape
Returns	CHARACTER
	The query string with the escaped brackets

Top

PUBLIC LOGICAL InsertToQuery (handle)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Insert the QueryString into the query
Notes:	Actually performs QUERY-PREPARE on the Query-Handle

Parameters:
phQuery	HANDLE
	The HANDLE of the QUERY widget
Returns	LOGICAL
	True if successful

Top

PROTECTED ParseListQueryExpression (ListQueryExpression, integer, integer)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Parses a ListQueryExpression instance
Notes:	See main comments

Parameters:
poQuery	Consultingwerk.ListQueryExpression
	The ListQueryExpression to parse
piExpressionCount	INTEGER
	The count of expressions in the query expression
piParenthesesCount	INTEGER
	The count of parentheses in the query expression

Top

PROTECTED ParseQuery (character)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Parses the logical buffer's target query and stores it for
	transformation to the datasource query.
Notes:	See main comments

Parameters:
pcQuery	CHARACTER
	The QueryString to parse

Top

PROTECTED ParseQuery (IQueryExpression, ListSortField)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Parses the logical buffer's target query and stores it for
	transformation to the datasource query.
Notes:	See main comments

Parameters:
poQueryExpression	Consultingwerk.IQueryExpression
	The QueryExpression to parse
poQuerySort	Consultingwerk.ListSortField
	The ListSortField for the query

Top

PROTECTED ParseSortExpression (character)

Inherited from Consultingwerk.OERA.Query.QueryString

Purpose:	Parses the Sort Expression
Notes:

Parameters:
pcSort	CHARACTER
	The sort expression to parse

Constructor Detail

Top

PUBLIC DSQueryStringProcedural (character, handle, character)

Purpose:	Constructor for the DSQueryStringProcedural class
Notes:

Parameters:
pcQueryString	CHARACTER
	The query string from the current read request
phProcedure	HANDLE
	The handle of the owning data access object procedure (for call backs)
pcTable	CHARACTER
	The name of the temp-table this DSQueryStringProcedural instance is providing source query manipulation for

Top

PUBLIC DSQueryStringProcedural (character, handle, character, logical)

Purpose:	Constructor for the DSQueryStringProcedural class
Notes:

Parameters:
pcQueryString	CHARACTER
	The query string from the current read request
phProcedure	HANDLE
	The handle of the owning data access object procedure (for call backs)
pcTable	CHARACTER
	The name of the temp-table this DSQueryStringProcedural instance is providing source query manipulation for
plFilterUsingInnerJoin	LOGICAL
	The value for the FilterUsingInnerJoin property

Property Detail

Top

PUBLIC LOGICAL FilterUsingInnerJoin

Inherited from Consultingwerk.OERA.Query.QueryString

Returns	LOGICAL

Top

PUBLIC LOGICAL ThrowErrorsOnInvalidSourceMapping

Inherited from Consultingwerk.OERA.Query.QueryString

Returns	LOGICAL

info@consultingwerk.de http://www.consultingwerk.de 08.12.2024 13:00:20