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.
  • 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