Subject | invalid database key |
---|---|
Author | bgm1000de@yahoo.de |
Post date | 2001-07-05T10:52:12Z |
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
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