Main Page | Modules | File List | Globals | Related Pages | Examples

Transaction control functions


Defines

#define sqlo_autocommit_on(_dbh)   sqlo_set_autocommit(_dbh, SQLO_ON)
 A macro used to set autocommit on.
#define sqlo_autocommit_off(_dbh)   sqlo_set_autocommit(_dbh, SQLO_OFF)
 A macro used to set autocommit off.

Functions

int sqlo_commit (sqlo_db_handle_t dbh)
 Commit.
int sqlo_rollback (sqlo_db_handle_t dbh)
 Rollback.
int sqlo_set_autocommit (sqlo_db_handle_t dbh, int on)
 sqlo_set_autocommit
int sqlo_autocommit (sqlo_db_handle_t dbh)
 sqlo_autocommit

Define Documentation

#define sqlo_autocommit_off _dbh   )     sqlo_set_autocommit(_dbh, SQLO_OFF)
 

A macro used to set autocommit off.

executes sqlo_set_autocommit( dbh, SQLO_OFF )

Parameters:
_dbh I - A database handle.
See also:
sqlo_set_autocommit
Since:
Version 2.3.2

Definition at line 1252 of file sqlora.h.

#define sqlo_autocommit_on _dbh   )     sqlo_set_autocommit(_dbh, SQLO_ON)
 

A macro used to set autocommit on.

executes sqlo_set_autocommit( dbh, SQLO_ON )

Parameters:
_dbh I - A database handle.
See also:
sqlo_set_autocommit
Since:
Version 2.3.2

Definition at line 1239 of file sqlora.h.


Function Documentation

int sqlo_autocommit sqlo_db_handle_t  dbh  ) 
 

sqlo_autocommit

Returns the state of the autocommit flag. Either SQLO_ON or SQLO_OFF

Parameters:
dbh I - A database handle.
Returns:
  • SQLO_ON
  • SQLO_OFF
  • SQLO_INVALID_DB_HANDLE
See also:
sqlo_set_autocommit
Since:
Version 2.3.2

int sqlo_commit sqlo_db_handle_t  dbh  ) 
 

Commit.

Execute a commit on this database.

Parameters:
dbh I - A database handle.
Returns:
  • SQLO_SUCCESS
  • < 0 on error

int sqlo_rollback sqlo_db_handle_t  dbh  ) 
 

Rollback.

Execute a rollback on this database.

Parameters:
dbh I - A database handle.
Returns:
  • SQLO_SUCCESS
  • < 0 on error
Examples:
ex16.c.

int sqlo_set_autocommit sqlo_db_handle_t  dbh,
int  on
 

sqlo_set_autocommit

Set autocommit on the attached server on or off.

Autocommit is off by default.

Note:
If you change the setting, it is valid until you detach from the server (sqlo_server_detach or sqlo_finish). If you stay attached and change the session via sqlo_session_end and sqlo_session_begin, the autocommit setting is the same as before.
Parameters:
dbh I - A database handle.
on I - SQLO_ON or SQLO_OFF
Returns:
  • SQLO_SUCCESS
  • SQLO_INVALID_DB_HANDLE
See also:
sqlo_autocommit
Since:
Version 2.3.2


Generated on Mon Apr 24 09:45:35 2006 for libsqlora8 by  doxygen 1.3.9.1