Yes, it's a bit confusing. I tested the field type and if it's text or apha field has length more than 50, it's keyword index, else it's cluster Btree.
Alan Chan 4D iNug Technical <[email protected]> writes: >I'd like to know if a field (alpha or text) has a keyword index. > >With 4D langage, I have a "setter" (CREATE INDEX) but no "getter". > >With SQL, I can get the index type from _USER_INDEXES.INDEX_TYPE, but "Cluster >BTree index" and "Keywords index" both have the same value, 3. > >Something I'm missing? > > ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
