From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe Mistachkin Sent: Saturday, April 8, 2017 1:18 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Selecting from view with System.Data.SQLite throws
> What is the declared data type for the column? Also, what are the raw > values for the first row? You may want to use the SQLite command line tool > to query the database for them. I was selecting from all columns which were declared as either INT or TEXT. I resolved it unintentionally by removing an alias as it was a single select on the one view and did not need any aliasing. The command text went from: SELECT s.Id, s.foo ... FROM SomeView s WHERE s.bar = @bar; to: SELECT Id, foo ... FROM SomeView WHERE bar = @bar; Odd... Thanks, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
