Subject | Re: [IBO] problem with .Commit |
---|---|
Author | Helen Borrie |
Post date | 2001-10-18T17:10:55Z |
At 03:21 PM 18-10-01 +0000, you wrote:
What do you see in the SQL Trace?
Check that your Keylinks are correct.
Also, show us the actual code snippets where you are starting, testing and committing your transaction.
regards,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>Hi,What do you see in the callstack?
>
>After converting from BDE to Interbase I cannot get transactions to
>work despite trying out lots of stuff. Calling .Commit results in an
>Access Violation in ib_utils.
What do you see in the SQL Trace?
>I don't need multiple transactionsIf you are using StartTransaction, then Autocommit will be suspended. But if you don't plan to use Autocommit, make it False.
>since I usually want this scenario:
>
>starttransaction
>(lots of writes)
>commit
>and if an error undo EVERYTHING
>
>
>Could it be one of my property settings?
>
>Autocommit = true;
>TIB_Database being used (with TwwIBOTables)TwwIBOTable is a descendant of TIBOTable. Use TIBODatabase. Also make sure that the version of Infopower you are using actually needs TwwIBOTable. The more recent distributions use TIBOTable.
Check that your Keylinks are correct.
>No Transaction components, using all defaultsIf changing to TIBOTable and TIBODatabase doesn't fix your problem, do the traces and see what is being passed and report back with any additional information.
Also, show us the actual code snippets where you are starting, testing and committing your transaction.
regards,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________