[sqlite] Mutex logic for shared sqlite database between Native & Android Application

Is there something wrong with my native code in mutex lock? If the above code is fine, then why does the mutex lock initiated at native level not getting reflected at Application level? Thanks in advance. Warm Regards, Ajay Gaonkar ___ sqlite-users mail

[sqlite] PENDING Lock / Sqlite .NET

Hi I have a question on how to enable PENDING LOCK before issuing an INSERT statement from the C# code. Do let me know if you can point me to some resources where I can find the answer or provide me the response. Regards Ajay Solanki +91 98192 54465

RE: [sqlite] RE: Maintaining Master-Child relationships

Thanks Kishore/Stephen for your suggestions. Regards Ajay -Original Message- From: stephan nies [mailto:[EMAIL PROTECTED] Sent: 29 March 2007 15:54 To: sqlite-users@sqlite.org Subject: Re: [sqlite] RE: Maintaining Master-Child relationships CREATE TRIGGER sync_child_with_parent_update

RE: [sqlite] RE: Maintaining Master-Child relationships

er table. But I don't know how to select id INTO a variable which can be used while inserting data into both the tables. Is it possible? Regards Ajay. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: 28 March 2007 17:42 To: sqlite-user

[sqlite] RE: Maintaining Master-Child relationships

ll be highly appreciated. Regards Ajay -Original Message- From: Arora, Ajay Sent: 28 March 2007 15:04 To: 'sqlite-users@sqlite.org' Subject: Maintaining Master-Child relationships Hi, I've two tables in my database, a master and a child with ID as a common key. I

[sqlite] Maintaining Master-Child relationships

Hi, I've two tables in my database, a master and a child with ID as a common key. I've created a table with one column to generate the sequence number.How can I insert related records into both the tables using same ID? Thanks Ajay THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY

RE: [sqlite] Any way to do this faster?

I'm not sure if SQLite support this syntax, but try following statement, Delete from tableB b Where not exist ( select 'x' from tableA a where a.id = b.id ) -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: 26 March 2007 16:12 To:

[sqlite] Query Issue

and c.extract_sequence = a.extract_sequence But, unfortunately this does not work either and gives an error [syntax error near "," ] in the above line. Please let me know if there is anyother way to achieve this in SQLite. Regards Ajay THE INFORMATION CONTAINED IN THIS

Re: [sqlite]cross compiling with powerpc

configure: error: unable to find a compiler for building build tools Have you tried setting the path where the powerpc compiler in installed? Regards, Ajay. On 12/2/05, Julien LEFORT <[EMAIL PROTECTED]> wrote: > > Hi, > I've been struggling for few hours trying to run the

[sqlite] sqlite3-3.2.1 execution error!

Hello, I tried compiling the source sqlite3-3.2.1 with the following commands on a i686 machine distro rehat linux 9 with the following commands, ./configure make make install And the above process returns successful message and all the lib* libraries are present in /usr/local/lib, i can also i

[sqlite] Problem Installing sqlite3 in redhat linux 9 i686 machine

Hello, I tried compiling the source sqlite3-3.2.1 with the following commands on a i686 machine distro rehat linux 9 with the following commands, ./configure make make install And the above process returns successful message and all the lib* libraries are present in /usr/local/lib, i can also i

[sqlite] INTEGER data type

Hello All, What is the maximum number that can be stored using INTEGER data type? My table uses INTEGER to store primary key, I store lot of records in table. I suspect that primary key will run out of limit. How can I use long instead of INTEGER? Regards, Ajay Sonawane

RE: [sqlite] Insert all rows from old table into new table but in sorted order

_brad -Original Message- From: Ajay [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 9:38 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Insert all rows from old table into new table but in sorted order Seems to be top of my head, Is there any simple and sweet solution ? -Ori

RE: [sqlite] Insert all rows from old table into new table but in sorted order

which may not be the way they were originally inserted. _brad -Original Message- From: Ajay [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 8:21 AM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: RE: [sqlite] Insert all rows from old table into new table but in sorted ord

RE: [sqlite] Insert all rows from old table into new table but in sorted order

Yaa that's what I wanted to do , So what do you think what could be the solution for this ? -Original Message- From: Steve O'Hara [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 5:28 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Insert all rows from old table into new ta

RE: [sqlite] Insert all rows from old table into new table but in sorted order

you misinterpreted my problem, I want to add all rows of old table into new table but with sorted order I don't want to fire another query (select * from newtable order by desc no ) to give sorted rows, I want to insert all rows in sorted order into new table. -Original Message- From: P

[sqlite] Insert all rows from old table into new table but in sorted order

Hello all, I can insert all rows of existing table into new table having same columns using query : Insert into NEWTABLE select * from OLDTABLE But I want all rows of NEWTABLE sorted by field No, So I used query Insert into NEWTABLE select * from OLDTABLE order by no desc But i

RE: [sqlite] Error : Library routine called out of sequence

] Error : Library routine called out of sequence On Jun 28, 2005, at 5:08 AM, Ajay wrote: > I am trying to insert values into table and executing that query from > thread. There are 2 more threads that accesses same table. > Do all the threads use the same sqlite handle? I believe that ca

RE: [sqlite] Error : Library routine called out of sequence

Sorry for wrong query! I am trying to insert values into table and executing that query from thread. There are 2 more threads that accesses same table. Correct query is Insert table SOURCEFEED (SOURCEFEED, STATUS) values ("ABC",0) Let me know what could be reason behind this -Original M

[sqlite] Error : Library routine called out of sequence

getting this error? My application is a multithread application and executes query from a worker thread. Let me know the possible solutions. Regards Ajay Sonawane

[sqlite] UNIQUE Constraint but case sensitive

Hi, I need to create a unique constraint on a column of type varchar, but it is not case sensitive by default. Does any one know how to make a unique constraint case sensitive? Thanks and best regards, Ajay Sonawane    

[sqlite] Writing a triiger to achieve same effect of ON_DELETE_CASCADE

End; Regards, Ajay Sonawane (Webtech Developers Pvt. Ltd. Pune)

[sqlite] Writing a triiger to achieve same effect of ON_DELETE_CASCADE

CE Begin Delete from ITEM where sourceno = old.sourceno; End; Regards, Ajay Sonawane (Webtech Developers Pvt. Ltd. Pune)

[sqlite] Query for ON_DELETE_CASCADE

query to do so) Let me know is there any other solution to do so. Regards, Ajay Sonawane

RE: [sqlite] UNICODE Support

But what about the SQLite Function's parameters whose data type is LPSTR ? Let me know the details to support wide char ? Regards, Ajay Sonawane -Original Message- From: Martin Engelschalk [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 6:48 PM To: sqlite-users@sqlit

[sqlite] UNICODE Support

Hello there, Does SQLite support UNICODE? Can I store some Arabic or Chinese text in database? If it does not support UNICODE, Is there any workaround for that? Regards, Ajay Sonawane

RE: [sqlite] ON_DELETE_CASCADE constraint is not working

" Regards, Ajay Sonawane > Hello there, > > I have two tables and used constraint ON_DELETE_CASCADE in one of the table > to delete records from second table if records from first table are deleted > which foreign key points to first table. I'm using SQLiteExplorer to

[sqlite] ON_DELETE_CASCADE constraint is not working

d all records of first table as it is though record of foreign key is deleted from second table. Let me know solution. Regards, Ajay Sonawane