7.1.4.1389 = SQL Window, exporting to .CSV

[pwo1433]

When you run a query and bring the results back to the screen, then make a change to the program and rerun the program exporting the results to a .csv file, it actually exports the results of the program you ran BEFORE the change.
You have to change the program, bring the results back to the screen again first, and then export to a .csv file in order to get an accurate output file.
Anyone know how to get it to export the results of the changed program ?
Thanks.

 

[Marco Kalter]

I'm not quite sure what the difference between the 2 scenarios is. Can you elaborate?

 

[pwo1433]

In the first scenario, just change the query and don't run it then (where the results come back to the screen), but just click on the 'Export Query Results...' button and immediately send output to .csv (while the results of the first query are still sitting on the screen).
In the second scenario, you change the query, run it (results to screen) and THEN click on the export button and select .csv (or whatever format).
I guess the story is, when you make a change to a query, you need to run it through at least 1 screenfull of results BEFORE clicking the export button. That is, the export button takes it's data from the results window and NOT from the query in the sql code window. It that correct?
If so, that's inconvenient if it takes a long time for that 1 screenfull of results to process.
Thanks for your advice, Marco.
Paul and Tony

 

[pwo1433]

Actually, Marco, you can cancel this question.
I see that all we need do is clear the results and THEN click export and the sql code results are exported and NOT what was in the results screen.
We are ok then.
Thanks.