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
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
Subject: [sqlite] Update value from either database table?
I have a field I need
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: sqlite-users@sqlite.org
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
?
- 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 the sources using LCC
under
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... Do I have
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.
Im trying
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.
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
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 [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Friday, March 09, 2007 12:59 PM
Subject
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
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 (
sqlite3 ) ?
thanks - i can take
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: sqlite-users@sqlite.org
Sent: Wednesday, November 15, 2006 2:02 AM
Subject: RE:
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!
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
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] wrote:
Hello,
I'm currently using SQLite3 on my multi-threaded
-
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 writing, how to avoid this?, I cant stop my
: 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, only a few get the
data populated..
I can not tell when
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: sqlite-users@sqlite.org
Sent: Wednesday, July 12, 2006 3:15 PM
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: sqlite-users@sqlite.org
Sent: Wednesday,
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
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
made 2 routines in my program, one
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
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
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.
In particular, if your
: [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 compression is getting rid of repetitive data, so... I
26 matches
Mail list logo