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"

Reply via email to