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
Default

Hi

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
else
work with recordset
end if

Nickie
Reply With Quote