Concurrency violation: the UpdateCommand affected 0 of
the expected 1 records
On 30 Mar 2012, at 6:27pm, "Agrawal, Manish" <magra...@usf.edu> wrote:
> Thanks very much. Most of our tables do have datetime fields.
Not in SQLite they don't. There is no such datatype in
: [sqlite] Concurrency violation: the UpdateCommand affected 0 of
the expected 1 records
Agrawal, Manish wrote:
>
> So my question is: is this a bug or a feature in System.Data.SQLite
>
The behavior seen here does not originate with System.Data.SQLite. It has to
do with how
al Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joe Mistachkin
Sent: Monday, March 26, 2012 2:47 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Concurrency violation: the UpdateCommand affected 0 of
the expected
At System.Data.SQLite.SQLiteConnection.get_MemoryUsed()
Workarounds or solutions would be greatly appreciated.
Thanks
Manish
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Agrawal, Manish
Sent: Sunday, March 25, 2012 8:37 AM
To: sqlite-users
Hello
I am getting this error when trying to update a database row in a C#
application. The data set ds has been created using the standard Visual Studio/
System.Data.SQLite tools.
The table definition is:
CREATE TABLE "Test" (
"test_Id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
Subject: Re: [sqlite] how to replace connection string at runtime
--
--
--
--ô¿ô--
K e V i N
On Fri, Mar 2, 2012 at 2:47 PM, Agrawal, Manish <magra...@usf.edu> wrote:
> My question is: what is the simplest way to replace the connection string
> in a C#
Hello
I suspect my question may already have been answered many times before, but I
could not find a way to search through the archives of the sqlite users mailing
list at: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/. Is there
a way to search the archives?
My question is:
Thanks very much, hopefully my last question in the series:
Since the 32-bit installer will install 32-bit assemblies, and VS2010 is a
32-bit app, what is the benefit of installing 64-bit assemblies into the GAC.
Thanks
Manish
>
> 2. If only the 32-bit setup files are useful, what is the use
Thanks very much, that is very helpful. I had three follow up questions:
1. To confirm, if I want data source and other visual support, I MUST INSTALL
the setups on my development machine. It is not adequate to just copy the dll
files to the project.
2. If only the 32-bit setup files are
of SQLite Database
Subject: Re: [sqlite] Relative path to sqlite database
On 21 Feb 2012, at 2:49am, "Agrawal, Manish" <magra...@usf.edu> wrote:
> All the sqlite examples I see use absolute paths to the sqlite database in
> Visual Studio projects, e.g. "C:\users\test\apps
All the sqlite examples I see use absolute paths to the sqlite database in
Visual Studio projects, e.g. "C:\users\test\apps\db\test.db3".
How can I specify the path to the sqlite database relative to the application
root folder, e.g. "db\test.db3"?
This is helpful when I am developing the app
I am still playing with the sqlite setup in Visual Studio. Previously I found
success following the instructions at:
http://www.tsjensen.com/blog/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx
But this requires the sqlite packages to be "installed" on the local computer.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Kees Nuyt
Sent: Monday, February 06, 2012 3:29 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Relations in sqlite and checking consistency of existing
data base
On Sun, 5
Hello
I must be missing something very elementary, but for the life of me, I
cannot save changes to a sqlite database from within the VS2010 designer.
I started by creating a sqlite database file using Firefox SQlite
Manager and adding 2 tables - user, assignments. Then, I
to the System.Data.SQLite dll in the project on VS2010.
optional:: you can also use FireFox AddsON and search for Sqlite -> add it
--> use as viewer page to play with Sqlite db or you can use others.
thanks, Alok
On 1 February 2012 04:22, Agrawal, Manish <magra...@usf.edu> wrote:
> Hello
>
>
Manish
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joe Mistachkin
Sent: Tuesday, January 31, 2012 6:01 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLite on Visual Studio 2010
Agrawal, Manish wrote
Hello
I am a newbie to both Visual Studio and SQLite, but have a few years of
Java/ Netbeans/ Glassfish/ MySQL experience.
I am trying to get started with using SQLite on Visual Studio 2010
(VS10) but am unable to get a SQLite Data Source type in my project. I created
a WPF
17 matches
Mail list logo