• Some Wonk (unregistered) in reply to Eric B.
    Eric B.:
    George:
    Under the spreading B11CFee, I soldU and you soldB. There we lie and there EscB, under the spreading R5Fee.

    Nice poem, comrade.

    No. Oceania has always been at war with Eurasia. We are allies with Eastasia.

  • oosterwal (unregistered) in reply to trwtf
    trwtf:
    Isn't it supposed to be a vase?
    shotcircut:
    Isn't all VBA?

    No, some VBA is supposed to be two faces. And some is supposed to be a duck, and some is supposed to be a rabbit.

    I'd bet pi/e shares of that company's stock that it's a graph of the company's stock price during Trent's tenure supporting the freight calculator code.

  • Tom (unregistered)

    And of course on a line like the last one shown, only the LAST variable is strongly typed, the rest are all Variants.

  • * (unregistered)

    What design pattern is this?

  • darklydrawl (unregistered) in reply to pinkduck

    hahaha, yeah, that was my thought as well. Mostly variants. that is going to cause some pain...

  • Design Pattern (unregistered)
    cindy:
    A Lange & Sohne watches

    Audemars Piguet watches

    Ulysse Nardin watches

    Worse than Failure: Using Akismet!
  • Shinobu (unregistered) in reply to ABT
    ABT:
    the real WTF is that in VBA (unlike VB proper), the last variable is the only one that gets assigned the variable type passed. For instance, in this line: Public PrmID, ImptID As Long only ImptID is cast as a Long. PrmID is cast as the default -- a memory clogging 'Object' type.
    That's false on two counts. 1) Variables without As clause are considered Variants, not Objects. The difference is huge, for example, if you have this declaration: ‘Dim A, B As Object’ then ‘IsEmpty(B)’ will be False, while ‘A Is Nothing’ will yield a run-time error: Object required. 2) This is true not just in VBA, but also in VB proper, since they share the same engine. VB.net doesn't have Variants so they had to change it some way or another and the decision was taken to make it behave like the C family.

Leave a comment on “Feng Shui”

Log In or post as a guest

Replying to comment #:

« Return to Article