Forums

This topic is locked

Show region probs HELP!!!

Posted 18 Apr 2001 12:36:41
1
has voted
18 Apr 2001 12:36:41 Michael O'Neill posted:
I am having a nightmare where I try to show a search results page but when
the recordset is empty I get the 800a0bcd error. The show region if
recordset is not empty only seems to work if I do not use any of the move to
record or recordset navigation commands on the page at all. Even if I use
show region with these I still get the 800a0bcd error.
I have got around this problem by modifying the code but I am not entirely
happy doing this and would like to know if there is a better solution or if
<<my mod>> is ok.
Thanks in advance..
Mike



' reset the cursor to the beginning (had to modify this myself with the if
not eof my mod inside << >&gt
<<If Not Recordset1.EOF Or Not Recordset1.BOF Then >>
If (Recordset1.CursorType > 0) Then
Recordset1.MoveFirst
Else
Recordset1.Requery
End If
<<End If>>

Reply to this topic