Step 4. Executing a select query (and fetching result set)

#include <stdio.h>  // for printf#include <SQLAPI.h> // main SQLAPI++ headerint main(int argc, char* argv[]){    SAConnection con; // connection object    SACommand cmd(        &con,        "Select fid, fvarchar20 from test_tbl");    // command object        try    {        // connect to database (Oracle in our example)        con.Connect("test", "tester", "tester", SA_Oracle_Client);        // Select from our test table        cmd.Execute();        // fetch results row by row and print results        while(cmd.FetchNext())        {            printf("Row fetched: fid = %ld, fvarchar20 = '%s'\n",                 cmd.Field("fid").asLong(),                (const char*)cmd.Field("fvarchar20").asString());        }        // commit changes on success        con.Commit();        printf("Rows selected!\n");    }    catch(SAException &x)    {        // SAConnection::Rollback()        // can also throw an exception        // (if a network error for example),        // we will be ready        try        {            // on error rollback changes            con.Rollback();        }        catch(SAException &)        {        }        // print error message        printf("%s\n", (const char*)x.ErrText());    }        return 0;}