OpenDBX/C API/odbx result

int odbx_result(
    odbx_t* handle,
    odbx_result_t** result,
    struct timeval* timeout,
    unsigned long chunk )

Description:

Retrieves the result of a query statement sent by odbx_query() from the database server. On success, a dynamically allocated object representing the result is stored in "result". Otherwise the "result" pointer is set to NULL.

The third parameter restricts the time the function is waiting for a result. It may be NULL to wait until a result arrives. Otherwise it can contain any number of seconds and microseconds in a timeval structure to wait for. The timeval structure must be set each time before calling odbx_result() because its content may be changed by the function. Waiting the specified time may be implemented in the backends if it is possible, but there is no guarantee.

Dependent on the backend, it may be possible to retrieve all results at once (if "chunk" is zero), one by one or more at once. If paging (more at once) is not supported by the backend, it will use "one by one" or "all at once" if this is the only option provided.

This function must be called multiple times until it returns zero, even if you know your query contains only one statement. If you don't do this, memory may be leaked.

Parameters:

• handle: Connection object created by odbx_init()
• result: Pointer to a result pointer
• timeout: Amount of time waiting for a result
• chunk: Number of rows to fetch at once

Return values:

• Three if a result is available
• Two if the query was not SELECT-like
• One in case of a timeout
• Zero if no more results are available
• Less than zero if an error occured

Errors:

• -ODBX_ERR_PARAM: One of the parameters or its content is invalid
• -ODBX_ERR_NOMEM: Allocating new memory failed
• -ODBX_ERR_RESULT: Waiting of result failed
• -1: Any error retured by the backend

---

Back to Overview