This example shows how to fetch data from a result set.
// ********************************************************************* // Copyright 1994-2008 iAnywhere Solutions, Inc. All rights reserved. // This sample code is provided AS IS, without warranty or liability // of any kind. // // You may use, reproduce, modify and distribute this sample code // without limitation, on the condition that you retain the foregoing // copyright notice and disclaimer as to the original iAnywhere code. // // ********************************************************************* #include <stdlib.h> #include <stdio.h> #include <string.h> #include "sacapidll.h" int main( ) { SQLAnywhereInterface api; a_sqlany_connection * conn; a_sqlany_stmt * stmt; unsigned int max_api_ver; if( !sqlany_initialize_interface( &api, NULL ) ) { printf( "Could not initialize the interface!\n" ); exit( 0 ); } if( !api.sqlany_init( "MyAPP", SQLANY_CURRENT_API_VERSION, &max_api_ver ) ) { printf( "Failed to initialize the interface! Supported version=%d\n", max_api_ver ); sqlany_finalize_interface( &api ); return -1; } /* A connection object needs to be created first */ conn = api.sqlany_new_connection(); if( !api.sqlany_connect( conn, "uid=dba;pwd=sql" ) ) { api.sqlany_free_connection( conn ); api.sqlany_fini(); sqlany_finalize_interface( &api ); exit( -1 ); } printf( "Connected successfully!\n" ); if( (stmt = api.sqlany_execute_direct( conn, "select * from systable" )) != NULL ) { int num_rows = 0; a_sqlany_data_value value; while( api.sqlany_fetch_next( stmt ) ) { num_rows++; printf( "\nRow [%d] data .......\n", num_rows ); for( int I = 0; I < api.sqlany_num_cols( stmt ); I++ ) { int rc = api.sqlany_get_column( stmt, I, &value ); if( rc < 0 ) { printf( "Truncation of column %d\n", I ); } if( *(value.is_null) ) { printf( "Received a NULL value\n" ); continue; } switch( value.type ) { case A_BINARY: printf( "Binary value of length %d.\n", *(value.length) ); break; case A_STRING: printf( "String value [%.*s] of length %d.\n", *(value.length), (char *)value.buffer, *(value.length) ); break; case A_VAL64: printf( "A_VAL64 value [%lld].\n", *(long long *)value.buffer ); break; case A_UVAL64: printf( "A_UVAL64 value [%lld].\n", *(unsigned long long *)value.buffer ); break; case A_VAL32: printf( "A_VAL32 value [%d].\n", *(int*)value.buffer ); break; case A_UVAL32: printf( "A_UVAL32 value [%d].\n", *(unsigned int*)value.buffer ); break; case A_VAL16: printf( "A_VAL16 value [%d].\n", *(short*)value.buffer ); break; case A_UVAL16: printf( "A_UVAL16 value [%d].\n", *(unsigned short*)value.buffer ); break; case A_VAL8: printf( "A_VAL8 value [%d].\n", *(char *)value.buffer ); break; case A_UVAL8: printf( "A_UVAL8 value [%d].\n", *(unsigned char *)value.buffer ); break; } /* do some processing with the data ... */ } } /* Must free the result set object when done with it */ api.sqlany_free_stmt( stmt ); } api.sqlany_disconnect( conn ); /* Must free the connection object or there will be a memory leak */ api.sqlany_free_connection( conn ); api.sqlany_fini(); sqlany_finalize_interface( &api ); return 0; } |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |