Then you don't need a thirty-line table at all...

This is becoming religious and I don't see anyone convincing anyone else. You've all got your methods; use them. I have an extra tool that I can use with or without your blessing. So I'm not going to beat this example to death; it was a bad example from the beginning because it only gains significance if scaled up, which was part of the issue I was trying to avoid. If you can't generalize the concept from the example, then again we go nowhere, and the gain frankly isn't worth it even if one of us happened to convince another.

The only point I WILL make at this juncture, is this:

Then you don't need a thirty-line table at all...but a numeric variable NumberOfToolSetsRented somewhere, that fluctuates between zero and thirty.

Um... get thee behind me? This is, IMO, a far WORSE solution, since you are now hard-coding minute details of the transaction INTO A FREAKING VARIABLE NAME. What was that about scaling up? I give it...six months before such a horrible hack would get taken back out of the code. Make an invoice object with a Qty property, maybe, but NumberOfToolSetsRented is going too far.

Post #108,369 by CRConrad 7/3/03 3:51:15 PM Reply	Then you don't need a thirty-line table at all... ...but a numeric variable `NumberOfToolSetsRented` somewhere, that fluctuates between zero and thirty. Worst case, you have to have a (one-line) table to keep it in. Then you can just update that table (increase or decrease the value by one) every time a toolset gets rented out or returned... And the way to do that is, of course, by using a stored procedure. Oh, and if you ever find you only have twentynine toolsets on hand, and want to know which customer didn't actually return his as he was supposed to, then what do you do? Then you wish you'd bar-coded your toolchests and used the `ToolChestID` value of the barcode as a primary key, that's what do you do. [link\|mailto:MyUserId@MyISP.CountryCode\|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.) Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link\|http://z.iwethey.org/forums/render/content/show?contentid=71575\|Ashton Brown]
Post #108,404 by mmoffitt 7/3/03 10:56:12 PM Reply	Thank you. bcnu, Mikem The soul and substance of what customarily ranks as patriotism is moral cowardice and always has been...We have thrown away the most valuable asset we had-- the individual's right to oppose both flag and country when he (just he, by himself) believed them to be in the wrong. We have thrown it away; and with it all that was really respectable about that grotesque and laughable word, Patriotism. - Mark Twain, "Monarchical and Republican Patriotism"
Post #108,435 by FuManChu 7/4/03 1:18:46 PM Reply	Should I answer? This is becoming religious and I don't see anyone convincing anyone else. You've all got your methods; use them. I have an extra tool that I can use with or without your blessing. So I'm not going to beat this example to death; it was a bad example from the beginning because it only gains significance if scaled up, which was part of the issue I was trying to avoid. If you can't generalize the concept from the example, then again we go nowhere, and the gain frankly isn't worth it even if one of us happened to convince another. The only point I WILL make at this juncture, is this: Then you don't need a thirty-line table at all...but a numeric variable `NumberOfToolSetsRented` somewhere, that fluctuates between zero and thirty. Um... get thee behind me? This is, IMO, a far WORSE solution, since you are now hard-coding minute details of the transaction INTO A FREAKING VARIABLE NAME. What was that about scaling up? I give it...six months before such a horrible hack would get taken back out of the code. Make an invoice object with a `Qty` property, maybe, but `NumberOfToolSetsRented` is going too far. I'm gonna go build my own theme park! With Blackjack! And hookers! In fact, forget the park!

Welcome to IWETHEY!