still trying to figure out eof bof problem...

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

3 messages

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

3 total messages Started by Peter Dragun Wed, 28 Mar 2001 16:47

#5661

Author: Peter Dragun
Date: Wed, 28 Mar 2001 16:47

26 lines
1978 bytes

Hello,

I am using CB5pro, with ADOExpress, I have installed the latest ADOExpress
patch for CB5.  I am also attaching to a MS SQL 2000 database, using MDAC
2.6.  .  I am using ADOQuery to work with the tables.  Anytime I filter a
table and the result ends up being an empty instance of the table a BOF EOF
exception is thrown.  I have read information about problems of this, and
apparently they have been fixed.  But the problem still comes up.  I never
had this sort of problem when I used MS SQL 7.0.  Is there solution?

As an example of what I am doing.  I have two tables:

TableA:         TableB:
ID                    ID        Id number-auto generated - key
Name               AID     references to ID in Table A
                        Description

I have to queries.

QueryA, and QueryB.  I have two DBGridsA, and B.  When ever DBGridAScroll
Event is triggered it will filter QueryB.  But if QueryB ends up being empty
the exception is raised.

Is there a better way to do this, is there a way to fix this?

-Peter

Re: still trying to figure out eof bof problem...

#5587

Author: J. R. Antley
Date: Sun, 01 Apr 2001 09:40

45 lines
2404 bytes

Hi Peter,

I've a similar but different problem.  However, I can't find the BDB5
[upgrade 1] and ADOExpress [Upgrades 1 and 2?] upgrades anywhere.

Yes, I know the links to them are widely published, but I get "404"!  I
think you saw the same thing.  As typical, you didn't get a response, and
somebody who had the stuff was kind enough to send it to you?

TIA,
JR

"Peter Dragun" <pdragun@home.com> wrote in message news:3ac26a56_2@dnews...
> Hello,
>
> I am using CB5pro, with ADOExpress, I have installed the latest ADOExpress
> patch for CB5.  I am also attaching to a MS SQL 2000 database, using MDAC
> 2.6.  .  I am using ADOQuery to work with the tables.  Anytime I filter a
> table and the result ends up being an empty instance of the table a BOF
EOF
> exception is thrown.  I have read information about problems of this, and
> apparently they have been fixed.  But the problem still comes up.  I never
> had this sort of problem when I used MS SQL 7.0.  Is there solution?
>
> As an example of what I am doing.  I have two tables:
>
> TableA:         TableB:
> ID                    ID        Id number-auto generated - key
> Name               AID     references to ID in Table A
>                         Description
>
> I have to queries.
>
> QueryA, and QueryB.  I have two DBGridsA, and B.  When ever DBGridAScroll
> Event is triggered it will filter QueryB.  But if QueryB ends up being
empty
> the exception is raised.
>
> Is there a better way to do this, is there a way to fix this?
>
> -Peter
>
>
>
>

Re: still trying to figure out eof bof problem...

#5588

Author: Peter Dragun
Date: Sun, 01 Apr 2001 13:15

25 lines
1650 bytes

Here is the path to the ADO Upgrade for BCB5.0 Pro
http://www.borland.com/devsupport/bcppbuilder/patches/

I haven't received a response from anyone yet.  I may go back to ODBC, which
is to sad, because I ADOExpress components work quite efficiently with
MSAccess and MS SQL 7.0.

-Peter



"J. R. Antley" <jantley@phoenixdsl.com> wrote in message
news:3ac70a45$1_2@dnews...
> Hi Peter,
>
> I've a similar but different problem.  However, I can't find the BDB5
> [upgrade 1] and ADOExpress [Upgrades 1 and 2?] upgrades anywhere.
>
> Yes, I know the links to them are widely published, but I get "404"!  I
> think you saw the same thing.  As typical, you didn't get a response, and
> somebody who had the stuff was kind enough to send it to you?
>
> TIA,
> JR
>

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