void |
setSQL(const char *sql) |
Set SQL for execution. |
boolean |
exec() |
Exec SQL. No data returned. Returns true if successful, or false on error. |
boolean |
open() |
Exec SQL and return dataset. Returns true if successful, or false on error. The cursor is on first position (first position is 0) |
void |
close() |
Close dataset |
void |
next() |
Fetch next recod. The cursor is moved to next position (You do not need to call this for accessing first record). |
boolean |
eof() |
Returns true if last record reached. Returns true if next() crashed. |
unsigned int |
getFieldCount() |
Returns column count in dataset |
const char * |
getFieldName(unsigned int no) |
Returns column name. First column is 0 |
const char * |
getFieldData(unsigned int no) |
Returns column data as string. First column is 0 |
long int |
getAffectedCount() |
Returns affected (inserted, deleted, updated) record count after INSERT,
UPDATE, DELETE SQL statements. Returns 1, if this feature is not suported |
long int |
getRecordCount() |
Returns record count in dataset. Returns -1, if this feature is not suported |
boolean |
gotoRecordNum(unsigned long int) |
Move the cursor to specified position. (only few databases support this) Returns false, if this feature is not suported |