#155 Assert Record values exception

[Anonymous]

|AssertRecordValues|1|1|1|

The above code yields the following in the Log: "Object reference not set to an instance of an object

[Mike Longin]

Can you please attach the commands above this so we can better understand the issue?

[Anonymous]

Below is the attached code. This is a new install of SWAT. The rest of test works well. That is, I am able to navigate the browser, stimulate elements etc. The failure is on |asswerRecordValuesByColumn|

|ConnectToMssql|localhost|sa|password|15|
|SetDatabase|reservation|
|SetQuery|select l.ReservationType
from reservation r
JOIN ReservationLock l on r.ReservationId = l.ReservationId
where ReservationId = '402870138641' and r.status = 0|
|AssertRecordValuesByColumnName|0|ReservationType|2|
|AssertRecordCount|1||AssertRecordValues|1|1|1|

[Anonymous]

Below is the attached code. This is a new install of SWAT. The rest of test works well. That is, I am able to navigate the browser, stimulate elements etc. The failure is on |AssertRecordValuesByColumn|

By the way, AssertRecordValues or AssertRecordValuesByColumnName produce the same error.

[Mike Longin]

Is this in the editor or fitnesse? If in Fitnesse do you call a SWATFixture such as InternetExplorerSWATfixture above the commands?

[Anonymous]

I am playing this back through the editor. I have the following above in the test file:

|SWAT.Fitnesse|

#Globals
!define roleEditURL {http://localhost/reservations/RoleEdit.aspx}
!define serverURL {http://localhost/reservations/ReservationSearch.aspx}

!|InternetExplorerSWATFixture|
!|SWATFixture|

#Setup
|OpenBrowser|
|NavigateBrowser|${roleEditURL}|
|StimulateElement|Expression|id:btnCheckAll|onclick|INPUT|
|NavigateBrowser|${serverURL}|

....at this point there are several navigations and stimulated elements followed finally the database check.

[Anonymous]

I mention I'm running a machine with a fresh (first time) install of swat.