Kbase P80881: With dynamic queries, options like MAX-ROWS shall be used in the QUERY-PREPARE()
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/18/2004 |
|
Status: Unverified
GOAL:
How to use the MAX-ROWS option with dynamic queries
FIX:
The options that are available in the static OPEN QUERY statement are also available with Dynamic Queries. You shall use them in the QUERY-PREPARE() method (and not in the QUERY-OPEN() itself).
q:QUERY-PREPARE("FOR EACH customer no-prefetch MAX-ROWS 10").