Return
-
Title
Toad Data Report does not save changes made to the SQL query within the Data tab. -
Description
Run a query in the Editor.
Right click on data grid and Send To | Report Data DesignerSave the report (.tdr)Go to Data tab and make a change to the query ( do not execute the new query)Go to File | Save FileClose the Report DesignerNow re-open the .tdr reportThe change to the SQL will not applyHowever, if a change is made to the query in the Data Report (in the Data tab) AND it is executed, this results in a looping message:"You have changes in your SQL that have not been applied. Would you like to apply them now and update the data?"If 'YES' is clicked then the message comes up again. 'NO' or 'CANCEL' stops the looping and Toad does recognize that a change has been made (denoted by the * beside the file name). At this point if it's saved, then the changes will be applied.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.