Re: Web

2018-04-11 Thread Patrick Emanuel via 4D_Tech
Did you check preference in 4D about security. There is some improvement on it. It may be the cause. For that, there is an article on the 4D Blog (blog.4d.com) Patrick - Patrick EMANUEL Administrator www.association-qualisoft.eu

Re: Web Service Call in 4Dv15

2018-04-11 Thread Julio Carneiro via 4D_Tech
4D WebServices license perhaps? > On Apr 11, 2018, at 2:57 AM, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi All, > > I would like to seek some help/advise on an XML issue in 4Dv15 on Windows. > > I have an app that is currently running in v11. XML transmission via the > cons

Re: Installing a Wildcard SSL Certificate

2018-04-11 Thread Douglas Cryer via 4D_Tech
Pascal, Re: Does the server start up correctly ? How did you make the cert.pem file ? Make sure it does not contain any invisible characters and the linefeeds should be just regular linefeeds not windows linefeeds. Yesterday I was getting no error starting and stopping the web server and I re

v13+ LEP - What is sent to OS

2018-04-11 Thread Chip Scheide via 4D_Tech
Is there a way to see exactly what is being sent to the (in this case) CMD, or Terminal? Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG

Re: Installing a Wildcard SSL Certificate

2018-04-11 Thread Pascal Geuns via 4D_Tech
Yes, you should rename or remove the public key file from the folder as stated in the referred article. I see no reason why 4D Server should not be able to support wildcard certificates. Does the server give any error after you remove the public key file and if yes, whats the error message ?

v13 - Custom Constants & 4D Pop

2018-04-11 Thread Chip Scheide via 4D_Tech
a couple of questions: 1 - where does 4D pop put the cliff file for custom constants? (Mac) 2 - can I move this file around (i.e. to other database/systems)? 3 - Is there a way to get 4D pop to create a character (string) constant for Carriage Return, Line Feed, and CrLF by this I mean - not - the

ORDA query & pointers syntax question

2018-04-11 Thread Keith Culotta via 4D_Tech
Hello, I didn't recognize a solution for this in the docs. When the table and field are unknown until execution time, any suggestions on what the ORDA approach to this type of query would be? QUERY(pTable->;pField->=$aValue) Thanks - Keith - CDI ***

RE: v13+ LEP - What is sent to OS

2018-04-11 Thread Tim Nevels via 4D_Tech
On Apr 11, 2018, at 2:00 PM, Chip Scheide wrote: > Is there a way to see exactly what is being sent to the (in this case) > CMD, or Terminal? Hi Chip, Every time I am going to do a new LEP command, the first thing I do is manually execute it in a Command or Terminal window on macOS. I don’t ev

RE: v13+ LEP - What is sent to OS

2018-04-11 Thread Chip Scheide via 4D_Tech
Thanks Tim, (windows) I have done the set text to pasteboard thing, and I have pasted into a .bet file -- it works. I have typed - exactly - what I have for a command being fed to LEP and it works run it through LEP and nothing... That is why I want to see what LEP is feeding to the OS On Wed,

Re: Installing a Wildcard SSL Certificate

2018-04-11 Thread jdcryer--- via 4D_Tech
Pascal, Re: > Does the server give any error after you remove the public key file and if > yes, whats the error message ? Once I read the second article I removed the key.pem and then ran the tests I stated with the different results. I am stumped. Regards, Dougie ***

RE: v13+ LEP - What is sent to OS

2018-04-11 Thread Timothy Penner via 4D_Tech
Hi Chip, I agree with Tim Nevels' approach. It’s very solid. Another thing to add, is that sometimes you may need to call the actual cmd.exe and feed your command into that, as described in this tech tip: http://kb.4d.com/assetid=76658 On windows that would be like this: $theRestOftheCommand:=

RE: v13+ LEP - What is sent to OS

2018-04-11 Thread Chip Scheide via 4D_Tech
I think the problem is in escaping the file path. I'm trying to get xCopy to work. I have tried a variety of variations, none of which want to work. That is why I would like to see what it is that LEP is handing off to the OS On Wed, 11 Apr 2018 19:31:34 +, Timothy Penner wrote: > Hi Chip,

Re: ORDA query & pointers syntax question

