> Monte wrote:
>
> Perhaps something like:
>
> split by and [{replacing |
> splitting | ignoring} duplicates]
Yes.
+1
Jim Lambert
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and ma
]
Sent: Thursday, November 02, 2017 6:49 PM
To: rdim...@evergreeninfo.net
Cc: How to use LiveCode
Subject: Re: results of SPLIT when keys not unique
On Thu, Nov 2, 2017 at 3:45 PM, Ralph DiMola wrote:
> Whoops, not tested and I saw an error.
>
> Select mytable.animalname,mytable.animalnu
On Thu, Nov 2, 2017 at 3:45 PM, Ralph DiMola wrote:
> 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
You're a bit over my
The last one of course.
Bob S
> On Nov 2, 2017, at 15:39 , Monte Goulding via use-livecode
> wrote:
>
> A quick test and it looks like split will clobber any new elements with the
> same key as those previously parsed. The docs state that only one element
> will be created but are unclear
On Thu, Nov 2, 2017 at 3:39 PM, Monte Goulding via use-livecode
wrote:
> It would probably be nice to have some explicit syntax to govern this
> behavior so that you could explicitly declare
> you want clobbering behavior or first come best dressed.
explicit is (almost) always nice (says the gu
On Thu, Nov 2, 2017 at 3:45 PM, Ralph DiMola wrote:
> 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
>
You just shot *way*
> On 3 Nov 2017, at 9:39 am, Monte Goulding wrote:
>
> It would probably be nice to have some explicit syntax to govern this
> behavior so that you could explicitly declare you want clobbering behavior or
> first come best dressed.
Oh… one might also feasibly want output like this I guess:
v
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
rdim...@evergreeninfo.net
Would something like this work?
Select mytable.animalname,mytable.animalnumber from (select distinct
mytable.animal from mytable as mytable2) left join mytable on
mytable.animalname = mytable2animalname
Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net
-Orig
A quick test and it looks like split will clobber any new elements with the
same key as those previously parsed. The docs state that only one element will
be created but are unclear about which element value will be retained.
It would probably be nice to have some explicit syntax to govern this
10 matches
Mail list logo