Return
-
Title
Unable to reverse engineer a query with Dateadd function -
Description
I have a query that runs fine in the editor but when I try to send the query to Query Builder (reverse engineer), Toad says that it's unable to model the query. It sends it to the sql query window.
Note that the builder has somehow "MORPHED" the correct syntax of a line
... Dateadd(day,-1000,getdate())Into something else that it can't parse:function.dateadd.day.1000.function.getdateand seems to think is a table... -
Resolution
WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for SQL Server
-
Defect ID
ST86511