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.