>> To prevent a division by zero >> i examine the divisor for zero. >> >> >> INSERT INTO "TEMP"."TABLE2" >> (COLUMN1) >> SELECT >> CASE >> WHEN SOURCECOL = 0 THEN 0 >> WHEN SOURCECOL <> 0 THEN (Sum(SOURCECOL3/SOURCECOL)) >> END AS REAGENZ >> FROM "TEMP"."TABLE1" >> GROUP BY SOURCECOL; >> >> Does not functioned for "Insert into ... ". >> >> Is using the "case" statement in combination with "insert" possible ? >> >>
ZE> If we knew the kernel version used and what 'does not functioned' mean ZE> (error, wrong result?) answering would be easier. Sure. sorry. ZE> So I assume we are talking about a problem solved and released with ZE> version 7.4.3.32, a problem that always the first case was found to be true, ZE> not matter if it really was true or not. The Version is 7.5.00.08. I can run the statement successfully without the "INSERT INTO .. " part. Otherwise i get an -3024 error code. -- Best regards, Raik Thalheim -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
