+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: parameterization (/Thread-parameterization--3211)
parameterization - seenu - 03-11-2010
Hi, can anybody help me in doing parameterization, i hv written the following script,
Code:
vbwindow("frmlogin").vbedit("txtuserid").set DataTable ("username",dtGlobalSheet)
vbwindow("frmlogin").vbedit("txtuserid").set DataTable ("password",dtGlobalSheet)i hv made the columns name with username and password in the globalsheet,
wn i execute the script i am getting the following error
"The retrive datatable.value operation failed.The<username> column doestnot exist".
can i any one help me out wts the mistake i hv done in this script...Thanks in advance
RE: parameterization - Saket - 03-11-2010
are you sure you have created the columns in the global sheet not in local, check again.
also watch out the correctness of spelling.
can you attach the snapshot of datatable?
RE: parameterization - rajeshwar - 03-11-2010
Hi,
It seems,the column name you have used doesnot exist in the DataTable.
you have to doubleclick on the Header Where its written 'A','B'.... a popup will appear, change the Header to 'username' and then try executing.
RE: parameterization - DhanavanthaG - 03-12-2010
Hi,
Just ensure whether you having the column name called <username> in the global sheet.
If you have then copy the column name from the Global sheet then paste it in where you using in scripting, unfourtunality you may given space at end/begin.
please check the Capital/Small Character in parameter name, because it's case sensitive
or just try the following:-
--------------------------
let assume <username> and <password> are column name in global sheet.
in QTP
Code:
Dim UName, PWD
UName = DataTable.GetSheet("Global").GetParameter("username").ValueByRow(1)
PWD = DataTable.GetSheet("Global").GetParameter("password").ValueByRow(1)
Browser(BrName).Page(PgName).Frame(FrName).WebEdit(TextUser).Set UName
Browser(BrName).Page(PgName).Frame(FrName).WebEdit(TextPass).Set PWD
Browser(BrName).Page(PgName).Frame(FrName).Webbutton("ButtonName).ClickRegards,
Dhanavantha G Krishnan