Connect to Database

Just make a call to SAConnection::Connect and provide the credentials. SQLAPI++ does the rest by dynamically loading specified client's native library and calling corresponding APIs.

SAConnection con;
con.Connect(_TSA("demo"), _TSA("guest"), _TSA("secret"), SA_SQLServer_Client);

Insert Data into a Table

To insert data create SACommand, bind input variables as needed using stream operators and call SACommand::Execute to send command to the server. SQLAPI++ takes care of preparing and executing the command using native APIs when needed.

SACommand insert(&con, _TSA("INSERT INTO EMPLOYEES (NAME, AGE) VALUES (:1, :2)"));

insert << _TSA("Tom Patt") << 30;
insert.Execute();
insert << _TSA("Nick Barry") << 35;
insert.Execute();

Read Data from a Table

To read data execute a SELECT command, bind WHERE clause variables as needed and use SACommand::FetchNext in a loop to retrieve all the rows. SQLAPI++ does the hard work of interfacing with native APIs, allocating buffers, etc.

SACommand select(&con, _TSA("SELECT NAME, AGE FROM EMPLOYEES WHERE AGE > :1"));

select << 30;
select.Execute();

while(select.FetchNext()) {
    SAString sName = select[1].asString();
    long nAge = select[2].asLong();
    printf("Name: %s, age: %d \n", sName, nAge);
}

More Examples

Compatibility

SQLAPI++ library supports the following C/C++ compilers:

• Microsoft Visual C++
• Embarcadero (Borland) C++
• GNU GCC C++ compiler
• Solaris Studio C++ compiler

Latest Release

Bug Fixes

• General: Fixed default buffer size used for the long/LOB data writing (thanks Filippo Capizzi)

See full history...