TLama

118 reputation

TLama (extraordinary class type)

Delphi, C++ and Assembler enthusiast, InnoSetup insider, C# newbie

“Programs must be written for people to read, and only incidentally for machines to execute.”
– Abelson and Sussman

“If you have a procedure with ten parameters, you probably missed some.”
– Alan Perlis

“Make everything as simple as possible, but not simpler.”
– Albert Einstein

“The difference between theory and practice is that in theory, there is no difference between theory and practice.”
– Richard Moore

“I think it’s a new feature. Don’t tell anyone it was an accident.”
– Larry Wall

♫ Dead Can Dance - Rakim
♫ Playing For Change - Imagine
♫ Playing For Change - Chanda Mama

You may occasionally catch me on tlama@inbox.com if you want to. And yes, that little kitty from my profile picture has boss eyedness :-)

Jumping smiley

	118 reputation	bio	website		visits	member for	1 year, 1 month
14 badges		location	Czech Republic		seen	Apr 20 at 16:55

Mar 17	awarded	Notable Question
Dec 10	awarded	Popular Question
May 10	accepted	What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?
Apr 9	comment	What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint? I hope so, but nothing changes for me in this case, if I want to support both I need to use triggers. Thanks anyway!
Apr 9	comment	What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint? +1ed, so that is valid also for SQL server, not only for MySQL ?
Apr 9	comment	What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint? @ypercube, so you would prefer to delete related rows by your own. I like that however I need to perform some calculations over that when the rows are deleted, again back to SO, to calculate what is the overall score of the question (of course my case is much more complicated).
Apr 9	awarded	Scholar
Apr 9	comment	What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint? Thanks! Just one sidenote; I haven't mentioned in my Q that I was planning to use triggers along with the cascade actions, but there's a note in `MySQL 5.5. reference`, cascaded foreign key actions do not activate triggers, so now I'm thinking about to use only triggers.
Apr 9	awarded	Supporter
Apr 9	awarded	Student
Apr 9	asked	What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?