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.
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
Attachments
Old KB# 35264
#SupportTip
#EnterpriseAnalyzer