Re: [sqlite] Performance issue using SQLite

Sorry, the first sql statement in my previous mail is incorrect. It is not " sprintf (sql_str, "select ctrl_no from T_CTRL_CLRRULE where CTRL_NO='%s' and ((PRODUCT_ID='%s' and OPERATE_TYPE='%s') or (PRODUCT_ID='AA' and OPERATE_TYPE='%s') or (PRODUCT_ID='%s' and OPERATE_TYPE='AA')) and C

[sqlite] sqlite3_bind_text issue

Hi Experts, I'm trying to use sqlite3_bind_text in my database insert procedure using sqlite 3.8.4.3. I have a very simple table and the '.schema' output is as following: sqlite> .schema CREATE TABLE ins_test(col1 text, col2 text, col3 text, col4 text, col5 text, col6 text); CREATE INDEX id