fetch data from SQL database at runtime
hi Is there a way to execute a query at run time and store the result in DB table and continue execution according to the result set obtained. I was able to get the snapshot but I need it to con...
Forum Discussion
thanks Curt,
but, what I am looking is to make the data from the SQL available in the DBTable of Test Complete after the SQL connection is closed.
Since script has to process a lot of data from SQL, I need to fetch data and copy it to the DBTable (or any storage location in Test Complete), then close the connection and use the data for further processing.
Specifically, the VBS code to do the declaration, copying and fetching of / from DB Table
thank you
Jinith
but, what I am looking is to make the data from the SQL available in the DBTable of Test Complete after the SQL connection is closed.
Since script has to process a lot of data from SQL, I need to fetch data and copy it to the DBTable (or any storage location in Test Complete), then close the connection and use the data for further processing.
Specifically, the VBS code to do the declaration, copying and fetching of / from DB Table
thank you
Jinith