Re: Wish I was using .net


"Michael C" <nospam@xxxxxxxxxx> wrote in message
news:OcDNSpZNGHA.964@xxxxxxxxxxxxxxxxxxxxxxx
I just got an bug report from a customer and found the problem was
something
like this:

Dim c as new ADODB.Command
set c = GetNewConnection ' function that returns a new sqlserver
connection

The last line should have read "set c.activeConnection =
GetNewConnection".
Now I'm going to have to do a new build and go through all the hassle of a
release (there's quite a few steps to this now). Undoubtedly this got out
due to human error however c# or vb.net wouldn't have even let this line
of
code compile because it knows straight off that a connection object cannot
be set into a command object. It's amazing how many similar errors it
picks
up like this while working. Many of those errors would be picked up fairly
quickly but some will get through.


You can't blame this on VB. GetNewConnection is apparently not returning a
reference to an ADODB.Connection object. It it were, you'd have gotten a
Type Mismatch error (I tested it to be sure). So, it's YOUR fault and ONLY
your fault (or whoever the programmer was). There's no excuse for this bug
not to have gotten discovered during testing.

As to "Wish I was using .net", well....use it then and quit your bellyaching
about VB6. <g> Other than ranting, what was the purpose of your message?

--
Mike
Microsoft MVP Visual Basic



.

Relevant Pages

  • Re: Wish I was using .net
    ... set c = GetNewConnection ' function that returns a new sqlserver ... due to human error however c# or vb.net wouldn't have even let this line ...
    (microsoft.public.vb.general.discussion)
  • Re: Impact of hardware with bad SNR & Attenuation
    ... > attempting to negotiate a connection with the exchange).. ... what BT do once the ISP raises a fault to them is sometimes ...
    (uk.telecom.broadband)
  • Re: I know they said there would be difficulties....
    ... It's only after connection completes that Eclipse ... It helps if your router has a log that you can extract and send ... fill in to raise a fault with BT. ... Is the line losing sync or just dropping PPP? ...
    (uk.comp.sys.mac)
  • Re: ADSL connection goes down at roughly the same time in the evening
    ... |> foot of the street lights on its way down the road. ... |>> I've had an ongoing issue with BT over my broadband connection. ... |>> I'm suspecting some sort of interference on the line or perhaps BT ... almost useless when it comes to getting a fault fixed. ...
    (uk.telecom.broadband)
  • System errors
    ... The thread about obesity and its connection to poverty has just been bugging ... pounds overweight to having health problems to not being able to find apples ... "It's the fault of our ... is that the truly deserving people lose out. ...
    (misc.writing)