#include <FBwQuery.h>
Public Methods | |
| FBwBQuery (FBwDb *pMdb) | |
| Constructor. | |
| void | Prepare () |
| void | UnPrepare () |
| void | SetSql (string sqltext) |
| Sets query sql text. | |
| string | GetSql () const |
| Get query sql text. | |
| void | Open () |
| Prepares the query for execution. | |
| void | Close () |
| Close the query. | |
| void | First () |
| For select query's moves to first record. | |
| void | Next () |
| For select query's moves to next record. | |
| bool | IsOpen () const |
| Tests wether the query is currently opened. | |
| bool | IsPrepared () |
| Tests wether the query is currently prepared. | |
| bool | Eof () |
| for Select querys tests wether the are no more rows for fetching | |
| bool | Bof () |
| for Select querys tests wether this is the first record | |
| bool | Error () |
| Tests for error condition. | |
| string | Text () |
| void | Debug () |
| void | GetLastError (BasicFBwErrorMgr *err) |
| virtual | ~FBwBQuery () |
| Destructor. | |
| void | DumpFields (std::ostream &o) const |
| Dumps fields to an ooutput stream. | |
| void | SetAutoCommit (bool how) |
| void | ExecSQL () |
| Executes a query. | |
Public Attributes | |
| FieldList | Fields |
| FieldList holding output fields for a select query. | |
| FieldList | Params |
| FieldList holding param for an insert, update or delete query. | |
Protected Methods | |
| void | ClearStatus () |
| virtual char * | GetSqlText () |
| Gets query text as char *. | |
| int | Fetch () |
| fetches data from an opened query used by First and Next methods | |
| XSQLDA * | CreateSqlda () |
| Create an init xsqlda. | |
| void | CreateParams () |
| Create an init Params List. | |
| bool | XSQLDAResize (XSQLDA **qx) |
| bool | Execute () |
| void | SqlStmtInfo () |
| Gets information about the dynamic sql statetment. | |
| void | VCommit () |
| Virtual commit. | |
| XSQLDA * | GetXSQLDA () |
| void | GenCursorName () |
| Generate unique cursor name. | |
Provides basic facilities to work with querys has no buffering, back navigation, nor update
Represents select, update or insert querys.
|
|
Constructor.
|
|
|
Gets query text as char *. the const_cast is used because ibase.h declares all non const char * so the user is responsible for not changing the pointer obtained |
|
|
Adjust xsqlvar[] size if necesary Executes the query |
1.2.17