Re: Either BOF or EOF is true . . .

Apply the D5 updates from Borland site - this error fixed there for ADO
components

--
With best regards, Mike Shkolnik
EMail: mshkolnik@xxxxxxxxxxxxx
http://www.scalabium.com

"Paul Smith" <paulsmithatdwt.com> wrote in message
news:42b13112$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>


.

Relevant Pages

  • Re: Either BOF or EOF is true . . .
    ... >fetches a result set from a SQL Server table using a SELECT statement. ... >stored procedure accepts an input parameter, and may return an empty result ... My program doesn't care if it gets an empty ... I get an exception "Project Outlook.exe raised exception ...
    (borland.public.delphi.database.ado)
  • Either BOF or EOF is true . . .
    ... fetches a result set from a SQL Server table using a SELECT statement. ... stored procedure accepts an input parameter, and may return an empty result ... My program doesn't care if it gets an empty ... I get an exception "Project Outlook.exe raised exception ...
    (borland.public.delphi.database.ado)
  • Re: Processing speed
    ... > include de-referencing variables and releasing unmanaged resources. ... How about using a stored procedure in the database to empty the tables? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Default Values
    ... explicit value. ... When using a stored procedure that executes an UPDATE, ... I set it to "empty" but still inserts null ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: while c = f.read(1)
    ... The problem with interpreting empty as false is that empty ... > If Python is too "wild" for your taste, ... In that case you wouldn't return an empty sequence if you wanted ... a false value in a sequence context but would throw an exception. ...
    (comp.lang.python)
Loading