Oracle 5.0, Справочное руководство

Страница: 2240 / 3232

C API Prepared Statement Function Descriptions
2220
bind[0].length= &length;
bind[0].is_null= 0;
/* Bind the buffers */
if (mysql_stmt_bind_param(stmt, bind))
{
fprintf(stderr, "\n param bind failed");
fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
exit(0);
}
/* Supply data in chunks to server */
if (mysql_stmt_send_long_data(stmt,0,"MySQL",5))
{
fprintf(stderr, "\n send_long_data failed");
fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
exit(0);
}
/* Supply the next piece of data */
if (mysql_stmt_send_long_data(stmt,0,
" - The most popular Open Source database",40))
{
fprintf(stderr, "\n send_long_data failed");
fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
exit(0);
}
/* Now, execute the query */
if (mysql_stmt_execute(stmt))
{
fprintf(stderr, "\n mysql_stmt_execute failed");
fprintf(stderr, "\n %s", mysql_stmt_error(stmt));
exit(0);
}
20.6.10.26.
mysql_stmt_sqlstate()
const char *mysql_stmt_sqlstate(MYSQL_STMT *stmt)
Description
For the statement specified by
stmt
,
mysql_stmt_sqlstate()
returns a null-terminated string
containing the SQLSTATE error code for the most recently invoked prepared statement API function
that can succeed or fail. The error code consists of five characters.
"00000"
means “no error.” The
values are specified by ANSI SQL and ODBC. For a list of possible values, see Appendix C, Errors,
Error Codes, and Common Problems .
Note that not all MySQL errors are yet mapped to SQLSTATE codes. The value
"HY000"
(general
error) is used for unmapped errors.
Return Values
A null-terminated character string containing the SQLSTATE error code.
20.6.10.27.
mysql_stmt_store_result()
int mysql_stmt_store_result(MYSQL_STMT *stmt)
Description
Result sets are produced by calling
mysql_stmt_execute()
to executed prepared
statements for SQL statements such as
SELECT
,
SHOW
,
DESCRIBE
, and
EXPLAIN
. By default,
result sets for successfully executed prepared statements are not buffered on the client and
mysql_stmt_fetch()
fetches them one at a time from the server. To cause the complete result
set to be buffered on the client, call
mysql_stmt_store_result()
after binding data buffers with