update delay response sql
Hi there experts,
I've got a question for you guys... the thing is that I'm updating via XI a sql table, and that update raises a trigger at sql database that also updates another table. When message comes out from XI it actually updates the first sql table, but since the trigger is updating another table, the first one responses XI with a COUNTER = 0 (as if it hasn't been updated, but it was successfully updated actually). Is there any way of setting a delay or maybe catching up the triggered table COUNTER?