Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. More mining from our deep seam of WTF's

More mining from our deep seam of WTF's

Scheduled Pinned Locked Moved The Weird and The Wonderful
rubycssdatabasejson
15 Posts 7 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Rob Grainger

    Another gem from the VB6 app I'm in the process of replacing. In production code no less.

    SQL = "select policyid, policynumber, covdate"   ' Rest of SQL omitted
    MsgBox SQL
    RS.Open SQL, con, adOpenStatic
    

    My guess is this was a diagnostic message someone neglected to remove. The SQL statement is quite long (involving a few joins). Must be quite intimidating for users.

    "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

    J Offline
    J Offline
    jim lahey
    wrote on last edited by
    #2

    If only WTFs could be used as an energy source - the VB6 and PHP legacy code out there could fuel us until entropy.

    R C 2 Replies Last reply
    0
    • J jim lahey

      If only WTFs could be used as an energy source - the VB6 and PHP legacy code out there could fuel us until entropy.

      R Offline
      R Offline
      Rob Grainger
      wrote on last edited by
      #3

      Sadly true!

      "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

      1 Reply Last reply
      0
      • J jim lahey

        If only WTFs could be used as an energy source - the VB6 and PHP legacy code out there could fuel us until entropy.

        C Offline
        C Offline
        charlieg
        wrote on last edited by
        #4

        Oh, a sweet quote for sure. Just replace with your topic of choice...

        Charlie Gilley You're going to tell me what I want to know, or I'm going to beat you to death in your own house. "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759

        J 1 Reply Last reply
        0
        • C charlieg

          Oh, a sweet quote for sure. Just replace with your topic of choice...

          Charlie Gilley You're going to tell me what I want to know, or I'm going to beat you to death in your own house. "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759

          J Offline
          J Offline
          jim lahey
          wrote on last edited by
          #5

          Parameterised and reusable!

          1 Reply Last reply
          0
          • R Rob Grainger

            Another gem from the VB6 app I'm in the process of replacing. In production code no less.

            SQL = "select policyid, policynumber, covdate"   ' Rest of SQL omitted
            MsgBox SQL
            RS.Open SQL, con, adOpenStatic
            

            My guess is this was a diagnostic message someone neglected to remove. The SQL statement is quite long (involving a few joins). Must be quite intimidating for users.

            "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

            N Offline
            N Offline
            Nagy Vilmos
            wrote on last edited by
            #6

            How about the extra points for the numpty who did this in server side code? System hung, grrr, over to data centre, into server room, find the box, see message, scream "E****! You Elephant Seamstress's Child!"

            Reality is an illusion caused by a lack of alcohol "Nagy, you have won the internets." - Keith Barrow

            R 1 Reply Last reply
            0
            • N Nagy Vilmos

              How about the extra points for the numpty who did this in server side code? System hung, grrr, over to data centre, into server room, find the box, see message, scream "E****! You Elephant Seamstress's Child!"

              Reality is an illusion caused by a lack of alcohol "Nagy, you have won the internets." - Keith Barrow

              R Offline
              R Offline
              Rob Grainger
              wrote on last edited by
              #7

              Luckily, that is not server side. Unluckily it is VB6.

              "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

              V R 2 Replies Last reply
              0
              • R Rob Grainger

                Luckily, that is not server side. Unluckily it is VB6.

                "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                V Offline
                V Offline
                vonb
                wrote on last edited by
                #8

                You know what? Just read this, then turned the head around. My colleague behind me has a XP box with a VB6 project open.. (true story)

                The signature is in building process.. Please wait...

                R 1 Reply Last reply
                0
                • V vonb

                  You know what? Just read this, then turned the head around. My colleague behind me has a XP box with a VB6 project open.. (true story)

                  The signature is in building process.. Please wait...

                  R Offline
                  R Offline
                  Rob Grainger
                  wrote on last edited by
                  #9

                  Don't leap to assumptions - I also have a VB6 project open, but only because I've been tasked with updating it to C#.

                  "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                  V 1 Reply Last reply
                  0
                  • R Rob Grainger

                    Don't leap to assumptions - I also have a VB6 project open, but only because I've been tasked with updating it to C#.

                    "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                    V Offline
                    V Offline
                    vonb
                    wrote on last edited by
                    #10

                    The problem is: we can't update it. First it's a very large project, seondly the end-user machine does not have and never will have (old box) .NET installed. It has to be that machine due to hardware (scanner, other devices)

                    The signature is in building process.. Please wait...

                    N 1 Reply Last reply
                    0
                    • V vonb

                      The problem is: we can't update it. First it's a very large project, seondly the end-user machine does not have and never will have (old box) .NET installed. It has to be that machine due to hardware (scanner, other devices)

                      The signature is in building process.. Please wait...

                      N Offline
                      N Offline
                      Nicholas Marty
                      wrote on last edited by
                      #11

                      We also have some old legacy projects which need maintenance from time to time. However the gain of updating them to .NET would probably never justify the costs involved.

                      V 1 Reply Last reply
                      0
                      • N Nicholas Marty

                        We also have some old legacy projects which need maintenance from time to time. However the gain of updating them to .NET would probably never justify the costs involved.

                        V Offline
                        V Offline
                        vonb
                        wrote on last edited by
                        #12

                        The project we have basically produces forms (word docs printed), each one of the form has one or more input masks. Actually over 200. These docs are not allowed to be saved, therefore the application.

                        The signature is in building process.. Please wait...

                        1 Reply Last reply
                        0
                        • R Rob Grainger

                          Luckily, that is not server side. Unluckily it is VB6.

                          "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                          R Offline
                          R Offline
                          Raybarg
                          wrote on last edited by
                          #13

                          Could this sentence be one of those which could be my last: "Whats wrong with VB6?"

                          R 1 Reply Last reply
                          0
                          • R Raybarg

                            Could this sentence be one of those which could be my last: "Whats wrong with VB6?"

                            R Offline
                            R Offline
                            Rob Grainger
                            wrote on last edited by
                            #14

                            It was fine for a product of its time, but is flawed compared to modern languages, for a whole variety of reasons. Wikipedia (VB on Wiki[^] mentions some of its shortcomings, but actually its not as bad as its reputation - it largely suffered from being easy to hack in, so a lot of VB6 programs have appalling design and plenty of moments that make your jaw drop. It really is truly awful at string-handling though - appending to a string would generally reallocate the whole thing, copy, then append. I came a across apps that frequently added 10-20 characters to a 10MB string, which would grind to halt due to this. It should absolutely not be used for any new projects, and existing code should be ported to alternatives now though - Microsoft dropped support a while ago, it will now only work (the IDE) on an XP machine (or VM), and there is no guarantee that the runtime will run on new versions of Windows.

                            "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                            R 1 Reply Last reply
                            0
                            • R Rob Grainger

                              It was fine for a product of its time, but is flawed compared to modern languages, for a whole variety of reasons. Wikipedia (VB on Wiki[^] mentions some of its shortcomings, but actually its not as bad as its reputation - it largely suffered from being easy to hack in, so a lot of VB6 programs have appalling design and plenty of moments that make your jaw drop. It really is truly awful at string-handling though - appending to a string would generally reallocate the whole thing, copy, then append. I came a across apps that frequently added 10-20 characters to a 10MB string, which would grind to halt due to this. It should absolutely not be used for any new projects, and existing code should be ported to alternatives now though - Microsoft dropped support a while ago, it will now only work (the IDE) on an XP machine (or VM), and there is no guarantee that the runtime will run on new versions of Windows.

                              "If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.

                              R Offline
                              R Offline
                              Raybarg
                              wrote on last edited by
                              #15

                              Thanks for clarification. I was in false impression that "VB" would be also referring to VB.NET but now I see VB.NET is just another compiler for .Net framework and is far from same thing as VB. Then there is VBA which I often confuse with too. Although VBA is something I have to use sometimes when some Excel-crazy person begs me do something within excel which seems only possible with VBA, then I get to tackle some hundred-sheet workbook with thousands character long cell functions.

                              1 Reply Last reply
                              0
                              Reply
                              • Reply as topic
                              Log in to reply
                              • Oldest to Newest
                              • Newest to Oldest
                              • Most Votes


                              • Login

                              • Don't have an account? Register

                              • Login or register to search.
                              • First post
                                Last post
                              0
                              • Categories
                              • Recent
                              • Tags
                              • Popular
                              • World
                              • Users
                              • Groups