Debugging - catching runtime errors and a comment...

Hello:


Is the brief, euphoric rush you get when you finally find the bug worth the
endless, gnawing frustration of debugging needed to discover it? When you
discover a long-sought after bug do you:

a) yell "Yes, Yes, oh YES!" like Meg Ryan in "When Harry Met Sally"?
b) dance around the room in your boxers like Tom Cruise in "Risky Business"?
c) rip off your shirt like Mia Hamm after the big goal?
d) all of the above...?

Inquiring minds want to know... register your response here:
___________________________.

OK..., so I've got this process to download book information from Amazon.com
and the Library of Congress using web services and Z39.50.. (I know, I know,
you are all sick of hearing about it <g>). I decide to see if I can make it
into a batch process, so that I could feed the program a table of say, 150
ISBN numbers and fill another table with the downloaded data. Ok, that takes
me quite while, but I do finally get it working. Feed it 5 or 10 ISBNs and
it fills the table nicely! Cool! I feel good!

But strangely, as I add more ISBN numbers it starts to error out. My
errorhandling shows error number 13 - "Type Mismatch". Hm. I start applying
my less than formidable debugging skills. To make a long, long story short,
I spend all my Access "playtime" for a week or more trying to find this
maddening bug. In desperation, I remove all errorhandling code. And *then* I
see a "Visual Basic Runtime" error message:

Run-Time Error '2146697208 (800c0008)':
The download of the specified resource has failed.

HA! It *isn't* my code... it is from the Z39.50 client! On a hunch I insert
a bit of code to pause for a second on each interation - and voila! It
works! It was some sort of timing issue...

Question:

Why doesn't my errorhandling show this error? ( I suspect because it is
external to Access...) and, more importantly, how can I trap this type of
error?

Thanks!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/



.

Relevant Pages

  • Re: Please Report SP6 bugs! (was Re: Visual Studio SP6)
    ... Can you clear your Internet Explorer cache and download the ... Service Pack again and then after it downloads, ... > If you have discovered a bug in VB6 ***that was introduced with the ... > The MS dev team is awaiting our report, therefore in order to get them to ...
    (microsoft.public.vb.controls)
  • Re: Please Report SP6 bugs! (was Re: Visual Studio SP6)
    ... Can you clear your Internet Explorer cache and download the ... Service Pack again and then after it downloads, ... > If you have discovered a bug in VB6 ***that was introduced with the ... > The MS dev team is awaiting our report, therefore in order to get them to ...
    (microsoft.public.vb.winapi)
  • Re: Please Report SP6 bugs! (was Re: Visual Studio SP6)
    ... Can you clear your Internet Explorer cache and download the ... Service Pack again and then after it downloads, ... > If you have discovered a bug in VB6 ***that was introduced with the ... > The MS dev team is awaiting our report, therefore in order to get them to ...
    (microsoft.public.vb.syntax)
  • Re: Please Report SP6 bugs! (was Re: Visual Studio SP6)
    ... Can you clear your Internet Explorer cache and download the ... Service Pack again and then after it downloads, ... > If you have discovered a bug in VB6 ***that was introduced with the ... > The MS dev team is awaiting our report, therefore in order to get them to ...
    (microsoft.public.vb.bugs)
  • Re: Please Report SP6 bugs! (was Re: Visual Studio SP6)
    ... Can you clear your Internet Explorer cache and download the ... Service Pack again and then after it downloads, ... > If you have discovered a bug in VB6 ***that was introduced with the ... > The MS dev team is awaiting our report, therefore in order to get them to ...
    (microsoft.public.vb.general.discussion)
Loading