Hi, how do I get my SQL7 session to automatically commit my posts to the database? I have an app, that when running against our sql6.5 server, auto-commited, but not on sql7, I've gone through and added 'commit' queries after my update/inserts which seems to work fine when I have "inplicit transactions' set on the datbase (at the server side), but I don't really like this. How can I a) set implicit transactions -just- for my session, or b) set auto-commit on for my session. Do I need to put something in my TDatabase's Params property? Mark -- There are exceptions, I'm sure, but the Windows 2000 on-line community seems to have, in general, the moral and spiritual qualities of your average porn site. (c) Bryan Pfaffenberger, Linux Journal, Jan 2001. --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"