Kbase P4330: Executing a query getting error 7488
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
Using SQL92
Executing a SQL query
Using SQL select statement with big where clause
Server not reachable or possible RPC error. (7488)
CAUSE:
There is a limitation of 250 elements per set
FIX:
Put the elements in a table and then use a select statement for the IN set like follow:
SELECT Sum(Pub."ord-prod"."qt-item") COLUMN1
FROM Pub."ord-prod"
WHERE Pub."ord-prod".Tipo in ('1','2','3') AND Pub."ord-prod".estado = 'R' AND Pub."ord-prod"."nr-ord-prod" IN (SELECT element FROM Pub.sets)