Re: How does one commit using ODBC.
Date: Thu, 15 Oct 1998 12:12:20 GMT
Message-ID: <704or3$kne$1_at_nnrp1.dejanews.com>
Hi,
Commits in ODBC are done by one of 2 ways:
1/ SQLExecDirect("commit");
This is deprecated, frowned upon and regarded as inherently dodgy by the ODBC
spec; the results are at best "undefined".
2/ SQLTrans(0)
This is the proper way to force a transaction (0) or rollback (1) at a given
point in the application.
Regards,
~Tim
In article <3624CCEE.9E197C8B_at_stelnj.com>,
nospam_at_nospam.com wrote:
> Hi,
>
> I have an ODBC interface to Ada and it commits after every
> transaction.
>
> It does not have a commit or rollback command associated w/ it. I was
> wondering
> it there were come example of how it usally works to do a transation and
> then commit using ODBC.
>
> Thanks,
>
> reply to:
> smithm_at_stelnj.com
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 15 1998 - 14:12:20 CEST