Board index » delphi » Different ADOQuery Results in Debug and Runtime?

Different ADOQuery Results in Debug and Runtime?

Hi,

I'm unable to determine the problem but when I'm in the Delphi IDE, an put a
breakpoint somewhere in my code my ADOQuery returns what seems to be the
right recordset.

When I let the program run without any breakpoints or run the executable I
get another recordset, there are some rows missing.

I'm using D6 Enterprise SP2, MS SQL 7.

Is this another bug in the ADO components?

How can I get two different answers from the same question?

Any help would be greatly appreciated.
Art

 

Re:Different ADOQuery Results in Debug and Runtime?


Quote
>When I let the program run without any breakpoints or run the executable I
>get another recordset, there are some rows missing.

>I'm using D6 Enterprise SP2, MS SQL 7.

Are you trying to do an Asnycronous fetch?

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Re:Different ADOQuery Results in Debug and Runtime?


Thanks Brian

How would Asynchronous fetch do that?

I'm not sure if it was Asynchronous fetch that was causing it, in
desperation I tried another component, the TADODataSet with the same query
and that one works fine, of course I was getting the wrong answer in
runtime, now I get the same returned query.

Appreciate the Help.

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:es6vaukk0i4evkcj9gudoi3vlegb3gfqr0@4ax.com...

Quote

> >When I let the program run without any breakpoints or run the executable
I
> >get another recordset, there are some rows missing.

> >I'm using D6 Enterprise SP2, MS SQL 7.

> Are you trying to do an Asnycronous fetch?

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Re:Different ADOQuery Results in Debug and Runtime?


Quote
>How would Asynchronous fetch do that?

There have been problems with Asynconous fetches not showing the first couple of
records returned in the dataset.   It was the only thing I could think of that
came anywhere near your problem description.
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads