Standalone database is the database that is configured on single pc or client instead of being configured on the server side.
What Is A Standalone Database In QTP?
Quick Test Pro (QTP) is a good tool mainly used for functionality testing. QTP is quite user friendly for both technical and non technical users. Every one can easily access this. A stand alone database in QTP is where the data can be accessed from for various tests.
This data can be obtained from the data base into a data table of QTP. A variety of databases like Oracle, MS Access, SQL Server, or Mysql with QTP can be used with QTP. After we make a connection we can use this database. We can parametrize objects, checkpoints, data driven tables for more flexibility using QTP. Runtime parameters can also be added to data sheets.
The syntax for doing the same is :
Datatable.GetSheet("Global").AddParameter("NewColumn_Price")
This will add a new column called NewColumn_Price in the datatable under Global Sheet. Similarly exporting data present in Data table to an ".xls" file is also quite easy.
This data can be obtained from the data base into a data table of QTP. A variety of databases like Oracle, MS Access, SQL Server, or Mysql with QTP can be used with QTP. After we make a connection we can use this database. We can parametrize objects, checkpoints, data driven tables for more flexibility using QTP. Runtime parameters can also be added to data sheets.
The syntax for doing the same is :
Datatable.GetSheet("Global").AddParameter("NewColumn_Price")
This will add a new column called NewColumn_Price in the datatable under Global Sheet. Similarly exporting data present in Data table to an ".xls" file is also quite easy.
