#include
#include
#include
static int callback ( void* NotUsed, int argc, char** argv, char** azColName )
{
int i;
fprintf ( stderr, "callback called\n" );
for ( i = 0; i < argc; i++ )
{
printf ( "%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL" );
}
printf ( "\n" );
return 0;
}
int main ( int argc, char* argv[] )
{
sqlite3* db;
char* zErrMsg = 0;
int rc;
char* sql;
/* Open database */
rc = sqlite3_open ( "test.db", &db );
if ( rc )
{
fprintf ( stderr, "Can't open database: %s\n", sqlite3_errmsg ( db ) );
exit ( 0 );
}
else
{
fprintf ( stderr, "Opened database successfully\n" );
}
#if 0
sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " \
"VALUES (32, 'Paul', 32, 'California', 20000.00 ); ";
#endif
sql = "UPDATE COMPANY set SALARY = 28000 where ID = 1;";
/* Execute SQL statement */
//rc = sqlite3_exec ( db, sql, callback, 0, &zErrMsg );
char test[] = "sfsadfasf\n";
rc = sqlite3_exec ( db, sql, callback, test, &zErrMsg );
if ( rc != SQLITE_OK )
{
fprintf ( stderr, "SQL error: %s\n", zErrMsg );
sqlite3_free ( zErrMsg );
}
else
{
fprintf ( stdout, "Records created successfully\n" );
}
sqlite3_close ( db );
return 0;
}