Problem with Data Table

[Rakesh Sahukari]

I am just giving some user credentials in data table and executing the flight application

My Data Table look likes below..

Username Password
---------- ---------
aaaaa mercury
bbbbb testing
ccccc mercury

Actually the scenario is to check with each of the user credentials & verify whether the user credentials are correct or not.

Below is my code...

Code:

InvokeApplication "C:\Program Files (x86)\HP\QuickTest Professional\samples\flight\app\flight4a.exe"

CntDtData=DataTable.GetRowCount

For i=1 to CntDtData
    Username1=DataTable.Value("Username",i)
    Password1=DataTable("Password",i)
        Dialog("Login").WinEdit("Agent Name:").Set(Username1)
    Dialog("Login").WinEdit("Password:").Set(Password1)
    Dialog("Login").WinButton("OK").Click
    If Window("Flight Reservation").Exist Then
        Reporter.ReportEvent micPass,"Flight Reservation","Login Successful for user:"&Username1
        Window("Flight Reservation").Close
        InvokeApplication "C:\Program Files (x86)\HP\QuickTest Professional\samples\flight\app\flight4a.exe"
     else
           Reporter.ReportEvent micFail,"Flight Reservation","Login Unsuccessful for user:"&Username1
        Dialog("Login").Dialog("Flight Reservations").WinButton("OK").Click
    End If

Next
else
    Reporter.ReportEvent micFail,"Login Window","Login Window is not displayed"
End If

When I am executing the above code,I can able to verify the 1st user credential but after that I am geeting the run time error as 'Column Name Username does not exists'

Please find the attached screen shot regarding my error.

[Sandeep81]

Hi,
You are getting this error because you are using i in place of sheetid. Since i is changing with every iteration, code is trying to fetch value from a column, in sheet i. You can omit using i and just give only the column name. The best way to do this is:

Code:

CntDtData=DataTable.GetRowCount
For i=1 to CntDtData
    DataTable.SetCurrentRow(i)
    Username1=DataTable.Value("Username")
    Password1=DataTable("Password")
........
........
.....
Next

[Rakesh Sahukari]

Thanks Sandeep.Its working fine..