Need help ! insert query in pgm that works sometimes

[Acie]

I have a VB6 program, and I'm using ADO to pull data from a DB2 DB(linked
tables) and inserting the data into an existing table.

I run this same query but for two different dates. If I run the query in
Access it brigns back less than 200 rows(correct #) for each of the two
dates. However, when I run it from the program for one date it brings back
nothing, and for the second query it brings back data.

If I run it in debug mode, the data comes back. I'm confused as hell about it.
Is it a flushing issue ?

Any thoughts/ideas.

[Steve Sanford]

Hi Acie,

Without seeing the code, I'd have to say, if the query in Access is
returning the correct number of rows but the program doesn't return the same
number of rows, there is something wrong in the code.

Maybe you would post the revelant code????

--
HTH
---
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)