Start a new topic

How to add a new file when exporting data using appendFile

[This topic is migrated from our old forums. The original author name has been removed]

Two SQL scripts need to write to same output file . The second SQL file has the appendFile=True feature in the export settings and it works in appending the data set to the file. The issue here is that data is written on the same line where the first sql last row ends instead of appending data in the new file .How to resolve the issue ? Thanks LP

[This reply is migrated from our old forums.]

Re: How to add a new file when exporting data using appendFile
Hi, Can you please post the exact script(s) your are running? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: How to add a new file when exporting data using appendFile
Hi I am using DB Visualizer Pro 9.2.10 on Windows 7 . and what is happening is the following : 2 SQL Scripts (S1 & S2) write to the same text file (T1) using the export feature . Order of Script execution : S1 , S2 S1 writes 5 lines L1 to L5 . When S2 is executed instead of writing the data on Line 6 (L6)- new line .It's being appended onto the data at Line 5 which has data from the S1. How can that be done ?
[This reply is migrated from our old forums.]

Re: How to add a new file when exporting data using appendFile
Hi, I cannot reproduce what you describe. Which DbVisualizer version do you use, and on which operating system? Which database type? Best Regards, Hans