> On Oct 5, 2016, at 5:49 AM, Santiago Bayeta wrote:
>
> But I also read from SQLite docs that now SQLite supports unlimited Reading
> operations while writing.
It does if the databases uses a WAL (Write-Ahead Log). This is a persistent
per-database setting that can be enabled by a ‘pragma’ c
You are using the straight SQLite classes to execute commands and such. Why
not use EF6 and use SQLite as a data source. All the visual studio stuff works
with it just the same a SQL server. If you can use .Net 4.0 or 4.5 then that
is the way to go. You can use the EF 6 entity diagrams to de
7;
Subject: Re: [sqlite] [SQLite.NET] Cannot read BLOB data
Kevin Keigwin wrote:
>
> I cannot read the data into a DataTable using the adapter, because the
> exception "Invalid storage type: DBNull." is thrown.
>
There was a recently fixed issue with the SQLiteDataAdapter
Kevin Keigwin wrote:
>
> I cannot read the data into a DataTable using the adapter, because the
> exception "Invalid storage type: DBNull." is thrown.
>
There was a recently fixed issue with the SQLiteDataAdapter class. The fix
can be seen here:
https://system.data.sqlite.org/index.ht
On Wed, 22 May 2013 12:23:12 -0700
"Kevin Keigwin" wrote:
> What I don't understand is why the database is so forgiving of dates
> being saved, while the SQLiteDataAdapter isn't.
As Simon said, "SQLite doesn't have a DateTime type." As far as SQLite
is concerned, your datestring is a string, no
On 22 May 2013, at 8:23pm, "Kevin Keigwin" wrote:
> And I've discovered the source of the problem by downloading the source code
> and debugging the SQLiteDataAdapter. I had created some test data through
> the GUI tool and entered a non-ISO8601 date string. Because SQLite is so
> forgiving wh
>Can you try the other stuff I wrote ? We don't yet have enough information
to figure out what's going wrong.
>Simon.
Sorry, Simon. I missed what else you wrote because it was embedded in my
original email text. My error.
And I've discovered the source of the problem by downloading the source
On 22 May 2013, at 7:59pm, Kevin Keigwin wrote:
> I understand.
Can you try the other stuff I wrote ? We don't yet have enough information to
figure out what's going wrong.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.
>SQLite doesn't have a DateTime type. If you are using some sort of library
which does type testing and produces an error if the value is of >the wrong
type, it will always produce an error message when checking for DateTime.
>Simon.
I understand. As I said in my post, the underlying type of th
On 22 May 2013, at 5:47pm, "Kevin Keigwin" wrote:
> When our code tries to execute "SELECT * FROM ORDER by
> .id", I get the exception "String was not recognized as a valid
> DateTime".
Use your code to populate your database but don't worry about a SELECT command.
Download the sqlite3 shell
On Fri, 19 Apr 2013 16:41:53 -0700, "Joe Mistachkin"
wrote:
>Actually, ALL the non-static packages on the download page require the MSVC
>runtime libraries of the appropriate version to be installed.
>
>The download page does mention these requirements in each applicable
>download
>package sectio
Gilles Ganault wrote:
>
> Got it: "Dependency Walker" shows that the (no-)bundle versions rely
> on MSVCR110.DLL, which is part of the "Visual C++ Redistributable for
> Visual Studio 2012 Update 1", available here:
>
> www.microsoft.com/en-us/download/details.aspx?id=30679
>
> Once installed, th
On Fri, 19 Apr 2013 23:42:19 +0200, Gilles Ganault
wrote:
>Thanks the tip. More testing in the IDE shows that it works OK even
>when editing the PATH, and I can no longer trigger the "Unable to
>load DLL 'SQLite.Interop.dll': The specified module could not be
>found. (Exception from HRESULT: 0x80
On Thu, 18 Apr 2013 23:46:58 -0400, markus diersbock
wrote:
>Since it worked, you can move the files to any final folder, and add a
>reference to System.Data.SQLite.dll
>
>And add your folder to PATH, to find SQLite.Interop.dll
Thanks the tip. More testing in the IDE shows that it works OK even
w
Putting them in your /debug folder was just to troubleshoot.
Since it worked, you can move the files to any final folder, and add a
reference to System.Data.SQLite.dll
And add your folder to PATH, to find SQLite.Interop.dll
For the end-user you can keep it simple and put the files in the same
fo
On Thu, 18 Apr 2013 13:36:54 -0400, markus diersbock
wrote:
>Put SQLite.Interop.dll in the same folder as your VB assembly (ie
>/debug or /release)
Thanks for the tip.
But it's kind of a pain to have to copy SQLite.Interop.dll +
System.Data.SQLite.dll in \debug with every new project.
Why can't
Sorry... replied to the wrong message. :(
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Marc L. Allen
Sent: Thursday, April 18, 2013 1:40 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] [SQLite.Net] Right
abase
Subject: Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?
Put SQLite.Interop.dll in the same folder as your VB assembly (ie /debug or
/release)
On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote:
> Hello,
>
> I'm having a problem getting VB Express to find
Put SQLite.Interop.dll in the same folder as your VB assembly (ie
/debug or /release)
On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote:
> Hello,
>
> I'm having a problem getting VB Express to find SQLite .Net:
>
> 1. I went to...
> http://system.data.sqlite.org/index.html/doc/trunk/www/down
On Thu, 18 Apr 2013 16:10:48 +0200, Gilles Ganault
wrote:
>It did work finally by using
>
>sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip
I wanted to edit the FAQ to spare other newbies, but even after
logging on as "anonymous" and typing the one-time password, there's no
Edit link a
It doesn't work either with
sqlite-netFx45-binary-bundle-Win32-2012-1.0.84.0.zip
whether System.Data.SQLite.dll is located in .\Externals or some other
location.
It did work finally by using
sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip
Could it be due to VC++ dependency?
_
On Thu, 18 Apr 2013 15:32:02 +0200, Gilles Ganault
wrote:
>Does it mean that we have to copy the two files in each and every
>application, instead of just putting them in eg. C:\Windows?
Still no go.
1. Per the FAQ
(http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q8),
created .\E
On Thu, 18 Apr 2013 09:27:00 -0400, Kevin Benson
wrote:
>http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html
Thanks.
"In order for this to work successfully, it must be able to locate
that file at runtime, which means the "SQLite.Interop.dll" file must
reside in the
http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html
--
--
--
--Ô¿Ô--
K e V i N
On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote:
> Hello,
>
> I'm having a problem getting VB Express to find SQLite .Net:
>
> 1. I went to...
> http://sys
check the target CPU, if not x86, will probably fail.
On Fri, Jun 8, 2012 at 12:37 AM, netra wrote:
> Hi,
>
>
> Hope you could help me immediate on this issue.
> I am using System.Data.SQLite.DLL (version 1.0.66.0) but when i am adding to
> WPF setup i am unable to see this dll in the setup.Let m
majorthorb...@mst-it-services.info wrote:
>
> C:\Program Files\System.Data.SQLite\2010\GAC>"..\..\..\microsoft
> sdks\windows\v7
> .1\bin\gacutil" /i System.Data.SQLite.dll
> Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1
> Copyright (c) Microsoft Corporation. All rights r
Installed latest SDK (7.1) and reran the command and got the following:
C:\Program Files\System.Data.SQLite\2010\GAC>"..\..\..\microsoft
sdks\windows\v7
.1\bin\gacutil" /i System.Data.SQLite.dll
Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1
Copyright (c) Microsoft Corporat
>
> majorthorb...@mst-it-services.info wrote:
>>
>> I have tried to install sqlite from what I thought were the correct
>> files
>>
>
> Which files are you referring to? What site did you download them from?
>
sqlite-netFx40-setup-bundle-x64-2010-1.0.77.0.exe from
system.data.sqlite.org downloads.
majorthorb...@mst-it-services.info wrote:
>
> I have tried to install sqlite from what I thought were the correct files
>
Which files are you referring to? What site did you download them from?
>
> but have not managed to find the sqlite.net folder that the help file
> mentions as support for
: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLite.Net
On 20.09.2007 15:06 CE(S)T, Samuel R. Neff wrote:
> can you be more specific? Thread links..
http://sqlite.phxsoftware.com/forums/t/731.aspx
"SQLiteDataReader.GetValue() not returning DateTime"
http://sqlite.phxsoftware.
Goergen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 20, 2007 6:31 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SQLite.Net
>
> On 20.09.2007 15:06 CE(S)T, Samuel R. Neff wrote:
> > can you be more specific? Thread links..
>
> http
On 20.09.2007 15:06 CE(S)T, Samuel R. Neff wrote:
> can you be more specific? Thread links..
http://sqlite.phxsoftware.com/forums/t/731.aspx
"SQLiteDataReader.GetValue() not returning DateTime"
http://sqlite.phxsoftware.com/forums/t/795.aspx
"Cannot retrieve data from a column; inconsistent res
n the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 20, 2007 8:34 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLite.Net
On 19.09.2007 17:54 CE(S)T, Samuel R. Neff
On 19.09.2007 17:54 CE(S)T, Samuel R. Neff wrote:
> However, I do use the one Robert suggested heavily
> and can attest to the fact that it is extremely well written and works
> without errors.
Ehm, wait, I know of two bugs that have been reported in their forum and
were not even replied to for we
qlite.org
Subject: RE: [sqlite] SQLite.Net
Ok, but why I can't use this wrapper
http://www.phpguru.org/static/SQLite.NET.html ?
-Message d'origine-
De : Robert Simpson [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 19 septembre 2007 17:16
À : sqlite-users@sqlite.org
Objet : RE:
ge-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 8:29 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
> Ok, but why I can't use this wrapper
> http://www.phpguru.org/static/SQLite.NET.html ?
>
&g
Ok, but why I can't use this wrapper
http://www.phpguru.org/static/SQLite.NET.html ?
-Message d'origine-
De : Robert Simpson [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 19 septembre 2007 17:16
À : sqlite-users@sqlite.org
Objet : RE: [sqlite] SQLite.Net
And for good reason ..
And for good reason ... Adapting the sqlite3 api to .NET is not trivial.
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 8:09 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
>
[mailto:[EMAIL PROTECTED]
Envoyé : mercredi 19 septembre 2007 17:00
À : sqlite-users@sqlite.org
Objet : RE: [sqlite] SQLite.Net
If you're using the Finisar library, it doesn't work with the later sqlite3
libraries. If you're using the PHP one, it hasn't been updated in almos
software.com
Robert
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 7:42 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] SQLite.Net
>
> SQLite.NET.2.0.1
>
> -Message d'origine-
>
SQLite.NET.2.0.1
-Message d'origine-
De : Robert Simpson [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 19 septembre 2007 16:31
À : sqlite-users@sqlite.org
Objet : RE: [sqlite] SQLite.Net
What .NET wrapper are you using?
> -Original Message-
> From: Michael Martin [ma
What .NET wrapper are you using?
> -Original Message-
> From: Michael Martin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 19, 2007 7:13 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SQLite.Net
>
> Hi all,
>
>
>
> I try to use SQLite (sqlite3.dll) in DotNet; this is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Brass Tilde wrote:
>>>Stupid question, but how can i create an in-memory database with
>>>SQLite.NET provider? When i use Data Source=:memory: i get an exception
>>>that the specified file isn't found.
>>
>>If you are using the ADOSQLiteDotNet provider
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Brass Tilde wrote:
>>Stupid question, but how can i create an in-memory database with
>>SQLite.NET provider? When i use Data Source=:memory: i get an exception
>>that the specified file isn't found.
>
>
> If you are using the ADOSQLiteDotNet provider
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Berkenbosch wrote:
> Stupid question, but how can i create an in-memory database with
> SQLite.NET provider? When i use Data Source=:memory: i get an exception
> that the specified file isn't found.
>
> Can anyone explain to me how it is done ?
> > Stupid question, but how can i create an in-memory database with
> > SQLite.NET provider? When i use Data Source=:memory: i get an exception
> > that the specified file isn't found.
>
> If you are using the ADOSQLiteDotNet provider from SourceForge, add
> "New=True"
> to your connection stri
> Stupid question, but how can i create an in-memory database with
> SQLite.NET provider? When i use Data Source=:memory: i get an exception
> that the specified file isn't found.
If you are using the ADOSQLiteDotNet provider from SourceForge, add "New=True"
to your connection string.
47 matches
Mail list logo