Re: [sqlite] View workarounds

On 2016/05/25 5:42 PM, Balaji Ramanathan wrote: Thanks again, Ryan. The options right now come down to either expanding the view with all the raw columns so that I can filter and sort directly using a select * from view. Or I can use the view for unfiltered, unsorted look at my data, and use

Re: [sqlite] View workarounds

On 25 May 2016, at 4:42pm, Balaji Ramanathan wrote: > I vote for more extensive support of hidden columns in tables, views, etc. > Is there some site for submitting enhancement requests for SQLite? It's here. You just did it. Don't hold your breath. Simon. __

Re: [sqlite] View workarounds

Thanks again, Ryan. The options right now come down to either expanding the view with all the raw columns so that I can filter and sort directly using a select * from view. Or I can use the view for unfiltered, unsorted look at my data, and use the query of the view to do filtering and sorting.

Re: [sqlite] View workarounds

On 2016/05/24 2:17 AM, Balaji Ramanathan wrote: Thank you for continuing with this thread, Ryan. I don't have nuclear launch codes in my database, but it is over 4MB in size. But the data in it is not that important. Let me post the view I am interested in: select Trip.TripID as 'Trip Numbe