On 05/27/2014 02:24 AM, Richard Hipp wrote:
Please download beta snapshots of SQLite 3.8.5 from
http://www.sqlite.org/download.html and test them in your applications. We
hope to release SQLite version 3.8.5 within the next few weeks.
See http://www.sqlite.org/draft/releaselog/3_8_5.html
2014-05-27 5:57 GMT+02:00 jose isaias cabrera cabr...@wrc.xerox.com:
Richard Hipp wrote...
Please report any problems to this mailing list and/or directly to me.
I am having problem using the pre-built DLL:
http://www.sqlite.org/snapshot/sqlite-dll-win32-x86-201405262205.zip
I am
Visual Studio 2013 Update 1 and newer allows explicitly to target Windows
XP, but it has to be compiled with correct runtime library.
Best regards,
Filip Navara
On Tue, May 27, 2014 at 11:33 AM, Jan Nijtmans jan.nijtm...@gmail.comwrote:
2014-05-27 5:57 GMT+02:00 jose isaias cabrera
On Tue, May 27, 2014 at 4:18 AM, Török Edwin edwin+sqli...@etorok.netwrote:
On 05/27/2014 02:24 AM, Richard Hipp wrote:
Please download beta snapshots of SQLite 3.8.5 from
http://www.sqlite.org/download.html and test them in your applications.
We
hope to release SQLite version 3.8.5
On 05/27/2014 01:40 PM, Richard Hipp wrote:
On Tue, May 27, 2014 at 4:18 AM, Török Edwin edwin+sqli...@etorok.netwrote:
On 05/27/2014 02:24 AM, Richard Hipp wrote:
Please download beta snapshots of SQLite 3.8.5 from
http://www.sqlite.org/download.html and test them in your applications.
We
2014-05-27 1:24 GMT+02:00 Richard Hipp d...@sqlite.org:
Please report any problems to this mailing list and/or directly to me.
$ gcc -DSQLITE_USE_FCNTL_TRACE -c sqlite3.c
sqlite3.c: In function ‘sqlite3VdbeExec’:
sqlite3.c:73742:37: error: expected expression before ‘==’ token
if(
Jan Nijtmans wrote...
2014-05-27 5:57 GMT+02:00 jose isaias cabrera cabr...@wrc.xerox.com:
Richard Hipp wrote...
Please report any problems to this mailing list and/or directly to me.
I am having problem using the pre-built DLL:
On Tue, May 27, 2014 at 10:39 AM, jose isaias cabrera cabr...@wrc.xerox.com
wrote:
Jan Nijtmans wrote...
2014-05-27 5:57 GMT+02:00 jose isaias cabrera cabr...@wrc.xerox.com:
Richard Hipp wrote...
Please report any problems to this mailing list and/or directly to me.
I am
Richard Hipp wrote...
On Tue, May 27, 2014 at 10:39 AM, jose isaias cabrera
cabr...@wrc.xerox.com
wrote:
Jan Nijtmans wrote...
2014-05-27 5:57 GMT+02:00 jose isaias cabrera cabr...@wrc.xerox.com:
Richard Hipp wrote...
Please report any problems to this mailing list and/or
All,
Is there any difference between using REPLACE as opposed to deleting records
and then inserting new ones to take their place?
Thanks,
--
Bill Drago
Senior Engineer
L3 Communications / Narda Microwave Easthttp://www.nardamicrowave.com/
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 /
On Tue, May 27, 2014 at 2:11 PM, Drago, William @ MWG - NARDAEAST
william.dr...@l-3com.com wrote:
All,
Is there any difference between using REPLACE as opposed to deleting
records and then inserting new ones to take their place?
REPLACE only deletes records when it is absolutely necessary
On Tue, May 27, 2014 at 10:50 AM, Richard Hipp d...@sqlite.org wrote:
On Tue, May 27, 2014 at 10:39 AM, jose isaias cabrera
cabr...@wrc.xerox.com wrote:
H... I am running the original DLL created for 3.8.4.3 on the WinXP
and
it works fine, so it was not a change as far as v3.17 and
On May 27, 2014, at 8:11 PM, Drago, William @ MWG - NARDAEAST
william.dr...@l-3com.com wrote:
Is there any difference between using REPLACE as opposed to deleting records
and then inserting new ones to take their place?
Same difference.
For example:
create table foo
(
id integer
Richard Hipp wrote...
On Tue, May 27, 2014 at 10:50 AM, Richard Hipp d...@sqlite.org wrote:
On Tue, May 27, 2014 at 10:39 AM, jose isaias cabrera
cabr...@wrc.xerox.com wrote:
H... I am running the original DLL created for 3.8.4.3 on the WinXP
and
it works fine, so it was not a change
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Richard Hipp
Sent: Tuesday, May 27, 2014 2:15 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] DELETE INSERT vs. REPLACE
On Tue, May 27, 2014 at 2:11
Seems no solution?
if use sqlite 3, PRAGMA short_column_name=ON run correctly
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/PRAGMA-short-column-names-ignored-when-GROUP-BY-is-used-tp22272p75842.html
Sent from the SQLite mailing list archive at Nabble.com.
Hi there,
We use SQLite in our application to store the data, and some of our users
prefer to keep the files on a network drive. The application opens a connection
to sqlite database and keeps it open for a while, storing and retrieving the
data at user's request.
The issue that some clients
Just lately, I am having to change my SQL statements to retrieve data.
Queries that use to be set to things such as WHERE some_int_field =
other_int_field is now forcing me to do WHERE some_int_field LIKE
other_int_field which is obviously slower. Any thoughts? Both fields are
set as integer.
Yes, very interesting. I didn't realize that the pk would auto-increment on a
replace.
-Bill
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Petite Abeille
Sent: Tuesday, May 27, 2014 3:01 PM
To: General Discussion of
Jan Nijtmans wrote...
2014-05-27 5:57 GMT+02:00 jose isaias cabrera cabr...@wrc.xerox.com:
Richard Hipp wrote...
Please report any problems to this mailing list and/or directly to me.
I am having problem using the pre-built DLL:
On Tue, May 27, 2014 at 8:58 AM, Mike Appenzellar mappenzel...@gmail.comwrote:
Just lately, I am having to change my SQL statements to retrieve data.
Queries that use to be set to things such as WHERE some_int_field =
other_int_field is now forcing me to do WHERE some_int_field LIKE
On 27 May 2014, at 1:58pm, Mike Appenzellar mappenzel...@gmail.com wrote:
WHERE some_int_field LIKE
other_int_field which is obviously slower. Any thoughts? Both fields are
set as integer. Would be be causing this?
Why on earth are you using LIKE to match integers ? It's for strings.
On 27 May 2014, at 9:12pm, Drago, William @ MWG - NARDAEAST
william.dr...@l-3com.com wrote:
Let me rephrase the question by asking, how should I overwrite existing data?
For example, Jane has 5 guitars in her instrument table. She trades her 5
guitars for 5 new ones. Almost everything
On 26 May 2014, at 3:06pm, sbmzhcn sbmz...@gmail.com wrote:
Seems no solution?
if use sqlite 3, PRAGMA short_column_name=ON run correctly
Please note that this PRAGMA is deprecated and you should not be creating new
code that depends on it. If you want a column to have a specific name
If you are interested to try an sqlite3.dll built by the latest
MinGW (version 4.0.3), you can have a look here:
I believe the latest MinGW gcc version is
gcc version 4.8.1 (GCC)
___
sqlite-users mailing list
sqlite-users@sqlite.org
Denis Y. Zibarev wrote:
The problem goes down to winLock() implementation, particularly to
winLockFile() ...
I've made some experimental changes on the winLockHandle branch that should
address
this issue; however, I still need to add some tests to verify the new
behavior.
--
Joe Mistachkin
26 matches
Mail list logo