Created On:  25 November 2011

Problem:

The requirement is to find ANY SQL statements with a WHERE clause containing a specific first predicate field name.  How can this be done in HyperView - Clipper?

Resolution:

Within the HyperView, the lowest level of any SQL STATEMENT, will contain an SQL CLAUSE - WHERE.

Within the properties of the SQL CLAUSE - WHERE, the TEXT entity contains the first predicate comparison, for eample   EN_N = :WS-EN-N

The attached query is written to find the first pridicate field name of EN_N and is defined as "EN_N*" in the query

This can be amended as required.

The Attached XML file can be imported directly into clipper for use.
Incident #2541142