Numeric value out of range

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...