UPDATE 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
&g
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 inc
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
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
--
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.
Dependi
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 wrote:
Thanks for the info.
LL 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 to compile the
sources
brary?
- Original Message -
From: "John Stanton" <[EMAIL PROTECTED]>
To:
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 the sources using LCC
u
st main.c is not how it should 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 -
F
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
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 PRO
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: Re[2]: [sqlite] Re: Re
anyone?
- Original Message -
From: "Gussimulator" <[EMAIL PROTECTED]>
To:
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 (
sqlite3 ) ?
thanks - i can take scri
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!
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 3:15 PM
Subject: Re: [sqlit
;t read while writing" though. You'll have to figure
out something for this. I'd use a named mutex (or similar IPC) for this. Or:
Serialize all database access via a queue and a single threaded queue
processor... The results are most likely better using a (properly written)
queue, rath
-
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To:
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 writing", how to avoid this?, I
ing a
database then.
- Original Message -
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 12, 2006 12:59 PM
Subject: Re: [sqlite] Problems with Multi-Threaded Application.
On 7/12/06, Gussimulator <[EMAIL PROTECTED]> wrote:
Hello,
I'm currently
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 da
Christian said:
For desktop or server use, storage is cheap.
Thats true, however I'd like to compress the database because I need
portability.
Sure, one could compress the DB and move it into a mobile storaging unit,
then when you're done you could decompress the DB on the destination
harddr
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: Wednesday, July 05, 2006 6:44 P
EMAIL PROTECTED]>
To:
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
princ
uly 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
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 f
QL statement. Strings are
surrounded by single-quotes with escapes on interior quotes as needed.
BLOBs are encoded as hexadecimal literals. The current implementation of
VACUUM uses this function. The function is also useful when writing
triggers to implement undo/redo functionality.
Gussimulator w
d 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 with a few of this chars
so I
ma
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
27 matches
Mail list logo
