Re: [sqlite] Select * from tablename results in an exception

2010-03-31 Thread Burnett, Joe
: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Wednesday, March 31, 2010 11:30 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select * from tablename results in an exception > I had issues in my SQLite DB schema - VARCHAR

Re: [sqlite] Select * from tablename results in an exception

2010-03-31 Thread Pavel Ivanov
sqlite.org] On Behalf Of Tim Romano > Sent: Tuesday, March 30, 2010 5:20 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Select * from tablename results in an exception > > http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/27aec61 > 2-

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Burnett, Joe
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tim Romano Sent: Tuesday, March 30, 2010 5:20 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select * from tablename results in an exception http

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Tim Romano
http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/27aec612-5ca4-41ba-80d6-0204893fdcd1 Maybe related. Regards Tim Romano ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Simon Slavin
On 30 Mar 2010, at 2:55pm, Burnett, Joe wrote: > Your understanding is correct. However, I used the SQLite Admin tool and > the select * query > was successful after the table was populated and the program exited. > > Isn't that the same thing? Okay, if I understand your result, you have a

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Burnett, Joe
: [sqlite] Select * from tablename results in an exception On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: > I am using SQLite in a C# .NET application. I am inserting into tables > without any issues as confirmed by the SQLite Admin tool. > However, later in the application, I want

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Simon Slavin
On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: > I am using SQLite in a C# .NET application. I am inserting into tables > without any issues as confirmed by the SQLite Admin tool. > However, later in the application, I want to query the table where I > inserted the data, I get the following

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Burnett, Joe
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, March 30, 2010 9:23 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select * from tablename results in an exception On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: >string sql = &quo

Re: [sqlite] Select * from tablename results in an exception

2010-03-30 Thread Simon Slavin
On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: >string sql = "select * from Table"; Can you use 'Table' as the name of a table ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Select * from tablename results in an exception

2010-03-30 Thread Burnett, Joe
Hi All, I am using SQLite in a C# .NET application. I am inserting into tables without any issues as confirmed by the SQLite Admin tool. However, later in the application, I want to query the table where I inserted the data, I get the following exception: "Failed to enable constraints. One or