can save the follwing queries

J

Jonas

Hi

if I try saving the flowwing query access 2k crashes:

SELECT CAPTIONS.Key, CAPTIONS.Translation
FROM CAPTIONS, (SELECT ALanguage.ActiveLanguage AS ActiveLanguage FROM
PARAMETER, (SELECT CInt(PARAMETER.Value) AS ActiveLanguage FROM PARAMETER
WHERE PARAMETER.Description="activelanguage") AS ALanguage) AS
ActiveLanguageTmp WHERE CAPTIONS.LanguageID =
ActiveLanguageTmp.ActiveLanguage

Why can this happen ?

Regards

Jonas
 
Top