Re: v13+ Plugin List issue

[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 (or is not) happening?


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SQL Date Math

[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 one type to 
> another.

http://doc.4d.com/4Dv16R6/4D/16-R6/4D-SQL-engine-implementation.300-3628406.en.html

in other words, you can't expect 4D to implicitly convert numeric 2 to 
TIMESTAMP.

besides, with an expression such as
Select someDate - 2
it is unclear whether you want to subtract 2 years, months, days, hours, 
minutes, second or milliseconds.

in addition to that, there is no way to express 2 days as TIMESTAMP.
this is mentioned in the same URL, that 4D SQL does not support date constants 
where the month or day is 0.
in other words, you can't use { d '-00-02' } to specify 2 days.
and in case you are wondering, you can't use {t '48:00:00'} either,
because a time constant that exceeds 24 hours throws a parser error.

even if you find a way to specify 2 days in a way that the parser can 
understand,
there is the fundamental problem that arithmetic expressions between VK_TIME 
(TIMESTAMP) values are type unsafe in 4D SQL.

so I think the best option is to use {FN () } with an "Add to date" wrapper

http://doc.4d.com/4Dv16R6/4D/16-R6/4d-function-call.300-3628422.en.html



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Access to Runtime Explorer

[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 explorer. Posting 
events from 4D did not work.

John DeSoi, Ph.D.



> On May 4, 2018, at 3:04 PM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 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 be very helpful.
> 
> How do others with multiple designers get around this issue?

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SQL Date Math

[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 kind of date expression in the Where clause.  The 
manual is silent on date math as far as I can tell.


Richard Wright
DataDomain
rwri...@datadomainsoftware.com


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Access to Runtime Explorer

[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 be very helpful.

How do others with multiple designers get around this issue?

Thanks




Jody Bevan
Developer

Argus Productions Inc. 
+1 587-487-6120



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v13+ Plugin List issue

[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 LIST.

However, Plugin List is returning ONLY 4D Quick, even when the needed 
plugin is in both the host, and component's respective plugin folders.

Ideas as to what is (or is not) happening?
Thanks
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: HTTPS Connection for Web Module

[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.4d.com> 
> wrote:
> 
> Hi,
> 
> I’ve written earlier about a 4Dv11 application with a web module.  
> The client's IT now wants all access to be secured and only allow https 
> connections.
> 
> According to the manual, we would need to place 2 files alongside the 
> structure files in the database folder, namely the cert.pea dn key.em.
> However, the client’s IT has generated only one certificate file with a .cer 
> extension.
> 
> May I ask how I should proceed?
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

[ANN] hmBarcode 6.0 available / QR-Code/Datamatrix/Aztec Code/PDF417 and others

[Christian Sakowski via 4D_Tech]

Today, heubach media released version 6.0 of hmBarcode.

hmBarcode is a plug-in developed by heubach media, Hamburg, Germany for 4th 
Dimension.

With Version 6.0 of hmBarcode we provide the Plugin as native Unicode Plugin 
for 4D v16 and 4D v17 in 32 and 64 Bit.

hmBarcode 5 and 6 introduces the following NEW features:

-> Complete new demo database, which demonstrates all Barcode types and it’s 
options
-> New way of Barcode creation with more options and output possibilities
-> Native output in SVG, BMP, PNG, EPS, GIF
-> Output into a picture variable
-> New Symbologies: DotCode and Han Xin (Chinese Sensible) Code 
-> New constants for each Barcode type

The demo database now demonstrates all available Barcodes.

With hmBarcode can produce 1D and 2D-Barcodes in your 4D application. Supported 
barcodes are:

- QR-Code
- Aztec Code
- Datamatrix
- PDF417
- Australia Post Redirection
- Australia Post Reply Paid
- Australia Post Routing
- Australia Post Standard Customer
- Codabar
- Code 11 
- Code 16K
- Code 128
- Code 128 (Subset B)
- Code 2 of 5 Data Logic | IATA | Industrial Code
- 3 of 9 (Code 39)
- Code 93
- Deutsche Post Identcode & Leitcode
- DotCode
- EAN Extended Code 3 of 9 (Code 39+) 
- FIM
- Flattermarken
- GS1 DataBar Expanded | Expanded Stacked | Limited
- GS1 DataBar-14 | Stacked | Stacked Omnidirectional
- GS1-128
- Han Xin (Chinese Sensible) Code
- Interleaved 2 of 5
- ISBN (EAN-13 with verification stage) 
- ITF-14
- LOGMARS
- MicroPDF417
- MSI Code
- MSIPlessey
- NVE-18
- PDF417 normal & Truncated
- Pharmacode One-Track | Two-Track
- PLANET
- Plessey Code
- PostNet
- PZN
- Royal Mail 4 State (RM4SCC)
- Standard Code 2 of 5
- Telepen Alpha | Numeric
- UPC A & UPC E
- USPS OneCode
- and some others...

=== Download ===

You find more information the download here:



The download includes a sample database with the hmBarcode Plugin and a 
documentation.

=== Requirements ===
hmBarcode will run with 4D v16/v17 on Macintosh 10.11 and higher/Windows 7 SP1 
and higher
hmBarcode uses the newest available system API's.

--

Grüße/Regards,
[heubach-media] | Christian Sakowski
christian.sakow...@heubach-media.de
Tel: +49/(0)40/52 10 59-23


--
heubach media
Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
22529 Hamburg
tel: 040 / 52 10 59 - 10 | fax: -99
mail: i...@heubach-media.de
home: www.heubach-media.de
Geschäftsführer|CEO: Matthias Heubach

Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei:
http://www.milo-rental.com

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten 
haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht 
gestattet.
 
This e-mail may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

HTTPS Connection for Web Module

[Ronnie Teo via 4D_Tech]

Hi,

I’ve written earlier about a 4Dv11 application with a web module.  
The client's IT now wants all access to be secured and only allow https 
connections.

According to the manual, we would need to place 2 files alongside the structure 
files in the database folder, namely the cert.pea dn key.em.
However, the client’s IT has generated only one certificate file with a .cer 
extension.

May I ask how I should proceed?

Regards,
Ronnie
Tarawerkz




**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**