SQA Basic ODBC functionality
I am using Excel files for the data-driven tests. Now I am thinking about switching the data source from Excel to ODBC source. I am familiar with database connectors(like ADO or JDBC for example ) and SQL, so it seem simple to use such kind of connectors in the script. But my question is -- can anyone give me real-world proven testing scenarios in using SQA Basic ODBC functionality? I dont want to make the change form Excel to ODBC without sufficient arguments. On the other side I am convinced that SQL is a powerfull weapon ...but I have a lot of questions about how it might be applied in testing. For example: should I use the SQA SQL function or using 'CreateObject' function to create ADO object and this way to get all the possibilies of ADO?
thank you in advance...
All the best
Re: SQA Basic ODBC functionality
I'm using Robot for data-driven testing, all data is stored in MS-SQL database. I hate this solution. Robot is not made to use all power of SQL. I'm working with SQL for years, and I really like it - but Robot is not supposed to store smth in database and to use SQL to retrieve data. It has several SQL functions (you're sure to know them), but it's difficult to use them. For example, to retrieve set of data from DB, you must create an array, redim this array (it is not easy, because there is no function in Robot which tells you how many rows your query returns), you must pass this array somewhere (global array of variant type... - do you like it? I don't). And what you finally get is just an array, you cannot refer to the values of this array by field names. I'm having large functions to execute SQL statements, I'm having global arrays - so I fill one array with SQL data, then copy this array to not-global array to be able to use it... I've never used Excel in Robot, but my impression is that it's easier. If it already works, use it. SQL is powerfull, but it's difficult to use this power in Robot.