Re: 2017 World Tour Component

2017-04-12 Thread Brian Young via 4D_Tech
Hi Jim, The PDF that accompanies the component lists 4D v16.x or above as a requirement to run the demo database: Demo Requirement - 4D v16.x or Above (32bit AND 64-bit versions) - PICT_Convert Component - MoreObjects example database I haven’t spoken to JPR, who authored the

Re: Questions about the 'Sum' function

2017-04-12 Thread Tim Nevels via 4D_Tech
On Apr 12, 2017, at 2:00 PM,Kirk Brooks wrote: > Sum works fine on a selection of records or on an array. It used to be a > little slow but not now. Sum and the other series commands are optimized and will use the index on field a field if it exists. Saves loading all the records in the

2017 World Tour Component

2017-04-12 Thread Jim Medlen via 4D_Tech
Trying to use the PICT_Convert.4dbase from the 2017 World Tour I placed the component in the components folder for 4D v15.4 and received an Error Can¹t load component ³PICT_Convert.4DB Disk NbPart. Type Name Media Type Speed Total Size Description *

Re: Questions about the 'Sum' function

2017-04-12 Thread Kirk Brooks via 4D_Tech
Peter, Sum works fine on a selection of records or on an array. It used to be a little slow but not now. If you are working on 4D server it's useful to build some functions that will run on the server to speed things up even more. Using your example you could write: // Customer_get_invoiceSum

Another woe of compiler complacency in v15.4

2017-04-12 Thread Kirk Brooks via 4D_Tech
I'm using Query by formula with Match regex to search for email addresses. I believe I got this idea from the 4D docs but could have been somewhere else. Anyway, here's what I'm doing: SET QUERY DESTINATION(Into set;"emailMatch") $pattern:="(?i)"+$email QUERY BY FORMULA([WebUser_subMgr];Match

Re: Replacing - OAuth.bundle

2017-04-12 Thread Kirk Brooks via 4D_Tech
Miyako, Your github account is an absolute trove of useful information and resources for a 4D dev. Your repos organization reflects, I think, the focus and drive I see when you work so there's nothing to apologize for. Github isn't the optimal format for 4D style resources but like Sujit said

Re: Questions about the 'Sum' function

2017-04-12 Thread Sujit Shah via 4D_Tech
Just recalling the term series from memory. Something I read in the manual. My understanding is a selection or array i think it works for both. Not in front of computer so not 100% sure. On Wed, 12 Apr 2017 at 9:34 pm, Peter Jakobsson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On 12 Apr 2017,

Re: Questions about the 'Sum' function

2017-04-12 Thread Peter Jakobsson via 4D_Tech
On 12 Apr 2017, at 13:29, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> wrote: > Sum has always worked on a series Thanks Sujit. But what’s the definition of a ‘series’ ? Does a field from a current selection qualify as a ‘series’ ? Peter

Re: Questions about the 'Sum' function

2017-04-12 Thread Sujit Shah via 4D_Tech
Perhaps you are confusing it with subtotal? Sum has always worked on a series E On Wed, 12 Apr 2017 at 9:22 pm, Peter Jakobsson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi > > Occasionally I’d like to use the “Sum” function on a current selection but > am hesitant because of distant

Questions about the 'Sum' function

2017-04-12 Thread Peter Jakobsson via 4D_Tech
Hi Occasionally I’d like to use the “Sum” function on a current selection but am hesitant because of distant memories of it only being supported in certain circumstances (e.g. in reports, on single user.not client server etc). Do people use this outside of a report context and on any current

Re: Replacing - OAuth.bundle

2017-04-12 Thread Sujit Shah via 4D_Tech
Thank god there are still some people who find websites and web applications non ituitive. But GitHub is used by millions so you cannot really argue. ;-) On Wed, 12 Apr 2017 at 4:38 am, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Clive, > > I'm reading this and thinking you're

Re: Replacing - OAuth.bundle

2017-04-12 Thread Keisuke Miyako via 4D_Tech
Hello, in general, only the source files (plain text) are expected to be under source-control, as well as common format documents such as PDF or images. large binary files are expected to be published under "Releases". 4D is an unusual case, because the source code (the structure file) is

Re: Replacing - OAuth.bundle

2017-04-12 Thread Douglas Cryer via 4D_Tech
Kirk, Thank you for a very clear, concise description of how to navigate GitHub repositories. I too have struggled with the interface and terminology. Your description demystifies it all. Regards, Dougie telekinetix Limited- J.

Going in designer environment 4D crash

2017-04-12 Thread stardata.info via 4D_Tech
Hi All, I use 4D V15.4 with Windows 8.1 Pro, and sometime when i want to go in designer environment of my application, 4D crash. This is not always, i delete the settings of 4D in AppData\Roaming\4D but the issue remain. Someone have the same problem? Thanks Ferdinando