Progress
ADM 2 Reference


newQueryString (lookup.p)

Returns a new query string to the passed query. The tables in the passed query must match getQueryTables(). Adds column/value pairs to the corresponding buffer’s WHERE clause. Each buffer’s expression will always be enclosed in parentheses.

Parameters:

INPUT pcColumns AS CHARACTER

Comma-separated list of column names, of the form table.fieldname

INPUT pcValues AS CHARACTER

Comma-separated list of the corresponding values

INPUT pcDataTypes AS CHARACTER

Comma-separated list of the corresponding datatypes

INPUT pcOperators AS CHARACTER

Comma-separated list of operators. If a single operator, applies to all columns. If blank, defaults to EQ. Separate alternative string operators with a slash; example: "EQ/BEGINS"

INPUT pcQueryString AS CHARACTER

A complete, fully-qualified query string matching the queries tables. If "?", use the base query.

INPUT pcAndOr AS CHARACTER

How to relate the new expression to the existing query (for each buffer). Valid values are "AND" and "OR".

Returns: CHARACTER

Notes: This was taken from query.p but changed for lookups to work without an SDO.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095