> -----Original Message----- > From: Raik Thalheim [mailto:[EMAIL PROTECTED] > Sent: Freitag, 16. April 2004 11:34 > To: maxdb > Subject: division by zero / Insert Statment > > > Dear list, > > 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 ? > >
If we knew the kernel version used and what 'does not functioned' mean (error, wrong result?) answering would be easier. So I assume we are talking about a problem solved and released with version 7.4.3.32, a problem that always the first case was found to be true, not matter if it really was true or not. --> please use the newest version of MaxDB. Elke SAP Labs Berlin > Best Regards, > > Raik Thalheim > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
