Kbase 8858: How to use the SQL EXISTS function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to use the SQL EXISTS function
901010-gfs01Certain SQL queries using the EXISTS keyword generate a Memory
Violation (Error 49) in version 5. This is fixed in 5.2J & 6.2C.
You cannot use EXISTS under the following conditions:
o With a join in the subquery
o Where it does not involve a simple index lookup. The EXISTS
search condition works only when an indexed search can satisfy
the request. Therefore, you must use an indexed field in the
WHERE clause when you specify EXISTS.
You should only use EXISTS when it is translatable to the PROGRESS
CAN-FIND function.
Progress Software Technical Support Note # 8858