|
Options |
Name |
Purpose |
|
|
+
|
CHARACTER BufferWhereClause (character, character)
|
Returns the complete query where clause for a specified buffer
INCLUDING leading and trailing blanks.
EXCLUDING commas and period.
|
|
|
+
|
HANDLE CloneQuery (handle)
|
Clones the query by creating a query for additional buffers
for the query buffers
|
|
|
+
|
INTEGER ColumnsBufferIndex (character, handle)
|
Returns the Index of the Queries Buffer the column belongs to
|
|
|
+
|
INT64 CountResults (character)
|
Counts the results of the provided database Query String
|
|
|
+
|
INT64 CountResults (character, handle)
|
Counts the results of the provided Query String
|
|
|
+
|
INT64 CountResults (character, handle[])
|
Counts the results of the provided Query String
|
|
|
+
|
HANDLE CreatePreparedQuery (handle)
|
Creates, Prepares and Opens a new Query widget for the given
buffer handle. The Query will be positioned at the first result row
|
|
|
+
|
HANDLE CreatePreparedQuery (handle, character)
|
Creates, Prepares and Opens a new Query widget for the given
buffer handle. The Query will be positioned at the first result row
|
|
|
+
|
DeleteQueryAndBuffers (handle)
|
Deletes the Qeury and the buffer handles
|
|
|
+
|
ExecuteQuery (character, character, integer, table-handle)
|
Executes a database query and returns a temp-table with the results
|
|
|
+
|
ROWID GetCurrentRowids (handle)
|
Returns a ROWID Array containing the rowids of the current
Query result row.
|
|
|
+
|
GetCurrentRowids (handle, rowid[])
|
Returns a ROWID Array containing the rowids of the current
Query result row.
|
|
|
+
|
HANDLE GetQueryFieldHandle (handle, character)
|
Returns the handle of a field from a queries buffer
|
|
|
+
|
CHARACTER InsertExpression (character, character, AndOrEnum)
|
Inserts an expression into ONE buffer's where-clause.
|
|
|
+
|
CHARACTER InsertExpression (character, character, character)
|
Inserts an expression into ONE buffer's where-clause.
|
|
|
+
|
CHARACTER InsertExpressionForBuffer (character, character, character)
|
Inserts an expression into ONE buffer's where-clause.
|
|
|
+
|
InsertIntoOrder (handle, character, character, integer)
|
Inserts a free slot into a sequence of ordered records (e.g.
OrderLine.LineNum). I.o.w. prepares a lists of records to insert
a new record at the desired position
|
|
|
-
|
CHARACTER InsertString (character, character, integer, integer)
|
Inserts a String into and existing string
|
|
|
+
|
INTEGER NumberOfRowids (rowid[])
|
Returns the number of rowids assigned in a ROWID[]
|
|
|
+
|
OpenNonMatchingQuery (handle)
|
Open a query that returns no records
|
|
|
+
|
PrepareQueryInReserveOrder (handle)
|
Prepares a Query in reverse sort order
|
|
|
+
|
PrepareQueryInReverseOrder (handle)
|
Prepares a Query in reverse sort order
|
|
|
+
|
CHARACTER QualifiedColumnName (character, handle)
|
Returns the column name qualified with the first table name
of the Queries buffers that contains the field name
|
|
|
+
|
CHARACTER QueryBufferNames (character)
|
Returns a comma delimited list of the Buffer Names in the Query String
|
|
|
+
|
CHARACTER QueryBufferNames (handle)
|
Returns a comma delimited list of the Buffer Names in the Query
|
|
|
+
|
CHARACTER QueryLargeColumns (handle)
|
Returns the large columns of the buffers from the given query handle
|
|
|
+
|
Consultingwerk.ListSortField QuerySortList (character)
|
Returns the list of SortField instances for the given query string
|
|
|
+
|
CHARACTER QuerySortPhrase (character)
|
Returns the sort phrase of the given query string
|
|
|
+
|
CHARACTER QueryStringEntries (character)
|
Returns an array with the entries of a query string, uses "," as the
delimiter, but does not consider comma's in quotes or brackets
|
|
|
+
|
CHARACTER ReplaceBufferNameInQuery (character, character[], character)
|
Renames any buffers from their defined form to use an alternate buffer name
|
|
|
+
|
CHARACTER ReplaceLockMode (character, LockModeEnum)
|
Replaces the existing lock mode with the input.
|
|
|
+
|
LOGICAL RepositionToRowidArray (handle, rowid[])
|
Moves a query objects result list pointer to the row corresponding
to the specified ROWID or ROWIDs. To reposition to a particular row
when the query is a join, supply the ROWIDs of the buffers that
correspond to the desired row.
|
|
|
+
|
CHARACTER ResolveOfRelation (handle, handle)
|
Resolves the OF relation between two buffer handles by returning the
WHERE clause (including WHERE) for the join between the two tables
|
|
|
+
|
CHARACTER SetQuerySort (character, character)
|
Sets or replaces the sort string (BY phrase) in the provided query
string
|
|
|
+
|
CHARACTER SetUseIndex (character, character)
|
Inserts a USE-INDEX option into a query string. Defaults to using
the first buffer criteria for adding the query string
|
|
|
+
|
CHARACTER SetUseIndex (character, integer, character)
|
Inserts a USE-INDEX option into a query string
|
|
|
+
|
ValidateQuery (character, character)
|
Validates a query string and returns an error when the
query string cannot be prepareed
|
|
|
+
|
ValidateQuery (character, character, character)
|
Validates a query string and returns an error when the
query string cannot be prepareed
|
|
|
+
|
CHARACTER WhereClauseBuffer (character)
|
Returns the buffername of a where clause expression.
|
