results of SPLIT when keys not unique

Ralph DiMola rdimola at
Thu Nov 2 18:45:41 EDT 2017

Whoops, not tested and I saw an error. 

Select mytable.animalname,mytable.animalnumber from (select distinct
mytable.animalname from mytable as mytable2) left join mytable on
mytable.animalname = mytable2animalname

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at] On Behalf
Of Dr. Hawkins via use-livecode
Sent: Thursday, November 02, 2017 6:24 PM
To: How to use LiveCode
Cc: Dr. Hawkins
Subject: results of SPLIT when keys not unique

If I use split such that keys are not unique, will that have the effect of
filtering out duplicates?

For example, if I have
  dog 3
  dog 5
  cat 8

and SPLIT it, will I end up with 5 in entry dog?

More specifically, is this a defined behavior, or "just how it currently

I'm trying to find a quick & clean way around SQLite's lack of "DISTINCT
ON"--I need to keep those numbered keys attached to work with, and DISTINCT
alone won't due that.

Dr. Richard E. Hawkins, Esq.
(702) 508-8462

use-livecode mailing list
use-livecode at
Please visit this url to subscribe, unsubscribe and manage your subscription

More information about the use-livecode mailing list