QuoteWerks Knowledgebase Topic (Article ID 6147)
SQL Execute Error (-2147217913) - When Saving a Document
This information applies to :
July 1, 2009
When saving a document an error window appears -
SQL Execute Error
SQL Execute ErrorQuoteWerks trapped error Syntax error in date in query expression '#month/date/year hour/minute/seconds pm#'
(The month/date/year and hour/minutes/seconds will be populated with actual values).
QuoteWerks will then be unable to save the document.
In the Windows Regional Settings (under Control Panel) the Time tab has the Time Separator set to "." (without quotes).
(Note: When date and time are both set to use the same separator a value is returned which does not differentiate between the two, causing a conflict.)
-Close QuoteWerks and any related applications such as CRM.
-In the Windows Regional Settings, accessed through your Control Panel, on Time Tab change the separator to ":" (colon) as the default.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)