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; }