Cursor
[C API]


Detailed Description

A cursor is used to navigate the contents of a table or the result of an SQL query.

To obtain a cursor handle for a table, call db_open_table_cursor. To create a cursor from an SQL statement, call db_prepare_sql_cursor and then db_execute.

See also:
SQL


Data Structures

struct  db_table_cursor_t
 Table cursor settings. More...

Typedefs

typedef struct db_cursor_t_s * db_cursor_t

Functions

db_result_t db_table_cursor_init (db_table_cursor_t *)
db_result_t db_table_cursor_destroy (db_table_cursor_t *)
db_cursor_t db_open_table_cursor (db_t, const db_objname_t *table, const db_table_cursor_t *)
db_cursor_t db_duplicate_cursor (db_cursor_t, db_flags_t flags)
db_result_t db_close_cursor (db_cursor_t)
db_flags_t db_get_cursor_flags (db_cursor_t)
db_fieldno_t db_find_field (db_cursor_t, const db_objname_t *)
db_fieldno_t db_get_field_count (db_cursor_t)
db_result_t db_get_field (db_cursor_t, db_fieldno_t, db_fielddef_t *)
int db_bof (db_cursor_t)
int db_eof (db_cursor_t)
db_result_t db_seek_first (db_cursor_t)
db_result_t db_seek_next (db_cursor_t)
db_result_t db_seek_prior (db_cursor_t)
db_result_t db_seek_last (db_cursor_t)
db_result_t db_seek (db_cursor_t, db_seek_t, db_row_t, db_object_t, db_fieldno_t nfields)
db_result_t db_fetch (db_cursor_t, db_row_t, db_object_t)
db_result_t db_insert (db_cursor_t, db_row_t, db_object_t, db_flags_t)
db_result_t db_delete (db_cursor_t, db_flags_t)
db_result_t db_update (db_cursor_t, db_row_t, db_object_t)
db_result_t db_get_bookmark (db_cursor_t, db_oid_t *)
db_result_t db_goto_bookmark (db_cursor_t, const db_oid_t *)
db_result_t db_set_range (db_cursor_t h, db_row_t low_row, db_object_t low_object, db_fieldno_t low_fields, db_row_t high_row, db_object_t high_object, db_fieldno_t high_fields)
db_result_t db_qseek (db_cursor_t, db_seek_t, const db_bind_t *, db_len_t, db_object_t, db_fieldno_t nfields)
db_result_t db_qfetch (db_cursor_t, const db_bind_t *, db_len_t, db_object_t)
db_result_t db_qinsert (db_cursor_t, const db_bind_t *, db_len_t, db_object_t, db_flags_t)
db_result_t db_qupdate (db_cursor_t, const db_bind_t *, db_len_t, db_object_t)


Copyright © 2005-2007 ITTIA®. All rights reserved.