2018-04-11 Thread Dani Beaubien via 4D_Tech
Hi Kieth, These are equivalent. C_OBJECT($medicaidEligibleStudentsInDistr) $medicaidEligibleStudentsInDistr:=ds.Student.query("Medicaid_Eligible = 'Yes' & District_ID = :1";$districID) $medicaidEligibleStudentsInDistr:=ds["Student"].query("Medicaid_Eligible = 'Yes' & District_ID = :1";$distric

Re: ORDA query & pointers syntax question

2018-04-11 Thread Julio Carneiro via 4D_Tech
Something like this might do the trick (did not try it yet): $tableName:=Table name(pTable) $fieldName:=Field name(pField) QUERY(ds[$tableName];ds[$tableName][$fieldName]=$aValue) When an object property name is on a variable, you can use the “object[property]” syntax. hth julio > On Apr 11,

Re: v13 - Custom Constants & 4D Pop

2018-04-11 Thread Chip Scheide via 4D_Tech
I have been looking at a constants file, and I can see that "special" characters use a distinct notation: " = " for example Are there equivalents for: Carriage return Line feed and tab? On Wed, 11 Apr 2018 13:19:43 -0400, Chip Scheide via 4D_Tech wrote: > a couple of questions: > 1 - where doe

Re: v13 - Custom Constants & 4D Pop [solved!]

2018-04-11 Thread Chip Scheide via 4D_Tech
here is the needed xml to assign carriage return, line feed, and CrLF to Konstants in an xliff file (spacing adjusted to be more readable in plain text) Lf Cr CrLf On Wed, 11 Apr 2018 15:59:26 -0400, Chip Scheide via 4D_Tech wrote: > I have been looking at a constants file, an

Re: v13 - Custom Constants & 4D Pop [solved!]

2018-04-11 Thread Keisuke Miyako via 4D_Tech
FYI these are standard XML notations alternatively you can code hexadecimal i.e. and https://en.m.wikipedia.org/wiki/XML technically you can widen the range of valid unicode characters by specifying version=1.1 in declaration.

Re: v13+ LEP - What is sent to OS

2018-04-11 Thread Keisuke Miyako via 4D_Tech
the values you pass as the first two arguments to LEP are passed “as is” to the CLI (well, actually they are converted from Unicode to ANSI if you use text not BLOB, but that is mostly irrelevant when your locale uses English) so you can just examine those variables. (I advise against passing st

Re: ORDA query & pointers syntax question

2018-04-11 Thread Julio Carneiro via 4D_Tech
ooops, sorry I mixed up ‘classic 4D’ and ORDA :-) The query line should read: ds[$tableName].query($tableName+”.”+$fieldName+” = “+$aValue) or ds[$tableName].query($tableName+”.”+$fieldName+” = :1“;$aValue) hth julio > On Apr 11, 2018, at 5:00 PM, Julio Carneiro wrote: > > Something like this

Re: v13+ LEP - What is sent to OS

2018-04-11 Thread Keisuke Miyako via 4D_Tech
typing code to the console program is not the same as calling CMD.exe via the CLI. in general, with the console program, you only have to care about quoting arguments that contain a space because arguments are separated by space. however, when you call CMD.exe via the command line, you have to

Re: v13+ LEP - What is sent to OS

2018-04-11 Thread Kenneth Geiger via 4D_Tech
Have you tried ROBOCOPY instead of XCOPY? > On Apr 11, 2018, at 1:38 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I think the problem is in escaping the file path. > I'm trying to get xCopy to work. > > I have tried a variety of variations, none of which want to work. > That

Re: ORDA query & pointers syntax question

2018-04-11 Thread Keith Culotta via 4D_Tech
Thanks! > On Apr 11, 2018, at 4:04 PM, Julio Carneiro via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > ooops, sorry I mixed up ‘classic 4D’ and ORDA :-) > > The query line should read: > > ds[$tableName].query($tableName+”.”+$fieldName+” = “+$aValue) > or > ds[$tableName].query($tableName+”.”+$

Web Server Freeze

2018-04-11 Thread Sujit Shah via 4D_Tech
We are having random occasional freezing of the Web Server with several SOAP call processes accumulating on the Server Process window with a "waiting for flag" state. Eventually the 4D Server stops responding and a forced restart is required. Our sites can have upto 300 calls per second. There are

RE: Web Server Freeze

2018-04-11 Thread Stephen J. Orth via 4D_Tech
We have been experiencing web service issues also (4D V16.3 NB217768). Although we don't have as high a hit rate as you, what we are seeing is the web server acting like it is not running. Incoming web service calls are not received, and this is causing our automated system a LOT of problems.

Re: Web Server Freeze

2018-04-11 Thread John DeSoi via 4D_Tech
What 4D version? Mac or Windows? > On Apr 11, 2018, at 6:55 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We are having random occasional freezing of the Web Server with several > SOAP call processes accumulating on the Server Process window with a > "waiting for flag" state. Ev

Re: Web Server Freeze

2018-04-11 Thread Sujit Shah via 4D_Tech
15.2 Windows On Thu, Apr 12, 2018 at 10:26 AM, John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > What 4D version? Mac or Windows? > > > On Apr 11, 2018, at 6:55 PM, Sujit Shah via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > We are having random occasional freezing of the Web Server wit

Re: Web Server Freeze

2018-04-11 Thread John DeSoi via 4D_Tech
I had tremendous problems with "waiting for flag" lockups in version 14 (Mac Server) related to transactions. No more problems after upgrading to version 15. It was a long road, hope you can find it. John DeSoi, Ph.D. > On Apr 11, 2018, at 7:29 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com>

Re: Web Service Call in 4Dv15

2018-04-11 Thread Ronnie Teo via 4D_Tech
Thanks Patrick, I’ll check it out. > Did you check preference in 4D about security. There is some improvement on > it. It may be the cause. > For that, there is an article on the 4D Blog (blog.4d.com > ) > > Patrick Julio, the web service is not hosted by 4D, so a 4D w

Appending XML Elements

2018-04-11 Thread Sujit Shah via 4D_Tech
Is there a more efficient way that a large number of sub - elements can be added to the root element? At the moment we are using a For Loop. (I am looking for something like SELECTION TO JSON or JSON Stringify array for XML..) -- xxx "There must be ingenuity as well