Objective Grid: Transactions with ODBC grids

Article ID: 368
Last updated: 27 Apr, 2018
Article ID: 368
Last updated: 27 Apr, 2018
Revision: 3
Views: 1763
Posted: 24 Jan, 2001
by Meltreger B.
Updated: 27 Apr, 2018
by Meltreger B.

Problem

 


Why doesn't BeginTrans()/CommitTrans() work with ODBCGrid?

 

 


Cause

 


 

 


Action

 


Transactions are turned off by default for odbc grids because in most cases when BeginTrans() is called with an ODBC grid (e.g. when you do Find/Replace or other operations), the operation cannot be undone in the grid. Therefore the ODBC grid implementation of BeginTrans() simply calls pDatabase->BeginTrans().

However, in the specific situation you are mentioning here, if you need to batch two commands together and you know which database operation is involved, you can call CGXGridCore::BeginTrans() and CGXGridCore::CommitTrans() instead.

This article was:   Helpful | Not helpful
Report an issue
Article ID: 368
Last updated: 27 Apr, 2018
Revision: 3
Views: 1763
Posted: 24 Jan, 2001 by Meltreger B.
Updated: 27 Apr, 2018 by Meltreger B.

Others in this category