Re: Calculate values of arrays...

2021-11-01 Thread Douglas von Roeder via 4D_Tech
"> Finally, the reason I need to drop this list forever. Sajonara." *Definitely* not from "How to win friends and influence people". -- Douglas von Roeder 949-910-4084 On Mon, Nov 1, 2021 at 2:07 PM Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> wrote: > > > > On 02 /11 /2021, at 07:23,

Re: Calculate values of arrays...

2021-11-01 Thread Douglas von Roeder via 4D_Tech
Jorg: At times, some of your replies come across as "perhaps having been put a different way" and, of course, this is coming from someone who falls in the exact same category. Overall, however, I don't find them offensive in the least. -- Douglas von Roeder 949-910-4084 On Mon, Nov 1, 2021 at

Re: Calculate values of arrays...

2021-11-01 Thread Jörg Knebel via 4D_Tech
> On 02 /11 /2021, at 07:23, THOMAS BENEDICT via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Finally, the reason I need to drop this list forever. Sajonara. ** 4D Internet Users Group (4D iNUG) New Forum:

Re: Calculate values of arrays...

2021-11-01 Thread Jörg Knebel via 4D_Tech
> On 02 /11 /2021, at 07:14, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi All, > >> On 02 /11 /2021, at 07:09, Douglas von Roeder via 4D_Tech >> <4d_tech@lists.4d.com > wrote: >> >> Perhaps the best approach would be for you to try the command

Re: Calculate values of arrays...

2021-11-01 Thread THOMAS BENEDICT via 4D_Tech
>You do know what an ARRAY is? Finally, the reason I need to drop this list forever. There is very activity, and extremely little useful content here. And the level of bullying and abuse has become intolerable. Goodbye 4D iNug. You were great while you lasted. Tom Benedict

Re: Calculate values of arrays...

2021-11-01 Thread Jörg Knebel via 4D_Tech
Hi All, > On 02 /11 /2021, at 07:09, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Perhaps the best approach would be for you to try the command and see if > you get the desired result. I’m sorry guys, it was just to late yesterday…

Re: Calculate values of arrays...

2021-11-01 Thread Douglas von Roeder via 4D_Tech
There's no difference in how an array is populated - it's a list of values in memory. Perhaps the best approach would be for you to try the command and see if you get the desired result. -- Douglas von Roeder 949-910-4084 On Mon, Nov 1, 2021 at 1:02 PM Jörg Knebel via 4D_Tech

Re: Calculate values of arrays...

2021-11-01 Thread Jörg Knebel via 4D_Tech
> On 02 /11 /2021, at 06:57, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >>> You do know what an ARRAY is? > Did you go look at the page? You sure it works with ARRAYs NOT filled by a selection? ** 4D Internet

Re: Calculate values of arrays...

2021-11-01 Thread Kirk Brooks via 4D_Tech
>> You do know what an ARRAY is? Did you go look at the page? On Mon, Nov 1, 2021 at 12:36 PM Jörg Knebel via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > > On 02 /11 /2021, at 02:24, Joshua Hunter via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > You want the docs for 'On a Series' > >

RE: Calculate values of arrays...

2021-11-01 Thread Joshua Hunter via 4D_Tech
I am aware of what an array is. I'm not sure if you're being serious or not at this point. But from the docs: The functions of this theme perform calculations on a series of values. The Average, Max, Min, Sum, Sum squares, Std deviation and Variance functions are applied to fields or

Re: Calculate values of arrays...

2021-11-01 Thread Jörg Knebel via 4D_Tech
> On 02 /11 /2021, at 02:24, Joshua Hunter via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > You want the docs for 'On a Series' > https://doc.4d.com/4Dv19R2/4D/19-R2/On-a-Series.201-5493482.en.html > And this works on an

Re: Search & menu questions

2021-11-01 Thread Douglas von Roeder via 4D_Tech
4D has supported cross table queries since the introduction of the SQL engine in V11. Given a table of sales reps ("Managers") and a Territories table (not my table name convention) that have a many to many table ManagerToTerritory, the following code will find the territories for a given

RE: Calculate values of arrays...

2021-11-01 Thread Joshua Hunter via 4D_Tech
You want the docs for 'On a Series' https://doc.4d.com/4Dv19R2/4D/19-R2/On-a-Series.201-5493482.en.html --Joshua -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jörg Knebel via 4D_Tech Sent: Monday, November 1, 2021 5:05 AM To: 4D Tech Mailing List Technical

Re: Calculate values of arrays...

2021-11-01 Thread Jeremy Roussak via 4D_Tech
In the docs? Min, Max and Average can all take numeric arrays as arguments. Jeremy Roussak Photography: jbr.is > On 1 Nov 2021, at 12:04, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> wrote: > > G’ day, > > I’m sure I have seen it before but can’t remember where. :-( > > I’m looking for

Calculate values of arrays...

2021-11-01 Thread Jörg Knebel via 4D_Tech
G’ day, I’m sure I have seen it before but can’t remember where. :-( I’m looking for "Get/Calculate Minimum, Maximum, Average etc.” on (numeric) Arrays. Is there anybody willing to help? Thanks Cheers Jörg ** 4D Internet