Chuck, This may be related:
http://doc.4d.com/4Dv16/4D/16/Creating-and-modifying-indexes.300-3048980.en.html Only the first 1024 characters are indexed. Wayne On Wed, 5 Apr 2017 at 06:57, Charles Miller via 4D_Tech < [email protected]> wrote: > Hi All > > I have in pseudo code the following > > distinct values on a text field, that can be anywhere from 5 or 6 > characters to >1000 > > These text fields are supposed to bed unique in in fact are. However, the > resultant array is not the same size as numbers of records. > > I know it is the same, as I added a field and did a hash on the text and > when I do a distinct on that field I get same number of elements as records > in table. Any idea as to why. It would appear that distinct does not use > entire field length!! > > Regards > > Chuck > -- > > ----------------------------------------------------------------------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Sever connectivity > http://www.informed-solutions.com > > ----------------------------------------------------------------------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 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] > ********************************************************************** -- Regards, Wayne [image: --] Wayne Stewart [image: http://]about.me/waynestewart <http://about.me/waynestewart> ********************************************************************** 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] **********************************************************************
