2 of 2 people found this helpful
This can be achieved when using the tag distribution strategy in the RDBMS interface, where you can execute an UPDATE statement immediately following your SELECT statement. I suggest you refer to page 57 in the RDBMS interface manual for more information, and then have a look at the example on page 210. I haven't actually used this myself, but it looks straight forward enough to implement.
Thanks John. Will give it a shot and see how we go.