a long time I am
confident that what we are doing is going to work.
Thanks to everyone for their input and patience during this thread. I'll
report back when I know more.
--
Joel Cochran
Greetings, Christian
-
To unsubscribe, send email to [EMAIL PROTECTED]
-----
--
Joel Cochran
sition is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original Message-
From: Joel Cochran [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 18, 2007 9:25 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Still getting "Insertion failed because database
isfull.&
AIL PROTECTED]> wrote:
"Joel Cochran" <[EMAIL PROTECTED]> wrote:
> should I be using
> Transactions for SELECT statements?
The only reason to use a transaction around SELECT statements
is if you want to make sure that the database is not changed
by another process in
the .NET Managed
Provider... if not, then I am just confused...
HTH,
Sam
Thanks Sam,
--
Joel Cochran
m going to seriously consider moving the database to the internal memory.
Thanks,
--
Joel Cochran
On 4/18/07, Christian Schwarz <[EMAIL PROTECTED]> wrote:
Hello Joel!
We were faced with similar problems in the field, too. Those were more
general ones with PCMCIA/CF/SD cards.
The reason w
no journal files. The user has full authority
to the entire system including the SQLite database.
Check for a journal file on the device after the error. Also
run the SQLite integrity-check on the database.
Dan.
OK, I'll have to find out about that...
Thanks,
--
Joel Cochran
with this
code so much that I'm ready to throw in the towel. But since I'd like to
keep my job that isn't an option. If I had hair, I'd pull it out.
Any help at all would be appreciated.
--
Joel Cochran
On 4/13/07, Michael Ruck <[EMAIL PROTECTED]> wrote:
Unless things have changed re
cards all the time, so if that
can extend the wear then it will be welcome.
Thanks a lot,
Joel
On 4/13/07, Dennis Cote <[EMAIL PROTECTED]> wrote:
Joel Cochran wrote:
>
> Or do you mean over the course of the lifetime of a CF card it can
> only be
> used so much?
John,
What do you mean by "general processing"? The database is on the CF card,
the application accesses the database. Other than what application normally
do (select, update, insert, etc.), I'm not sure what else to tell you.
Or do you mean over the course of the lifetime of a CF card it can
be its just the card, which is
corrupt and you're hitting these bugs at points, where the file system is
hitting a bad sector.
Is this running in a transaction?
Mike
-Ursprüngliche Nachricht-
Von: Joel Cochran [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 13. April 2007 17:46
An: [EMAIL PRO
I prefer the "ess cue ell" version. And I can never remmeber that there is
only one "el", so I end up saying "ess cue ell light" even though I know its
wrong.
--
Joel Cochran
On 4/4/07, Dennis Cote <[EMAIL PROTECTED]> wrote:
Hi All,
I have a simpl
was hoping to
have a head start before I get the device, because as it is I have no idea
what the cause could be.
Any thoughts would be greatly appreciated.
Thanks,
--
Joel Cochran
Thank you both... I'll be looking at those...
Joel
On 3/29/07, Griggs, Donald <[EMAIL PROTECTED]> wrote:
Hi Joel,
Have you already looked at:
http://www.sqlite.org/pragma.html#schema
(as well as sqlite_master as mentioned earlier)
-Original Message-
From: Joel Cochran [
Hi all,
Is there a way (through SQL) to retrieve metadata about an SQLite database?
Specifically I would like to find lists of tables, indexes, views, and table
schema.
Thanks,
--
Joel Cochran
fined as
CHAR(15). In the database, it's value is 'MIKE '
SELECT *
FROM MYFILE
WHERE NAMEFIELD = 'MIKE'
will return this row.
That is NOT true for SQLite, which would require the full 15 characters,
blanks and all, to return the row. That is all my original message was
asking about.
Thanks,
--
Joel Cochran
Yes, that's what I have decided to do: I am going to trim off the trailing
blank on the way into SQLite.
Thanks everyone,
--
Joel Cochran
On 3/27/07, John Stanton <[EMAIL PROTECTED]> wrote:
Why not get a better database by stripping out the trailing spaces?
Joel Cochran wrote:
&g
Did you create the index before or after populating the database?
--
Joel Cochran
On 3/27/07, Stephen Toney <[EMAIL PROTECTED]> wrote:
Hi everyone,
I'm trying to speed up index creation:
CREATE TABLE keyword (key, contyp int, imagecount int, searchcat int,
value, nextword, se
to insert the records into SQLite. The SQLite
version is the most recent (1.0.40?) and the platform is Windows. The data
file is then shipped to a Compact Framework application and is used on a
Windows Mobile device, so there is that platform as well.
Thanks,
--
Joel Cochran
On 3/26/07, Robert
Cochran
Stonewall Technologies, Inc.
On 3/26/07, P Kishor <[EMAIL PROTECTED]> wrote:
On 3/26/07, Joel Cochran <[EMAIL PROTECTED]> wrote:
> Howdy all,
>
> I am new to SQLite, so I hope this isn't too much of a newbie question,
but
> I searched the Internet, the arc
of you to
commiserate with!
Thanks,
--
Joel Cochran
Stonewall Technologies, Inc.
21 matches
Mail list logo
