Re: Options To Put Data Into Existing Excel Spreadsheets?

[Wayne Stewart via 4D_Tech]

2cv is faster than a Ferrari:

https://goo.gl/images/2yZ2L9

On Wed, 9 May 2018 at 01:16, Randy Engle via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Another "plug" for Pluggers XCEL plugin.
> We use it exclusively.
> Full control of the spreadsheet.
>
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas Cryer
> via 4D_Tech
> Sent: Tuesday, May 8, 2018 12:15 AM
> To: 4d_tech@lists.4d.com
> Cc: Douglas Cryer 
> Subject: Re: Options To Put Data Into Existing Excel Spreadsheets?
>
> Allan,
>
> Until recently we were using Keisuke's component.  Clients were asking for
> more, in particular images so we looked around and found the Pluggers
> Plugin.  Yes it does mean going from a free option to a paid option but
> equally it is like going from a 2CV to a Ferrari.  It does much more, far
> faster and far more efficiently.  Keisuke himself said that the component
> was written as an example and he never expected it to be used in production
> systems.
>
> Since adopting the Excel Plugin we have converted many outputs and our
> clients love it.  They have commissioned more reports and we have been able
> to recoup the cost of the plugin easily within months of purchase.
>
> If you still need the component I am sure I can dig you out a copy but I
> would urge you to either fund the cost of the plugin yourself or get your
> client to do so.  You will not be sorry.
>
> Regards,  Dougie
> 
>
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218 2nd Floor Broadway House, 4-6
> The Broadway, Bedford MK40 2TE
> 
> Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.com <
> http://www.telekinetix.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
> **
>
> **
> 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
> **

-- 

Regards,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart

**
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: Standalone application connection to 4D Server

[Wayne Stewart via 4D_Tech]

Hi,

Chipping in on the licensing question.

What is the standalone?

If it’s a sponsored 4D engine app then you are limited to two connections
per day.

If it’s SQL desktop app then you can connect whenever you want. I assume
the same for the developer editions too.

The oem desktop product could be covered depending on your agreement with
4D.

Just making life difficult,

Wayne



On Wed, 9 May 2018 at 02:52, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Chuck,
> Good point. I assumed he already has a web license but if that's not the
> case you are correct.
>
> On Tue, May 8, 2018 at 9:25 AM Charles Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > If you use SQL there is no additional licensing needed. The other SOAP or
> > HTTPS means another license either for soap server or web server on the
> 4d
> > server
> >
> > Regards
> >
> > Chuck
> >
> > On Tue, May 8, 2018 at 11:53 AM, Kirk Brooks via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> > > David,
> > > What version of 4D are you using? If it's v15+, with respect to Chuck's
> > > suggestion, I'd use HTTPS for the data transfers and JSON/c-objects.
> It's
> > > pretty easy to write an API on the server side to manage such a request
> > and
> > > shuffle the data between the two endpoints. JSON is a lot easier to
> work
> > > with than XML, I find.
> > >
> > > If you are a SQL pro (I am not) then that's a perfectly viable option,
> > but
> > > it's not required.
> > >
> > > On Tue, May 8, 2018 at 7:49 AM David Loeppky via 4D_Tech <
> > > 4d_tech@lists.4d.com> wrote:
> > >
> > > > I have a standalone 4D application that needs to occasionally connect
> > to
> > > > our 4D Server to exchange some data.  Realizing there are a few
> > different
> > > > architecture approaches to take, I'd appreciate some advice as to the
> > > > easiest way to approach this.  Thanks.
> > > >
> > > > --
> > > >
> > > > Regards,
> > > >
> > > > David Loeppky
> > > >
> > > > Co-Owner
> > > >
> > > > T: 360.380.1908 x11
> > > >
> > > > M: 360.319.9141
> > > >
> > > > F: 360.384.3673
> > > >
> > > > *dav...@chuckanutbay.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
> > > >
> **
> > >
> > >
> > >
> > > --
> > > Kirk Brooks
> > > San Francisco, CA
> > > ===
> > >
> > > *We go vote - they go home*
> > > **
> > > 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
> > > **
> >
> >
> >
> >
> > --
> >
> >
> -
> >  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
> >  Informed Solutions, Inc.
> >  Brookline, MA 02446 USA Registered 4D Developer
> >Providers of 4D, Sybase & SQL Server connectivity
> >   http://www.informed-solutions.com
> >
> >
> -
> > This message and any attached documents contain information which may be
> > confidential, subject to privilege or exempt from disclosure under
> > applicable law.  These materials are intended only for the use of the
> > intended recipient. If you are not the intended recipient of this
> > transmission, you are hereby notified that any distribution, disclosure,
> > printing, copying, storage, modification or the taking of any action in
> > reliance upon this transmission is strictly prohibited.  Delivery of this
> > message to any person other than the intended recipient shall not
> > compromise or waive such confidentiality, privilege or exemption
> > from disclosure as to this communication.
> > **
> > 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
> > **
>
>
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  

