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

Reply via email to