results of SPLIT when keys not unique

Ralph DiMola rdimola at evergreeninfo.net
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 evergreeninfo.net


-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] 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
works"

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 lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list