Re: Error -19191 ?

[Spencer Hinsdale via 4D_Tech]

It is old client cannot update via new network layer...

http://kb.4d.com/assetid=77427 

> On May 8, 2018, at 9:53 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Everyone,
> 
> I have a 4D Client user (v15r5, Windows) who can't connect, with error 
> -19191.  I can't find this error in either the language ref, the server 
> reference, or the design ref.  Does anyone have an idea of what this error is?
> 
> Thanks,
> 
> Bob Miller
> Parker Hannifin Corp.
> 
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged. It 
> only should be used or disseminated for the purpose of conducting business 
> with Parker. If you are not an intended recipient, please notify the sender 
> by replying to this message and then delete the information from your system. 
> Thank you for your cooperation."
> **
> 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
**

Error -19191 ?

[Bob Miller via 4D_Tech]

Hi Everyone,

I have a 4D Client user (v15r5, Windows) who can't connect, with error -19191.  
I can't find this error in either the language ref, the server reference, or 
the design ref.  Does anyone have an idea of what this error is?

Thanks,

Bob Miller
Parker Hannifin Corp.

ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It 
only should be used or disseminated for the purpose of conducting business with 
Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
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: Standalone application connection to 4D Server

[Kirk Brooks via 4D_Tech]

Chuck,
Good point. I assumed he already has a web license but if that's not the
case you are correct.

On Tue, May 8, 2018 at 9:25 AM Charles Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> If you use SQL there is no additional licensing needed. The other SOAP or
> HTTPS means another license either for soap server or web server on the 4d
> server
>
> Regards
>
> Chuck
>
> On Tue, May 8, 2018 at 11:53 AM, Kirk Brooks via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > David,
> > What version of 4D are you using? If it's v15+, with respect to Chuck's
> > suggestion, I'd use HTTPS for the data transfers and JSON/c-objects. It's
> > pretty easy to write an API on the server side to manage such a request
> and
> > shuffle the data between the two endpoints. JSON is a lot easier to work
> > with than XML, I find.
> >
> > If you are a SQL pro (I am not) then that's a perfectly viable option,
> but
> > it's not required.
> >
> > On Tue, May 8, 2018 at 7:49 AM David Loeppky via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> > > I have a standalone 4D application that needs to occasionally connect
> to
> > > our 4D Server to exchange some data.  Realizing there are a few
> different
> > > architecture approaches to take, I'd appreciate some advice as to the
> > > easiest way to approach this.  Thanks.
> > >
> > > --
> > >
> > > Regards,
> > >
> > > David Loeppky
> > >
> > > Co-Owner
> > >
> > > T: 360.380.1908 x11
> > >
> > > M: 360.319.9141
> > >
> > > F: 360.384.3673
> > >
> > > *dav...@chuckanutbay.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
> > > **
> >
> >
> >
> > --
> > Kirk Brooks
> > San Francisco, CA
> > ===
> >
> > *We go vote - they go home*
> > **
> > 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
> > **
>
>
>
>
> --
>
> -
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D, Sybase & SQL Server connectivity
>   http://www.informed-solutions.com
>
> -
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **
> 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
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
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: Standalone application connection to 4D Server

[Charles Miller via 4D_Tech]

If you use SQL there is no additional licensing needed. The other SOAP or
HTTPS means another license either for soap server or web server on the 4d
server

Regards

Chuck

