Well, how this code is supposed to work:
CASE lcTriggerType = "UPDATE" ;
AND laRelations[i, PARENTCOL] = lcTable
What if I have Trans_Employees_Queues and Trans tables?
UPDATE. I take it back. It does have SET EXACT ON which I didn't notice.
>PMFJI but if it aren't broken ...
>
>>Thanks, Craig. Do you think it's a good idea to slightly improve the code? E.g. I glanced at it yesterday and noticed the loop through array of relations. In our current database we have 252 relations (sic!) So my thought was that we can use ascan instead. But I don't know if it's worth the effort or the code is executed fast enough anyway.
If it's not broken, fix it until it is.
My Blog