Board index » delphi » Different Result Set

mw

Delphi Developer
Sat, 04 Sep 2004 10:31:51 GMT

Different Result Set

I'm getting different numbers of records when I run an ADOQuery than when I
run the query in Access 2000.

 Help!

 
Mike Collie

Delphi Developer
Sat, 04 Sep 2004 10:44:07 GMT

Re:Different Result Set


You need to tell us what your SQL statement is.

--
Michael Collier Bsc (Hons)

Interactive ADO Browser Trial  www.adoanywhere.com/cnet
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com
Email m...@adoanywhere.com
--

Quote
"mw" <c...@compuserve.com> wrote in message news:3c96a316_1@dnews...
> I'm getting different numbers of records when I run an ADOQuery than when
I
> run the query in Access 2000.

>  Help!

mw

Delphi Developer
Sat, 04 Sep 2004 12:55:15 GMT

Re:Different Result Set


"Like" statements are performing differently when doing them in Access, and
doing them within an ADOQUery.

Ever see that?

m

Quote
"Mike Collier" <m...@adoanywhere.com> wrote in message

news:3c96a551_2@dnews...
Quote
> You need to tell us what your SQL statement is.

> --
> Michael Collier Bsc (Hons)

> Interactive ADO Browser Trial  www.adoanywhere.com/cnet
> Free ADO Browser (FAB)  www.adoanywhere.com/fab
> Home Page www.adoanywhere.com
> Email m...@adoanywhere.com
> --

> "mw" <c...@compuserve.com> wrote in message news:3c96a316_1@dnews...
> > I'm getting different numbers of records when I run an ADOQuery than
when
> I
> > run the query in Access 2000.

> >  Help!

Mike Collie

Delphi Developer
Sat, 04 Sep 2004 13:42:43 GMT

Re:Different Result Set


yep, especially with wildcards.

--
Michael Collier Bsc (Hons)

Interactive ADO Browser Trial  www.adoanywhere.com/cnet
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com
Email m...@adoanywhere.com
--

Quote
"mw" <c...@compuserve.com> wrote in message news:3c96c4b1_1@dnews...
> "Like" statements are performing differently when doing them in Access,
and
> doing them within an ADOQUery.

> Ever see that?

> m

> "Mike Collier" <m...@adoanywhere.com> wrote in message
> news:3c96a551_2@dnews...
> > You need to tell us what your SQL statement is.

> > --
> > Michael Collier Bsc (Hons)

> > Interactive ADO Browser Trial  www.adoanywhere.com/cnet
> > Free ADO Browser (FAB)  www.adoanywhere.com/fab
> > Home Page www.adoanywhere.com
> > Email m...@adoanywhere.com
> > --

> > "mw" <c...@compuserve.com> wrote in message news:3c96a316_1@dnews...
> > > I'm getting different numbers of records when I run an ADOQuery than
> when
> > I
> > > run the query in Access 2000.

> > >  Help!

mw

Delphi Developer
Sun, 05 Sep 2004 09:49:12 GMT

Re:Different Result Set


AAAAAAHHHHH.

You're kidding me.  They behave differently?  What a nightmare.  This is a
bug, right?

Quote
"Mike Collier" <m...@adoanywhere.com> wrote in message

news:3c96d09e_1@dnews...
Quote
> yep, especially with wildcards.

> --
> Michael Collier Bsc (Hons)

> Interactive ADO Browser Trial  www.adoanywhere.com/cnet
> Free ADO Browser (FAB)  www.adoanywhere.com/fab
> Home Page www.adoanywhere.com
> Email m...@adoanywhere.com
> --

> "mw" <c...@compuserve.com> wrote in message news:3c96c4b1_1@dnews...
> > "Like" statements are performing differently when doing them in Access,
> and
> > doing them within an ADOQUery.

> > Ever see that?

> > m

> > "Mike Collier" <m...@adoanywhere.com> wrote in message
> > news:3c96a551_2@dnews...
> > > You need to tell us what your SQL statement is.

> > > --
> > > Michael Collier Bsc (Hons)

> > > Interactive ADO Browser Trial  www.adoanywhere.com/cnet
> > > Free ADO Browser (FAB)  www.adoanywhere.com/fab
> > > Home Page www.adoanywhere.com
> > > Email m...@adoanywhere.com
> > > --

> > > "mw" <c...@compuserve.com> wrote in message news:3c96a316_1@dnews...
> > > > I'm getting different numbers of records when I run an ADOQuery than
> > when
> > > I
> > > > run the query in Access 2000.

> > > >  Help!

Other Threads

1. Using the same ActiveX DLL on different machines results different results

2. Stored Procedure Result Sets with different field layouts

3. TQuery result different from DBE Result

4. Different results with different consistency of JOIN clauses

5. Different SQL result with different language driver??

6. Printing with same printer - different result on different PC's

7. Different results with VarIsNull

8. access the same table with different result

9. 1 Form, 2 Pc's, Different results

10. Different ADOQuery Results in Debug and Runtime?