Hi Friends, When i tried, query = "insert into ONTTable (slotId,ponChannelId,onuType,onuId,adminStatus) values (?1,?2,?3,?4,?5);"; then binding each parameter.....
//sqlite3_prepare_v2(db,query,strlen(query)+1, &stmt, NULL); sqlite3_bind_int(stmt,1,ontTable -> slotId); sqlite3_step(stmt,DONE); //sqlite3_prepare_v2(db,query,strlen(query)+1, &stmt, NULL); sqlite3_bind_int(stmt,1,ontTable -> ponChannelId); sqlite3_step(stmt,DONE); //sqlite_prepare_v2(db,query,strlen(query)+1, &stmt, NULL); sqlite3_bind_int(stmt,1,ontTable -> ontType); sqlite3_step(stmt,DONE); //sqlite3_prepare_v2(db,query,strlen(query)+1, &stmt, NULL); sqlite3_bind_int(stmt,1,ontTable -> onuId); sqlite3_step(stmt,DONE); //sqlite3_bind_prepare_v2(db,query,strlen(query)+1, &stmt, NULL); sqlite3_bind_int(stmt,1,ontTable -> adminStatus); I am getting the following error. sqilte3_bind_int(stmt,1,ontTable -> ponChannelId) failed with status 21: library routine called out of sequence. Regards, Bhaskar Reddy. -- View this message in context: http://old.nabble.com/sqlite3_bind.-error-as-library-routine-called-out-of-sequence.-tp33147572p33147572.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users