[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 tel:%2B91%2098192%2054465

[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 ATTACHMENT

[sqlite] RE: Maintaining Master-Child relationships

will 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've created a table

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

[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 MESSAGE AND ANY ATTACHMENT MAY

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 configure script the right

[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

[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

[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

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:

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

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 order Yaa that's what

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

-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 ? -Original

[sqlite] Error : Library routine called out of sequence

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

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 can cause

[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] 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] 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@sqlite.org

[sqlite] ON_DELETE_CASCADE constraint is not working

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

RE: [sqlite] ON_DELETE_CASCADE constraint is not working

Hello there, Will you please tell me when SQLite will be supporting FOREIGN KEYS and ON_DELETE_CASCADE? Where can I get more information about version and what's new feature? As well as Can someone guide me about how to write and fire trigger that could do work of ON_DELETE_CASCADE Regards, Ajay