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. -
Resolution
WORKAROUND
1. After making the change in the query of the Data Report, then attempt to run it.
2. Click 'Cancel' when the "You have made changes..." displays
3. At this point the file can be saved and the changes will apply
STATUS
Waiting for fix in a future release of Toad Data Point
-
Defect ID
QAT-4664