Thread: query problem
View Single Post
  #3 (permalink)  
Old September 8th, 2003, 04:27 AM
nbryson nbryson is offline
Authorized User
Join Date: Jun 2003
Location: Edinburgh, , United Kingdom.
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts


Although this is nothing to do with SQL question you asked but it is good practice to check if any records are being returned and deal with it appropriately :-

If rs.BOF = True And rs.EOF = True Then
raise error
work with recordset
end if

Reply With Quote