Executes the SQL statement specified by the string argument.

Syntax

a_sqlany_stmt * sqlany_execute_direct( a_sqlany_connection * conn, const char * sql )

Parameters

Remarks

Use this function if you want to prepare and execute a statement, or instead of sqlany_prepare followed by sqlany_execute. Do not use this function to execute a SQL statement with parameters.

Returns

A statement handle when the function executes successfully, NULL when the function executes unsuccessfully.

See also

• sqlany_fetch_absolute function
• sqlany_fetch_next function
• sqlany_num_cols function
• sqlany_get_column function

Example

 stmt = sqlany_execute_direct( conn, "select * from employees" ) ) {
   if( stmt ) {
       while( sqlany_fetch_next( stmt ) ) {
           int i;
           for( i = 0; i < sqlany_num_cols( stmt ); i++ ) {
                // Get i'th column data
           }
       }
       sqlany_free_stmt( stmt  );
   }