numeric value out of range...

[Jens Stier]

Hi there,


I have the following view:


CREATE VIEW "VTEST"
AS SELECT
TBLQDEPPMERKMAL.ID,
TBLQDEPPMERKMAL.ARBEITSVORGANG,
CASE
   WHEN TBLQDEPPMERKMAL.DPMERKMAL=TRUE THEN 2
   WHEN TBLQDEPPMERKMAL.KRITISCHESMERKMAL=TRUE THEN 1
   WHEN TBLQDEPPMERKMAL.DPMERKMAL=FALSE AND
TBLQDEPPMERKMAL.KRITISCHESMERKMAL THEN 0
END AS MERKMALTYP

FROM TBLQDEPPMERKMAL
        JOIN TBLQDEPPPOSITION ON TBLQDEPPMERKMAL.POSITION_ID=TBLQDEPPPOSITION.ID





if I do the this statement: select * from vtest where id=152

i get an error:

Numeric value out of range;-3019 POS(1) Invalid exponent





What is the reason for this error??




thanks for your help



Jens



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]