parameterization

[seenu]

Hi, can anybody help me in doing parameterization, i hv written the following script,

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

[Saket]

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?

[rajeshwar]

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.

[DhanavanthaG]

(03-11-2010 10:59 AM)seenu Wrote:  Hi, can anybody help me in doing parameterization, i hv written the following script,

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

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
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).Click

Regards,
Dhanavantha G Krishnan