Subject invalid database key
Author bgm1000de@yahoo.de
Hi,

When I try to fire the following SQL statement the connection is
getting lost after scrolling through the result
------
SELECT ADOSEN.JAHR, EXPOSITIONEN.STAMMNUMMER,
Sum(EXPOSITIONEN.MSVAUSSEN) AS EXPS_NAMTLICH,
Sum(EXPOSITIONEN.MSVINNEN) AS EXPS_INKORP,
ADOSEN.SUMME AS EXPS_AMTLICH
FROM EXPOSITIONEN INNER JOIN ADOSEN
ON (EXPOSITIONEN.JAHR = ADOSEN.JAHR)
AND (EXPOSITIONEN.STAMMNUMMER = ADOSEN.STAMMNUMMER)
GROUP BY ADOSEN.JAHR, EXPOSITIONEN.STAMMNUMMER, ADOSEN.SUMME
ORDER BY ADOSEN.JAHR, EXPOSITIONEN.STAMMNUMMER;
------
IBConsole's Interactive SQL fetches only the first record before the
connection to the server is beeing closed and the error
message "invalid database key" appears

Did I something wrong? How can I solve this problem? A validation
hasn't found any error even after a backup/restore the error still
exists. Any hint would be very appreciated!

Jan