Joe,
I'm afraid this doesn't seem to fix the issue.
Just out of interest are you able to run the code I sent on a real device or in
an emulator? I'm testing on a Motorola ES400 and didn't initially think to try
switching to the emulator which doesn't seem to throw the error (still testing
Thanks
I forgot to include coding language (vb)
Do you know where can i find a sample code.
Thanks Again
Sent from my iPhone
On Oct 4, 2012, at 4:47 PM, Bart Smissaert bart.smissa...@gmail.com wrote:
What is your coding language?
If VB then maybe via ODBC and ADO.
RBS
On Thu, Oct 4,
To connect to SQLite I recommend the VB wrapper written by Olaf Schmidt:
http://www.thecommon.net/
There are plenty of examples to connect to SQL Server with VB, ADO and ODBC.
A simple Google search will find them.
RBS
On 10/5/12, Jorge cotrinago...@yahoo.com wrote:
Thanks
I forgot to include
Thank you for your answer Mr.Simon Davies, but it seems that in a sqlite
format 3 file (that i have), the offset 28 value is not valid(not equal to
the file size) and surely not equal to offset 92 (00 00 00 00), what i am
trying to do, is extract an SQLite Format 3 file from the hex code of
Hello,
I've attached a patch which caches the column names in SQLiteDataReader.
During profiling a scenario where more than 100-200 records are read and
columns are accessed by name and not by index -- well over 50% of the time
was spent in System.Data.SQLite.SQLite3.ColumnIndex(). The attached
Hello,
I am currently developing a program that will use an sqlite database and I
would like to know if it is possible to load a database from a memory stream in
c#?
I would like to house my database in a ZIP file and extract the database to a
memory stream and then open it directly from the
Don't know why the patch didn't get through, sending again...
===
diff -ur a\System.Data.SQLite\SQLiteDataReader.cs
b\System.Data.SQLite\SQLiteDataReader.cs
--- a\System.Data.SQLite\SQLiteDataReader.csSat Aug 11 16:40:46 2012
+++ b\System.Data.SQLite\SQLiteDataReader.csFri Oct 05
It would seem to me that if GC.Collect fixes the problem than all you've done
is move the problem to someplace else that isn't fatal (at the moment) and
could rear its ugly head at most any time.
The reason your emulator doesn't throw the error would be for the same
reason...different memory
Michael,
Completely agree with your conclusion the GC.Collect is pretty much a plaster
over a severed limb, it's just hiding the problem rather than solving it. Just
mentioned it in case that gave Joe any ideas.
My code is all c# and the link privided I believe is a c++ only feature. I
On 10/05/2012 04:29 AM, Jonathan Engle wrote:
Ok, so here's a question (trying an experiment to see if this will
work, but throwing it out here as well).
What if the source db handle for the backup is opened to use private
cache? Will this have any effect at all or is it the cache mode of
db2
Hi,
I am looking for a diagramming tool for a sqlite
database. I want functionality similar to the diagrammer in sql server
management studio. Any suggestions?
Bill
___
sqlite-users mailing list
sqlite-users@sqlite.org
Ashish Kulkarni wrote:
Hello,
I've attached a patch which caches the column names in SQLiteDataReader.
During profiling a scenario where more than 100-200 records are read and
columns are accessed by name and not by index -- well over 50% of the time
was spent in
Matthew Dumbleton wrote:
I'm afraid this doesn't seem to fix the issue.
Odd, it seemed like a disposal race condition. I thought the additional
locking
semantics would fix it. On the desktop versions of the .NET Framework,
there is
an actual CriticalHandle class and the necessary
Joe Mistachkin wrote:
Good idea; however, I'm going to implement the column index caching using
a
Dictionary, which will result in slightly more efficient operation.
The changes can be seen here:
http://system.data.sqlite.org/index.html/ci/bdd8e44fd0
I'm curious what performance
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/10/12 05:47, Chris Sonon wrote:
I would like to house my database in a ZIP file and extract the
database to a memory stream and then open it directly from the memory
stream? Is this possible? If so, how?
You can get a zipvfs from the SQLite
15 matches
Mail list logo