Re: SFTP - Native to 4D?

Hi Janet, > On Sep 13, 2017, at 3:40 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I was familiar with the encryption command, we used it to generate a key for > securing a website hosted by a copy of 4D, however the documentation talks > about browsers. We would want to be

Re: SFTP - Native to 4D?

Hi Janet, > On Sep 13, 2017, at 3:18 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > What do you launch with LEP? You launch "curl". Type "man curl" in Terminal to see the details. This is installed by default on macOS. Not sure if this is fixed in more recent macOS versions,

Re: Server Process "Frozen"-ish

Just saw this happen to our production server tonight. We have a stored procedure that simply calls New Log File every few minutes. About an hour ago it just stopped working. The process is still there in the process list, and nothing else seems wrong with the server, but this very simple stored

Re: Server Process "Frozen"-ish

Steve, I have a few that I've been running for a long time. #1 is a method that manages sending emails. Emails created by users and the system go into a que and then are sent by the server. The method just sits and runs every few minutes. Another one runs every few minutes to update the current

Thread-safe coding (Was: Server Process "Frozen"-ish)

On Thu, Sep 14, 2017 at 9:56 AM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Wow… this turned out to be a lot longer post than I expected. But it might be helpful to less experienced 4D developers. Dude, you've been hiding your light under a bushel...you should write long posts more

RE: Server Process "Frozen"-ish

On Sep 13, 2017, at 4:48 PM, Stephen J. Orth wrote: > I've given up trying to write and use stored procedures, the Server is just > too fragile. I'd be open to anyone telling me you can really use stored > procedures in a "hard core" way without completely killing all connected > users

RE: SFTP - Native to 4D?

On Sep 13, 2017, at 4:48 PM, Janet Jonas wrote: > Thanks, John for the link to the key creation information. > > What do you launch with LEP? I use WS_FTP software from ipswitch. This is what the client already had, so I used it.

Re: Server Process "Frozen"-ish

I was hoping that with the Preemptive processes we could actually accomplish this. I have not tried it as of yet though with v16. I will stick with ‘Butlers’ as we called them, for now. Jody Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc.

Re: SFTP - Native to 4D?

If you look in the archive you will find examples of using applescript to do this Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: SFTP - Native to 4D?

John - I was familiar with the encryption command, we used it to generate a key for securing a website hosted by a copy of 4D, however the documentation talks about browsers. We would want to be sending files to another website via SFTP. Now we send similar files via regular 4D FTP commands

Re: read from a MS SQL server with 4D

As I have said before Microsoft's own web site. See below is a great resource https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation Regards Chuck Chuck Miller Voice:

RE: Server Process "Frozen"-ish

I've given up trying to write and use stored procedures, the Server is just too fragile. I'd be open to anyone telling me you can really use stored procedures in a "hard core" way without completely killing all connected users performance. For years now, with each new release of 4D, I've been

Re: Server Process "Frozen"-ish

> Le 13 sept. 2017 à 18:46, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > Just a workaround suggestion.. I use something very similar (a table describing what job to do + when to start). From the ages were I understood that I was unable to write an error free

RE: SFTP - Native to 4D?

Thanks, John for the link to the key creation information. What do you launch with LEP? JJ > On Sep 13, 2017, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote: > > Message: 7 > Date: Wed, 13 Sep 2017 12:17:07 -0500 > From: John DeSoi > > To: 4D iNug

RE: SFTP - Native to 4D?

Thanks, Stephen, but we are an all Mac shop. JJ > On Sep 13, 2017, at 9:30 AM, 4d_tech-requ...@lists.4d.com wrote: > > Message: 11 > Date: Wed, 13 Sep 2017 11:22:50 -0500 > From: "Stephen J. Orth" > > To: "'4D iNug Technical'"

Re: read from a MS SQL server with 4D

I have not done anything in 4D with MS SQL Server, but have done quite a bit of scripting using SQL Server Management Studio (SQLSMS). It is very easy to work with SQLSMS and I taught myself how to write the scripts by copying example scripts from the internet and running them in SQLSMS,

Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

In my mind a variable is the same thing as a key value pair. The variable name is the key and the data the variable contains is the value. I name all variables with a user readable name so what is the difference between a variable named vFirstName that contains “John” and oObj.firstname that

Re: v16x centipedes, trilobites and various other arthropods

Unfortunately keyboard shortcuts don't work in ALP 10 if a cell is being edited, which is even worse. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 1:10 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm using ALP v10.0b10 beta > > So, working fine in 16.2 and

Re: Server Process "Frozen"-ish

Hi Nigel, 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. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada

Re: SFTP - Native to 4D?

> On Sep 13, 2017, at 10:27 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Does 4D have any native capability to do SFTP file transfers and/or generate > a SSH-2 RSA public and private key pair? 4D does not have any native capability to SFTP. For the Mac I ended up using

RE: v16x centipedes, trilobites and various other arthropods

I'm using ALP v10.0b10 beta So, working fine in 16.2 and 16r4 Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain via 4D_Tech Sent: Wednesday, September 13, 2017 9:56 AM To: 4D iNug Technical

RE: v16x centipedes, trilobites and various other arthropods

Kirk, Thanks. Yes. I'm only running in 32bit (for now)  In v16.2 and 16r4, ALP clicks and events work as advertised (32bit) Just not in 16.1 Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk

Re: v16x centipedes, trilobites and various other arthropods

Only for 64-bit clients. 9.x works fine in 32-bit. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 12:54 PM, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > To my knowledge you need ALP v 10 when using 4D v16.

Re: v16x centipedes, trilobites and various other arthropods

Which version of ALP? We migrated to 16.2 with ALP 9.4 and it works fine (Mac, 32-bit clients), other than if ALP has the focus, the next click outside the ALP is lost. It's a bug in 4D 16.2 (fixed in R4 I guess) -- 4D isn't sending ALP a deactivate event. -- Jeffrey Kain

Re: Server Process "Frozen"-ish

I have server side processes that run in the background. Because i like to start as little as necessary at startup my code ‘automatically’ starts the process. So in my code(where it writes the jobs into a table for the server to process). After the client side(or server side) has written a

Re: v16x centipedes, trilobites and various other arthropods

Randy, I believe ALP for v16 is will only run 32 bit. On Wed, Sep 13, 2017 at 9:07 AM, Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I'm just now trying to get our product working with v16. > > V16.1 didn't work at all. Foobared ALP > Didn't recognize clicks in alp area except

RE: SFTP - Native to 4D?

We ended up using WinSCP as our SFTP tool. It was easy to create a profile, write a BAT file, and send the information. Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Janet Jonas via 4D_Tech Sent: Wednesday, September 13, 2017 10:28 AM To:

Re: v16x centipedes, trilobites and various other arthropods

Am 13.09.2017 um 18:07 schrieb Randy Engle via 4D_Tech <4d_tech@lists.4d.com>: > > Takes 2 Ctrl-V's to paste in. Not a show stopper, very annoying Somehow reassuring to know they are consistent across platforms, this is driving me nuts on Mac as well!

v16x centipedes, trilobites and various other arthropods

I'm just now trying to get our product working with v16. V16.1 didn't work at all. Foobared ALP Didn't recognize clicks in alp area except "outside" of all columns (i.e. on empty area) So now trying to work with 16.2 and 16r4 Fun so far: Item #1 I've got a loop running that opens an input

RE: read from a MS SQL server with 4D

Ferdinando, W3 Schools is a good source of examples: https://www.w3schools.com/sql/ Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of stardata.info via 4D_Tech Sent: Wednesday, September 13, 2017 5:28

SFTP - Native to 4D?

Does 4D have any native capability to do SFTP file transfers and/or generate a SSH-2 RSA public and private key pair? Any pointers would be welcome. JJ ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html

Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

Hi Bob, i will tell a little story that aligns perfectly with what you told: I have a huge database system for managing car spare parts. each part can be of a specific type, thus having specific descriptive criteria each part can be linked to any number of vehicles, sometimes with a specific

Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

Along the lines of, "what is an appropriate use of an object field", I've been considering this: We are a manufacturing company with lots of tools and lots of products. Each tool has various attributes, but each tool type has a different set of characteristics. Silly example that I hope

RE: read from a MS SQL server with 4D

Fernando writes: >I need to read from a MS SQL server with 4D. >Someone can give a link with examples. SQL LOGIN is a good command to start with. Tom Benedict Optum Inc This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the

Re: Can system tables be UPDATEd in a compiled database?

Thanks Miyako! -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 9:46 AM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > SQL system tables are virtual and read-only, > > but you can enable or disable journaling though other means: > >

Re: Can system tables be UPDATEd in a compiled database?

SQL system tables are virtual and read-only, but you can enable or disable journaling though other means: http://doc.4d.com/4Dv15/4D/15/ALTER-TABLE.300-2288140.en.html > 2017/09/13 22:17、Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> のメール： > Can system tables be UPDATEd in a compiled database?

Can system tables be UPDATEd in a compiled database?

Can system tables be UPDATEd in a compiled database? I'd like to change the value for 'logged' on a table that's in production, but thought I'd ask first if there's an issue with this. ** 4D Internet Users Group (4D iNUG) FAQ:

read from a MS SQL server with 4D

I all, I need to read from a MS SQL server with 4D. Someone can give a link with examples. Thanks /Ferdinando/ ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

RE: QUERY BY ATTRIBUTE is slow af

Since the feature of object fields is very near the concept of NoSQL databases like MongoDB and so on (at least it is partly stolen from their) ... I think the following article by Sarah Mei summarizes the discussion in the this thread in a way:

Re: QUERY BY ATTRIBUTE is slow af

On Tue, Sep 12, 2017 at 11:07 PM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Yeah, so many caveats to object fields. Bite the bullet, use a related > table... > > Well, I wrote that i am playing with it, Testing how it can be used, what commands are available and where are

Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

> Here´s my real-world use: > I wrote an iPhone app that collects data (scans barcodes). > That data is in JSON format and transferred via HTTP to a 4D Server. > The server stores that data in an object field (which is never queried. It > just holds the collected data). That's a great example of

Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

David Adams: > I've been asking about real-world use of object fields for quite some time Here´s my real-world use: I wrote an iPhone app that collects data (scans barcodes). That data is in JSON format and transferred via HTTP to a 4D Server. The server stores that data in an object field