Re: [sqlite] Insertion and Updation using sqlite3_prepare()
Thanks for your reply Igor. We checked and we have commited the transaction. Below is the query we used where all the fields are numeric and it is prepared once: INSERT INTO ShopDataNum values(?,?,?,?,?,?,?,?,?,?,?) When we bind the values the steps were returning the correct value but the record is not found in the DB. Then we tried by passing the static value for the first field in sqlite3_prepare and we bind the values. INSERT INTO ShopDataNum values(960002,?,?,?,?,?,?,?,?,?,?) The steps were executed correctly and the record is inserted correctly in the DB. Again we tried the first query and assigned the static value for the first field while binding the values, the steps were executed correctly but the record is not found in the DB. Please guide us how to proceed further. Thanks and Regards, Farzana. Igor Tandetnik wrote: > > "hussainfarzana" > wrote in > message news:21849799.p...@talk.nabble.com >> We are using the sqlite3_prepare() and sqlite3_bind() methods for >> insertion and updation of the records in the database.Everything >> works fine and sqlite3_step() returns 101 which is SQLITE_DONE.When >> we check the DB, the records are not inserted. > > Do you, by any chance, start a transaction and then forget to commit it? > > Igor Tandetnik > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Insertion-and-Updation-using-sqlite3_prepare%28%29-tp21849799p21866676.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
[sqlite] Insertion and Updation using sqlite3_prepare()
Dear All, We are using SQLite version 3.6.10. We are using the sqlite3_prepare() and sqlite3_bind() methods for insertion and updation of the records in the database.Everything works fine and sqlite3_step() returns 101 which is SQLITE_DONE.When we check the DB, the records are not inserted. Please help us in this regard. Thanks and Regards, Farzana. -- View this message in context: http://www.nabble.com/Insertion-and-Updation-using-sqlite3_prepare%28%29-tp21849799p21849799.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
Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE
Yes,the SQL prepared statement has got 14 placeholders. The statement is "INSERT INTO CollDataNum values(?,?,?,?,?,?,?,?,'?',?,?,?,?,?)" Regards, Farzana. SimonDavies wrote: > > 2009/2/2 hussainfarzana : >> >> Dear All, >> >> We are working with SQLite Version 3.6.10. >> We tried to insert or update the records in the database using >> sqlite3_prepare and binding the values using sqlite3_bind functions.We >> have >> started with the index 1.We have a table with 14 columns and when we use >> sqlite3_bind_int,for the first 13 columns its returning 0 and for the >> last >> 14th column which is also an integer datatype, but the function is >> returning >> value 25(SQLITE_RANGE) error. > > Your table may have 14 columns, but has the SQL for your prepared > statement got 14 parameter placeholders? > >> >> Please help us how to proceed further. >> >> Regards, >> Farzana. > > Rgds, > Simon > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/sqlite3_bind_int-returns-SQLITE_RANGE-tp21788383p21788991.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
[sqlite] sqlite3_bind_int returns SQLITE_RANGE
Dear All, We are working with SQLite Version 3.6.10. We tried to insert or update the records in the database using sqlite3_prepare and binding the values using sqlite3_bind functions.We have started with the index 1.We have a table with 14 columns and when we use sqlite3_bind_int,for the first 13 columns its returning 0 and for the last 14th column which is also an integer datatype, but the function is returning value 25(SQLITE_RANGE) error. Please help us how to proceed further. Regards, Farzana. -- View this message in context: http://www.nabble.com/sqlite3_bind_int-returns-SQLITE_RANGE-tp21788383p21788383.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
[sqlite] SQLITE LIB ( 3.6.7 version) for ARMV4T processor
Hi All, We have downloaded the sqlite version 3.6.7 code and built the LIB files specific for the following processors x86,MIPS,ARMV4T and ARMV4I. In these all works except the one built for ARMV4T processor. The lib file gets generated successfully and we have included it into our EVC4 project to built an application for DTX 10 device which is of ARMV4T processor, the exe is also generated successfully. But when we execute the application we face the issues, the Connection to the DB through SQLITE3_OPEN is successful and when to try to access the DB with some queries through SQLITE3_EXEC and it is getting failed with the error SQLITE_ERROR. " E.g we executed "select * from Auditors", but the reuslt is "no such table : Auditors exists" (actually the table exists in the DB). We have used the same sqlite source code to build the lib file for ARMV4I processor and it is working fine in the devices. At the same time the SQLITE version 3.6.1 LIB file for ARMV4T processor is working fine in the device, kindly let us know what could be the problem in our case. Regards Farzana -- View this message in context: http://www.nabble.com/SQLITE-LIB-%28-3.6.7-version%29-for-ARMV4T-processor-tp21172113p21172113.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
Re: [sqlite] SQLITE3_OPEN returns SQLITE_NOMEM
Dear Kartthi, Hope you have resolved this issue, and we have started 3.6.7 version of Sqlite and now we too got the same error. If you have already solved this and having a solution, kindly guide us so that we could get rid of this issue. Note: We are working with 3.6.1 version of sqlite and it is working fine without any problem. Regards Farzana sqlite wrote: > > Dear All, > > I have just started using the SQLite Db in my applications. My application > runs under MIPS processor. I have generated the Sqlite3.dll and > Sqlite3.lib file for the MIPS processor and it is geting compiled. When i > use Sqlit3_Open function to open a DB, it fails with the error message > SQLITE_NOMEM. But the same code is running fine in the Windows mode. How > should i rectify this? Can anyone help me in this regard. > > Thanks > Kartthi > -- View this message in context: http://www.nabble.com/SQLITE3_OPEN-returns-SQLITE_NOMEM-tp16254109p21123489.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
Re: [sqlite] COMMIT in SQLite
Thanks for your reply Igor. We have used BEGIN and COMMIT while executing our statements.While executing the BEGIN the return value is 0,but for COMMIT its returning 1. Please guide us. Regards, Farzana. Igor Tandetnik wrote: > > "hussainfarzana" > wrote in > message news:20971588.p...@talk.nabble.com >> We have developed our application in eVC++ 3.0 using SQLite as the >> database. While insertion or updation of records >> We have used BEGIN and COMMIT method to insert or update the records. >> While running the application we are able to insert and update and we >> are able to check that value also.Once we exit the application and >> reopen the application again we are not able to see the values and >> these records are missing in the database also.The records are >> inserted or updated temporarily. > > You are executing a BEGIN, but you are _not_ executing a COMMIT. Check > your code, figure out why. Without COMMIT, your transaction gets rolled > back. > > Igor Tandetnik > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/COMMIT-in-SQLite-tp20971588p21009480.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
[sqlite] COMMIT in SQLite
Hi All, We have developed our application in eVC++ 3.0 using SQLite as the database. While insertion or updation of records We have used BEGIN and COMMIT method to insert or update the records. While running the application we are able to insert and update and we are able to check that value also.Once we exit the application and reopen the application again we are not able to see the values and these records are missing in the database also.The records are inserted or updated temporarily. Please help us how to save the values. Regards HussainFarzana. -- View this message in context: http://www.nabble.com/COMMIT-in-SQLite-tp20971588p20971588.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