[sqlite] sqlite db5 error for symbian
err = stmt.Prepare(db, _L("SELECT Col1 FROM tbl1 WHERE col2 = :var")); TInt paramIndex = stmt.ParameterIndex(_L(":var")); err = stmt.BindInt(paramIndex,user_id); id.AppendNum(user_id); iChitDemoAppUi->Log(id); TInt columnIndex = stmt.ColumnIndex(_L("UserNamePasswordHash")); TBuf8<100> data; while((err = stmt.Next()) == KSqlAtRow) { //data.Zero(); data= stmt.ColumnBinaryL(columnIndex); iChitDemoAppUi->Log(data); RDebug::Print(_L("val=%d\n"), data); // } it is not printing value in Log and debug also in symbian c++ for v9.1. I want to get the value of col1 where col2 = bind variable value. Can anyone provide any input on what i am missing in this. Thanks in advance. Regards, Manasi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite error: cannot commit transaction - SQL statements in progress
Hi All, I am working on an application. In my code nowhere I am explicitly setting AutoCommit = False after any statement. But i am getting "SQLite error: cannot commit transaction - SQL statements in progress" this error. Can anyone provide any input on this case in which all senerio we get this error. Thanks in advance. -- Regards, Manasi Save ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Exception: SQLite BUSY
Thanks for the reference :-). -- Thanks and Regards, Manasi Save > On 8/06/2009 8:22 PM, Manasi Save wrote: >> Hi All, >> >> I have one query regarding SQlite Busy error. >> >> Can anyone explain me in what cases this error occurs? > > Yes. You should be able to explain it to yourself after reading relevant > parts of: > > http://www.sqlite.org/faq.html > http://www.sqlite.org/lockingv3.html > http://www.sqlite.org/lang_transaction.html > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Exception: SQLite BUSY
Hi All, I have one query regarding SQlite Busy error. Can anyone explain me in what cases this error occurs? -- Thanks in advance! Regards, Manasi Save ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLiteException: no such table
Hi, I am sorry. But I didn't understand what do you mean by ASCII versus UTF-8 or UTF-16? -- Thanks and Regards, Manasi Save > On Mon, 1 Jun 2009 04:38:37 -0700 (PDT), "Manasi Save" > <manasi.s...@artificialmachines.com> wrote: > >>Hi, >> >>we are developing an application on android we are using SQLite Database >>and on phone we are getting SQLiteException:no such table. but, it is >>working fine on simulator. >> >>Can anyone provide any input on this? > > ASCII versus UTF-8 or UTF-16? > -- > ( Kees Nuyt > ) > c[_] > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Exception: no such table on Android
Hi, Sorry for (no subject) :P we are developing an application on android we are using SQLite Database and on phone we are getting SQLiteException:no such table. but, it is working fine on simulator. Can anyone provide any input on this? -- Thanks and Regards, Manasi Save ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] (no subject)
Hi, we are developing an application on android we are using SQLite Database and on phone we are getting SQLiteException:no such table. but, it is working fine on simulator. Can anyone provide any input on this? -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. manasi.s...@artificialmachines.com Ph:- 9833537392 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] (no subject)
Hi All, Can anyone help me out with the command to see the SQLite table defination on command-line SQLite application. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. manasi.s...@artificialmachines.com Ph:- 9833537392 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to install sqlite3-3.6.14.1.bin.gz
Hi, Can anyone help me on how to run sqlite3-3.6.14.1.bin.gz on Linux machine. I am working on Fedora 10. Please if anyone can provide any input on this. -- Thanks and Regards, Manasi Save ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users