|
Hi,
I'm trying to update a table on a ASA9 database using a process procedure
(I'm using the ODBC driver).
The table has the following primary key:
LLAVE
KEY(vTranP:BusinessDate,vTranP:storeNum,vTranP:idCaja,vTranP:txnNum,vTranP:itemNum),NOCASE,OPT,PRIMARY
Where vTranP:BusinessDate is a DATE field.
The SQL trace shows the following statement:
0314H(1) 08:27:37.476 Preparing Statement 024A68A0H : UPDATE VTRANSPAGO SET
DOCTOCXC = ?, POSTED = ? WHERE BUSINESSDATE = ? AND STORENUM = ? AND IDCAJA = ?
AND TXNNUM = ? AND ITEMNUM = ? Time Taken:0.00 secs
0314H(1) 08:27:37.476
Binding ? 1 for input with C type CHAR(NTS) as VARCHAR(15) for Statement
024A68A0H Time Taken:0.00 secs
0314H(1) 08:27:37.476 Binding ? 2 for input
with C type UTINYINT as TINYINT for Statement 024A68A0H Time Taken:0.00
secs
0314H(1) 08:27:37.476 Binding ? 3 for input with C type DATE as DATE for
Statement 024A68A0H Time Taken:0.00 secs
0314H(1) 08:27:37.476 Binding ? 4
for input with C type SSHORT as SMALLINT for Statement 024A68A0H Time Taken:0.00
secs
0314H(1) 08:27:37.476 Binding ? 5 for input with C type SLONG as INTEGER
for Statement 024A68A0H Time Taken:0.00 secs
0314H(1) 08:27:37.476 Binding ?
6 for input with C type SLONG as INTEGER for Statement 024A68A0H Time Taken:0.00
secs
0314H(1) 08:27:37.476 Binding ? 7 for input with C type SLONG as INTEGER
for Statement 024A68A0H Time Taken:0.00 secs
0314H(1) 08:27:37.476 Executing
prepared Statement 024A68A0H
0314H(1) 08:27:37.476 Error Occurred: 07006
[Sybase][ODBC Driver][Adaptive Server Anywhere]Cannot convert SQLDATETIME to a
date
0314H(1) 08:27:37.476 Time Taken:0.00 secs
I'd appreciate any suggestions!!
Best regards,
Edgard
|