Nil Check for Recordset Not Working As Expected

pipefile · **Joined:** Sun Feb 19, 2006 7:06 pm **Posts:** 65

I have a RecordSet checked to see if it pulled any information. Here is the code (boss told me to change the variable names to protect the innocent)

dim rs as recordset
dim SearchString as string

SearchString = "Select * from database_table WHERE column1 = 'info'"

rs = app.db.SQLSelect(SearchString)

if rs <> nil then
  ' Match - Do something here
  
else
  ' No Match - Do something else here
  
end if

rs will ALWAYS return Non-Nil, even if there is not a match to the query. The values in the RecordSet are Nil but the RecordSet itself isn't Nil

What would cause this behavior? I haven't run into this before.

Thanks.

timhare · **Posted:** Mon Apr 05, 2010 7:23 pm

The only time the recordset will be nil is if there was an error in the query. Finding zero records is not an error. It will return an empty recordset, where rs<> nil and rs.EOF is already true.

rbasic20091005153 · **Joined:** Sat Apr 04, 2009 5:10 pm **Posts:** 954

I agree with Mr. expert. rs=Nil or rs<>Nil will tell you if the database is accessible. Meanwhile, the following is what I happened to write to find out if there are data matches.

If rs.RecordCount>0 Then
  // There's at least one match
Else
  // There's no match
End if

timhare · **Posted:** Mon Apr 05, 2010 10:53 pm

While RecordCount works well enough for RealSQLDatabase, it is hit or miss for the other databases. Testing EOF always works on all db's. Just fyi.

	Real Software Forums The forum for Real Studio and other Real Software products.
[ REAL Software Website \| Board Index ]

Real Software Forums

Nil Check for Recordset Not Working As Expected