Kbase P14376: What does the QUERY PREPARE() method do? Can we query an em
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2003 |
|
Status: Unverified
GOAL:
What does the QUERY PREPARE() method do? Can we query an empty table?
FACT(s) (Environment):
Progress 9.x
FIX:
1. What does QUERY PREPARE() method do?
The QUERY-PREPARE() method compiles a query condition. It returns a logical value of TRUE if successful and FALSE otherwise. It applies to a Query Object Handle.
For additional information on this method, refer to the Progress Language Reference Manual. For sample code using this method, refer to the Progress Programming Handbook.
2. Can we query an empty table?
An empty table may be queried just like any other table. A Query acting on an empty table will return ZERO records in its result set. In this case, the NUM-RESULTS() function, if the query is static, and the NUM-RESULTS attribute, if the query is dynamic will return the integer value of zero.