On Tue, May 8, 2018 at 11:53 AM, Kirk Brooks via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> David,
> What version of 4D are you using? If it's v15+, with respect to Chuck's
> suggestion, I'd use HTTPS for the data transfers and JSON/c-objects. It's
> pretty easy to write an API on the server side to manage such a request and
> shuffle the data between the two endpoints. JSON is a lot easier to work
> with than XML, I find.
>
> If you are a SQL pro (I am not) then that's a perfectly viable option, but
> it's not required.
>
> On Tue, May 8, 2018 at 7:49 AM David Loeppky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > I have a standalone 4D application that needs to occasionally connect to
> > our 4D Server to exchange some data.  Realizing there are a few different
> > architecture approaches to take, I'd appreciate some advice as to the
> > easiest way to approach this.  Thanks.
> >
> > --
> >
> > Regards,
> >
> > David Loeppky
> >
> > Co-Owner
> >
> > T: 360.380.1908 x11
> >
> > M: 360.319.9141
> >
> > F: 360.384.3673
> >
> > *dav...@chuckanutbay.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
> > **
>
>
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *We go vote - they go home*
> **
> 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
> **




-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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: OPEN FORM WINDOWS

[stardata.info via 4D_Tech]

Hi Kristopher,

Below my answers.

Thanks

Ferdinando


Il 08/05/2018 17:46, Kristopher Merolla ha scritto:

Hi Ferdinando,

In 16.3 HF2 I put together a simple case, making a custom output form for a table with 
two buttons.  One button runs your first block of code to open a Palette window and the 
other a Plain window.  The "form" opened by the buttons on the output form has 
field variables, and I am able to modify them and when closing the window, the records 
are modified.

Is this what you are trying to accomplish?
The issue is that using the option Palette form window, the list of 
records in the output form is not displayed correctly.


If not, what is in your "form" (are there any other buttons, bits of code, etc) and what 
exactly do you mean by the "selection of the records are not upgraded in the output 
form"?  Are you trying to change the selection like a query or modify the records? Do you have 
any other code executing here?
I open the window for do a queries, when I close the window, the list of 
records are the same and are not upgraded. If i click on another button 
upper the form windows, i can see the new selection of records.


Regards,
Kristopher



Kristopher Merolla
Technical Support Engineer

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Telephone :
Standard :
Fax :
Email : kmero...@4d.com
Web :

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of stardata.info 
via 4D_Tech
Sent: Tuesday, May 8, 2018 6:55 AM
To: 4d_tech@lists.4d.com
Cc: stardata.info 
Subject: OPEN FORM WINDOWS

Hi All,

I work 4D V16 on windows.
Using this code in one button of output form for doing a queries:
$Win:=Open form window("form";Palette form window;Horizontally 
centered;Vertically centered;*)
DIALOG("form")
CLOSE WINDOW
i notice that the selection of the records are not upgraded in the output form.

If use the option Plain form window i not have the same issue.
$Win:=Open form window("form";Plain form window;Horizontally 
centered;Vertically centered;*)
DIALOG("form")
CLOSE WINDOW

Someone know the reason?

Thanks
Ferdinando
**
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
**

Re: Standalone application connection to 4D Server

[Kirk Brooks via 4D_Tech]

David,
What version of 4D are you using? If it's v15+, with respect to Chuck's
suggestion, I'd use HTTPS for the data transfers and JSON/c-objects. It's
pretty easy to write an API on the server side to manage such a request and
shuffle the data between the two endpoints. JSON is a lot easier to work
with than XML, I find.

If you are a SQL pro (I am not) then that's a perfectly viable option, but
it's not required.

On Tue, May 8, 2018 at 7:49 AM David Loeppky via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have a standalone 4D application that needs to occasionally connect to
> our 4D Server to exchange some data.  Realizing there are a few different
> architecture approaches to take, I'd appreciate some advice as to the
> easiest way to approach this.  Thanks.
>
> --
>
> Regards,
>
> David Loeppky
>
> Co-Owner
>
> T: 360.380.1908 x11
>
> M: 360.319.9141
>
> F: 360.384.3673
>
> *dav...@chuckanutbay.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
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
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: Options To Put Data Into Existing Excel Spreadsheets?

[Randy Engle via 4D_Tech]

Another "plug" for Pluggers XCEL plugin.
We use it exclusively.
Full control of the spreadsheet.

