Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
index entries |
Mon, Oct 22 2012 1:33 AM | Permanent Link |
Bryn Lewis Intelligent Software and Systems | Is it possible to retrieve the entries in an index?
In the case of a text index, this would be all the strings that are in the index - although I am interesetd in text and varchar. Retrieving the entries in a query statement would be ideal, but if it is available in another way thats ok too. |
Mon, Oct 22 2012 4:00 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Bryn
>Is it possible to retrieve the entries in an index? > >In the case of a text index, this would be all the strings that are in the index - although I am interesetd in text and varchar. > >Retrieving the entries in a query statement would be ideal, but if it is available in another way thats ok too. I vaguely remember asking Tim something along these lines for full text indices ages ago and the answer was no. Things may have changed since then but if so its escaped my notice. For normal, non full text indices, its easy unless you want the actual strings held in the tree - just SELECT DISTINCT field FROM table Roy Lambert [Team Elevate] |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |