Either BOF or EOF is true . . .
- From: "Paul Smith" <paulsmithatdwt.com>
- Date: Thu, 16 Jun 2005 00:58:13 -0700
I am using D5, and TADOStoredProc to open a MSSQL stored procedure that
fetches a result set from a SQL Server table using a SELECT statement. The
stored procedure accepts an input parameter, and may return an empty result
set if it finds no match. My program doesn't care if it gets an empty
result set - it should just show an empty table - and it doesn't attempt to
process the result set; it just displays it in a table using a Delphi
datasource. Everything works as long as I pass in parameters that produce
records. If I pass in a parameter that produces an empty result set, I get
an empty table, as expected. However, the next time I open the stored
procedure (whether I pass in a parameter that should return records or an
empty result set), I get an exception "Project Outlook.exe raised exception
class EOleException with message 'Either BOF or EOF is True, or the current
record has been deleted. Requested operation requires a current record.' "
(My program runs as an Outlook addin). Can someone help me understand what
might be happening, please?
Thanks, Paul
.
- Follow-Ups:
- Re: Either BOF or EOF is true . . .
- From: Brian Bushay TeamB
- Re: Either BOF or EOF is true . . .
- From: Mike Shkolnik
- Re: Either BOF or EOF is true . . .
- Prev by Date: Re: Command object with named Parameters?
- Next by Date: Re: Getting Started
- Previous by thread: Strange behavior...Open an ADOTable fetch all records
- Next by thread: Re: Either BOF or EOF is true . . .
- Index(es):
Relevant Pages
|
