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: CHARACTERNotes: 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 |