August 23, 2010
QA Wizard Pro Lunch and Learn Webinar Recording: Data-driven Testing
Thanks to everyone who joined us for the QA Wizard Pro Lunch and Learn: Data-driven Testing event. The recording is now available if you missed the training session or want to watch it again. Q&A from the session is below.Email sign up
Q&A1. What databases can be used for external datasheets? Microsoft Access, Microsoft SQL Server, MySQL Server, Oracle (as well as Microsoft Excel and text files) 2. When should I use a local datasheet or an external datasheet? A local datasheet can be viewed as a “work area” where you can determine what fields will be needed in the script. Use a local datasheet if you want to store test data in QA Wizard Pro. External datasheets enable you to connect to existing pre-defined data. 3. Can I import data from an external datasheet to a local datasheet? Yes. The process is similar to connecting to an external datasheet. 4. Can I use variables in a dynamic query? Yes. Following are two ways the OpenRecordset statement can be modified to use variables:
LAST=”Simpsons” FILE=OpenRecordsetQuery("External Contacts", "Select * from [Sheet1$] where Last= " + LAST + “’”)or
LAST=”Simpsons” QUERY="Select * from [Sheet1$] where Last=‘" + LAST + “’” FILE=OpenRecordsetQuery("External Contacts", QUERY)5. What if I want the data set to apply for only part of the script? Use Datasheet Access statements with looping or conditional statements. 6. What about saving data dynamically in a datasheet? Can I edit both external and local datasheets? You can use the SetRowValue function to write to external datasheets that are connected to databases. You can also write to local datasheets if the cell has already been created, but since a prompt appears to reload or ignore the datasheet the change it is not practical.