Menu
▾
▴
#154 SQL Server compare data not working
open
nobody
None
5
2011-05-13
2011-05-13
Anonymous
No
|BeginCompareData|
|isRecordLocked|
|1|
|EndCompareData|
|Disconnect|
The above code is always succeeding, even if the value is one or zero. I am able to connect, the query is executing and returning one column, and one record. Is there an issue with one column being returned?
We are not aware of any known issues with begin and end compare data. Can you provide a sample SQL statement you use to generate this result?
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
The code is below. Note: the query is working in sql manager. I think this may be related to the other issue i noted with the AssertRecordValues. Perhaps the implementation of this swat command is catching the exception whereas AssertRecordValues is not ?
|ConnectToMssql|localhost|sa|password|15|
|SetDatabase|reservation|
|SetQuery|select l.isRecordLocked from reservation r JOIN ReservationLock l on r.ReservationId = l.ReservationId where ReservationId = '402870138641' and r.status = 0|
|BeginCompareData|
|isRecordLocked|
|1|
|EndCompareData|
|Disconnect|
One last question. What is the dbtype for the isrecordlocked column so that we can debug into this
isrecordlocked is an int