System.Data.SQLite version 1.0.77.0 is now available on the
System.Data.SQLite website:
http://system.data.sqlite.org/
Further information about this release can be seen at
http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
Please post on the SQLite mailing list
Hi,
My proc is an ARM920T, but yes, it did solve the problem.
Thank you very much !!
L.
Kees Nuyt writes:
On Fri, 25 Nov 2011 12:30:10 +0100, Laurent PERROTON
l.perro...@esiee.fr wrote:
I am having a cross-platform Intel/ARM sqlite file issue.
...the file format is
I'd appreciate some direction on how to make this work.
I have one process that writes on a database. It realoads tables by
filling a new table and then replacing the old one via a drop and a
rename within a transaction.
Then there are several processes that just read from this database.
I
On 28 Nov 2011, at 5:10pm, Alejandro Martínez wrote:
I have one process that writes on a database. It realoads tables by
filling a new table and then replacing the old one via a drop and a
rename within a transaction.
Then there are several processes that just read from this database.
I
The reader processes create all the papared statements at startup, so
they would be parsed only once.
then, whenever they need to read from the db, they just reset, bind
and step the prepared statements i already had.
Is that wrong?
On Mon, Nov 28, 2011 at 3:15 PM, Simon Slavin
On 11/28/2011 12:10 PM, Alejandro Martínez wrote:
I'd appreciate some direction on how to make this work.
I have one process that writes on a database. It realoads tables by
filling a new table and then replacing the old one via a drop and a
rename within a transaction.
Then there are several
The thing is, it seems this readers don't ever see any changes in
the db unless i shut them down and run them again.
But connecting with the sqlite3 shell shows the changes in the db as
they happen.
The above two facts suggest that your readers do not close their
reading transactions
On 11/28/2011 12:21 PM, Alejandro Martínez wrote:
The reader processes create all the papared statements at startup, so
they would be parsed only once.
then, whenever they need to read from the db, they just reset, bind
and step the prepared statements i already had.
Do it in a different
Ok!
I'll check all this points.
Thank you all a lot. This is my first time working with sqlite and it
is so great finding out that it's got such an active and friendly
community.
Cheers!
On Mon, Nov 28, 2011 at 3:24 PM, Pavel Ivanov paiva...@gmail.com wrote:
The thing is, it seems this
Worked like a charm :D
Thank you again!
Ale
2011/11/28 Alejandro Martínez elpeq...@gmail.com:
Ok!
I'll check all this points.
Thank you all a lot. This is my first time working with sqlite and it
is so great finding out that it's got such an active and friendly
community.
Cheers!
Hello,
I am trying to use SQLite on an embedded device (using cvm/CDC 1.1). So far
I was getting a ClassNotFoundException on SQLException.
Do you guys have any idea why is that?
I did some googling and found out that we can't use DriverManager for
jsr169 (for CDC 1.1). What other class can I
There's a bunch of wrappers listed...you'll need to experiment unless somebody
knows what works on your device.
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman
I am looking for information on the new version of the ADO provider for net
2.0/3.5.
I have downloaded
http://system.data.sqlite.org/sqlite-netFx-source-1.0.77.0.zip
sqlite-netFx-source-1.0.77.0.zip but was unable to locate anything specific
to the above. Could anyone offer some news on
Hi,
When working with queries that produce very large result sets, I would like to
be able to return these results in manageable batches to the requester.
First thought was to hold a handle to the results set and return the responses
in batches - doesnt seem too good since it holds a read
On Mon, Nov 28, 2011 at 3:26 PM, Liam Kenny l...@druidsoftware.com wrote:
Hi,
When working with queries that produce very large result sets, I would
like to be able to return these results in manageable batches to the
requester.
First thought was to hold a handle to the results set and
Hi,
Today I've been trying to run my .NET application on Mono with SQLite.
It is running fine on Windows (.NET 4.0) with MySQL and SQLite, and I'm
successfully using it on Linux (Mono 2.10) with MySQL only. But now that
I wanted to actually use SQLite on Linux, it failed. The error it gives
me is
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
problem I cannot figure out after plenty of trying. I keep getting the
error message:
I think this is a bug in SQL Lite I just came across this today and found
that there is an update pending that claims to resolve it
Not sure if this is the link but it is the site...
http://system.data.sqlite.org/index.html/timeline
M
-Original Message-
From:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
problem I cannot figure out after plenty of trying.
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
On 11/28/2011 5:08 PM, Dave wrote:
I just checked and the 0K file that is created is the same name except
it has .db3 added to it's name.
Why is this suprising? Your connection string requests a file named
MyDatabase.db3. Is this not the file you want to connect to?
--
Igor Tandetnik
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
On Mon, Nov 28, 2011 at 5:13 PM, Dave thesche...@cox.net wrote:
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
Yes, that is what I am trying to connect to. The problem is that it
apparently doesn't connect to it as it cannot see the tables in it. So
it creates another database file that has 0K in size. My database file
has the correct icon next to it's name with a little key in the pic
where the one
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3 to it and it remains in the same folder as the other file with
one exception. The properties for my database shows:
type: Data Base File
Where the one generated at 0K with the same
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
Thanks,
Dave
On 11/28/2011 4:14 PM, Igor Tandetnik wrote:
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3
Thanks John.
On 11/28/2011 4:18 PM, John Drescher wrote:
You probably have Hide extensions for known types enabled in windows
When this is enabled windows does not display the extension for known
types so that if you have more than 1 file with the same base name they
will appear as the same
On 11/28/2011 5:23 PM, Dave wrote:
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
It doesn't have .db added. It had it all along, you just couldn't see it.
Anyway, now you can name your file however you want. Make sure
On 28 Nov 2011, at 10:32pm, Igor Tandetnik wrote:
On 11/28/2011 5:23 PM, Dave wrote:
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
It doesn't have .db added. It had it all along, you just couldn't see it.
Anyway,
Thanks Igor,
I am just getting started so I am bound to get tripped up a little.
:-) That was going to be my next question anyhow, about the database
name. I was thinking we *had* to have the extension .db3 but you have
answered that. I just have been using VB.Net less than 30 days and that
Thanks Simon,
Actually, I knew that. Just having a bit of a multiple crash
course...all at once. I just recently built this pc and have been on XP
until recently too. I do some graphic stuff and have many same named
pics with the various .jpg, .bmp, .gif extensions.
Dave
On 11/28/2011 4:37
On 28 Nov 2011, at 10:44pm, Dave wrote:
On 11/28/2011 4:37 PM, Simon Slavin wrote:
Just to stress that the filename includes the bit after the '.'. You can
have any number of files with the same part before the '.' but different
extensions. To tell the operating system which one you want
On 11/28/2011 4:59 PM, Simon Slavin wrote:
On 28 Nov 2011, at 10:44pm, Dave wrote:
On 11/28/2011 4:37 PM, Simon Slavin wrote:
Just to stress that the filename includes the bit after the '.'. You can have
any number of files with the same part before the '.' but different extensions.
To
I have downloaded
http://system.data.sqlite.org/sqlite-netFx-source-1.0.77.0.zip
sqlite-netFx-source-1.0.77.0.zip but was unable to locate anything
specific
to the above. Could anyone offer some news on whether or not there will be
an installer for this provider into Visual Studio 2008.
The error it gives
me is a DllNotFoundException for SQLite.Interop.dll. But from what I've
read on the web by now, this isn't the path to go. I think I need some
sort of managed-only SQLite version that will use the platform's
libsqlite (in my Ubuntu, 3.7.7 is installed). Unfortunately I
35 matches
Mail list logo