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.

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.

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-users"<sqlite-users@sqlite.org> 抄送： Hi Experts, I'm trying to use sqlite3_bind_text in my database insert p

Re: [sqlite] sqlite3_bind_text issue

2014-05-03 Thread Graham Holden
sdu...@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 fol

[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