Home How To Online Documentation Support Download Order

 

 

Connecting to databases
Transactions
Executing an SQL command
Executing stored procedures
Binding input parameters
Fetching result set
Fetching multiple result sets
Optimizing Database Performance
Returning output parameters
Working with Long or Lob(CLob, BLob) Data
Working with date/time values
Error handling
Using native API
Query examples


Using native API (creating Firebird databse at runtime)

Using native DBMS API requires including the appropriate DBMS API header file (comes with SQLAPI++). Native DBMS methods are accessible just after SQLAPI++ database connection is initialized. The sample below shows how to create Firebird database with SQLAPI++ using native Firebird isc_dsql_execute_immediate call:
#include <SQLAPI.h>
#include <ibAPI.h>

int main(int argc, char **argv)
{
SAConnection con;
con.setClient(SA_InterBase_Client);
ibAPI *pibAPI = (ibAPI *)con.NativeAPI();

ISC_STATUS status_vector[20];
isc_db_handle db_handle = NULL;
isc_tr_handle dummy_handle = NULL;

pibAPI->isc_dsql_execute_immediate(
status_vector,
&db_handle,
&dummy_handle,
0,
"create database 'localhost:c:/test.gdb' user 'SYSDBA' password 'masterkey'",
1,
NULL);
if (status_vector[0] == 1 && status_vector[1])
{
/* Process error. */
pibAPI->isc_print_status(status_vector);
return 1;

}
return 0;
}


Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.