Hi,
Any help to the below problem is of great help.
Regards,
Reddy
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Kotapalle Purushotham (Nokia-D/Bangalore)
Sent: Tuesday, September 08, 2009 12:57 PM
To:
On Sep 14, 2009, at 1:35 PM, purushotham.kotapa...@nokia.com wrote:
Hi,
Any help to the below problem is of great help.
Please check if this happens with 3.6.18. I think these
issues may be fixed now.
Dan.
Regards,
Reddy
-Original Message-
From:
UIT DEVELOPMENT wrote:
Are you wanting something like this:
INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
VALUES (123456789, 1, NOW())
ON DUPLICATE KEY UPDATE 'visitorcount' = 'visitorcount' + 1
the key statement being: ON DUPLICATE KEY UPDATE
not tested but it seems
I tried twice to post it but it seems it didn't find its way to the
list. Sorry if ever it gets dupped.
Hi,
insert or replace deletes all rows that weren't specified in the query
Do you have a short example where INSERT OR REPLACE INTO ... can be
shown to actually _delete_ rows?
Which query
At 01:29 14/09/2009, you wrote:
´¯¯¯
CREATE TABLE table1( id INTEGER PRIMARY KEY ON CONFLICT REPLACE,
field1 TEXT
);
but I think that the table has to already have been created this way.
`---
Yes from what he said, I also believe this is the right and simplest way.
Jean-Christophe Deschamps wrote:
Do you have a short example where INSERT OR REPLACE INTO ... can be
shown to actually _delete_ rows?
Which query are you refering to?
sorry, i meant columns not rows, whet i do insert command, specifying
existing id and only some of the columns then the
Bear in mind a relational database is designed around relations. It's not
obvious what your 'data model' is but there is a suggestion it contains
variable types of things. If you want to store variable things then many of
the features of a relational database don't work.
Often an object maps
At 10:25 14/09/2009, you wrote:
´¯¯¯
sorry, i meant columns not rows, whet i do insert command, specifying
existing id and only some of the columns then the rest of the columns are
deleted
on the other hand, UPDATE command won't allow me to insert a new row
Then you can still do something along
My guess is that
sqlite isn't built to understand that word_id is unique (i.e. GROUP BY
is guaranteed to do absolutely nothing in this case).
SQLite is not smart enough to guess these things. And in fact I doubt
that any database is smart enough to guess such things. So I'd suggest
you to
I am trying to fix a problem with a friend's computer that started 2 days ago.
When trying to use Picasa,Google's picture viewer,she get's this error
messagePicasa3.exe-Entry Point Not Found. The procedure entry point
sqlite3_prepare_v2 could not be located in the dynamic link library
make test became faild. What's wrong?
I tried with sqlite-3.6.17.tar.gz and sqlite-3.6.18.tar.gz, but both packages
failed by running make test. Environments are Cygwin on WindowsXP SP3 and
VineLinux4.2 (http://www.vinelinux.org/).
Attached files were recorded by make test foo.log after running
Hello,
I want to get the query excuted on every table in my sqlite data base with
the new values inserted or updated and save the query in another table in
the same database. I try with this code to create the trigger:
CREATE TRIGGER trig_insert_contact_req AFTER INSERT ON contact
BEGIN
INSERT
I bet you need to check version of sqlite3.dll in c:\windows\system32
or c:\windows and change it to the new one.
Pavel
On Sun, Sep 13, 2009 at 11:48 AM, Irene Mickey Demoran
ireneandmic...@cableone.net wrote:
I am trying to fix a problem with a friend's computer that started 2 days
ago.
Thanks a lot. That was the problem.
Igor Tandetnik wrote:
Sara1409 wrote:
It is clear that those variables (new.contactnom, new.contactage,
new.contactmobile, new.contactmail, new.contactadresse) are token as
String, I tried many combinations (' + new.contactnom +', ' +
new.contactnom
Thanks Kees. My app still needs some optimizations, your suggestions look
good.
One question though: what will happen when id reaches 2^32 - 1 ? (This app
is going to log a lot of events, 24/7 for a long time, so it's not a purely
theoretical question.)
Kees Nuyt wrote:
On Fri, 4 Sep 2009
Hi,
I have an error for sometime compiling the latest versions of SQLite
amalgamation on eVC++ 4
error: 'Z' : use of class template requires template argument list
The problem is in the declaration of sqlite3_blob_read prototype.
It is declared in sqlite3.h and sqlite3.c as:
SQLITE_API int
On Mon, Sep 14, 2009 at 02:21:51PM +0100, Filipe Madureira scratched on the
wall:
Hi,
I have an error for sometime compiling the latest versions of SQLite
amalgamation on eVC++ 4
SQLite cannot be compiled with a C++ compiler. You must use a C
compiler.
-j
--
Jay A. Kreibich J A
Error message suggests that you're compiling C code of SQLite as C++.
So the first suggestion will be - do not do that, It's not always
compatible. Change settings for compilation of sqlite3.c to C language
(I don't know how it's done in VC++ 4, sorry).
Pavel
On Mon, Sep 14, 2009 at 9:21 AM,
On Mon, Sep 14, 2009 at 01:25:29AM -0700, yogibabu scratched on the wall:
Jean-Christophe Deschamps wrote:
Do you have a short example where INSERT OR REPLACE INTO ... can be
shown to actually _delete_ rows?
Which query are you refering to?
sorry, i meant columns not rows, whet
Filipe Madureira wrote:
I have an error for sometime compiling the latest versions of SQLite
amalgamation on eVC++ 4
error: 'Z' : use of class template requires template argument list
The problem is in the declaration of sqlite3_blob_read prototype.
It is declared in sqlite3.h and sqlite3.c
And your compiler seems to be buggy
BTW, Wikipedia says that VC++ 4.0 was designed for Windows 95 and
Windows NT suggesting that it was released about 15 years ago (which
definitely mean that it has buggy C++ part). I'm just curious: for
what OS are you developing with this compiler now?
Pavel
eVC++ 4 is not the same as VC++ 4. eVC++ 4 is an embedded C/C++ compiler.
http://www.microsoft.com/downloads/details.aspx?FamilyId=1DACDB3D-50D1-41B2-A107-FA75AE960856displaylang=en
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION
eVC++ 4 is not the same as VC++ 4. eVC++ 4 is an embedded C/C++ compiler.
I do apologize. Thought that this 'e' was just a typo.
The same wiki page says that eVC++ was replaced by VC++ 2005
suggesting that it's much newer compiler. And it makes more strange
that it has such bug...
Pavel
On
On Mon, 14 Sep 2009 06:09:45 -0700 (PDT), wlof
wlo...@gmail.com wrote:
Thanks Kees. My app still needs some optimizations, your suggestions look
good.
One question though: what will happen when id reaches 2^32 - 1 ? (This app
is going to log a lot of events, 24/7 for a long time, so it's not a
On 14 Sep 2009, at 10:38am, CityDev wrote:
Bear in mind a relational database is designed around relations.
It's not
obvious what your 'data model' is but there is a suggestion it
contains
variable types of things. If you want to store variable things then
many of
the features of a
On Mon, 14 Sep 2009 19:58:31 +0200, Kees Nuyt
k.n...@zonnet.nl wrote:
Oops, that should read
100 events per second during 15 years
= 4730400
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
Simon Slavin-2 wrote:
You can use property lists.
It's an interesting question as to what that gives you. It's clearly not a
relation if you know how it was formed but - just thinking about it briefly
- it may still behave as a relation as far as SQL is concerned. But it looks
dodgy to
I have an application that performs the following SQL action:
UPDATE table SET value = date('now', ?1, 'localtime') WHERE id = ?2
In my code I bind an integer to ?1. This results in null. I never intended
to code it that way, it is an honest to goodness bug. I wanted to bind
'+1 days' or
Rich Rattanni ratta...@gmail.com wrote:
Can a trigger reference the bound variables? I figure the answer is
NO.
The answer is NO.
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
i can't see the attachment
why don't you use the sqlite-amalgamation*.zip ? that's very easy to compile
2009/9/14 TEZ sqli...@tezukuri.hobby-site.org
make test became faild. What's wrong?
I tried with sqlite-3.6.17.tar.gz and sqlite-3.6.18.tar.gz, but both
packages
failed by running make
30 matches
Mail list logo