Good grief
-
I'm debugging some legacy VB X| code to figure out why a report is crashing, and encountered this fragment of SQL code:
e.TerminalType *= f.TerminalType:omg: The last time I encountered a left outer join specified in that way was probably 20 years ago. MarcImperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
The thing I hate most about syntax like that is that if you're not familiar with it it's near impossible to google.
-
I'm debugging some legacy VB X| code to figure out why a report is crashing, and encountered this fragment of SQL code:
e.TerminalType *= f.TerminalType:omg: The last time I encountered a left outer join specified in that way was probably 20 years ago. MarcImperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Marc Clifton wrote:
The last time I encountered a left outer join specified in that way was probably 20 years ago.
Makes sense. That's also about the last time VB was considered a good idea. :rolleyes:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
Marc Clifton wrote:
The last time I encountered a left outer join specified in that way was probably 20 years ago.
Makes sense. That's also about the last time VB was considered a good idea. :rolleyes:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Nah - we thought it was rubbish back then too. ;)
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
Nah - we thought it was rubbish back then too. ;)
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
-
Nah - we thought it was rubbish back then too. ;)
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
20 years ago it was considered a good idea by some people (the people churning out crap in it by choice). That people who preferred MFC, raw win32, or whatever *nix used at the time all thought it was a festering swamp doesn't change that then there were people who thought it a good idea for writing software (as opposed to a for a drinking game).
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
Marc Clifton wrote:
The last time I encountered a left outer join specified in that way was probably 20 years ago.
Makes sense. That's also about the last time VB was considered a good idea. :rolleyes:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Nah, VB was, for a while, good for a very specific purpose: Writing simple GUI tools and database frontends quickly, without having to worry (much) about destabilizing the rest of the system or leaking out all the RAM with a badly-written MFC app. It was never meant for high-end computing or commercial applications, though I've seen it used for both. Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels) -
Nah, VB was, for a while, good for a very specific purpose: Writing simple GUI tools and database frontends quickly, without having to worry (much) about destabilizing the rest of the system or leaking out all the RAM with a badly-written MFC app. It was never meant for high-end computing or commercial applications, though I've seen it used for both. Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Ian Shlasko wrote:
Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Fortunately(?) by the time your Excel turns into exHell it'll be slow enough that the bullet won't be able to break your skin. I had one of those too, as an initial proof of concept I ported the big nasty data mangling step to C# and called it from the VBA using COM (with was a cluster elephant in and of itself). It dropped the run time on our worst data set from ~6 hours to 45 seconds. Of which ~30 were spent scraping the spreadsheet and sending it over COM, 15 were spent by C# to do the data mangling, and <1 was spent to write the much smaller data set back to the spreadsheet. The truly amazing bit was that the intern/very junior dev (not sure if he went full time before or after writing it) managed to get the >1000 lines of very complex logic copy pasta with about 8 intend levels and gotos to short circuit another half dozen working and fully debugged. :omg:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
Nah, VB was, for a while, good for a very specific purpose: Writing simple GUI tools and database frontends quickly, without having to worry (much) about destabilizing the rest of the system or leaking out all the RAM with a badly-written MFC app. It was never meant for high-end computing or commercial applications, though I've seen it used for both. Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Ian Shlasko wrote:
It was never meant for ... commercial applications
LOL says who? I've written many a commercial app and website using it, what else were we supposed to use? It's like anything, the second it is superseded all of a sudden people talk like it's rubbish and always was. When .net is superseded people will be slagging it off saying how garbage it was, how assembly binding via configuration and convention was a stupid idea and so on.
-
The thing I hate most about syntax like that is that if you're not familiar with it it's near impossible to google.
-
F-ES Sitecore wrote:
if you're not familiar with it it's near impossible to google.
It's because at that time we didn't have google... Nor internet... I think we did have colour TV though ;)
Mika Wendelius wrote:
I think we did have colour TV though ;)
With a remote control that was attached by a long wire :)
-
I'm debugging some legacy VB X| code to figure out why a report is crashing, and encountered this fragment of SQL code:
e.TerminalType *= f.TerminalType:omg: The last time I encountered a left outer join specified in that way was probably 20 years ago. MarcImperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Marc Clifton wrote:
e.TerminalType *= f.TerminalTypeI've been forced to use that format when writing for older Oracle systems. So, it may not be the language that is/was the issue, it may be the data source. The implication being.. such a join may be seen in other languages like C, C#, etc.
-
Nah, VB was, for a while, good for a very specific purpose: Writing simple GUI tools and database frontends quickly, without having to worry (much) about destabilizing the rest of the system or leaking out all the RAM with a badly-written MFC app. It was never meant for high-end computing or commercial applications, though I've seen it used for both. Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Quote:
It was never meant for high-end computing or commercial applications,
And yet it is used for both, I know of at least one application where when it was found the reaction was "Oh No, change it!" Followed by "Well it has worked reliably for the X years, trust us you don't want to mess with this code as it is too wide spread to make a fix all update". It is used in flight control systems of a very well known heavy lift helicopter.:~
-
I'm debugging some legacy VB X| code to figure out why a report is crashing, and encountered this fragment of SQL code:
e.TerminalType *= f.TerminalType:omg: The last time I encountered a left outer join specified in that way was probably 20 years ago. MarcImperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
I recently encountered ( +) in an Oracle query. It's the same thing, except this query was written a week earlier... :sigh: I had never seen that syntax by the way, not in Oracle or SQL Server :D
Read my (free) ebook Object-Oriented Programming in C# Succinctly. Visit my blog at Sander's bits - Writing the code you need. Or read my articles here on CodeProject.
Simplicity is prerequisite for reliability. — Edsger W. Dijkstra
Regards, Sander
-
Quote:
It was never meant for high-end computing or commercial applications,
And yet it is used for both, I know of at least one application where when it was found the reaction was "Oh No, change it!" Followed by "Well it has worked reliably for the X years, trust us you don't want to mess with this code as it is too wide spread to make a fix all update". It is used in flight control systems of a very well known heavy lift helicopter.:~
glennPattonWorking wrote:
It is used in flight control systems of a very well known heavy lift helicopter.
:wtf:
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels) -
Ian Shlasko wrote:
Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Fortunately(?) by the time your Excel turns into exHell it'll be slow enough that the bullet won't be able to break your skin. I had one of those too, as an initial proof of concept I ported the big nasty data mangling step to C# and called it from the VBA using COM (with was a cluster elephant in and of itself). It dropped the run time on our worst data set from ~6 hours to 45 seconds. Of which ~30 were spent scraping the spreadsheet and sending it over COM, 15 were spent by C# to do the data mangling, and <1 was spent to write the much smaller data set back to the spreadsheet. The truly amazing bit was that the intern/very junior dev (not sure if he went full time before or after writing it) managed to get the >1000 lines of very complex logic copy pasta with about 8 intend levels and gotos to short circuit another half dozen working and fully debugged. :omg:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Yeah, I could tell some horror stories about a portfolio management system written in Excel... But given that this is a public forum and I'm using my real name, I think I'll refrain :)
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels) -
glennPattonWorking wrote:
It is used in flight control systems of a very well known heavy lift helicopter.
:wtf:
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)When I was include on the Email chain it was truely a :wtf: moment. what better (or worse) it was using VB5!!
-
Nah, VB was, for a while, good for a very specific purpose: Writing simple GUI tools and database frontends quickly, without having to worry (much) about destabilizing the rest of the system or leaking out all the RAM with a badly-written MFC app. It was never meant for high-end computing or commercial applications, though I've seen it used for both. Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Ian Shlasko wrote:
It was never meant for high-end computing or commercial applications
Are you sure? Microsoft had - 16-17 years ago - DNA Labs all over the word, where Microsoft gave the help to port enterprise-scale applications to VB6... My boss felt for it and I spend there half a year and cursed for an other two, before we moved back to c++...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
I'm debugging some legacy VB X| code to figure out why a report is crashing, and encountered this fragment of SQL code:
e.TerminalType *= f.TerminalType:omg: The last time I encountered a left outer join specified in that way was probably 20 years ago. MarcImperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project! Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
... aaand back to therapy... :sigh:
-
Mika Wendelius wrote:
I think we did have colour TV though ;)
With a remote control that was attached by a long wire :)
-
Yeah, I could tell some horror stories about a portfolio management system written in Excel... But given that this is a public forum and I'm using my real name, I think I'll refrain :)
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Don't get me started on having very important calculations written in VBA, I have known my fair share of Actuaries.
if (Object.DividedByZero == true) { Universe.Implode(); } Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016
