[sqlite] INDEX list

Thanks very much Niall, the SELECT DISTINCT column FROM table is doing exactly what I was looking for. The ORDER BY clause gives the whole list and that's not what I wanted. Regards, Rob -- This email and any attachments to it may be confidential and are intended solely for the use of the

Re: [sqlite] Index list

On Sat, Feb 11, 2017 at 3:54 PM Simon Slavin wrote: > On 11 Feb 2017, at 2:50pm, Rob van der sloot > wrote: > > I want to use the index of a specific column of a table as a pulldown > list > > But I can't find any syntax how to select or view an

Re: [sqlite] Index list

On 11 Feb 2017, at 14:50, Rob van der sloot wrote: > I want to use the index of a specific column of a table as a pulldown list > in my application. Wouldn't SELECT DISTINCT column FROM table; give you the same effect? I expect the query planner would use the table or not according to

Re: [sqlite] Index list

On 11 Feb 2017, at 2:50pm, Rob van der sloot wrote: > I want to use the index of a specific column of a table as a pulldown list > in my application. > But I can't find any syntax how to select or view an index. Sorry. There is no way to find the contents of an

[sqlite] Index list

I want to use the index of a specific column of a table as a pulldown list in my application. But I can't find any syntax how to select or view an index. Thanks Rob van der Sloot -- This email and any attachments to it may be confidential and are intended solely for the use of the individual