Log In    |    Knowledge Base    |    4D Home
Tech Tip: DISTINCT VALUES Command Modified in 4D v6.5
Published On: June 18, 1999
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In


This command is applied to a field to build an array of unique values that exist for that field, in its parent table. The command has been modified in 4th Dimension v6.5 in the following two ways:

  • DISTINCT VALUES now functions with all indexable fields, that is, those fields whose type supports indexing. The fields do not now need to be indexed to work with this command. However, executing this command on unindexed fields will be slower than if the fields were indexed.
  • DISTINCT VALUES also now functions inside transactions. This means that even if a record is created inside a transaction, and the transaction has not yet been validated, the record will be treated like any other record in that table for the purposes of the DISTINCT VALUES command.