| || |
Store query results into a CSV file
I have to write a small qtp script that fills out the form with random sets of data and upon submission, there will be a query or database checkpoint that returns certain columns from database and save the results to a csv file.
Since this process will be a repetitive process (about 100 times), the form needs to get submitted 100 different times with different data and upon every submission, the database checkpoint or query will run and return the results and save it to CSV File.
Does anybody have any idea on how to store the results of query or database checkpoint to a csv file? Any other ideas on my approach will also be appreciated.
Re: Store query results into a CSV file
Search the forum to see how to connect to a database and then you can use one of the below two methods
Just use the delimiter as "," for a CSV file