Transactions? I have a few questions... 
Author Message
 Transactions? I have a few questions...

I keep on experiencing problems with transations in some following cases.
I tried to find something in the KB but could't find any relating info.  If
you have any experience with transaction, please help me.

CDaoRecordset rst;
rst.m_pDatabase->m_pWorkspace->BeginTrans ();
[ a few changes in the query using Edit () and Update () ]
rst.Requery ();
[ a few changes in the query using Edit () and Update () ]
rst.m_pDatabase->m_pWorkspace->CommitTrans ();                    // throws
an excpetion as if the transaction had not been begun (?)

and what happens if:

rst.Edit ();
rst.m_pDatabase->m_pWorkspace->BeginTrans ();
[ values written to rst using SetFieldValue () ]
rst.Update ();
rst.m_pDatabase->m_pWorkspace->CommitTrans ();     OR    
rst.m_pDatabase->m_pWorkspace->Rollback ();

or what if:

rst.Edit ();
rst.m_pDatabase->m_pWorkspace->BeginTrans ();
[ values written to rst using SetFieldValue () ]
rst.m_pDatabase->m_pWorkspace->CommitTrans ();     OR    
rst.m_pDatabase->m_pWorkspace->Rollback ();
rst.Update ();

Please mail me directly too.
Thank you a lot for your help.

Cezary Nolewajka




Mon, 12 Jul 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. A few questions for the VC++ Team

2. A few questions on standards conformance.

3. Few questions reguarding System::Windows::Forms::Control...(

4. ATL Server (web apps) - few questions

5. A few Questions

6. a few questions

7. A few questions...

8. Newbie C Learner.. a few questions

9. A few C questions....

10. A few C-related Questions (linked lists, and parsing)

11. A few C questions

12. A few more newbie questions

 

 
Powered by phpBB® Forum Software