|
Recently i saw a man that named tables like your example in MSAccess.
I asked him why?
He said "for security reasons".
His mind==>
|
|
|
|
|
That just looks like generated code (albeit poorly generated unless it is also obfuscated). I say, get a new application for generating the stuff. That is atrocious!
Matt
(Find your own niche! This one's mine.)
|
|
|
|
|
Do they also have a mandate that every second line should be blank, to improve readability?
Cheers,
Vikram.
"If a trend is truly global, then that trend ought to be visible across ANY subset of that data" - fat_boy
|
|
|
|
|
I couldnt stand this number salad: "Life is to short for that."
Greetings from Germany
|
|
|
|
|
I should work with tons of code like THAT. Fantastic, isn't it?
More like Craptastic...
Could be worse though. I knew a guy who only used the characters Q,O,0,1,I,l in his variable names. He evidently believed they should be hard to understand as well as hard to type....
'droid
|
|
|
|
|
God, I hate VB. All I want for Christmas is for you to smite the retards responsible for its existence....and if it pleases you, oh God: can you send some of the "Non"s with them?
This was written in 2005 in a VB.NET project
GoTo Error_Trap
End Try
Me.LBL_status.Text = ""
Else
Me.DV_Search.Visible = True
Me.DV_Results.Attributes("style") = "display:none"
Me.LBL_status.Text = "No Rows Returned."
End If
Exit Sub
Error_Trap:
ShowError()
...The "Business Logic", "Data Access" and "Presentation" layers are maintained not as separate projects inside a solution, but as FOLDERS!!! inside a single project. ...which results in a "hard-wired disgusting switch-boxed bastardization" of the layered pattern ...The mechanism that was chosen by our unqualified senior architect (who makes God knows how much a year) for accessing the database is to have the presentation layer do something like this:
Dim tbl As DataTable
tbl = Common.GetDataTable(SQLScripts.GetBaseEmpSql(UserID))
rather than having stored procedures encapsulate the sql scripts, the choice was made to maintain them in code. (Granted, I obfuscated the schema name and each of the table names so that I could post)
Public Shared Function getSQL(ByVal aryPVIDs() As String) As String
'aryPVIDs must be an array of pvids
Dim sql, strSelect, strFrom, strWhere As String
Dim strPVIDs As String
strPVIDs = Join(aryPVIDs, "','")
strSelect = "Select p.ID, p.Ps_Project_NBr, " & vbCrLf & _
" p.Project_Desc_txt, pt.Project_type_txt, p.project_type_cd, " & _
" p.spread_method_cd, sm.spread_method_txt, p.project_mgr_id, pm.last_nm||', '||pm.first_nm ProjectMgrFullName, " & vbCrLf & _
" p.asset_mgr_id, am.last_nm||', '||am.first_nm AssetMgrFullName, " & vbCrLf & _
" p.lead_eng_id, le.last_nm||', '||le.first_nm LeadEngineerFullName, " & vbCrLf & _
" p.start_dt, p.revised_start_dt, " & vbCrLf & _
" p.orig_serv_dt, p.revised_serv_dt, p.projected_serv_dt, " & vbCrLf & _
" p.host_flg, p.engineer_group_cd, eg.engineer_group_txt, " & vbCrLf & _
" p.Trans_region_cd, tr.transmission_region_txt, p.comments_txt, " & vbCrLf & _
" p.Distr_region_cd, dr.distr_region_txt, " & vbCrLf & _
" p.project_status_cd, priority_cd , archive_flg, " & vbCrLf & _
" ps.cpp, p.glbu, ps.ci_status_nbr ci_status, capital_flg, p.funding_type_cd, " & vbCrLf & _
" ps.funding_id, ft.funding_type_desc, " & vbCrLf & _
" p.outsourced_flg, p.asset_type_cd, at.asset_type_desc, p.asset_class_cd, ac.asset_class_desc, " & vbCrLf & _
" p.voltage_class_cd, vc.voltage_class_desc, p.outsourced_cd, o.outsourced_desc, " & vbCrLf & _
" p.budget_ind, pstat.project_status_txt, p.super_project, p.last_updated_by, p.last_updated_dt, " & vbCrLf & _
" (Select count(1) from xxx.yyy where id = p.ID) as mn_est_cnt, " & vbCrLf & _
" (Select count(1) from xxx.yyy where id = p.ID) as yr_est_cnt, " & vbCrLf & _
" p.created_by, cb.first_nm||' '||cb.last_nm CreatedByFullName, pf.last_updated_dt forecast_upd_dt, pf.last_updated_by forecast_upd_by, " & vbCrLf & _
" (select decode(count(*),0,0,1) from xxx.zzz where id = p.id) HasReimbursable, " & vbCrLf & _
" (SELECT first_nm || ' ' || last_nm FROM aaa WHERE employee_id = p.last_updated_by) lastUpdatedName, " & vbCrLf & _
" (SELECT first_nm || ' ' || last_nm FROM aaa WHERE employee_id = p.created_by) createdByName, " & vbCrLf & _
" get_states_by_project(p.id) as state_cd " & vbCrLf
strFrom = " from xxx.aaa p, xxx.bbb PT, xxx.aaa pm, " & vbCrLf & _
" xxx.aaa le, xxx.ccc eg, xxx.ddd tr, " & vbCrLf & _
" xxx.aaa am, xxx.aaa cb, xxx.eee sm, " & vbCrLf & _
" xxx.fff ps, xxx.ggg dr, " & vbCrLf & _
" xxx.hhh ac, xxx.iii at, xxx.ccc vc, " & vbCrLf & _
" xxx.jjj o, xxx.kkk ft, " & vbCrLf & _
" xxx.lll pstat, " & _
" (SELECT DISTINCT t1.id, t1.last_updated_dt, e.first_nm||' '||e.last_nm last_updated_by " & _
" FROM xxx.project_forecast t1, xxx.aaa e " & _
" WHERE e.employee_id = t1.last_updated_by and (t1.id, t1.last_updated_dt) IN " & _
" (SELECT id, max(last_updated_dt) FROM mmm" & _
" WHERE id IN ('" & strPVIDs & "') GROUP BY id ) ) pf "
strWhere = " where pf.id(+) = p.id and p.id in ('" & strPVIDs & "') and pt.project_type_cd(+) = p.project_type_cd " & vbCrLf & _
" and p.Project_Mgr_Id = pm.Employee_ID(+) and p.created_by = cb.Employee_Id(+) " & vbCrLf & _
" and p.Asset_Mgr_Id = am.Employee_Id(+) and p.spread_Method_cd = sm.spread_Method_cd(+) " & vbCrLf & _
" and p.Lead_Eng_ID = le.Employee_Id(+) and p.trans_region_cd = tr.transmission_region_cd(+) " & vbCrLf & _
" and p.engineer_group_cd = eg.engineer_group_cd(+) " & vbCrLf & _
" and p.ps_project_nbr = ps.ps_project_nbr(+) and p.distr_region_cd = dr.distr_region_cd(+) " & vbCrLf & _
" and p.asset_type_cd = at.asset_type_cd(+) and p.asset_class_cd = ac.asset_class_cd(+) " & vbCrLf & _
" and p.voltage_class_cd = vc.voltage_class_cd(+) " & vbCrLf & _
" and p.outsourced_cd = o.outsourced_cd(+) " & vbCrLf & _
" and p.funding_type_cd = ft.funding_type_cd(+) " & vbCrLf & _
" and p.project_status_cd = pstat.project_status_cd(+) "
sql = strSelect & strFrom & strWhere
Return sql
End Function
...There are no ObjectDataSources used, save for the ones in my sector of the system. All of the controls at the Presentation layer are bound directly to ADO.NET objects. ...Abso-frickin-lutely ridiculous
"I need build Skynet. Plz send code"
modified on Monday, January 21, 2008 11:02:39 AM
|
|
|
|
|
...btw, if you're a VB programmer and you think that I was insulting you or anything, then you misunderstood my intentions. ...My gripe is with the language and the reasoning behind the language....VB was designed to give "Non"programmers the ability to write quick, dirty desktop apps. I have a HUGE problem with VB being the language of choice in an enterprise setting, because most of the people that actually would say "Oh, I think we'll write this in VB. It does what we need to do" probably doesn't have the skill to make that decision. VB should never be used for anything other than "my app: I'm building it; I'm supporting it; It's running on my machine" Anything that is to actually be deployed to production should be written in a much more appropriate language because the GENERAL developer base for VB is absolute crap(a bunch of kiddie scripters that read a book and presto: qualified) ...and you end up with systems designed like the one that my snippets illustrate.
Again, not insulting ALL VB programmers(A qualified programmer is a qualified programmer is a qualified programmer) ...I write VB(mostly against my will, but what are you gonna do when the system was written in this horrible language and an enhancement comes your way?) ....Gripe about it.....every chance you get. GOD I HATE VB!!!!!
"I need build Skynet. Plz send code"
|
|
|
|
|
I suppose you don't actually *believe* in God.
ROFLOLMFAO
|
|
|
|
|
Why is your post not titled "I hate dumb ass VB programmers"?
I have seen equally as dumb ass stuff written in C++, C#, Pascal, etc...
The language is syntacticly FINE. It is the idiots that USE it that you have problems with.
|
|
|
|
|
Ray Cassick wrote: The language is syntacticly FINE.
Verbose though.
Ray Cassick wrote: It is the idiots that USE it that you have problems with.
That's certainly true, but that's the demographic to which it's marketed.
And having members of that demographic using C# isn't all that much better either.
|
|
|
|
|
The UnEducated (Mostly Indian/Russian/Chinese) Developers will always write poor programs no matter what the language. VB just makes it eaiser for them to do it!
I have seen some excellent and well written VB Programs
|
|
|
|
|
Hey! I write good programs!
ROFLOLMFAO
|
|
|
|
|
Ri Qen-Sin wrote: I write good programs!
I believe you... because you didn't say, "I write programs good!"
|
|
|
|
|
You don't say, "I write programs good!" You say, "I write programs well."
|
|
|
|
|
I've worked with some damn fine Indian developers ... although come to think about it they all learned the ropes with C++, Java and or C#. Perhaps it is VB
I'm largely language agnostic
After a while they all bug me
|
|
|
|
|
sulu wrote: I have seen some excellent and well written VB Programs
Refuting this is not my point. If you take a skilled developer and tell them to write something in VB, they can apply their skills to a bad situation and usually pull an app out of the crapper.
My point is that VB was never a language that was targeted at SKILLED developers. VB is a language that is targeted at...say, an accountant that knows how to write Excel macros and wants to come up with something to impress their manager. ...That's all fine and cool; IF IT STAYS THERE!!! ...when those people teach themselves VB and then consider themselves a "programmer" and slide into IT to screw systems up that someone like me has to go in and fix, there is DEFINITELY a problem.
Like I said: "A skilled developer is a skilled developer is a skilled developer" ....taken further, "A skilled C++ developer is a skilled Java developer is a skilled VB developer" ...The language itself is irrelevant. You should be able to throw any language at a skilled developer and have them write proficiently....the architects at Microsoft tried their damnedest to break this fact when they formulated Visual Basic
sulu wrote: The UnEducated (Mostly Indian/Russian/Chinese) Developers will always write poor programs no matter what the language. VB just makes it eaiser for them to do it!
I nearly completely disagree with this stereotype. There is an undeniable presence of "brain dump certifications" that are handed out overseas, but I don't think that you can make the blanket statement that Indian, Russian, or Chinese developers are intrinsically less qualified, which I'm not sure you actually are saying...maybe you're just using heavy-handed statements
"I need build Skynet. Plz send code"
|
|
|
|
|
sulu wrote: The UnEducated (Mostly Indian/Russian/Chinese) Developers will always write poor programs no matter what the language. VB just makes it eaiser for them to do it!
And what nationality is responsible for raising a person with such a biased , ignorant viewpoint ?
|
|
|
|
|
Ray Cassick wrote: The language is syntacticly FINE. It is the idiots that USE it that you have problems with.
...please tell me that you're just saying that to be argumentative and that you don't actually believe that crap...VB syntax is absolutely disgusting
Ray Cassick wrote: I have seen equally as dumb ass stuff written in C++, C#, Pascal, etc...
...Don't even get me started on C++ lol ...I *almost* hate C++ more than I hate VB. ...C++ is the bastard child that hangs out in the middle of nowhere that hybridizes the procedural mentality with object oriented design capabilities...when an unqualified programmer gets hold of ANY language, the results are laughable....when a *semi*qualified programmer gets hold of C++, O.....M......G. When you get someone that has a decent grasp of object oriented design, but they use a language that has a direct interface into memory as a staple of its core, you usually end up in the situation where an app starts out rock-solid up front: (Solid implementation of design patterns, the application is programmed to target interfaces; not implementations...etc) but when said "semi-qualified" programmer runs into a tough spot in their design...the approach is usually "Uh-oh...I don't know how to do that....what ****CAN**** I do. And C++ will allow them to take an otherwise well-structured body of work and stitch it together into a frankenstein monster that is more hideous than having to debug FORTRAN's GOTO structure
"I need build Skynet. Plz send code"
|
|
|
|
|
Alaric_ wrote: ...please tell me that you're just saying that to be argumentative and that you don't actually believe that crap...VB syntax is absolutely disgusting
Seconded. Verbosity for the sake of verbosity. An entire ethos developed around the idea that every concept needs at least 3 words summing 30 characters in length. Painful to write, painful to read.
Its like hungarian notation: a useful idea from the '70s painfully continued ad nauseum today.
I'm largely language agnostic
After a while they all bug me
|
|
|
|
|
Ray Cassick wrote: Why is your post not titled "I hate dumb ass VB programmers"?
Because if you think that's what I was saying, you either are incapable of(or you simply posted before)reading my follow-up to my original post.
I'll quote myself on this one:
Alaric_ wrote: ...btw, if you're a VB programmer and you think that I was insulting you or anything, then you misunderstood my intentions. ...My gripe is with the language and the reasoning behind the language....VB was designed to give "Non"programmers the ability to write quick, dirty desktop apps. I have a HUGE problem with VB being the language of choice in an enterprise setting, because most of the people that actually would say "Oh, I think we'll write this in VB. It does what we need to do" probably doesn't have the skill to make that decision. VB should never be used for anything other than "my app: I'm building it; I'm supporting it; It's running on my machine" Anything that is to actually be deployed to production should be written in a much more appropriate language because the GENERAL developer base for VB is absolute crap(a bunch of kiddie scripters that read a book and presto: qualified) ...and you end up with systems designed like the one that my snippets illustrate.
Again, not insulting ALL VB programmers(A qualified programmer is a qualified programmer is a qualified programmer) ...I write VB(mostly against my will, but what are you gonna do when the system was written in this horrible language and an enhancement comes your way?) ....Gripe about it.....every chance you get. GOD I HATE VB!!!!!
"I need build Skynet. Plz send code"
|
|
|
|
|
Ray Cassick wrote: language is syntacticly FINE. It is the idiots that USE it that you have problems with.
I ditto that. The same code could have been done in any other language and looked just as bad.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Paul Conrad wrote: I ditto that. The same code could have been done in any other language and looked just as bad.
I think I could make some reasonable disagreement with that. When I'm forced to use VB.NET, I think differently than when I'm using C#. The C# language can do things VB.NET can't; and while I do try hard to retain the clarity of work I do in C#, the language itself gets in the way.
It's like being a highly skilled acrobat trying to walk down a straight hallway when all of the strangely shaped objects on the floor keep moving, trying to trip you. VB is those moving objects. The language itself seems designed to prevent clarity of thought.
It has become appallingly obvious that our technology has exceeded our humanity. - Albert Einstein
|
|
|
|
|
Patrick Sears wrote: hard to retain the clarity of work I do in C#, the language itself gets in the way.
Can you give an example? Only problem I have is switching back to C# from VB.NET and forgetting ; sometimes.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Then i guess the problem is you, and not the language. Programming languages are just tools used to create what we imagine. If you lack skill and imagination you cannot write any sensible code with C# or C++.
I work with VB most of the time, but I can develop in C# or C++ easily without any problems.
Most people are decieved into thinking writing code that "looks" complex makes them skilled.
C++ code normally looks like the following, it mostly contains symbols and therefore makes it look like it belongs to a so called skilled programmer.
<br />
_ATL$Main<br />
{<br />
__ *HRESULT ^ pointer!:<br />
<br />
?0x000007-IXc<br />
x++<br />
}
|
|
|
|
|
What the bloody hell are you talking about?
I'm not talking about writing complex code. You think VB is simple? Please. All the extra fluff simply obscures what the program does. You want to deride programs for "looking" complex to make the writer seem skilled, berate VB.
I have no problem in Matlab, C#, C++, or C. My problem is not a lack of imagination, you sanctimonious twit. VB, however, gives me hives because it is so verbose.
Believe it or not, there actually CAN be tools that are ineffective at making our mental constructs a reality. For instance, you wouldn't use a tire iron to build a fence. Maybe some people are really good at building fences with tire irons. Personally, I would find the tire iron to get in the way.
Now, if you replace "fence" with "program" and "tire iron" with "VB" you'll get what I'm saying. Maybe some people are good at writing programs in VB. For me, the language gets in the way. All tools are not equal, which is essentially what you're attempting to argue.
It has become appallingly obvious that our technology has exceeded our humanity. - Albert Einstein
|
|
|
|
|