BOF/EOF Again

Thread View: borland.public.cppbuilder.database.ado

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by David Latham Tue, 23 Jan 2001 13:48

#5817

Author: David Latham
Date: Tue, 23 Jan 2001 13:48

13 lines
1273 bytes

Hi All,

After applying the patch supplied by Borland I continued to get the BOF/EOF
errors.  I've traced it to the following:   I've got a result set with
nothing in it and my app sets "storedProc->Active = false".  When I came
back into the routine and set it to false again, I generate the BOF/EOF
error.

It's easy enough to check for, but is this still a bug?

Thanks for the input,

Dave

Re: BOF/EOF Again

#5818

Author: Rick Golden
Date: Tue, 23 Jan 2001 14:18

25 lines
1628 bytes

Did you install the AdoExpress Patch found at
http://www.borland.com/devsupport/bcppbuilder/patches
the file is named  BCB5ADOUpgrade1.exe

It fixed the problem for me.



David Latham <dlatham@qwest.net> wrote in message news:3a6d8bc9$1_1@dnews...
> Hi All,
>
> After applying the patch supplied by Borland I continued to get the
BOF/EOF
> errors.  I've traced it to the following:   I've got a result set with
> nothing in it and my app sets "storedProc->Active = false".  When I came
> back into the routine and set it to false again, I generate the BOF/EOF
> error.
>
> It's easy enough to check for, but is this still a bug?
>
> Thanks for the input,
>
> Dave
>
>

Re: BOF/EOF Again

#5819

Author: David Latham
Date: Wed, 24 Jan 2001 00:16

43 lines
1975 bytes

Hi Rick,

I did apply that patch and continued to get the error even after the patch.
Are you able to set the Active property to false on an inactive, empty
dataset without generating the error?

Thanks for the reply,

Dave




"Rick Golden" <GoldenRick@hotmail.com> wrote in message
news:94k3t5$gc84@bornews.inprise.com...
> Did you install the AdoExpress Patch found at
> http://www.borland.com/devsupport/bcppbuilder/patches
> the file is named  BCB5ADOUpgrade1.exe
>
> It fixed the problem for me.
>
>
>
> David Latham <dlatham@qwest.net> wrote in message
news:3a6d8bc9$1_1@dnews...
> > Hi All,
> >
> > After applying the patch supplied by Borland I continued to get the
> BOF/EOF
> > errors.  I've traced it to the following:   I've got a result set with
> > nothing in it and my app sets "storedProc->Active = false".  When I came
> > back into the routine and set it to false again, I generate the BOF/EOF
> > error.
> >
> > It's easy enough to check for, but is this still a bug?
> >
> > Thanks for the input,
> >
> > Dave
> >
> >
>
>

Re: BOF/EOF Again

#5820

Author: Rick Golden
Date: Wed, 24 Jan 2001 14:57

70 lines
2537 bytes

Yes,
I'm able to do that, but it is not a Stored proc, it is a TADORecordset....

Just to be sure the patch was installed properly,

Open the file adodb.pas (in ($BCB)\Source\vcl)
and check the InternalClose procedure..

it should look like that
  BindFields(False);
  if DefaultFields then DestroyFields;
  FIndexFields.Clear;
  DestroyLookupCursor;
  if stOpen in RecordsetState then
  begin
    if FEventsID > 0 then
    begin
      OleCheck(ConnectionPoint.UnAdvise(FEventsID));
      FEventsID := 0;
    end;
  end;
  FFindCursor := nil;
  FRecordsetObject := nil;
  FFilterGroup := fgUnassigned;
  FDetailFilter := '';
  SetConnectionFlag(cfOpen, False);

and not

  BindFields(False);
  if DefaultFields then DestroyFields;
  FIndexFields.Clear;
  DestroyLookupCursor;
  if stOpen in RecordsetState then
  begin
    Recordset.CancelUpdate;                                **** HERE CAUSED
THE PROBLEM ****
    if FEventsID > 0 then
    begin
      OleCheck(ConnectionPoint.UnAdvise(FEventsID));
      FEventsID := 0;
    end;
    Recordset.Close;
  end;
  FFindCursor := nil;
  FRecordsetObject := nil;
  FFilterGroup := fgUnassigned;
  FDetailFilter := '';
  SetConnectionFlag(cfOpen, False);


Hope it helps
Rick


David Latham <dlatham@qwest.net> wrote in message news:3a6e1ec5$1_2@dnews...
> Hi Rick,
>
> I did apply that patch and continued to get the error even after the
patch.
> Are you able to set the Active property to false on an inactive, empty
> dataset without generating the error?
>
> Thanks for the reply,
>
> Dave
>
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads