Bonjour tout le monde,

Je me fais des noeuds au cerveau avec cette erreur:

Envt:
- Adaptive Server Enterprise/12.5.4/EBF 14347 ESD#5/P/Linux Intel/Enterprise Linux/ase1254/2061/32-bit/OPT/Thu Apr 12 21:13:17 2007
- sqsh-2.1

J'ai une table:

CREATE TABLE TKMMONTHLYREPORT (
POLICYNUMBER varchar(20) NOT NULL,
DATEOFDEATH date NULL,
SURRENDERDATE date NULL,
NOTIFICATIONDATE date NULL,
NEWGUARANTEEDVALUE decimal(20,10) NULL,
NEWGUARANTEEDVALUEDATE date NULL,
DATEINSERT date NOT NULL
)
go


et voici mes commandes, sous sqsh:

 [504] cerise.referencedb.1> insert TKMMONTHLYREPORT values ("1200009348", NULL, NULL, NULL, 7000000, '2007-10-19', '2007-11-07');
(1 row affected)
[505] cerise.referencedb.1> select * from TKMMONTHLYREPORT where POLICYNUMBER = '1200009348';
Msg 247, Level 16, State 2
Server 'cerise', Line 1
Arithmetic overflow during implicit conversion of DATE value 'Jun 17 +(/'' to a DATETIME field .
Arithmetic overflow occurred.


Voila, si je passe sous isql pour lire la meme ligne, tout va bien:

 1> select * from TKMMONTHLYREPORT where POLICYNUMBER = '1200009348'
2> go
POLICYNUMBER DATEOFDEATH SURRENDERDATE NOTIFICATIONDATE NEWGUARANTEEDVALUE NEWGUARANTEEDVALUEDATE DATEINSERT
-------------------- ------------ ------------- ---------------- ----------------------- ---------------------- ------------
1200009348 NULL NULL NULL 7000000.0000000000 Oct 19 2007 Nov 7 2007

Bug Sybase, Bug sqsh/TDS, ...PEBKAC ???
Si qqu'un a des Idees je suis preneur...