Re: [sqlite] Update value from either database table?

E c > SET int_field = int_field+1 > WHERE (table a condition) OR (table b condition) > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Gussimulator > Sent: Monday, February 04, 2008 1:57 PM > To: sqlite-users@sqlite.org > S

[sqlite] Update value from either database table?

I have a field I need to update given a condition, but I don't know wether the condition occurs in table A or table B, how can I perform this query? I have 2 identical tables in design, but one contains system data and the other one contains user data... On my update routine (in C) I have to

[sqlite] auto index id?

Is it possible to have automatic index ID field in SQLite3?, I would like to have access to an index in my database... Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What query should I use?

try the DISTINCT keyword ? - Original Message - From: "erw2" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 04, 2007 4:14 PM Subject: [sqlite] What query should I use? Hi, I have a table with a following data: IdText1 Text2 Text3 Text4

Re: [sqlite] Re: Re: How do I know what DBs I have attached?

I don't know if this helps, but I'll comment anyway! I had a similar issue in the past, and what I did was to develop a small layer with a queue system, which took care of all the database requests and executed them without risking the database integrity nor the data to be processed.

Re: [sqlite] Compiling the linux package on windows using LCC ?

e lcc make within its own IDE so that the make file is generated by the lcc IDE. You could use a regular make and just subsitute the CC definition for the lcc compiler. You might find the need to substitute link library definitions as well. GCC holds is the solution to your problem. Gussimulator

Re: [sqlite] Compiling the linux package on windows using LCC ?

ou want dynamic linking to a DLL you need to look at the lcc documentation to see precisely how it is done. Gussimulator wrote: GCC?, I need to use the resulting DLL on normal C under windows later on, without having strange dependencies, etc. I'd like to know what am I doing wrong when I try

Re: [sqlite] Compiling the linux package on windows using LCC ?

? - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, March 09, 2007 2:10 PM Subject: Re: [sqlite] Compiling the linux package on windows using LCC ? Gussimulator wrote: Hi, I would like to compile the tar version of

Re: [sqlite] Compiling the linux package on windows using LCC ?

hould be done? if so, what should I do in order to properly compile all the sources? - This time I'm using the "pre-processed" version of the sources for windows, since I gave up on the other package... Thanks again. - Original Message - From: "Gussimulator" &l

[sqlite] Compiling the linux package on windows using LCC ?

Hi, I would like to compile the tar version of the sources using LCC under Windows. Since I'm not a *nix guy, I don't know where to start, because my little linux knowledge played against me. Heres the problem, I tried using the makefile with make.exe from LCC but that didnt work out (it said

Re: [sqlite] can i dynamically move backward and forward in a record-set ?

I'm sorry im not fluent in sqlite enough to recommend you anything regarding the subject, however as I read " virtual " I think you meant DYNAMIC!. Using the right word/s ''sometimes'' helps, with this kind of things though. - Original Message - From: "Ohad Eder-Pressman" <[EMAIL

Re: Re[2]: [sqlite] Re: Re: Handling null characters in blob data

What kind of compression algorithm leaves out null characters? every char will be taking a byte, its just stupid. - Original Message - From: "Shivshankar Subramani - TLS , Chennai" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 15, 2006 2:02 AM Subject:

Re: [sqlite] converting from mysql?

anyone? - Original Message - From: "Gussimulator" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, November 12, 2006 1:54 PM Subject: [sqlite] converting from mysql? what are the available tools to convert a mysql db onto this engine ( sqlit

[sqlite] converting from mysql?

what are the available tools to convert a mysql db onto this engine ( sqlite3 ) ? thanks - i can take scripts (php, phyton, perhaps ruby although i dont have it installed now) but any tool for windows would suffice too!

Re: [sqlite] Question about database?

Yeah and while we're at it, he could invest a few bucks on a couple twin diesel generators, a battery room, and whatnot, a group of hookers to save the night. - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 12, 2006

Re: [sqlite] Problems with Multi-Threaded Application.

n IPC. Mike -Ursprüngliche Nachricht- Von: Gussimulator [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. Juli 2006 19:47 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Problems with Multi-Threaded Application. Yes, in theory. However, when about 100 queries are fired in a second,

Re: [sqlite] Problems with Multi-Threaded Application.

- From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, July 12, 2006 2:57 PM Subject: Re: [sqlite] Problems with Multi-Threaded Application. On 7/12/06, Gussimulator <[EMAIL PROTECTED]> wrote: About the "cant read while wri

Re: [sqlite] Problems with Multi-Threaded Application.

n having a database then. - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, July 12, 2006 12:59 PM Subject: Re: [sqlite] Problems with Multi-Threaded Application. On 7/12/06, Gussimulator <[EMAIL PROTECTED]> w

[sqlite] Problems with Multi-Threaded Application.

Hello, I'm currently using SQLite3 on my multi-threaded software. I have tried several ways for dealing with my issue, however, I came to the conclusion that there must be some trick I havent been told of. Heres the situation, Theres a big amount of input coming in from the software to the

Re: [sqlite] Compressing the DBs?

I don't really think this is a good way of dealing with this but thanks for the idea, if everything else doesnt work out, I might end up doing this. However its not a solution at all. - Original Message - From: "Mikey C" <[EMAIL PROTECTED]> To: Sent:

Re: [sqlite] Compressing the DBs?

gt; Sent: Thursday, July 06, 2006 12:04 AM Subject: Re: [sqlite] Compressing the DBs? At 6:04 PM -0300 7/5/06, Gussimulator wrote: Now, since theres a lot of repetitive data, I thought that compressing the database would be a good idea, since, we all know.. One of the first principles of data com

Re: [sqlite] Syntax Errors with various strings?

ay, July 05, 2006 5:13 PM Subject: Re: [sqlite] Syntax Errors with various strings? Gussimulator wrote: Thanks Christian, I'll give it a shot later. Just because using quotation marks (did a quick macro that adds them to my string) did the job, doesnt mean its a better solution than this one.

[sqlite] Compressing the DBs?

I've been using SQLite for a very short period of time and so far Its doing a great job for my application (single user, quite a big amount of data though). Now, since theres a lot of repetitive data, I thought that compressing the database would be a good idea, since, we all know.. One of the

Re: [sqlite] Syntax Errors with various strings?

ndo/redo functionality. Gussimulator wrote: Hi, When I have strings with "-", "!", "\" or similar characters I get a syntax error.. Now, I thought this would happen with a few of this chars so I made 2 routines in my program, one that converts each of this chars into

Re: [sqlite] Syntax Errors with various strings? & ...Ampersand

ring with an ampersand as part of it. I am developing in a PHP/SQlite environment. On Wed, 5 Jul 2006 06:07:46 -0300, Gussimulator wrote: Hi, When I have strings with "-", "!", "\" or similar characters I get a syntax error.. Now, I thought this would happen

[sqlite] Syntax Errors with various strings?

Hi, When I have strings with "-", "!", "\" or similar characters I get a syntax error.. Now, I thought this would happen with a few of this chars so I made 2 routines in my program, one that converts each of this chars into a flag string, which then, by the other routine can be reverted to the