Using Win32 functions in Visual FoxPro Image Gallery
Extensible Storage Engine (ESE, Jet Blue)
JetAddColumn
JetBeginSession
JetBeginTransaction
JetCloseDatabase
JetCloseTable
JetCommitTransaction
JetCreateDatabase
JetCreateInstance
JetCreateTable
JetDeleteTable
JetDetachDatabase
JetEndSession
JetGetColumnInfo
JetGotoBookmark
JetInit
JetMove
JetOpenTable
JetPrepareUpdate
JetRetrieveColumn
JetRollback
JetSetColumn
JetTerm
JetUpdate
Code examples:
Extensible Storage Engine class library
JetCommitTransaction
..msdn    Add comment     W32 Constants      Translate this page
Commits the changes made to the state of the database during the current save point and migrates them to the previous save point.
Code examples:
Extensible Storage Engine class library
Declaration:
JET_ERR JET_API JetCommitTransaction(
  __in          JET_SESID sesid,
  __in          JET_GRBIT grbit
);
FoxPro declaration:
DECLARE INTEGER JetCommitTransaction IN esent;
    INTEGER sesid,;
    INTEGER grbit
Parameters:
sesid
The session to use for this call.

grbit
A group of bits specifying zero or more of predefined options.
Return value:
Returns the JET_ERR datatype with a predefined return code.
Usage:
LOCAL nBookmark, nBookmarkSize
nBookmarkSize=4

THIS.errorno = JetUpdate(THIS.jetsessionid, THIS.jettableid,;
    @nBookmark, m.nBookmarkSize, @nBookmarkSize)

IF THIS.errorno <> 0
    = JetRollback(THIS.jetsessionid, 0)
    THIS.errormessage = "JetUpdate call failed."
    RETURN .F.
ENDIF

= JetCommitTransaction(THIS.jetsessionid, 0)
My comment:
On success, any changes made to the database during the current save point for the given session will be committed and that save point will be ended. If the last save point for the session was ended then the transaction will optionally be flushed to the transaction log file and the session will exit the transaction.

On failure, the transactional state of the session will remain unchanged. No change to the database state will occur. The application should call JetRollback to abort the transaction.

See also: JetBeginTransaction, JetRollback
Word Index links for the JetCommitTransaction :
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2008-01-13 14:13:49
Modified: 2008-01-13 14:17:25
Visited in last 7 days: 5
User Contributed Notes:
There are no notes on this subject.


Copyright 2001-2014 News2News, Inc. Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use. The information on this page is presented AS IS, meaning that you may use it at your own risk. Microsoft Visual FoxPro and Windows are trade marks of Microsoft Corp. All other trademarks are the property of their respective owners. 

Privacy policy
Credits: PHP (4.4.9), an HTML-embedded scripting language, MySQL (5.1.68), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (54.204.168.212)
1 min.
Function group: 'Keyboard Input'
4.3 min.Function: 'JetCreateDatabase'
Function group: 'Extensible Storage Engine (ESE, Jet Blue)'
5.89 hrs.Function: 'midiOutGetNumDevs'
Function group: 'Windows Multimedia'
5.9 hrs.Example: 'Class for sound recording'
5.92 hrs.Function: 'JetCommitTransaction'
Function group: 'Extensible Storage Engine (ESE, Jet Blue)'
5.95 hrs.Example: 'How to generate GUID values'
Google
Advertise here!