Re: [sqlite] Selecting from view with System.Data.SQLite throws

2017-04-08 Thread Joseph L. Casale
From: sqlite-users [mailto:[email protected]] On Behalf Of Joe Mistachkin Sent: Saturday, April 8, 2017 1:18 PM To: SQLite mailing list Subject: Re: [sqlite] Selecting from view with System.Data.SQLite throws > What is the declared data type for the column? Also, w

Re: [sqlite] Selecting from view with System.Data.SQLite throws

2017-04-08 Thread Joe Mistachkin
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. Sent from my iPhone https://urn.to/r/mistachkin > On Apr 8, 2017, at 12:55 PM, Joseph L. Casale > wrote: > > I a

[sqlite] Selecting from view with System.Data.SQLite throws

2017-04-08 Thread Joseph L. Casale
I am using System.Data.SQLite.Core 1.0.104 in vs2017 with .NET 4.6.2 and trying to select from a view. The query is valid and does return data manually, however the reader throws an index out of range exception when accessing the first row result. Anything atypical needed when querying a view? Th