Hi George,This is almost certainly as a result of the "TRANS cache" inside the query processor. There is, I believe, an assumption that the data isn't changing during the query.
Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB+44-(0)1604-709200
_______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users