Question: Is it possible to change the trigger data for a specific item

[loops6972]

I need to return the results of a query when an item is inserted rather than the row data.

I can create a trigger that would do this but the app seems to rewrite the trigger even after the connection is made (i deleted and updated with my trigger, but it seemed to revert to the original code anyways)

Is there a way to prevent the overwrite if already exists or to change the trigger on load?

My table inserts about every couple seconds and I am loosing some messages due to the time it takes to re-do the query after the message has been received to get the actual data I need and this should speed it up quite a bit...

Any help or ideas would be appreciated.

Thanks