hc_pstmt_query_ez

Retrieves OIDs and optionally name-value records matching a prepared statement.

Synopsis

     hcerr_t hc_pstmt_query_ez(*pstmt,hc_string_t selects[],
          int n_selects,
          int results_per_fetch, 
          hc_query_result_set_t **rsetp);

Description

This function retrieves OIDs and optionally name-value records matching a prepared statement. hc_qrs_next_ez is used to access the results in the result set. If the selects list is NULL, only OIDs are retrieved. If selects is not NULL, name-value records are also retrieved and should each be freed using hc_nvr_free. In both cases the result set should be freed using hc_qrs_free.

When a query is incorrect and elicits an error from the server, the error is often reported after hc_qrs_free and not from hc_pstmt_query_ez. Your application should be prepared to receive and report an error from either place.

Parameters

pstmt

IN: Prepared statement generated by hc_pstmt_create.

selects

IN: Points to an array of hc_string_t, each of which is the name of a field to retrieve from the metadata (select clause). Set to NULL to only retrieve OIDs matching the query.

n_selects

IN: The number of items in the select clause.

results_per_fetch

IN: The number of results per internal fetch.

rsetp

OUT: Updated to point to the new result set. See hc_query_result_set_t.

Return Codes

     HCERR_OK
     HCERR_OOM
     HCERR_BAD_REQUEST
     HCERR_NULL_SESSION
     HCERR_INVALID_SESSION
HCERR_ILLEGAL_ARGUMENT

See Also

hc_pstmt_create