Sap DB wrote: > > I have got troubles with an update using parameter and negative value: > > > > running the following statement > > UPDATE DBM350_SM SET StatusCode=-2, DIST_FILE=?, > DIST_NUM=DIST_NUM+1 WHERE > MSN=30 AND (DIST_OWNER IS NULL) AND DIST_NUM=11 > > I got the message "Numeric value out of range;-3019 POS(1) Invalid > exponent." >
May I ask for some more info: Are there trigger on top of this table? Please provide the vtrace according to http://sapdb.2scale.net/moin.cgi/VTrace Do the updates below work correctly even if the additional AND (DIST_OWNER IS NULL) AND DIST_NUM=11 (part of the update above) are in? I can't believe that they will make some difference, but it is even hard to believe what could cause the -3019 above. Elke SAP Labs Berlin > > I have tried the same statement with a positive value for > StatusCode and it > works, and I have tried a statement without DIST_FILE and it works. > > NOK--> UPDATE DBM350_SM SET StatusCode=-2, DIST_FILE=?, > DIST_NUM=DIST_NUM+1 > WHERE MSN=30 > > OK--> UPDATE DBM350_SM SET StatusCode=2, DIST_FILE=?, > DIST_NUM=DIST_NUM+1 > WHERE MSN=30 > > OK--> UPDATE DBM350_SM SET StatusCode=-2, DIST_NUM=DIST_NUM+1 > WHERE MSN=30 > > > > I'm using the ODBC driver build 027-123-048-452 > > the table is create like : CREATE TABLE DBM350_SM (MSN SERIAL > PRIMARY KEY, > StatusCode INTEGER, DIST_FILE LONG BINARY, DIST_NUM INTEGER) > > > > If someone has any idea... > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
