Release 10.1A: OpenEdge Development:
ADM Reference

> ## updateAddQueryWhere

> Procedure restores a query to design-time state, re-adds the filters, then adds and saves the new WHERE clause.

> Location: data.p

> Parameters:

> `INPUT pcWhere AS CHARACTER`

> New WHERE clause.

> `INPUT pcField AS CHARACTER`

> Field to search and replace.

> Notes:

> - Ensures WHERE clause added is not cleared by filters, and is not duplicated in saved manualaddquerywhere. Where clause must be in correct format for an addquerywhere. If WHERE clause is blank but the field is passed in, then manual queries for that field are removed and default back to all.

> - Only supports adding a single where clause, but may be called many times. Used when putting a manual filter viewer above a browser.

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