Return
-
Title
Synchronization Wizard does not properly format date in update statement, leaving out commas. -
Description
Data compare finished without issue. Then ran Synchronization Wizard to create the update script to make target like source. The script fails when attempting to execute on the target because the dates are not quoted.
E.g.
Script create:
UPDATE [DBA].[Form_One]
SET [Exp_Date] = 2015-05-31 12:00:00 AMExpected:
UPDATE [DBA].[Form_One]
SET [Exp_Date] = '2015-05-31 12:00:00 AM' -
Cause
This only applies to SAP SQL Anywhere connections and timestamp datatypes. -
Resolution
WORKAROUND:
None.
Manually edit date format.STATUS:
Fixed in current version, 4.0 of Toad Data Point
-
Defect ID
TSY-1863 -
Additional Information
Fixed through Toad for SAP Solutions 3.1.