Hello,
FYI, Compiling for Pocket PC 2003 stopped to work since version 3.7.1
and 3.7.2. So using 3.6.23.1 for now until it gets fixed.
1Compiling...
1sqlite3.c
1..\..\Common\sqlite3\sqlite3.c(30471) : error C2065:
'LOCKFILE_EXCLUSIVE_LOCK' : undeclared identifier
Dear All,
I am quite new to databases in general and sqlite in particular.
I have a number of data files which are nothing else than text files with a
pretty simple simple structure: there are only 3 columns of integer numbers,
something along these lines
123 1000 199
123 1100 188
125
Lorenzo Isella lorenzo.ise...@... writes:
[...]
if you've no idea where a db can help you and if you don't have time to
investigate this and the possibilities a db offers you my suggestion is:
import your 3 or 5 files into a spreadsheet, add a column for your different
campaign and that's it
1. Define a separate file in SQLite for each campaign, with the three
columns you need:
CAMPAIGN1
Time number (assuming the values are always numbers; use TEXT if they
contain a mix of letters/numbers)
TagA number
TagB number
CAMPAIGN2
Time
TagA
TagB
Etc.
2. Import each of your text files
There have been several posts on this issue just this week, and suggested
workarounds.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joachim Wickman
Sent: Wednesday, August 25, 2010 12:37 AM
To: sqlite-users@sqlite.org
Hi,
I only saw http://article.gmane.org/gmane.comp.db.sqlite.general/58835,
was there anything else?
-Nikolaus
Gerry Snyder mesmerizerfan-re5jqeeqqe8avxtiumw...@public.gmane.org writes:
Er, did you not see Dan Kennedy's comments a fed days ago??
On 8/24/10, Nikolaus Rath
Doug Currie doug.currie-re5jqeeqqe8avxtiumw...@public.gmane.org writes:
On Aug 24, 2010, at 10:57 AM, Nikolaus Rath wrote:
Nikolaus Rath
nikolaus-bth8mxji4b0-xmd5yjdbdmrexy1tmh2...@public.gmane.org
writes:
Still no one able to clarify the issues raised in this thread?
Let me try to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a table of UPCs with lengths varying from 6 to 12. I'd like to
print those with length=10 to a file for printing.
SELECT *
FROM UPCs
WHERE LENGTH(UPC)=10;
works just fine. But when I export the table I naturally get the whole
table. Would
On Wed, Aug 25, 2010 at 10:05 AM, Ted Rolle Jr. ster...@gmail.com wrote:
I have a table of UPCs with lengths varying from 6 to 12. I'd like to
print those with length=10 to a file for printing.
SELECT *
FROM UPCs
WHERE LENGTH(UPC)=10;
works just fine. But when I export the table I
So simple. I never thought of using the command-line sqlite3...
in the sqlite3 shell, set output mode to file, and then select as
above. All your select output will go to your file.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Nikolaus,
I've traced your application a bit (with SQLite 3.6.18 sources) and
it looks like SQLite does some nasty thing nobody in this thread
expected. For some reason while doing first delete SQLite actually
commits transaction and degrades lock to SHARED. Then of course second
delete cannot
On Aug 25, 2010, at 10:40 PM, Pavel Ivanov wrote:
Nikolaus,
I've traced your application a bit (with SQLite 3.6.18 sources) and
it looks like SQLite does some nasty thing nobody in this thread
expected. For some reason while doing first delete SQLite actually
commits transaction and
Prior to version 3.6.5 SQLite used to delay committing the
transaction until all SELECT statements had finished. But that
behavior was deemed to be less intuitive.
But this is the current 3.7.1 documentation
(http://www.sqlite.org/lockingv3.html):
If multiple commands are
On Aug 25, 2010, at 11:04 PM, Pavel Ivanov wrote:
Prior to version 3.6.5 SQLite used to delay committing the
transaction until all SELECT statements had finished. But that
behavior was deemed to be less intuitive.
But this is the current 3.7.1 documentation
It seems that IBM's AIX is finicky with large file support, at least on the
system I'm working on. Out of the box, large file support will be disabled
for aix when compiling the sqlite3 amalgamation.
I had to make the following changes in sqlite3.c:
#ifndef SQLITE_DISABLE_LFS
# define
Hello,
Can some one please help me how do I connect to SQLite from a JSP page with
windows authentication mode?
Thank you,
Dev
--- On Wed, 8/25/10, Richard Hipp d...@sqlite.org wrote:
From: Richard Hipp d...@sqlite.org
Subject: Re: SQlite JDBC driver - need help
To: Dev Movva
All,
I am pleased to announce that DBD::SQLite (Self Contained RDBMS in a Perl DBI
Driver) version 1.30_04 has been released on CPAN (by Adam Kennedy).
http://search.cpan.org/~adamk/DBD-SQLite-1.30_04/
This developer release bundles the brand-new SQLite version 3.7.2, which (since
3.7.0)
17 matches
Mail list logo