Re: [sqlite] SQLITE is not working in pthread

2009-07-10 Thread Pramoda M. A
imon Davies Sent: Friday, July 10, 2009 12:52 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLITE is not working in pthread 2009/7/10 Pramoda M. A <pramod...@kpitcummins.com>: > > Hi, > >  We r using Fedora Linux 10. Our application is, when any dev

Re: [sqlite] SQLITE is not working in pthread

2009-07-10 Thread Pramoda M. A
s not a database" Please help me. Thanks & Regards Pramoda.M.A CREST | KPIT Cummins Infosystems Limited | Bengaluru | Cell: +91 91640 57663 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of pierr Sent: Friday,

[sqlite] SQLITE is not working in pthread

2009-07-10 Thread Pramoda M. A
Hi All Sqlite is not running in pthread. At first time, sqlite_open will execute in pthread. From next time, no one API is executing. Please guide me to make SQLite run in pthread. Please anybody help me. Thanks & Regards Pramoda.M.A CREST | KPIT Cummins Infosystems Limited | Bengaluru |

[sqlite] SQLITE is not working in pthread

2009-07-09 Thread Pramoda M. A
Hi All, I have used pthread_create(fedora 10) to insert data into database. But it is not working. Only sqlite3_open will execute first time. Not other things are executed in the thread. What should I do? Thanks & Regards Pramoda.M.A CREST | KPIT Cummins Infosystems Limited | Bengaluru | Cell:

Re: [sqlite] Error is coming in Linux while openings Databse

2009-07-09 Thread Pramoda M. A
user under which the application runs have write permission on the Directory the database resides in? Are you sure that the segfault occurs inside sqlite and not in your own code? Martin Pramoda M. A schrieb: > Hi All, > >I am working on Fedora 10. Using C interfaces, I am success

[sqlite] Error is coming in Linux while openings Databse

2009-07-09 Thread Pramoda M. A
Hi All, I am working on Fedora 10. Using C interfaces, I am successfully opening database. No error while inserting data Into database. But after insertion, if I try to get data it is giving segmentation fault error. When I try to open using in-built sqlite3 commands, "Select * from File",

Re: [sqlite] How sqlite will store the data?

2009-05-15 Thread Pramoda M. A
Sent: Friday, May 15, 2009 3:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] How sqlite will store the data? Pramoda M. A schrieb: > In which order, SQLite will store the data? In any order it likes, it might use the insertion order if thats convenient. > > I am usi

[sqlite] How sqlite will store the data?

2009-05-15 Thread Pramoda M. A
Hi All, In which order, SQLite will store the data? I am using SQLite 3.6.5 and which is storing data in some other manner than I am inserting? How to make it to store in the same way as insertion? Please anybody help me. With Regards Pramoda.M.A

[sqlite] Giving error While compiling sqlite in Linux

2009-04-14 Thread Pramoda M. A
Hi All, I tried to compile sqlite3.6.5 in linux as gcc -c sqlite3.c It is giving error : in pthreadMutexAlloc PTHREAD_MUTEX_RECURSIVE is undeclared... Please help anybody... With Regards Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905

[sqlite] sqlite3 is giving error while creating object file in Linux

2009-04-14 Thread Pramoda M. A
Hi All, I tried to create object file of sqlite3.6.5 using Gcc -c sqlite3.c But it is giving following error. In pthreaMutexAlloc, PTHREAD_MUTEX_RECURSIVE IS UNDECLARED Please can anybody tell me what options has to be used? With Regards Pramoda.M.A KPIT Cummins

[sqlite] Sqlite3 is not compiling in Linux

2009-04-14 Thread Pramoda M. A
Hi All, I tried to compile in Linux. But it is giving error at linking stage as 'unreferenced dlopne dlclose... Can anybody help me? With Regards Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905 ___

[sqlite] How to delete the rows which is the result of Select operation of another table?

2009-02-24 Thread Pramoda M. A
Dear All, I have to delete the rows of one table table but key is the result of select operation of another table? Delete from table1 where ID = ( Select ID from table2 where name like '%sqlite%'); Is it ok? With Regards Pramoda.M.A KPIT Cummins Infosystems Limited |

[sqlite] How to Select using Wild Characters?

2009-02-24 Thread Pramoda M. A
Hi All, I have to select using wild charcters? How to do it? For eg: I have to select field which should contain "sqlite"... Then *sqlite* is not working... Pleas help me. With Regards Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905

[sqlite] How to use wild characters to select rows?

2009-02-23 Thread Pramoda M. A
Dear All, Please can anybody help me how to use wild characters to select rows? With Regards Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905 ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Exception Problem - Heap

2009-02-14 Thread Pramoda M. A
Hi All, I am getting an exception/error after some data is retrieved. I have copied here the screenshot... After storing 250 rows of data, it is giving exception... How to use malloc functions efficiently? Please help me anybody... ___

[sqlite] Hi All

2009-01-16 Thread Pramoda M. A
HI , We are using freescale 1.MX31 board and Windows CE OS. We have ported sqlite 3.6.5. But system is hanging after porting. My colleagues saying that malloc functions used by sqlite itself causing the problem. Is it true? Can anybody please help me in this regard?

[sqlite] How to use BEGIN & COMMIT in my C program?

2009-01-16 Thread Pramoda M. A
Hi All, How to use BEGIN and COMMIT in my C program? Main() { BEGIN; Sqlite3_exec(db, - - - -); COMMIT; } Is it valid? Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru ___

[sqlite] How to turn off Indexing in SQLite?

2009-01-09 Thread Pramoda M. A
Hi All, I am using SQLite and C interface. How to turn off Indexing in SQLite? With Regards, Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] 50 inserts takeing 8 seconds

2009-01-09 Thread Pramoda M. A
Hi all. My desktop system with taking 8 seconds to insert 100 rows with only one column... I am inserting using Ffor loop (C interface) Can anybody help me? With Regards, Pramoda.M.A KPIT Cummins Infosystems Limited | Bengaluru