Re: HTTPS Connection for Web Module

2018-05-04 Thread Dani Beaubien via 4D_Tech
Hi Ronnie, I would consider putting Apache or NGINX in front of your 4D v11 application and configure Apache/NGINX as a reverse proxy to your 4D app. There has been messages on the nug that can tell you how to do that. Dani > On May 4, 2018, at 12:41 AM, Ronnie Teo via 4D_Tech <4d_tech@lists.4

v13+ Plugin List issue

2018-05-04 Thread Chip Scheide via 4D_Tech
so.. I have a component which needs a plugin. The host system needs to have the plugin available to it (in the host plugin folder) I wrote some code to check and copy the needed plugin from the component's plugin folder to the host's. To check whether or not the host has the plugin I use PLUGIN

Access to Runtime Explorer

2018-05-04 Thread Jody Bevan via 4D_Tech
In a Multi Developer environment none of the developers sign in as the ‘Designer’ user. We have a group that has access to the Design environment. We then put developers into this group. Therefore, when working on the system none of us have access to the Runtime Explorer. Sometimes that could b

SQL Date Math

2018-05-04 Thread Richard Wright via 4D_Tech
What kind of date math does 4D’s SQL support? The following gives an error where I’m trying to subtract 2 days from the date: Select someDate - 2 From someTable The error returned is “Operation VK_TIME - VK_LONG8 is not type safe. Failed to validate SELECT command.” Same thing if you put that

Re: Access to Runtime Explorer

2018-05-04 Thread John DeSoi via 4D_Tech
Hi Jody, I had a case where I wanted non-admin users to be able to open runtime explorer. I was able to do this by temporarily switching their access to designer, opening runtime explorer, then switching back their access. I had to use Apple Events to send the keystrokes to open up runtime expl

Re: SQL Date Math

2018-05-04 Thread Keisuke Miyako via 4D_Tech
the error message seems to be in line with what is explain in the documentation: > Automatic data type conversion is implemented between numeric types. > A string that represents a number is not converted to a corresponding number. > There are special CAST functions that will convert values from

Re: v13+ Plugin List issue

2018-05-04 Thread Keisuke Miyako via 4D_Tech
it sounds like PLUGIN LIST is being executed in the component's context. I guess it should the responsibility of the host to check for plugin availability, not the component. 2018/05/05 4:16、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール: Ideas as to what is (o