In my last post, SQL Is Still Your Friend, I wrote about using SQL to query TestTrack data. As a continuation of that thought, I wanted to bring a query tool to your attention: Microsoft Excel. There are plenty of alternatives to using Excel for queries but it has two major advantages: 1) almost everyone uses MS Office so your spreadsheet is portable and 2) after you retrieve the data from the database, you can use the extensive library of Excel functions to work with the data.
Continue reading…
query
Creating external datasheets allows QA Wizard Pro to use outside data to drive a script. The tester specifies the table or query to populate the datasheet, and must manually modify the properties to select a different set of data. It is possible locate a particular record using a database checkpoint to match a particular value (Creating Database Checkpoints in QA Wizard Pro), but some testers may want to modify existing queries automatically from the script itself.
Continue reading…
