The problem is the value of 100 which does not fit into a number having 2 digits
to the left of the decimal point (txr_rate_rent decimal(5,3)).
Please change the constraint ckc_txr_rate_txr to CHECK (txr_rate <= 99.999 )
Isn't this constraint obsolete then? Because a decimal(5,3) cannot be larger than 99.999 anyhow !?!
Arne
-- Institute of Shipping Economics and Logistics http://www.isl.org/ Arne Gehlhaar mailto:[EMAIL PROTECTED] Universitaetsallee GW1 Block A phone:+49.421.22096.49 D-28359 Bremen, Germany fax:+49.421.22096.55
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