Randy Engle, Director
XC2 Software LLC – XC2LIVE!

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas Cryer via 
4D_Tech
Sent: Tuesday, May 8, 2018 12:15 AM
To: 4d_tech@lists.4d.com
Cc: Douglas Cryer 
Subject: Re: Options To Put Data Into Existing Excel Spreadsheets?

Allan,

Until recently we were using Keisuke's component.  Clients were asking for 
more, in particular images so we looked around and found the Pluggers Plugin.  
Yes it does mean going from a free option to a paid option but equally it is 
like going from a 2CV to a Ferrari.  It does much more, far faster and far more 
efficiently.  Keisuke himself said that the component was written as an example 
and he never expected it to be used in production systems.

Since adopting the Excel Plugin we have converted many outputs and our clients 
love it.  They have commissioned more reports and we have been able to recoup 
the cost of the plugin easily within months of purchase.

If you still need the component I am sure I can dig you out a copy but I would 
urge you to either fund the cost of the plugin yourself or get your client to 
do so.  You will not be sorry.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218 2nd Floor Broadway House, 4-6 The 
Broadway, Bedford MK40 2TE Email : jdcr...@telekinetix.com  Web : 
http://www.telekinetix.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
**

**
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: Standalone application connection to 4D Server

[Charles Miller via 4D_Tech]

It all depends. How much data is exchanged? How automated do you need it to
be? How often will you be doing this? Is data movement bi-directional?

The most straightforward IMO is SQL, but you could also use SOAP, text(XML
files), HTTPS

Regards

Chuck

On Tue, May 8, 2018 at 10:48 AM, David Loeppky via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have a standalone 4D application that needs to occasionally connect to
> our 4D Server to exchange some data.  Realizing there are a few different
> architecture approaches to take, I'd appreciate some advice as to the
> easiest way to approach this.  Thanks.
>
> --
>
> Regards,
>
> David Loeppky
>
> Co-Owner
>
> T: 360.380.1908 x11
>
> M: 360.319.9141
>
> F: 360.384.3673
>
> *dav...@chuckanutbay.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
> **




-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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
**

Standalone application connection to 4D Server

[David Loeppky via 4D_Tech]

I have a standalone 4D application that needs to occasionally connect to
our 4D Server to exchange some data.  Realizing there are a few different
architecture approaches to take, I'd appreciate some advice as to the
easiest way to approach this.  Thanks.

-- 

Regards,

David Loeppky

Co-Owner

T: 360.380.1908 x11

M: 360.319.9141

F: 360.384.3673

*dav...@chuckanutbay.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
**

Re: Google Authenticator Integration

[Douglas Cryer via 4D_Tech]

Chip,

Thank you for the input.  I am trying to build to what people expect.  My 
target market in this instance is trading exchange users crypto exchanges in 
particular.  In this market 2FA is used extensively as a secondary or tertiary 
security level.  As example Binance but may others use 2FA linked with Google 
authenticator so my potential user base will already have an app for that and 
just need to add a new site entry.

Duo looks to be a good product but does not seem to fit the use case as far as 
I can see.  It is more for corporate use and is priced by user, which would 
make it expensive for a general web solution.  It would be like using 4D Mobile 
REST services and having to pay for all the licenses that could entailand not 
knowing how many people could hit your website at a given time...

I am looking at Authy as well although I do not yet understand the real 
differences.  So I am going to read through:
https://blog.devolutions.net/2016/10/most-popular-2-factor-authentication-2fa-compared
and see if I can educate myself.

It seems, regardless of the app used by the end user, the work in 4D would be 
about the same as the process is to generate a matching time sensitive key 
against which to match.  I have been looking at 
https://www.codementor.io/slavko/google-two-step-authentication-otp-generation-du1082vho

But I got a bit stuck at Step C: as I did not understand what was required.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.com 


 On 08/05/2018, 15:05, "Chip Scheide" <4d_o...@pghrepository.org> wrote:

personally, I do not believe anything from Google can be considered to 
be 'secure'... YMMV

I would try a different 2FA app.  
My Wife's employer uses something called Duo

 



**
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

[Tom DeMeo via 4D_Tech]

Hi,


