Progress
ADM 2 Reference
newQueryString (query.p)
Returns a new query string to the passed query. The tables in the passed query must match getTables(). Adds column/value pairs to the corresponding buffer’s WHERE clause. Each buffer’s expression will always be embedded in parentheses.
Parameters:INPUT pcColumns AS CHARACTER
Comma-separated column names of a table in the query in the form of TBL.FLDNM or DB.TBL.FLDNM. RowObject.FLDNM should be used for SDOs. If the fieldname is not qualified, it checks the tables in the TABLES property and assumes the first with a match.
INPUT pcValues AS CHARACTER
Corresponding values (CHR(1)-separated).
INPUT pcOperators AS CHARACTER
Operator for all columns. Blank defaults to EQ. Use a slash to define an alternative string operator. Comma-separated for each column/value.
INPUT pcQueryString AS CHARACTER
A qualified query string matching the queries tables.
INPUT pcAndOr AS CHARACTER
AND or OR decides how the new expression is appended to the passed query (for each buffer).
Returns: CHARACTERNotes: None
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |