KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: How to get a list of keywords from a keyword index?
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: June 26, 2008
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

4D v11 SQL supports a new "Keyword" index type, which can be applied to Text fields. The DISTINCT VALUES command has been updated to support this new type of index. When DISTINCT VALUES is called on a keyword-indexed field, the resulting array is populated with all keywords from the index in the current selection for that field.