One of the main reasons to use 4D to publish on the web is the efficient 
simplicity of the architecture. There may be circumstances where putting 
another web server such as Apache in front is worth the trouble, but all too 
often, its done for no good reason. 

Getting the correct files for an SSL cert for your web server is not solved in 
any way by adding another layer to your architecture, unless there is already 
an Apache server with SSL in place for you to use. Just go back to your IT  
department and make sure they give you both the cert and key files. 


Tom DeMeo
**
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: SPAM-LOW: Re: Google Authenticator Integration

[Douglas Cryer via 4D_Tech]

Chip,

Thank you for the input.  I am trying to build to what people expect.  My 
target market in this instance is trading exchange users crypto exchanges in 
particular.  In this market 2FA is used extensively as a secondary or tertiary 
security level.  As example Binance but may others use 2FA linked with Google 
authenticator so my potential user base will already have an app for that and 
just need to add a new site entry.

Duo looks to be a good product but does not seem to fit the use case as far as 
I can see.  It is more for corporate use and is priced by user, which would 
make it expensive for a general web solution.  It would be like using 4D Mobile 
REST services and having to pay for all the licenses that could entailand not 
knowing how many people could hit your website at a given time...

I am looking at Authy as well although I do not yet understand the real 
differences.  So I am going to read through:
https://blog.devolutions.net/2016/10/most-popular-2-factor-authentication-2fa-compared
and see if I can educate myself.

It seems, regardless of the app used by the end user, the work in 4D would be 
about the same as the process is to generate a matching time sensitive key 
against which to match.  I have been looking at 
https://www.codementor.io/slavko/google-two-step-authentication-otp-generation-du1082vho

But I got a bit stuck at Step C: as I did not understand what was required.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.com 


 On 08/05/2018, 15:05, "Chip Scheide" <4d_o...@pghrepository.org> wrote:

personally, I do not believe anything from Google can be considered to 
be 'secure'... YMMV

I would try a different 2FA app.  
My Wife's employer uses something called Duo

 



**
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: SSL cipher list

[Douglas Cryer via 4D_Tech]

Jim and Mike,

Thank you for your inputs on this.

The resource: 
https://mozilla.github.io/server-side-tls/ssl-config-generator/ was very 
helpful in creating a cipher list that 4D would accept and which got rid of all 
the insecure options.

With regards:
I would guess its a syntax issue with 4D.  Can you get the current cipher
list from 4D and just change one piece at a time until you get rid of the
weak portions?

Get database parameter(SSL cipher list;$vt_CipherList) returns an empty string 
till you set it.  So you do not seem to be able to get a list of the defaults.  
Maybe you need to dig into the OpenSSL library (yuck)...

Mike also thank you for your list, although it did not make things better.

Even with the config -generator whilst the resulting cipher list removed all 
orange options it did nothing to improve the bars on the already A+ rating.

As far as I can tell this is about as good as it gets.  I have two outstanding 
orange text pieces:
DNS CAA - No  : This appears to be more about who you buy your certificate from 
and the level of purchase (which is where it can get expensive). Also the 
message ECDH public server param reuse - Yes  : I see no way to affect this.  I 
tried switching off the cache to see if it made a difference but no...

If anyone else has any gems I will leave it there happy in the knowledge I have 
matched the target sites I was trying to match and exceeded many high street 
baking establishments.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
**

Re: v13+ - method comments (the Explorer Pane)

[Chip Scheide via 4D_Tech]

Dani, Wayne,

Thanks


