Re: Query & Order by on non indexed fields

2017-09-14 Thread Keisuke Miyako via 4D_Tech
you can also find out whether a query (not sort) used an index with DESCRIBE QUERY EXECUTION http://doc.4d.com/4Dv15/4D/15.4/DESCRIBE-QUERY-EXECUTION.301-3273970.en.html ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Server Process "Frozen"-ish

2017-09-14 Thread Arnaud de Montard via 4D_Tech
> Le 14 sept. 2017 à 03:58, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Houston, er, Clichy -- we have a problem here. Call Le Pecq, they left Clichy from a while ;-) -- Arnaud de Montard ** 4D

Re: SFTP - Native to 4D?

2017-09-14 Thread Koen Van Hooreweghe via 4D_Tech
Hi Janet, As others has mentioned, there is no native sftp client (yet?) in 4D. On Mac I’m using the OS built in sftp command which is called using LAUNCH EXTERNAL PROCESS. For my purpose, I create a ‘batch’ file which contains the necessary sftp commands and then run it with sftp. Eg. a

Query & Order by on non indexed fields

2017-09-14 Thread Andrew Hobson via 4D_Tech
Hello, I know there was a way to find all QUERY and ORDER BY that are performed on non indexed fields. But I don't remember how to do it. Is this possible with 4D v13 or must I use an external tool ? Thanks to refresh my memory. Andrew

Re: Query & Order by on non indexed fields

2017-09-14 Thread Keisuke Miyako via 4D_Tech
whether an index is used or not depends on the context. of course, 4D can't use an index that does not exist, but otherwise, just because an index is defined it doesn't mean that it will be used. the exact same query/sort condition may not alway use indexes, it depends on the current selection

Re: Query & Order by on non indexed fields

2017-09-14 Thread Chip Scheide via 4D_Tech
That functionality was available in through Data Check and/or Sanity Check (neither of which have been updated to work with any version of 4D newer then v2204(?)) On Thu, 14 Sep 2017 09:53:13 +0200, Andrew Hobson via 4D_Tech wrote: > Hello, > > I know there was a way to find all QUERY and

Re: Server Process "Frozen"-ish

2017-09-14 Thread Cannon Smith via 4D_Tech
Hmm, v16.2 eh? There goes our hope that it was fixed in that version. Is anyone having this happen regularly enough that they can turn on some logging to see, for example, what the last command that ran was? -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236

Re: Server Process "Frozen"-ish

2017-09-14 Thread John DeSoi via 4D_Tech
> On Sep 14, 2017, at 7:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > This is a big problem that must get addressed and fixed or it will do harm to > v16’s reputation. I was planning on upgrading one of my clients to v16 in a > few months. That is not going to happen now.

Re: SFTP - Native to 4D?

2017-09-14 Thread 4dialog via 4D_Tech
Have used CrushFtp/ CrushSync for many years for backup and sending xml data to external partners. It works very well, stable on Mac, flexible, easy to setup. - Hilsen -- Helge Antonsen 4Dialog as Tel: +47 64 000 164 Mob: +47 90 15 56 19 Web:

Re: Server Process "Frozen"-ish

2017-09-14 Thread Jeffrey Kain via 4D_Tech
I opened a case on the taow today - just FYI. > On Sep 14, 2017, at 8:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Then I’d call and speak to Add and get him involved in this. He knows you. > And you can tell him that others — like Jeff Kain — are experiencing the same >

Re: SFTP - Native to 4D?

2017-09-14 Thread Janet Jonas via 4D_Tech
Koen - That was super helpful. Thanks to some Google-fu I was able to find out some instructions on making SFTP batch files and how to run them from terminal commands, your examples of the commands I would want specifically will make it all so much easier. Thank you, JJ > On Sep 14, 2017,

Re: Server Process "Frozen"-ish

2017-09-14 Thread Tim Nevels via 4D_Tech
On Sep 14, 2017, at 2:00 PM, Cannon Smith wrote: > Hmm, v16.2 eh? There goes our hope that it was fixed in that version. > > Is anyone having this happen regularly enough that they can turn on some > logging to see, for example, what the last command that ran was? Hi Cannon, I’d called 4D

Re: Server Process "Frozen"-ish

2017-09-14 Thread Bernd Fröhlich via 4D_Tech
Cannon Smith: > Thanks for the idea. I did try that before to see if I could jumpstart the > process, but unfortunately it doesn’t work. 4D thinks the process is already > there. And it it there. It just doesn’t seem to be executing. Yep, same here. I do have a method that would start the