Re: SQL statement Scope

> I just have one question, what is the scope of set isolation and set lock > mode statement in .ec files They take effect when they are executed, and remain in effect until you issue a different level by way of the same appropriate statement. There is a myth on some sites that a cursor preserves the same isolation level throughout its life cycle, as it took when it was declared. This is quite untrue. You could (and probably should) change it to reflect the exact needs of the open, fetch, update or whatever that you're about to issue. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------- +44 117 974 2815