Progress
ADM 2 Reference


newQueryString (combo.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 embedded in parenthesis.

Parameters:

INPUT pcColumns AS CHARACTER

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

INPUT pcValues AS CHARACTER

Chr(1)-separated list of corresponding values

INPUT pcDataTypes AS CHARACTER

Comma-separated list of corresponding data types

INPUT pcOperators AS CHARACTER

Comma-separated list of corresponding operators. If blank, the operator is EQ for all columns. Alternative string operators can be separated with a slash, for example: EQ/BEGINS.

INPUT pcQueryString AS CHARACTER

A complete query string. This must be qualified correctly and match the queried tables. If "?", the base query is presumed.

INPUT pcAndOr AS CHARACTER

The operator that defines how the new clause is appended, for each buffer, to the query in pcQueryString. Valid values are "AND" and "OR".

Returns: CHARACTER

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


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