Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error:"Date format picture ends before......

Status
Not open for further replies.

rune

Technical User
Aug 9, 2000
15
NO
converting entire input string"- "Error detected by database DLL"

All my reports who select by date/time field give this respond. I locked at the SQL query and found this(lock at the date):
SELECT
CC_CLIENTS."NAME",
CC_CALLS."TIME", CC_CALLS."CALL_TYPE", CC_CALLS."CONNECTED"
FROM
"CC_REPORTS"."CC_CLIENTS" CC_CLIENTS,
"CC_REPORTS"."CC_CALLS" CC_CALLS
WHERE
CC_CLIENTS."ID" = CC_CALLS."CLIENT_ID" AND
CC_CLIENTS."NAME" = 'Ellos' AND
CC_CALLS."TIME" >= {ts '2001-10-12 00:00:00.00'} AND
CC_CALLS.&quot;TIME&quot; < {ts '2001-10-19 00:00:00.00'}

This happened after installing CR 8.5 on Win 2000. I can't find anything wrong in &quot;regional options&quot; ore &quot;options&quot; in CR. I have reinstalled the ODBC driver. I'm gone reinstall CR now, if that doesn’t help I hope I can find some help her in this forum.

Rune Flaathen
SNT-Norway
 
Is there no one who has experienced this problem before?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top