If you need for special job yes otherwise no need and also no need to specify it many times.set connection's transaction one time and all query will follow connection. Regards, Ara -- http://www.fastmail.com - Does exactly what it says on the tin