Hi
I have trying to insert in a sqlite db.. here is the code but i am getting
following error.. what could be the issue.
*Error Insert : sqlite3_bind_blob, Error code : 25*
#define INSERT_DN "BEGIN TRANSACTION; INSERT INTO TBL (dn) VALUES (?);
SELECT last_insert_rowid(); COMMIT;"
BinBuffer aInBuffer
char buffer[100] = "a/b/c/d";
char * testdn = buffer;
aInBuffer.size = 100;
aInBuffer.ptr = testdn;
reset_stmt(newStmt);
snprintf(command, 512, INSERT_DN);
if ( (rv = sqlite3_prepare_v2(sqlHandle->db, command, -1,
&newStmt, NULL) ) != SQLITE_OK )
{
fprintf(stderr, "Error Insert : sqlite3_prepare_v2, Error code :
%d\n", rv);
return;
}
rv = sqlite3_bind_blob(newStmt, 1, aInBuffer.ptr, aInBuffer.size,
SQLITE_STATIC);
if (rv != SQLITE_OK)
{
fprintf(stderr, "Error Insert : sqlite3_bind_blob, Error code :
%d\n", rv);
return;
}