PersonResponsible
-
Today I had occasion to create a property called 'PersonResponsible'. It struck me as such a nice if quaint idea. People being responsible for stuff. Remember that? -Rd
Richard A. Dalton wrote:
People being responsible for stuff. Remember that?
I remember very well, every day! There aren't many recognised job titles that are recognised under law as having responsibility, let alone where the individual has to be registered. We do stress very well![^] The formal assessment required as part of obtaining the position was the most stressful thing I have ever done in my life to date!
Dave Find Me On: Web|Facebook|Twitter|LinkedIn CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
-
personResponsibleId in the database is allowed to be null.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
SET IDENTITY_INSERT TableOfTasks ON
INSERT INTO TableOfTasks(PersonResponsibleID, ...) VALUES(-1, ...)
SET IDENTITY_INSERT TableOfTasks OFFPeople always find a way to dodge responsibility. EDIT: Now that I think about it, only TableOfTasks.TaskID would be likely to be an identity column. Would be interesting if the person responsible got automatically assigned using some auto-incrementing number. New version below:
UPDATE TableOfTasks SET PersonResponsibleID = -1 WHERE PersonResponsibleID = @MyID
There we go. That should dodge responsibility nicely. :rolleyes:
-
SET IDENTITY_INSERT TableOfTasks ON
INSERT INTO TableOfTasks(PersonResponsibleID, ...) VALUES(-1, ...)
SET IDENTITY_INSERT TableOfTasks OFFPeople always find a way to dodge responsibility. EDIT: Now that I think about it, only TableOfTasks.TaskID would be likely to be an identity column. Would be interesting if the person responsible got automatically assigned using some auto-incrementing number. New version below:
UPDATE TableOfTasks SET PersonResponsibleID = -1 WHERE PersonResponsibleID = @MyID
There we go. That should dodge responsibility nicely. :rolleyes:
truncate task;
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
-
truncate task;
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
CREATE TRIGGER SwallowData ON Tasks AFTER INSERT
BEGIN
TRUNCATE Tasks
ENDThere we go... a more maintainable solution. :)
-
personResponsibleId in the database is allowed to be null.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost
I thought it could only be set to null.
Steve Maier
-
Sadly, in many organisations you could equally well implement it as a property named "ConvenientScapegoat". :~
Anna :rose: Tech Blog | Visual Lint "Why would anyone prefer to wield a weapon that takes both hands at once, when they could use a lighter (and obviously superior) weapon that allows you to wield multiple ones at a time, and thus supports multi-paradigm carnage?"
Why Anna, you're getting cynical in your old age...
Software Zen:
delete this;
Fold With Us![^] -
Why Anna, you're getting cynical in your old age...
Software Zen:
delete this;
Fold With Us![^]Gary R. Wheeler wrote:
old age
Well I never! It should be referred to as "maturity". ;)
-
Richard A. Dalton wrote:
People being responsible for stuff. Remember that?
I remember very well, every day! There aren't many recognised job titles that are recognised under law as having responsibility, let alone where the individual has to be registered. We do stress very well![^] The formal assessment required as part of obtaining the position was the most stressful thing I have ever done in my life to date!
Dave Find Me On: Web|Facebook|Twitter|LinkedIn CPRepWatcher now available as Packaged Chrome Extension, visit my articles for link.
Me too, sometimes. "Responsible Person" in terms of regulations enacted under some Act of Parliament. I'm a volunteer member of the Rural Fire Service, a State government body. When I put on my Aviation Radio Operator hat, I'm operating under federal legislation that authorises me to use aviation band radio "for firefighting and related purposes". One of the tasks is to check and record, at least every half hour, that every aircraft on my patch is alive and well, along with its occupants. At the end of the day, I scrawl my name and autograph at the bottom of the page where it says "Name of Responsible Person" and "Signature of Responsible Person". Normally, the form winds up in a file somewhere, but if there's any kind of incident at all involving an aircraft, that form is one of the first things the investigators go for, along with our radio logs. There is a well-defined list of things to do when an aircraft is 5, 10, 15 minutes overdue, but routine radio calls come fairly low on the chopper pilot's priority list when he's carrying a bucket with 1500 litres of water through smoke to some fire front he can't see and trying to guess where the other choppers are. So we cut them a few minutes slack. I got the phone call from hell on my second day of ARO duty. "Hi, State Air Desk here. Have you lost one?" I had to do a three day course to get the ARO qualification, and I not only have to redo it to recertify every five years, but I must maintain "currency" - using the skills for real or in a live exercise - every 14 months.
Software rusts. Simon Stephenson, ca 1994.
-
Gary R. Wheeler wrote:
old age
Well I never! It should be referred to as "maturity". ;)
-
Me too, sometimes. "Responsible Person" in terms of regulations enacted under some Act of Parliament. I'm a volunteer member of the Rural Fire Service, a State government body. When I put on my Aviation Radio Operator hat, I'm operating under federal legislation that authorises me to use aviation band radio "for firefighting and related purposes". One of the tasks is to check and record, at least every half hour, that every aircraft on my patch is alive and well, along with its occupants. At the end of the day, I scrawl my name and autograph at the bottom of the page where it says "Name of Responsible Person" and "Signature of Responsible Person". Normally, the form winds up in a file somewhere, but if there's any kind of incident at all involving an aircraft, that form is one of the first things the investigators go for, along with our radio logs. There is a well-defined list of things to do when an aircraft is 5, 10, 15 minutes overdue, but routine radio calls come fairly low on the chopper pilot's priority list when he's carrying a bucket with 1500 litres of water through smoke to some fire front he can't see and trying to guess where the other choppers are. So we cut them a few minutes slack. I got the phone call from hell on my second day of ARO duty. "Hi, State Air Desk here. Have you lost one?" I had to do a three day course to get the ARO qualification, and I not only have to redo it to recertify every five years, but I must maintain "currency" - using the skills for real or in a live exercise - every 14 months.
Software rusts. Simon Stephenson, ca 1994.
-
Today I had occasion to create a property called 'PersonResponsible'. It struck me as such a nice if quaint idea. People being responsible for stuff. Remember that? -Rd
Richard A. Dalton wrote:
People being responsible for stuff. Remember that?
Vaguely :|
cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP
-
Why Anna, you're getting cynical in your old age...
Software Zen:
delete this;
Fold With Us![^]Gary R. Wheeler wrote:
Why Anna, you're getting cynical in your old age...
I fear I've encountered too many disfunctional organisations. :~ ...but OLD, you kidding? Nah. Just happy. :)
Anna :rose: Tech Blog | Visual Lint "Why would anyone prefer to wield a weapon that takes both hands at once, when they could use a lighter (and obviously superior) weapon that allows you to wield multiple ones at a time, and thus supports multi-paradigm carnage?"
-
Today I had occasion to create a property called 'PersonResponsible'. It struck me as such a nice if quaint idea. People being responsible for stuff. Remember that? -Rd
Richard A. Dalton wrote:
People being responsible for stuff. Remember that?
:laugh: yeah, and then I discovered I could yoink the spatula out of moms hand and never had to worry about that sort of silly stuff again. :rolleyes:
3x12=36 2x12=24 1x12=12 0x12=18