On Mon, 07 May 2018 21:59:39 +, Wayne Stewart via 4D_Tech wrote:
> Chip,
> 
> I wrote some code to do that for Foundation it relies on some discipline in
> creating your header comments of course.
> 
> 
> // 
> // Project Method:  --> ReturnType
> // Description
> // Access: Shared
> // Parameters:
> //   $1 : Type : Description
> //   $x : Type : Description (optional)
> 
> // Returns:
> //   $0 : Type : Description
> 
> // Created by Wayne Stewart ()
> // wa...@4dsupport.guru
> // 
> 
> 
> 
>// 
>// Project Method: Fnd_Shell_WriteComments {(Method Name; Do not use)}
> 
>// This method will create documentation comments
>//   it is based on the assumption that you format your
>//method header comments in the same manner as Foundation
>//  The second paramater is just used to trigger the method
>//   starting in a new process, you should not pass anything in this
> parameter
> 
>// Access: Shared
> 
>// Parameters:
>//   $1 : Text : Either pass
>//   (a) "" - All methods (or don't pass any parameters)
>//   (b) "Prefix" - Only methods which match a prefix (Eg. Fnd_Art)
>//   (c) "Specific method name" - write comments for that method
>//   $2 : Longint : Do not use this
> 
>// Created by Wayne Stewart
>// 
> 
> C_TEXT($1)
> C_LONGINT($2)
> 
> 
C_LONGINT($CurrentMethod_i;$NumberOfMethods_i;$Position_i;$ProcessID_i;$StackSize_i)
> 
C_TEXT($FirstChars_t;$MethodCode_t;$MethodName_t;$ThreadSafe_t;$ThreadSafeSection_t)
> C_OBJECT($Attributes_o)
> 
> ARRAY TEXT($MethodCode_at;0)
> ARRAY TEXT($MethodNames_at;0)
> 
> If (False)
>C_TEXT(Fnd_Shell_WriteComments ;$1)
>C_LONGINT(Fnd_Shell_WriteComments ;$2)
> End if
> 
> 
> $StackSize_i:=0
> 
> If (Count parameters=2)
> 
>METHOD GET PATHS(Path project method;$MethodNames_at)
> 
>$MethodName_t:=$1
> 
>If (Length($MethodName_t)>0)  //  A method name or prefix has been
> specified
> 
>  $NumberOfMethods_i:=Count in array($MethodNames_at;$MethodName_t)
> 
>  If ($NumberOfMethods_i=1)  // exactly one match (use this specific
> method)
>APPEND TO ARRAY($MethodNames_at;$MethodName_t)
>  Else
> 
>$NumberOfMethods_i:=Size of array($MethodNames_at)
>For ($CurrentMethod_i;$NumberOfMethods_i;1;-1)  // Go Backwards
>  If ($MethodNames_at{$CurrentMethod_i}=($MethodName_t+"@"))
>  Else
>DELETE FROM ARRAY($MethodNames_at;$CurrentMethod_i)
>  End if
> 
>End for
> 
>  End if
> 
>End if
> 
>$NumberOfMethods_i:=Size of array($MethodNames_at)
> 
>METHOD GET CODE($MethodNames_at;$MethodCode_at)
> 
>ARRAY TEXT($MethodComments_at;$NumberOfMethods_i)
> 
>For ($CurrentMethod_i;1;$NumberOfMethods_i)
>  $MethodCode_t:=$MethodCode_at{$CurrentMethod_i}
> 
>  $Position_i:=Position("comment added and reserved by
> 4D.\r";$MethodCode_t)
> 
>  $MethodCode_t:=Substring($MethodCode_t;$Position_i+Length("comment
> added and reserved by 4D.\r"))
> 
>//  Threadsafe?
>  METHOD GET ATTRIBUTES($MethodNames_at{$CurrentMethod_i};$Attributes_o)
>  $ThreadSafe_t:=OB Get($Attributes_o;"preemptive")
> 
>  Case of
>: ($ThreadSafe_t="capable")
>  $ThreadSafeSection_t:="\rPreemptive\r"
> 
>: ($ThreadSafe_t="incapable")
>  $ThreadSafeSection_t:="\rCooperative\r"
> 
>: ($ThreadSafe_t="indifferent")
>  $ThreadSafeSection_t:="\rPreemptive capable\r"
> 
>  End case
> 
>  $MethodCode_t:=Replace string($MethodCode_t;"\r  // Access:
> Shared\r";"\r  // Access: Shared\r"+$ThreadSafeSection_t)
>  $MethodCode_t:=Replace string($MethodCode_t;"\r  // Access:
> Private\r";"\r  // Access: Shared\r"+$ThreadSafeSection_t)
> 
>//  End Threadsafe section
> 
>  $MethodCode_t:=Replace string($MethodCode_t;"  //
> \r";"")
>  $MethodCode_t:=Replace string($MethodCode_t;"//
> \r";"")
> 
>  $MethodCode_t:=Replace string($MethodCode_t;"  // Project Method: ";"")
>  $MethodCode_t:=Replace string($MethodCode_t;"// Project Method: ";"")
> 
>  $MethodCode_t:=Replace string($MethodCode_t;"  // ";"")
>  $MethodCode_t:=Replace string($MethodCode_t;"// ";"")
> 
>  $Position_i:=Position("Created by";$MethodCode_t)
> 
>  $MethodCode_t:=Substring($MethodCode_t;1;($Position_i-3))
> 
>  $FirstChars_t:=Substring($MethodCode_t;1;2)
>  While ($FirstChars_t="\r\r")
>$MethodCode_t:=Substring($MethodCode_t;2)
>$FirstChars_t:=Substring($MethodCode_t;1;2)
>  End while
> 
>  $MethodComments_at{$CurrentMethod_i}:=$MethodCode_t
> 
>End for
> 
>METHOD SET 

Re: Google Authenticator Integration

[Chip Scheide via 4D_Tech]

personally, I do not believe anything from Google can be considered to 
be 'secure'... YMMV

I would try a different 2FA app.  
My Wife's employer uses something called Duo


On Tue, 08 May 2018 12:21:41 +0100, Douglas Cryer via 4D_Tech wrote:
> Hi folks,
> 
> In my quest for building better security solutions I am currently 
> looking at implementing 2FA specifically Google Authenticator Two 
> Factor Authentication.
> 
> Has anyone done this with 4D code and is willing to share an example?
> 
> Seems like the building blocks are there:
> QR Code generation via 4D Barcodes component
> Hashing encryption vai Common Crypto.bundle
> 
> Regards,  Dougie
> 
> 
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
> **
---
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
**

OPEN FORM WINDOWS

[stardata.info via 4D_Tech]

Hi All,

I work 4D V16 on windows.
Using this code in one button of output form for doing a queries:
$Win:=Open form window("form";Palette form window;Horizontally 
centered;Vertically centered;*)

DIALOG("form")
CLOSE WINDOW
i notice that the selection of the records are not upgraded in the 
output form.


If use the option Plain form window i not have the same issue.
$Win:=Open form window("form";Plain form window;Horizontally 
centered;Vertically centered;*)

DIALOG("form")
CLOSE WINDOW

Someone know the reason?

Thanks
Ferdinando
**
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
**

Google Authenticator Integration

[Douglas Cryer via 4D_Tech]

Hi folks,

In my quest for building better security solutions I am currently looking at 
implementing 2FA specifically Google Authenticator Two Factor Authentication.

Has anyone done this with 4D code and is willing to share an example?

Seems like the building blocks are there:
QR Code generation via 4D Barcodes component
Hashing encryption vai Common Crypto.bundle

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

[Arnaud de Montard via 4D_Tech]

> Le 8 mai 2018 à 09:14, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> 2CV to a Ferrari

What's the difference?


-- 
Arnaud de Montard 




**
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

[Douglas Cryer via 4D_Tech]

Ronnie,

As painful as it may seem I would second the comment made by Dani:

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

I have done this with Apache.  It took a lot of reading and trial and error.  
It was somewhat frustrating but it was secure.  It does have some additional 
benefits too as you can display a maintenance page when your 4D system is down.

With v11 you can get HTTPS but if your client's IT do any testing you will 
quickly find it rather lacking when compared against todays stringent security 
requirements.  With v15/v16 you can get an A rating with v17 you can get an A+ 
rating.  With v11 native not so good...

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

[Douglas Cryer via 4D_Tech]

Allan,

Until recently we were using Keisuke's component.  Clients were asking for 
more, in particular images so we looked around and found the Pluggers Plugin.  
Yes it does mean going from a free option to a paid option but equally it is 
like going from a 2CV to a Ferrari.  It does much more, far faster and far more 
efficiently.  Keisuke himself said that the component was written as an example 
and he never expected it to be used in production systems.

Since adopting the Excel Plugin we have converted many outputs and our clients 
love it.  They have commissioned more reports and we have been able to recoup 
the cost of the plugin easily within months of purchase.

If you still need the component I am sure I can dig you out a copy but I would 
urge you to either fund the cost of the plugin yourself or get your client to 
do so.  You will not be sorry.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
**