Hi Graham,
The trigger needs a where clause, as in the following:
sqlite>
sqlite> create table temp( id integer primary key,
...> interested integer,
...> val1 text,
...> val2 text,
...>
Hi All,
I'm trying to learn SQLITE from a book and am making slow progress. My
question is, in the following TRIGGER how do I tell it to only update
the single record that the field Interested was updated? its a logical
field either TRUE of FALSE, I want the trigger to work when the Field is
Hi Nick,
On Tue, 28 Aug 2007 17:39:16 +0100, you wrote:
> When enclosed in a single transaction, would inserting
> many rows into a table using the special default keyword
> 'CURRENT_TIMESTAMP' result in all of the rows
> guaranteeing the same timestamp value?
Did you try?
I did.
Thanks everyone for your input.
Shilpa
On 8/27/07, Asif Lodhi <[EMAIL PROTECTED]> wrote:
> Hi Shilpa,
>
> On 8/28/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote:
> > Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL
> > installed. Can it access "mysqlitedb.db"
>
> IIRC, I did
Brandon, Nicholas (UK) wrote:
When enclosed in a single transaction, would inserting many rows into a
table using the special default keyword 'CURRENT_TIMESTAMP' result in
all of the rows guaranteeing the same timestamp value?
If not, is there a recommended way to assign a unique value to a
On Tue, 28 Aug 2007 18:44:50 +0200, you wrote:
>On Tue, 28 Aug 2007 15:13:47 +, you wrote:
>
>>In reference to
>>
>> http://www.sqlite.org/cvstrac/tktview?tn=2592
>>
>>This is the first public indication we have had that
>>Skype is using SQLite in their windows clients. However,
>>the
On 8/28/07, rahed <[EMAIL PROTECTED]> wrote:
> /usr/include/sys/types.h:176: error: previous definition of 'B_TRUE' was here
> *** Error code 1
> make: Fatal error: Command failed for target `lemon'
>
> Could somenone suggest what's wrong?
>
Rahed:
Funny enough, I just ran into this problem
rahed <[EMAIL PROTECTED]> wrote:
> Hello,
>
> when running make I get:
>
> sed -e s/--VERS--/3.4.2/ ../sqlite/src/sqlite.h.in | \
> sed -e s/--VERSION-NUMBER--/3004002/ >sqlite3.h
> gcc -g -O2 -o lemon ../sqlite/tool/lemon.c
> .../sqlite/tool/lemon.c:111: error: redeclaration of enumerator
Would this be a good time to replace the older sqlite3_prepare() and
sqlite3_prepare16() interfaces with what is currently the newer
sqlite3_prepare_v2() and sqlite3_prepare16_v2() interfaces respectively?
Admittedly they are definitely not among the "less frequently used
interfaces", but such
On Tue, 28 Aug 2007 15:13:47 +, you wrote:
>In reference to
>
> http://www.sqlite.org/cvstrac/tktview?tn=2592
>
>This is the first public indication we have had that
>Skype is using SQLite in their windows clients. However,
>the person who wrote the ticket seems to be a bit confused.
>Can
When enclosed in a single transaction, would inserting many rows into a
table using the special default keyword 'CURRENT_TIMESTAMP' result in
all of the rows guaranteeing the same timestamp value?
If not, is there a recommended way to assign a unique value to a
collection of inserts in a single
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 28, 2007 8:14 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Skype client using SQLite?
>
> In reference to
>
>http://www.sqlite.org/cvstrac/tktview?tn=2592
>
> This is the first
On 8/28/07, Jeremy Hinegardner <[EMAIL PROTECTED]> wrote:
> On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote:
> > In reference to
> >
> >http://www.sqlite.org/cvstrac/tktview?tn=2592
> >
> > This is the first public indication we have had that
> > Skype is using SQLite in
Hello,
when running make I get:
sed -e s/--VERS--/3.4.2/ ../sqlite/src/sqlite.h.in | \
sed -e s/--VERSION-NUMBER--/3004002/ >sqlite3.h
gcc -g -O2 -o lemon ../sqlite/tool/lemon.c
../sqlite/tool/lemon.c:111: error: redeclaration of enumerator `B_FALSE'
/usr/include/sys/types.h:176: error: previous
The same file appears on the windows version
-Original Message-
From: Jeremy Hinegardner [mailto:[EMAIL PROTECTED]
Sent: 28 August 2007 17:05
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Skype client using SQLite?
On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote:
>
I'm thinking in a more generic way... using /dev/shm works on linux, but not
on windows.
Also, r/w support is a must have, so this approach cannot solve the problem.
Since we have 'drivers' for windows / linux / etc, a 'memory' driver would
be enought,
simulating file opening / closing / deleting,
On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote:
> In reference to
>
>http://www.sqlite.org/cvstrac/tktview?tn=2592
>
> This is the first public indication we have had that
> Skype is using SQLite in their windows clients. However,
> the person who wrote the ticket seems
Hi,
I did tried something crazy like this (it worked, for read only DB only).
I changed pread to preadCustom api.Then in preadCustom maintained a static
fdArray. if fd is not listed then i mmap the whole file and the use the memcpy
to return the data. There was significant performance again as
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> I wonder if it might not be better to change this API to accept an empty
> string, in addition to a NULL pointer, to find the default VFS. It seems
> to me this might make life easier for those writing wrappers in
> languages that don't have a concept
Hi
There´s possible to share a sqlite3 handle to a memory database in all
threads of application?
Or there´s a way to duplicate the handle (sqlite_open() or something like
that)?
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> > sqlite3_vfs *sqlite3_vfs_find(const char *zVfsName);
> >
> >
> > The argument is the symbolic name for the desired VFS. If the argument
> > is a NULL pointer, then the default VFS is returned. The function
> > returns a pointer to the
On Aug 28, 2007, at 4:51 PM, Dennis Cote wrote:
I wonder if it might not be better to change this API to accept an
empty string, in addition to a NULL pointer, to find the default
VFS. It seems to me this might make life easier for those writing
wrappers in languages that don't have a
The "sqlite3_exec" function has resided in the "legacy.c" file since
shift to version 3. The function is still around in current v3.5 draft
as http://www.sqlite.org/capi350ref.html says.
That function is still kept around for compatibility reasons, as it
was a important function in SQLite v2
Just FYI, ODBC specs is very similar to JDBC, except that ODBC is in C whereas
JDBC is in java.
Thanks
Uma
Markus Hoenicka <[EMAIL PROTECTED]> wrote: Quoting Uma Krishnan :
> Hello Markus,
>
> How is libdbi different from, say odbc?
>
I've never used ODBC, but from what I read I'd say the
[EMAIL PROTECTED] wrote:
The transition from 3.4.2 to 3.5.0 will perhaps be the
largest single change to SQLite since 2.8->3.0.
I have *started* to prepare documentation describing
the changes in 3.5.0. This is draft documentation.
But for those who are interested, please visit
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- [EMAIL PROTECTED] wrote:
> > > The transition from 3.4.2 to 3.5.0 will perhaps be the
> >
> > > The SQLite code currently in CVS HEAD is not ready for
> > > production use. We know that. We know what many of the
>
Markus Hoenicka wrote:
Quoting Uma Krishnan <[EMAIL PROTECTED]>:
Hello Markus,
How is libdbi different from, say odbc?
I've never used ODBC, but from what I read I'd say the main differences
are the footprint and the scope. libdbi is language-specific (C),
lightweight, and allows you
Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- [EMAIL PROTECTED] wrote:
> > The transition from 3.4.2 to 3.5.0 will perhaps be the
>
> > The SQLite code currently in CVS HEAD is not ready for
> > production use. We know that. We know what many of the
> > problems are and Dan and I are working
Hi,
First my thanks to everyone for the response.
Sorry for the delay in replying I was on leave.
I am working on client server database method.
I am going to manage a large amount of data. Somewhere around 4 records.
Is it possible for me to fix the id range for each and every column.
So
Quoting Uma Krishnan <[EMAIL PROTECTED]>:
Hello Markus,
How is libdbi different from, say odbc?
I've never used ODBC, but from what I read I'd say the main
differences are the footprint and the scope. libdbi is
language-specific (C), lightweight, and allows you to do simple things
in
30 matches
Mail list logo
