Kbase P21022: Error 7325 => should use additional buffers in query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2003 |
|
Status: Unverified
SYMPTOM(s):
QUERY-PREPARE text must have 1 FOR EACH/PRESELECT for each query buffer. (7325)
join on same table in the QUERY
CAUSE:
Same default buffer was used for the two instances of the same table.
Example:
OPEN QUERY FOR EACH customer NO-LOCK,
FIRST customer NO-LOCK WHERE customer.salesrep = customer.salesrep
FIX:
Should use additional buffer for the additional instance of same table
DEFINE BUFFER cust2 FOR customer.
OPEN QUERY FOR EACH customer NO-LOCK,
FIRST cust2 NO-LOCK WHERE cust2.salesrep = customer.salesrep.