HDFql Reference Manual v2.6.0

5.2.21hdfql_subcursor_last

Syntax

int hdfql_subcursor_last(HDFQL_CURSOR *cursor)

Description

Move the subcursor in use to the last position within the result subset. In other words, the subcursor will point to the last element of the result subset, and its position is set to the value returned by hdfql_subcursor_get_count - 1. If the result subset is empty, an error is returned, and its position remains unchanged (i.e. remains minus one).

Parameter(s)

cursor – pointer to a cursor to move the subcursor in use to the last position within the result subset. If the pointer is NULL (in C), the subcursor of the cursor in use is moved to the last position instead. The equivalent of a NULL pointer in C++, Java, Python, C#, Fortran, R, and MATLAB HDFql wrappers is NULL, null, None, null, NULL(), NULL, and NaN, respectively. While in C cursor is mandatory, in C++, Java, Python, C#, Fortran, R, and MATLAB it is optional (when not specified, the subcursor of the cursor in use is moved to the last position instead).

Return

int – depending on the success in moving the subcursor to the last position within the result subset, it can be HDFQL_SUCCESS, HDFQL_ERROR_EMPTY, HDFQL_ERROR_BEFORE_FIRST, or HDFQL_ERROR_AFTER_LAST.

Example(s)

// create an HDF5 dataset named "my_dataset" of data type variable-length int of two dimensions (size 2x2)
hdfql_execute("CREATE DATASET my_dataset AS VARINT(2, 2)");

// insert (i.e. write) values into dataset "my_dataset" 
hdfql_execute("INSERT INTO my_dataset VALUES(((7, 8, 5), (9)), ((6, 1, 2, 3), (4, 0)))"); 

// select (i.e. read) data from dataset "my_dataset" and populate cursor in use with it 
hdfql_execute("SELECT FROM my_dataset");

// move the cursor in use to the first position within the result set 
hdfql_cursor_first(NULL);

// display position of subcursor in use within the result subset (should be "Position of subcursor is -1")
printf("Position of subcursor is %lld\n", hdfql_subcursor_get_position(NULL)); 

// move the subcursor in use to the last position within the result subset 
hdfql_subcursor_last(NULL);

// display (again) position of subcursor in use within the result subset (should be "Position of subcursor is 2")
printf("Position of subcursor is %lld\n", hdfql_subcursor_get_position(NULL));