Re: [BUGS] Transactions from Visual C++

2006-08-26 Thread Jim Nasby
On Aug 23, 2006, at 7:31 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote: Let us assume that the second statement fails because value 'b' is illegal. Either the ODBC driver or the DBMS now rejects all follow-on queries with the error message: Error while executing the query; ER

[BUGS] Transactions from Visual C++

2006-08-23 Thread Christof.Paal
Hi, I noticed that the database engine does not let you implement your own transaction logic from Microsoft VC++ applications. The database automatically rolls back when the first error occurs, not the way it is programmed. Consider the following example: void RunMyQuery(CDatabase* pDB, LPCTSTR