Forums
This topic is locked
Driving me mental
Posted 31 Jan 2002 17:43:22
1
has voted
31 Jan 2002 17:43:22 sdfjhb uhgij posted:
This error message is. keep getting it when performing a simple search. can anyone help? im kinda new to this, but im not thick!ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
Thanks in advance
-Rich-
Replies
Replied 31 Jan 2002 18:10:57
31 Jan 2002 18:10:57 Owen Eastwick replied:
Are you getting this when you are sure there is a match, or only when there is no match?
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 31 Jan 2002 23:17:56
31 Jan 2002 23:17:56 sdfjhb uhgij replied:
There is definately a match
Replied 01 Feb 2002 22:57:34
01 Feb 2002 22:57:34 boyd ringrose replied:
Replied 04 Feb 2002 12:32:06
04 Feb 2002 12:32:06 Kent Steelman replied:
Every time I have encounter this error, it was due to my SQL statement being incorrect and returning a "Null" set..... try this as a trouble shoot.... set the regions to hide the object you want to display is the record set is empty..... and then set another region (string text) to only show when the record set is empty. If this eliminates your error message and the one area is hidden and the other area is shown, then for some reason, your SQL statement is quering the DB, but a "Null" value is being returned to the page.
Wm. Kent Steelman
Wm. Kent Steelman