>
Sorry to steal your instructor time for free, but out of curiosity... Would have it mattered if recursive was turned on? I would think that as the second call to the trigger there would be no records complying with WHERE Inserted.nStndCost # Deleted.nStndCost as the only field updated within the trigger was dStndCost, thus ending the trigger and the recursion with some overhead. >
>Hi, Hugo, good question. To be honest, aside from any impact of additional overhead, I don't know of any additional harm in this instance. (Though since they're disabled by default, one would only use them for specific reasons). Maybe someone else reading this can jump in.
Thanks Kevin.
I was reading my question again and it is a little miracle that you were able to understand it, as it looks as if I used some grammar from hell <g>
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges