Re-inventing the wheel
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Wow, thanks, I didn't know that was there.:-O Teach me to read the instructions, I suppose. "Any clod can have the facts, but having opinions is an art." Charles McCabe, San Francisco Chronicle
-
Wow, thanks, I didn't know that was there.:-O Teach me to read the instructions, I suppose. "Any clod can have the facts, but having opinions is an art." Charles McCabe, San Francisco Chronicle
Stan Shannon wrote: Wow, thanks, I didn't know that was there. Teach me to read the instructions, I suppose. Don't worry, you are not the only one. In fact I have yet to meet even a DBA who knows about that Wizard feature in EM. Hell, I brought up this point at a Microsoft event and the guy presenting SQL 2000 to us said that the only tools he knew of to auto-generate SPs were third party tools! Also I will warrant all us "real" coders shy away from anything labelled "Wizard." Using a Wizard is like using VB. :rolleyes:
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
-
Stan Shannon wrote: Wow, thanks, I didn't know that was there. Teach me to read the instructions, I suppose. Don't worry, you are not the only one. In fact I have yet to meet even a DBA who knows about that Wizard feature in EM. Hell, I brought up this point at a Microsoft event and the guy presenting SQL 2000 to us said that the only tools he knew of to auto-generate SPs were third party tools! Also I will warrant all us "real" coders shy away from anything labelled "Wizard." Using a Wizard is like using VB. :rolleyes:
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
I was just playing with it though, and it doesn't really do much for you if you need to do joins etc. Does it? Or do I still need to read the instructions? "Any clod can have the facts, but having opinions is an art." Charles McCabe, San Francisco Chronicle
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Yeah, I've had that happen - spend days implementing something only to discover that someone else already has, but just gave it an illogical name so you never found it when you searched for something that did what you were after :| -- Help me! I'm turning into a grapefruit!
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Heck, if we didn't re-invent the wheel all the time, we wouldn't make as much money off of our clients. Right now I'm sitting here working on how to format a report so that the client's address and the customer's address fits in that see through window part of the envelope. How many times has that been done? But you know why I'm doing it? Because I'm using a report writer that I wrote (because in those days, there was no such thing as Crystal Reports, and besides, have you ever tried to use CR???) Anyways, the cool thing about your tool is that: 1. It's useful for other database engines other than M$; 2. It'll be really useful when M$ removes the "wizard"; 3. It's tweakable. The wizard isn't; 4. It's embedable. I can use it as a wizard in my own apps! So don't fret too much. Marc Help! I'm an AI running around in someone's f*cked up universe simulator.
Sensitivity and ethnic diversity means celebrating difference, not hiding from it. - Christian Graus
Every line of code is a liability - Taka Muraoka -
Heck, if we didn't re-invent the wheel all the time, we wouldn't make as much money off of our clients. Right now I'm sitting here working on how to format a report so that the client's address and the customer's address fits in that see through window part of the envelope. How many times has that been done? But you know why I'm doing it? Because I'm using a report writer that I wrote (because in those days, there was no such thing as Crystal Reports, and besides, have you ever tried to use CR???) Anyways, the cool thing about your tool is that: 1. It's useful for other database engines other than M$; 2. It'll be really useful when M$ removes the "wizard"; 3. It's tweakable. The wizard isn't; 4. It's embedable. I can use it as a wizard in my own apps! So don't fret too much. Marc Help! I'm an AI running around in someone's f*cked up universe simulator.
Sensitivity and ethnic diversity means celebrating difference, not hiding from it. - Christian Graus
Every line of code is a liability - Taka MuraokaMarc Clifton wrote: Anyways, the cool thing about your tool is that... :-O :-D Thanks mate :) Marc Clifton wrote: address fits in that see through window part of the envelope LOL We had the exact same requirement in our last project. We also had to print "folding" guidelines on the paper so that the Delivery Receipt letter was folded correctly. Ugh! Oh, and this was a website. You just try doing printing from the web without some client side control. Totally insane.
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
-
Marc Clifton wrote: Anyways, the cool thing about your tool is that... :-O :-D Thanks mate :) Marc Clifton wrote: address fits in that see through window part of the envelope LOL We had the exact same requirement in our last project. We also had to print "folding" guidelines on the paper so that the Delivery Receipt letter was folded correctly. Ugh! Oh, and this was a website. You just try doing printing from the web without some client side control. Totally insane.
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Paul Watson wrote: Oh, and this was a website. You just try doing printing from the web without some client side control. Totally insane. Tell me about it. I once had to create and invoice that printed the header and footer on each page and the page number, all using HTML!!! Of course the page was generated by ASP. It took the use of fixed width fonts and lots of trial and error to figure out the exact number of order lines that can fit on the page. And all for something they decieded not to deploy in the end because there was no real reason for it in the first place. It was just the whim of a manager that didn't know what he was doing (wait, is that an oxymoron?) Three weeks of my life, gone. Jason Gerard "This almost never matters, except quite often."
-
Paul Watson wrote: Oh, and this was a website. You just try doing printing from the web without some client side control. Totally insane. Tell me about it. I once had to create and invoice that printed the header and footer on each page and the page number, all using HTML!!! Of course the page was generated by ASP. It took the use of fixed width fonts and lots of trial and error to figure out the exact number of order lines that can fit on the page. And all for something they decieded not to deploy in the end because there was no real reason for it in the first place. It was just the whim of a manager that didn't know what he was doing (wait, is that an oxymoron?) Three weeks of my life, gone. Jason Gerard "This almost never matters, except quite often."
Jason Gerard wrote: Three weeks of my life, gone on the interview for my last job, the manager asked me "if you worked on something for two weeks then found out we didn't need it, would you be upset?" i answered truthfully, "yes." he astutely replied, "i don't think you'll be happy here." we were both right. -c
-
Jason Gerard wrote: Three weeks of my life, gone on the interview for my last job, the manager asked me "if you worked on something for two weeks then found out we didn't need it, would you be upset?" i answered truthfully, "yes." he astutely replied, "i don't think you'll be happy here." we were both right. -c
Chris Losinger wrote: on the interview for my last job, the manager asked me "if you worked on something for two weeks then found out we didn't need it, would you be upset?" i answered truthfully, "yes." he astutely replied, "i don't think you'll be happy here." haha.. At least they were upfront with you about not having a clue. Jason Gerard "This almost never matters, except quite often."
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Paul Watson wrote: That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. But yours is so cool - and we can say "a friend made this" :cool: And of course, you got to learn and have fun while making it.
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some-it won't hurt you'... -Christian Graus on Code Project outages His thoughts tumbled in his head, making and breaking alliances like underpants in a tumble dryer. It hurt the way your tongue hurts after you accidentally staple it to he wall**-Shaun Wilde**
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Hah, you think that's something. Get a load of the number of IPicture derived classes that exist on CP. Everybody's out to prove they can make their own version of the same class. C++ versions Peter Hendrix http://www.codeproject.com/bitmap/cpicture.asp Yovav Gad http://www.codeproject.com/bitmap/pictureshow.asp Wilhem Svenselius (aka W2k) http://planetcpp.tk/ derived from Peter Hendrix CPicture added a function to draw portion of an image DanG http://www.codeproject.com/useritems/ExtendedBitmap.asp Derived from Peter Hendrix CPicture, except for drawing functions Base class is set to CBitmap. Drawing to screen is done via CBitmap functions. Eugene Khodakovsky http://www.codeproject.com/bitmap/picturestream.asp C versions Wes Rogers http://www.codeproject.com/bitmap/render.asp goofy http://www.codeproject.com/bitmap/load\_jpeg\_\_gif\_resource..asp
-
Arrgghhh! You know when you bemoan something for ages and then ten minutes after having actually done something about it, you find someone else has already done it? In fact that someone else was the very makers of the thing you were bemoaning. In fact the very thing you were bemoaning, and fixed, had been in the thing you were bemoaning all the time? Arrgghhhhh! That just happened to me with the SPGen tool of mine. Matt just showed me that SQL Enterprise Manager already has a Stored Procedure generator in it. Tools \ Wizards *click* Expand Database \ Create Stored Procedure Wizard *click* *sigh* Aaarrrgghhh! Still, I had fun making the app, and I learnt some tricks in coding it. So not wasted effort. But still... Aaarrrgghhhh!
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Take a number - the same thing happened to me with my MSDE tool, I found most of it was in the IDE already. Christian No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002
C# will attract all comers, where VB is for IT Journalists and managers - Michael P Butler 05-12-2002
Again, you can screw up a C/C++ program just as easily as a VB program. OK, maybe not as easily, but it's certainly doable. - Jamie Nordmeyer - 15-Nov-2002 -
Paul Watson wrote: Oh, and this was a website. You just try doing printing from the web without some client side control. Totally insane. Tell me about it. I once had to create and invoice that printed the header and footer on each page and the page number, all using HTML!!! Of course the page was generated by ASP. It took the use of fixed width fonts and lots of trial and error to figure out the exact number of order lines that can fit on the page. And all for something they decieded not to deploy in the end because there was no real reason for it in the first place. It was just the whim of a manager that didn't know what he was doing (wait, is that an oxymoron?) Three weeks of my life, gone. Jason Gerard "This almost never matters, except quite often."
Jason Gerard wrote: Tell me about it. I once had to create and invoice that printed the header and footer on each page and the page number, all using HTML!!! Just on that did you ever manage to control the browsers header and footer from the server side? We have not found a way and have had to rely on the user editing the options in their Page Setup. Damned annoying.
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
-
Jason Gerard wrote: Tell me about it. I once had to create and invoice that printed the header and footer on each page and the page number, all using HTML!!! Just on that did you ever manage to control the browsers header and footer from the server side? We have not found a way and have had to rely on the user editing the options in their Page Setup. Damned annoying.
Paul Watson
Bluegrass
Cape Town, South AfricaShog9 wrote: Everybody just wants to be naked and famous, Paul.
Paul Watson wrote: Just on that did you ever manage to control the browsers header and footer from the server side Not sure what you mean exactly. Jason Gerard "This almost never matters, except quite often."