DataBlade API Programmer's Manual

DataBlade API Programmer's Manual
Chapter 12: DataBlade API Function Descriptions

Home Contents Index Master Index New Book

mi_last_serial()

The mi_last_serial() function returns a SERIAL value that the database server has generated for the most recent INSERT statement on a SERIAL8 column.

Syntax

mi_integer mi_last_serial(conn, serial_val)

		MI_CONNECTION *conn;

		mi_integer serial_val; 


conn
is a pointer to the connection descriptor that a previous call to mi_open() or mi_server_connect() established.

serial_val
is the new SERIAL value that the mi_last_serial() function obtains.







 



Valid in Client Application?

Valid in Server Routine?

Yes
Yes

Usage

The database server automatically generates values for SERIAL columns when it executes an INSERT statement on the column. Use the mi_last_serial() function to obtain this system-generated value for your DataBlade routine.

To use the mi_last_serial() function in a DataBlade API client application, call it after the INSERT has completed; that is when the mi_get_result() function has returned the MI_DML statement.

DataBlade API Programmer's Manual
Chapter 12: DataBlade API Function Descriptions

Home Contents Index Master Index New Book

mi_last_serial()

Syntax

Usage

Return Values

MI_OK
The function was successful.

MI_ERROR
The function was not successful.

Related Topics

DataBlade API Programmer's ManualChapter 12: DataBlade API Function Descriptions Home Contents Index Master Index New Book

mi_last_serial()

Syntax

Usage

Return Values MI_OK The function was successful. MI_ERROR The function was not successful.

Related Topics

DataBlade API Programmer's Manual
Chapter 12: DataBlade API Function Descriptions

Home Contents Index Master Index New Book

Return Values

MI_OK
The function was successful.

MI_ERROR
The function was not successful.