Timestamp Problem
Posted: Thu Aug 03, 2000 3:19 pm
DEVCALLHISTORY.CTransformerStage1.DSLink4: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO pubs.guest.CALL_HISTORY (CallID, SiteID, CustomerDetailID, RepAssigned, CallStatus, CallType, CallPriority, CallDate) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.
SQLSTATE=22005, DBMS.CODE=0
[Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
CallID = 1496371
SiteID = SF132402-1
CustomerDetailID = 3
RepAssigned = DMO63370
CallStatus = C
CallType = PJ
CallPriority = P3
CallDate = "03-06-2000 15:10:34
The CallDate is a Timestamp type in a SQL 7 database. Anyone know how I can get rid of this message or what Im doing wrong.