|
Fortunately, there's a VB-coding consultant working for us, so it looks like i can push the problem off on him... 
----
It appears that everybody is under the impression that I approve of the documentation. You probably also blame Ken Burns for supporting slavery.
--Raymond Chen on MSDN
|
|
|
|
|
You lucky sob!
I did not think VB6 programmers should have been writing DLLs to begin with, I considered it a ridiculous idea even when I was forced to use that language for the main interface. All of my DLLs and COMs where written in C or C++.
I have yet to decide about VB.Net.
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
John R. Shaw wrote: I did not think VB6 programmers should have been writing DLLs to begin with,
I do not think VB6 programmers should be doing around anything with coding.
|
|
|
|
|
That is the wave of the future – coding without understanding.
Modern MS languages are good for business – but it requires real programmers to create the frame works first. What that means is that people who understands how it all works decreases and the number of people who know how to use it increases.
Translation: If you know how it all works there are fewer jobs – If you know how to use it there are lots of jobs.
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
I've just stopped smoking and drinking at the same time, I'm working on abominable VB6 and VBA code between Acess and SQL Server, so I took on a little job for extra money, and I've just received the script for the table I am to code a front end for. Field names have been changed to preserve confidentiality.
The one redeeming point is that there is no code here, I get to insert fresh, sexy, new C# code.
CREATE TABLE "dbo"."clientTable" (
"oneField" varchar(8000),
"abotherField" varchar(8000),
"andGgain" varchar(8000),
"totalOf" varchar(8000),
"21fields" varchar(8000),
"like" varchar(8000),
"this" varchar(8000),
...
...
)
GO
|
|
|
|
|
INSERT INTO clientTable VALUES("a","b","c","d"....That's going to be fun - a database that's in negative numbers for normal form. I see that they don't want Unicode either; obviously because it takes up so much space
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
"What's in a name?..." -- Bill S.
|
|
|
|
|
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row.
SQL Server 2000, anyway. SQL Server 2005 might do something different since it now supports varchar(max), but I think you actually have to use that syntax to get out-of-row varchar fields. SQL Server 2000 makes you use the slightly-differently-behaving text datatype, which confusingly can be set to be stored in the row if it's below a certain length of data.
(If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)
|
|
|
|
|
Mike Dimmick wrote:
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row.
No, but I have just received the refreshing news that we have carte blanch with the databases for our development. This is a small company, and they are actually running seven different databases on the same server!
Not for too long I suppose.
|
|
|
|
|
There is nothing wrong with running seven different databases on the same server. SQL Server is designed to do that. It depends on your definition of "database", and it is the actual size of each database and the number of users which will determine your hardware requirement, not the "number of databases" which has almost no bearing on your hardware choices.
The "not for too long" here is the lack of types in the tables. You obviously know the problem with that. Just don't go around in a small startup company telling people you need more hardware, or it will be you that's not around for too long. Tell them how to run all those databases on a cheaper server and get better performance out of it... and they'll give you a raise. Shouldn't be too much trouble to improve things, given where you're starting from.
|
|
|
|
|
In this case there is. My application had to do a cross-database query just to get user rights. This client only has one application, which uses all seven databases. I suspect they were all imported from Access at different times, without the benefit of qualified consultants like they have now.
|
|
|
|
|
I just see big dollar signs in a situation like that 
|
|
|
|
|
Yes, me too, just barely visible over the horizon, but approaching
"A little learning is a dangerous thing; drink deep, or taste not the Pierian spring: there shallow draughts intoxicate the brain, and drinking largely sobers us again.", by Alexander Pope
My Blog
|
|
|
|
|
Mike Dimmick wrote: (If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)
Kramer did it.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
I do not know about Brady, but I have two hands. 
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
LOL - was each filed to hol the chapter of a book! LOL - oh the horror!
|
|
|
|
|
Congrats on quitting! 
My father did that too, when he decided that he did not like what he saw when looking in the mirror at his local bar. He put down his drink, threw away is cigarettes, and walked home.
The last time I tried to seriously quit smoking I discovered exactly how much of a stimulant it was. I was driving to work, 45 minutes at the time, and drove off the side of the road. It turns out my coffee was not the only thing waking me up.
As for drinking, my grandfather drank until his death at 92 and I expect to be doing the same; the drinking part, not the reaching 92 part.
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
Thanks, but I haven't quit yet, I've only started quitting. The drinking is only for a break, to give my poor body some rest. I was getting into a risky situation of drinking every night, to soften the ravages felt from the previous night. Then on weekends, Friday night made having more than a few beers on Saturday inevitable, and so on, and Monday mornings were just not good.
The cigarettes I hope to see the end of permanently. I have stopped smoking before, for up to two years, and then the demon weed insidiously crept back into my life. I casual smoke here or there over a beer etc. but then I was much younger, and now that I'm 37 I feel it's time to really get rid of that poison.
|
|
|
|
|
Smart, very smart, sounds similar to my story. Quit smoking for 2 years and then started back up to piss someone off, my Ex. At 37 I was still playing pool and drinking every night for hours, but I was no longer enjoying that. I still like my glass of bourbon or some beer in the evenings, but rarely go out any more because I fall back into the old pattern and tend to stay tell closing.
Suggestion: Take up running or long vigorous walks, during either and afterwards you normally do not want a smoke. It also gives you time to think without any distractions or you can just observe the world around, very relaxing if you ignore the garbage people leave along the roads and paths.
Good Luck!
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
Hi
i want to change the header on sort
for example
when i click the header of grid pax_name it schould change to pax_name(ASC)
and so on Descending pax_name(Desc)
i write code int he sortcommand event of the datagrid by using viewstate.
Bind();
if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString() == "DESC")
{
dv.Sort = e.SortExpression;
ViewState["SortExpression"]= e.SortExpression + "ASC";
ViewState["SortOrder"] = "ASC";
}
else
{
dv.Sort = e.SortExpression + " DESC";
ViewState["SortExpression"]= e.SortExpression + " DESC";
ViewState["SortOrder"] = "DESC";
}
dgHistory.DataBind();
-- modified at 3:20 Tuesday 24th April, 2007
|
|
|
|
|
This is Code Horros Forum, hence
you (perhaps us?) missed something...
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
SQL2 = "SELECT Firstname,Surname FROM tblMembers where ID='"&rg
<b>i have change this code to the following one</b>SQL2 = "SELECT Firstname,Surname FROM tblMembers where ID='"&rg&"'"
<b>but am still an error message for this line</b>:<b>Data type mismatch in criteria expression.</b>set RS = objConn.Execute (SQL2)
please help
|
|
|
|
|
So, what forum did you think this was again?
----
It appears that everybody is under the impression that I approve of the documentation. You probably also blame Ken Burns for supporting slavery.
--Raymond Chen on MSDN
|
|
|
|
|
Where i work, we have an aspx page with a single 750 line function for page load.
It works by posting querystring data back to itself, and It's order of execution is backwards, i.e. the first bit of executed logic is at the end of the function, and in some cases it goes 12 branch statements deep.
Fun :S
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
So, wait, 12 postbacks before the user gets a usable web page?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
