Re: [sqlite] sqlite3_bind_text issue

2014-05-05 Thread Josep Niubó Caselles
A Dilluns, 5 de maig de 2014 02:59:59, lyx va escriure: I have tried to use SQL_TRANSIENT instead of SQLITE_STATIC in sqlite3_bind_text. But the result is still not correct. The column num is correct now but the row number embedded in column data in every row is all assigned to zero now. It

Re: [sqlite] sqlite3_bind_text issue

2014-05-05 Thread Hick Gunter
-Ursprüngliche Nachricht- Von: lyx [mailto:sdu...@163.com] Gesendet: Montag, 05. Mai 2014 05:00 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] sqlite3_bind_text issue I have tried to use SQL_TRANSIENT instead of SQLITE_STATIC in sqlite3_bind_text. But the result is still not correct

Re: [sqlite] sqlite3_bind_text issue

2014-05-04 Thread smartenc
change SQLITE_STATIC to SQLITE_TRANSIENT 2014-05-04 smartenc 发件人:lyx sdu...@163.com 发送时间:2014-05-04 13:11 主题:[sqlite] sqlite3_bind_text issue 收件人:sqlite-userssqlite-users@sqlite.org 抄送: Hi Experts, I'm trying to use sqlite3_bind_text in my database insert procedure using sqlite 3.8.4.3

[sqlite] sqlite3_bind_text issue

2014-05-03 Thread lyx
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

Re: [sqlite] sqlite3_bind_text issue

2014-05-03 Thread Graham Holden
...@163.com Date: 04/05/2014 06:11 (GMT+00:00) To: sqlite-users@sqlite.org Subject: [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