Re: Either BOF or EOF is true . . .
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Thu, 16 Jun 2005 19:22:54 -0500
>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?
You need to apply the 2nd D5 update for ADO to fix this.
it is due to a change Microsoft made to MDAC 2.6 and higher versions.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- Either BOF or EOF is true . . .
- From: Paul Smith
- Either BOF or EOF is true . . .
- Prev by Date: Re: MyADO.Connected := true; causes errors when running through debugger.
- Next by Date: Re: Strange behavior...Open an ADOTable fetch all records
- Previous by thread: Re: Either BOF or EOF is true . . .
- Next by thread: De-activating a TADOConnection before program launch?
- Index(es):
Relevant Pages
|
