Release 10.1A: OpenEdge Development:
ADM Reference

> ## newQueryString

> 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 is always enclosed in parentheses.

> Location: lookup.p

> 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 data type.

> `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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095