hi, 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." 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
