Re: "Optimal" 4D Server hardware

2020-09-15 Thread Tom Benedict via 4D_Tech
f cloud backups, as well, via whatever service. > > > On Sat, Sep 12, 2020 at 11:46 PM Tom Benedict via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> I understand that medical data wouldn’t be stored in the public cloud, but >> what about private cloud? Private clo

Re: "Optimal" 4D Server hardware

2020-09-12 Thread Tom Benedict via 4D_Tech
I understand that medical data wouldn’t be stored in the public cloud, but what about private cloud? Private cloud has been used to store medical data for some years now. But not in Canada yet? Seems like there must be a way for a cloud provider to have geographic control of where the data

Re: "Optimal" 4D Server hardware

2020-09-12 Thread Tom Benedict via 4D_Tech
Indeed, security in the cloud is important. I’ve never used the data encryption features of 4D, but I suspect that could address the cloud security issues. At the company I’m working for now, everything other than 4D is in the cloud. They have absolutely no local data, no local servers. None at

Re: "Optimal" 4D Server hardware

2020-09-12 Thread Tom Benedict via 4D_Tech
Chip, Your redundancy here is impressive but I don’t see anything about cloud backup. Weekly off site backup is nice, but it could be up to a week old when you have fire in your data center. A cloud backup (continuous or other interval) would address that risk. Another redundancy design which

Re: "Optimal" 4D Server hardware

2020-09-11 Thread Tom Benedict via 4D_Tech
use for things like backups. I'm curious how you all decided to use > that much of a RAID on a Mac Mini? > > On Fri, Sep 11, 2020 at 2:22 PM Tom Benedict via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Hi David, >> >> I think the answer really depends o

Re: "Optimal" 4D Server hardware

2020-09-11 Thread Tom Benedict via 4D_Tech
Hi David, I think the answer really depends on number of things: - How much growth you expect, in terms of concurrent users/processes and data file size, over the next 3-5 years. - How is your application expected to change over then next 3 - 5 years. - What kind of IT support you have. -

Re: 4D Write Pro - Print Object

2020-07-14 Thread Tom Benedict via 4D_Tech
>Can a 4D Write Pro area be used with the Print Object command? I have not tried it. However, page 14 of the 4D_Write_Pro v16 documentation https://download.4d.com/Documents/Products_Documentation/LastVersions/Line_16/VIntl/PDF_Format/4D_Write_Pro_v16.pdf

Re: 4D Write to 4D Write pro Commands

2020-06-16 Thread Tom Benedict via 4D_Tech
Nisha writes: > I have tried Invoke action but could not get it to work in 4D Write Pro. I think you’re on the right track with INVOKE ACTION. INVOKE ACTION is a tricky concept, but once mastered it should serve you well. >I would recommend moving over to the forums, this list is in its last

Re: One to One mapping of 4D Write to 4D Write pro

2020-06-09 Thread Tom Benedict via 4D_Tech
Hi Nisha, I wish there was such a thing, but unfortunately the changes from 4D Write Classic to 4D Write Pro are fundamental and cannot be easily mapped. No longer are there discrete commands which only apply to 4D Write. Instead you will use commands from a range of 4D themes. Also, building

Re: How do I redirect http to https on initial site access?

2020-06-01 Thread Tom Benedict via 4D_Tech
Hi Rebecca, The 17.4 docs at https://doc.4d.com/4Dv17/4D/17.4/Using-TLS-Protocol-HTTPS.300-4882192.en.html state: To automatically redirect HTTP requests to HTTPS, you can activate HTTP Strict Transport Security (HSTS) using the WEB SET OPTION

Re: Re: iNUG Messages ― Is it time for it to be more than just 'plain text' ???

2020-05-03 Thread Tom Benedict via 4D_Tech
On May 2, 2020, at 12:43, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: >On May 2, 2020, at 2:00 PM, Tom Benedict wrote: > > >I say we join the 20th century and move everything to the new forums. > >Shutdown this list on 1 Jun 2020 and >redirect any posts to the new forums. >Actually

Re: iNUG Messages ― Is it time for it to be more than just 'plain text' ???

2020-05-02 Thread Tom Benedict via 4D_Tech
I say we join the 20th century and move everything to the new forums. Shutdown this list on 1 Jun 2020 and redirect any posts to the new forums. Tom Benedict > On May 2, 2020, at 08:18, Vincent de Lachaux via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hello Chip, > You can activate, for the

Re: 4D v18 — Need methodology to

2020-04-24 Thread Tom Benedict via 4D_Tech
Indeed. The "Execute on server” method attribute is very different from the “Execute on server” command. The former says “Run this code on the server and return a value” while the latter starts a stored procedure. Tom Benedict > On Apr 24, 2020, at 15:52, lists via 4D_Tech

Re: Opinion

2020-04-24 Thread Tom Benedict via 4D_Tech
Hi Ken, Does this app use 4D Write? If it does, and if you ever think this app will move beyond v17, you gotta think about 64 bit, if you haven’t already. Also, Chuck mentioned getting pictures converted, but there’s more to 64bit compatibility. Would be good to run a 64 bit compatibility

Re: Longitude Index: B-Tree or Cluster

2020-04-10 Thread Tom Benedict via 4D_Tech
The Google tells me that you are located in Coffs Harbour, New South Wales, Australia > Exercise: > Name the town where I’m located when my position is: > > - 30.30225° 153.1086° > ** 4D Internet Users Group (4D iNUG)

Re: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

2020-04-10 Thread Tom Benedict via 4D_Tech
There’s a good article on the 4D Blog describing pros and cons of binary and Project Mode: https://blog.4d.com/binary-database-vs-project-database/ At the bottom of the post in the “Con” section it mentions: Development with

Re: Configure 4D server as Windows Service on Windows Server 2016

2020-04-10 Thread Tom Benedict via 4D_Tech
Hi Tim, The OPEN ADMINISTRATION WINDOW command can be called by any client to view the Server UI. I believe you can even launch client on the server machine where the service is running. (You do have have Designer or Administrator access though.) HTH, Tom Benedict > On Apr 10, 2020, at

Re: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

2020-04-10 Thread Tom Benedict via 4D_Tech
Whoops. I missed the part about it running in interpreted mode. So please disregard my comments about .4DZ. Tom Benedict > On Apr 10, 2020, at 08:02, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Apr 10, 2020, at 07:28, 4dinug via 4D_Tech <4d_tec

Re: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

2020-04-10 Thread Tom Benedict via 4D_Tech
On Apr 10, 2020, at 07:28, 4dinug via 4D_Tech <4d_tech@lists.4d.com> wrote: > >So, my conclusion is that converting the database to a v18 project database is >the performance killer. Which is mildly annoying, because the project database >>format was a most significant reason why I wanted to

Re: Longitude Index: B-Tree or Cluster

2020-04-10 Thread Tom Benedict via 4D_Tech
John, Make sure you include testing a single query, if you haven’t already, then see what 4D’s query analyzer does with it in the query plan. Your current use of two queries may very well be optimal for your data set, since most countries don’t span much of the world in terms of longitude.

Re: Backup Settings Not Saving

2020-04-09 Thread Tom Benedict via 4D_Tech
Hi Cannon, I can confirm the same thing in 4D Server 17.3 Build 17.244600. I find that I can change it from “Retry after x..” to “Retry at the next scheduled date and time” and it will save, though. The > On Apr 9, 2020, at 14:33, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: How to Verify Page Setup for a Form?

2020-04-09 Thread Tom Benedict via 4D_Tech
I think I have discovered the answer to my question. I’ve found that the “Print Settings” property, in the Property List for the form, will display the Page Setup/Print Setup dialog with the ‘custom’ settings selected. Tom > On Apr 9, 2020, at 07:40, Tom Benedict via 4D_Tech <4d_tech

How to Verify Page Setup for a Form?

2020-04-09 Thread Tom Benedict via 4D_Tech
Is there any way to ‘know’ by observation the PAGE SETUP details for a given form? I ask because I’m trying to verify that a given form was not inadvertently changed by opening and saving it in the dev environment with a different default printer. For example, if I open a form, select “Page

Re: Multiple instances of 4D Client

2020-04-02 Thread Tom Benedict via 4D_Tech
Is that needed when connecting to two clients on one machine to two different 4D Servers or only when connecting two clients on one machine to the same 4D Server? Tom Benedict > On Apr 2, 2020, at 12:36, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Create a folder named

Re: 4D v13 web service error: -9926

2020-04-02 Thread Tom Benedict via 4D_Tech
If the XML is not being validated against a schema (XSD), and if you aren’t in control of the source, the XML may be, as Lutz suggested, missing elements or had an element renamed or be otherwise malformed. Tom Benedict > On Apr 2, 2020, at 11:45, Robert ListMail via 4D_Tech

Re: Where Are All The Steppers And Spinners?

2020-04-02 Thread Tom Benedict via 4D_Tech
I guess that makes sense, in that Project Mode handles libraries differently than Binary Mode. Tom Benedict > On Apr 2, 2020, at 08:12, kculotta via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Just in case you did not see it, a Stepper and a Spinner are available in the > Object Library of the

Re: Where Are All The Steppers And Spinners?

2020-04-01 Thread Tom Benedict via 4D_Tech
developer.4d.com. Thanks for the clarification, Tom Benedict > On Apr 1, 2020, at 17:45, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > the new documentation site "developer.4d.com" is entirely dedicated to > project mode. > >> 2

Re: Where Are All The Steppers And Spinners?

2020-04-01 Thread Tom Benedict via 4D_Tech
>you need to be in project mode for that. Is that documented? I’m looking at https://developer.4d.com/docs/en/FormObjects/stepper.html and I don’t see any mention of Project Mode dependency. What other new features require Project

Re: SOAP Secure Both Ways?

2020-04-01 Thread Tom Benedict via 4D_Tech
Thanks for the response Neil. Yes, data goes both directions, so 443 is used in both places. But only the external system has the SSL Certificate. Tom > On Apr 1, 2020, at 10:49, Dennis, Neil wrote: > >> Does the customer’s internally hosted 4D app also need to be configured with >> a SSL

SOAP Secure Both Ways?

2020-04-01 Thread Tom Benedict via 4D_Tech
We have a 4D app used by many customers. The app has the option to exchange data from a customer’s internally hosted 4D app with an externally hosted 4D app. Data is exchanged in both directions. The externally hosted 4D app is configured to use SSL over port 443 (t has the required SSL

Re: Text Editor Which Knows 4D Tags?

2020-03-27 Thread Tom Benedict via 4D_Tech
20, at 04:22, Milan Adamov via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> On Mar 27, 2020, at 3:34 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Thanks Neil. I”ll check out Atom. I have a MacOS, but do all my 4D work in >&g

Re: Text Editor Which Knows 4D Tags?

2020-03-26 Thread Tom Benedict via 4D_Tech
with Atom, it does allow adding 4D tags. Miyako sent out the > tags add on awhile back, maybe at a summit? Anyway you can add custom tags. > > > >> On Mar 26, 2020, at 3:22 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> I’m v

Re: Text Editor Which Knows 4D Tags?

2020-03-26 Thread Tom Benedict via 4D_Tech
of the method editor (eg. linking to another method) > but it will show the code blocks like you describe. Plus it's just a more > full featured text editor. > > On Thu, Mar 26, 2020 at 2:22 PM Tom Benedict via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> I’

Text Editor Which Knows 4D Tags?

2020-03-26 Thread Tom Benedict via 4D_Tech
I’m very new to 4D Web programming and I’m trying to get comfortable with the tools. One thing that I’m challenged by is debugging HTML. For example, I’m getting an error on a web page that says “4DENDIF expected”, so I’ve traced the html in Chrome using the Developer Tools and I have

Re: Gmail, LSA, and OAuth

2020-03-19 Thread Tom Benedict via 4D_Tech
I support a 4D app which currently uses Twilio sendgrid.net send all outbound email. While our email volume is modest Iaven’t run into any issues with it. Seems stable. Tom Benedict > On Mar 19, 2020, at 13:50, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > what relay would

Re: Remote working with 4D networks - what are people using ?

2020-03-19 Thread Tom Benedict via 4D_Tech
In my experience, what you describe is the ideal situation, where you have an office workstation to which you connect via some kind of screen sharing app on your remote machine. You get the full horsepower of your office workstation and all the remote machine has to do is screenshare. Terminal

4D Summit Virtual?

2020-03-11 Thread Tom Benedict via 4D_Tech
Well, l'll gotta think the chances of 4D Summit happening in Chicago are approaching nil now. Maybe there can be a virtual summit? https://www.nytimes.com/2020/03/11/world/coronavirus-news.html Tom Benedict ** 4D Internet Users

Re: DOM EXPORT TO FILE adds CRLF

2020-03-09 Thread Tom Benedict via 4D_Tech
have realized that without your help. Thanks again, Tom > On Mar 9, 2020, at 13:04, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Try this: > XML SET OPTIONS($rootRef_t;XML indentation;XML no indentation) > > Jim Hays > > On Mon, Mar 9, 2020 at 2:

DOM EXPORT TO FILE adds CRLF

2020-03-09 Thread Tom Benedict via 4D_Tech
I am updating values in an XML file using DOM commands. I finish by calling DOM EXPORT TO FILE. What I’ve found is that the end-of-line chars in the XML file are doubled every time I export, so eventually there is lots of white space between lines in the document. According to the documentation

Re: iOS 13.x User Agent Shows iPad as Macintosh

2020-03-08 Thread Tom Benedict via 4D_Tech
Thanks Ron. This is food for thought. Looks like I have some work to do. These suggestions will come in handy. Tom > On Mar 7, 2020, at 21:58, Ronald Rosell wrote: > > Hi Tom, > > If your code is assessing the userAgent in the On Web Connection database > method then you’d have an issue,

Re: iOS 13.x User Agent Shows iPad as Macintosh

2020-03-07 Thread Tom Benedict via 4D_Tech
Hmmm.. I’m not very web savvy so I’m not quite understanding how this works. In our app, when a user enters a URL in their browser, code in the On Web Connection database method in our app parses the HTTP header and gets the UserAgent value, then it serves either a desktop or a mobile html

Re: iOS 13.x User Agent Shows iPad as Macintosh

2020-03-07 Thread Tom Benedict via 4D_Tech
gt;document.createEvent("TouchEvent"); >console.log("tryiOS") >return true; >} catch (e) {} >} >return false; > } > > var iOS = testios(); > __ > > Ron Rosell > President > StreamLMS > > >> O

iOS 13.x User Agent Shows iPad as Macintosh

2020-03-06 Thread Tom Benedict via 4D_Tech
In iOS v13.x there is a new feature, called “Request Desktop Website”, which allows iPads and iPhones to pretend that they are desktop devices. It does this by returning a value in the UserAgent included in the HTTP Header which indicates “Macintosh" instead of “iPad" or “iPhone”. This new

Re: ALP Documentation Link?

2020-03-03 Thread Tom Benedict via 4D_Tech
here on > the NUG or you can contact tech support via the eNode forum. Advantages to > using the eNode forum - the folks at eNode are very helpful and you might > find that the issue that’s got you stumped has already been discussed. > > -- > Douglas von Roeder > 949-910

ALP Documentation Link?

2020-03-03 Thread Tom Benedict via 4D_Tech
Not sure why I can’t find it right now, but I’m looking for a URL that will take me to AreaListPro documentation. I’m having trouble navigating the eNode website and keep running into dead ends. If anyone can send me a link I’d appreciate it. Right now I don’t think it matters what version.

Re: atom/st indent/lex file

2020-02-28 Thread Tom Benedict via 4D_Tech
Along the same lines, I’d like something like this for HTML which can recognize 4D Tags and color them differently than HTML comments in NotePad++. Tom Benedict > On Feb 28, 2020, at 08:30, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm working on something for TextMate and/or

Re: Necessary To End Task After Quitting Server

2020-02-26 Thread Tom Benedict via 4D_Tech
Chuck (and others), Are you referring to the “Tasks Pending” Alert that appears at server shutdown or is it something else? If it’s the "Tasks Pending” Alert, here’s a post from Doug Cottrill from a 2014 which describes what to do about it.

Re: 4D v18.0 LTS - Form Wizard Missing

2020-02-26 Thread Tom Benedict via 4D_Tech
If you’re using v18 in Project Mode, there is no Form Wizard. Details here: http://151.80.33.215/4Dv18/4D/18/Creating-a-form-using-the-Form-Wizard.300-4575673.en.html Tom Benedict > On Feb 23,

Re: Related Table Field in Quick Report Causes Report to Fail to Generate

2020-02-25 Thread Tom Benedict via 4D_Tech
m. > What happens with only one record on the report? Also what 4D > version, and O/S combination are you running in? > > Regards > > Chuck > > On Tue, Feb 25, 2020 at 1:20 PM Tom Benedict via 4D_Tech > <4d_tech@lists.4d.com> wrote: >> >> It’s been ma

Related Table Field in Quick Report Causes Report to Fail to Generate

2020-02-25 Thread Tom Benedict via 4D_Tech
It’s been many years since I’ve done much with Quick Reports, but now a customer has reported that a specific Quick Report template that they use is no longer working. The “Print Preview” and “Print” icons in the QR Toolbar are enabled, but clicking on them does “nothing” (no report is

Re: Update Project Mode Incompatible Object Types via Code?

2020-02-25 Thread Tom Benedict via 4D_Tech
rted .4DForm files which are > JSON? > > On Feb 25, 2020, at 8:00, Tom Benedict via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> wrote: > I was hoping for a SET OBJECT TYPE command, but that was wishful thinking. > **

Re: Best "back to school" pathway for upgraders

2020-02-21 Thread Tom Benedict via 4D_Tech
I agree with Randy, unless you converted all your PICTs years ago when 4D first started to warn us about them. If you haven’t converted them you’ll need to do that in 32bit mode. Tom > On Feb 21, 2020, at 08:27, Randy Kaempen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Peter, > >> On

Re: What constitutes high-perf. hardware for 4D server these days ?

2020-02-21 Thread Tom Benedict via 4D_Tech
Glad to be of assistance. I will add that, once properly configured, VM performance was very good. It was at least as good as the former dedicated hardware we were using. We aways had very high end enterprise grade hardware. All very expensive stuff ($100K for a SAN etc). VM is not a great way

Re: What constitutes high-perf. hardware for 4D server these days ?

2020-02-19 Thread Tom Benedict via 4D_Tech
>Everything at this place is on VM - nothing I can do about it as it’s >contractor managed. (In fact they seem to be able to change >the “hardware" without me even taking the server down - that’s something I >never thought I’d see and am too old now to bother >speculating how they do it :-) !).

Re: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE

2020-02-06 Thread Tom Benedict via 4D_Tech
You should be able to automate conversion of most PICTs using JPR’s PICT_Convert. However, if you have static PICTs pasted directly onto forms, those will need to be individually visited. A v17 MSC log will give you a listing of those, I think. Tom Benedict > On Feb 6, 2020, at 09:40, Ken

Re: v18 and 4D Write Classic - does it work ?

2020-02-05 Thread Tom Benedict via 4D_Tech
Ditto what Tim said. His description of the process is comprehensive and realistic. I had about 120 methods and forms to re-write. Took 3 months, but hasn’t been deployed due to a constraint on testing resources. Some level of support for Automated Testing in 4D would be nice in a case like

Re: 4D Application as a 3-tier System

2020-01-28 Thread Tom Benedict via 4D_Tech
Steve Orth writes: > 1. What options are available? -> Many routers and server OS have > round-robin load balancing built in. Bigger hardware devices, like F5 BigIP > are available. > 2. How it works with 4D? -> 4D doesn’t know about it, so there is no > impact. > 3. Has anyone

Re: 4D Application as a 3-tier System

2020-01-28 Thread Tom Benedict via 4D_Tech
>To complete the fault tolerance system, we have another Amazon instance that >is running another copy of 4D Server as a mirror. Production 4D Server sends >log files to Mirror 4D Server every 10 minutes. If Production 4D Server goes >down, we can switch to Mirror 4D Server and have the 4D

Re: 4D Application as a 3-tier System

2020-01-28 Thread Tom Benedict via 4D_Tech
When I was supporting an enterprise app which had 4D as its core, we had four 4D Clients running as Web Services Clients and used ‘round robin’ DNS load balancing. We also tried BigIP from F5, which is much smarter about load balancing but I don’t recall why we went back to round robin. It’s

Re: For those using Javascript - here is a grid component...

2020-01-16 Thread Tom Benedict via 4D_Tech
AG-Grid was included in the Web Development with 4D Training I attended in San Jose last fall. Tom Benedict > On Jan 15, 2020, at 19:47, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > AG-Grid (https://www.ag-grid.com/) > Javascript component which is supposed to play well with

Re: gitignore for projects

2020-01-06 Thread Tom Benedict via 4D_Tech
On Jan 6, 2020, at 07:54, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > >> @John - method comments are gone - does that mean that they aren't even >> exported when the project is created? > > Completely gone and not exported in project mode as far as I can tell. > Just to clarify,

Re: gitignore for projects

2020-01-06 Thread Tom Benedict via 4D_Tech
On Jan 5, 2020, at 18:45, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Hi Tom, > >> Also, my attempt at setting up a git repository ran into similar performance >> issues, only hours instead of minutes. I lost interest at that point. > > Is this with git directly from the command

Re: gitignore for projects

2020-01-04 Thread Tom Benedict via 4D_Tech
John DeSoi, Ph.D. Thanks for offering your workflow, John. This is very interesting. > "Master" branch is version 17. When I want to commit a new version I have a > 4D method that copies the structure, opens it in 4D 18, and then exports the > structure in project mode format. This can be

Re: gitignore for projects

2020-01-03 Thread Tom Benedict via 4D_Tech
This is a great discussion of best practices and guidelines for 4D Projects and I hope others chime in. It’s a new world for many of us. I would like to start using Project Mode, but our apps have hundreds (maybe thousands) of highlight buttons, which are incompatible. If anyone has built an

Re: gitignore for projects

2020-01-03 Thread Tom Benedict via 4D_Tech
In case you haven’t already seen it, there’s a great post on the 4D Blog on how to get started with 4D and GitHub. It’s a step-by-step listing covering the basics of getting a repository set up and working. Gitignore isn’t covered, but may be in an upcoming post. Here’s the link:

Re: FLUSH BUFFER

2019-12-13 Thread Tom Benedict via 4D_Tech
As Chuck pointed out, you may need to increase the size of your cache. The Info Report will make this evident. Tom > On Dec 13, 2019, at 09:13, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Contact 4D Tech Support. > > Tom > >> On Dec 13, 201

Re: FLUSH BUFFER

2019-12-13 Thread Tom Benedict via 4D_Tech
Contact 4D Tech Support. Tom > On Dec 13, 2019, at 09:08, stardata.info wrote: > > Hi Tom, > > > How I can find this component? > > Thanks > > Ferdinando > > Il 13/12/19 18:06, Tom Benedict ha scritto: >> That is the default and should work pretty well. You may be suffering from a >>

Re: FLUSH BUFFER

2019-12-13 Thread Tom Benedict via 4D_Tech
That is the default and should work pretty well. You may be suffering from a related condition informally known as “cache thrashing” which was not uncommon in 4D v13 (as well as some later versions, but I haven’t kept up on what progress has been made). If you aren’t already using it, you can

Re: FLUSH BUFFER

2019-12-13 Thread Tom Benedict via 4D_Tech
What is the “Flush Cache every..” value in Database Settings>Memory? If there are ‘lots’ of records being flushed, sometimes that can take a while. Setting the value smaller causes it to happen more frequently, but fewer records, which can be more efficient. HTH, Tom Benedict > On Dec 13,

Re: maximum number of record

2019-12-13 Thread Tom Benedict via 4D_Tech
I’ve had systems where tables had 10 million records in ‘wide’ (200+ fields) tables. And over 50,000,000 in ‘narrow’ (10 fields) tables. That was under v13.x. I think you should be fine. Of course you must only do indexed queries. HTH, Tom Benedict > On Dec 13, 2019, at 07:13, stardata.info

Re: Automatic Excel to Text-tab delimited?

2019-12-12 Thread Tom Benedict via 4D_Tech
Hi Kirk, Converting Excel to Text is a problem that others have tackled, so I would rely on their work rather than trying to build it yourself. Plugger’s XL Plugin is probably something you should look at, if you haven’t already. There are components and libraries that do similar things with

Re: Structure and Verification issue

2019-12-10 Thread Tom Benedict via 4D_Tech
Viewing the logs in a web browser is painful, especially on large structures. I open the log in a text editor and look for strings like “warning” or “Error”. Notepad++ has a good search feature which will list all the occurrences in context. HTH, Tom > On Dec 10, 2019, at 11:14, Eric Naujock

Re: Structure and Verification issue

2019-12-10 Thread Tom Benedict via 4D_Tech
Some years ago I adopted the habit of always deleting the .4DIndy file (the structure index) when deploying .4DC files. I adopted this as a best practice after a number of ‘weird behavior’ episodes during deployment. It may be superstition, but the overhead for 4D to recreate the .4DIndy is

Re: O/S Replication and Backup interaction with 4D (2004, v15)

2019-12-04 Thread Tom Benedict via 4D_Tech
I can confirm from experience that VSC can and will crash and corrupt (or maybe vice versa) a 4D data file. Years ago we had mysterious crashes when the IT staff added VSS backups to our 4D data file without telling us. It took a long to realize what was happening. I’m sure you already asked

Re: 4D Web Server Security

2019-11-26 Thread Tom Benedict via 4D_Tech
I get comfort from all the efforts that 4D has made to be very secure, but when a customer hands you a 644 cyber security audit report and says “Address these issues”, I need to know where to begin. It’s one thing for 4D to be able to say their product can pass all security audits, but there

Re: Create SQL DB ERD from 4D Export Structure XML File?

2019-11-25 Thread Tom Benedict via 4D_Tech
tools? Tom > On Nov 25, 2019, at 08:48, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thank you for correcting me Miyako! I should have dug deeper. > > I’ll check it out. > > Tom Benedict > >> On Nov 25, 2019, at 08:02, Keisuke M

Re: Create SQL DB ERD from 4D Export Structure XML File?

2019-11-25 Thread Tom Benedict via 4D_Tech
xsltproc, > so the remarks “It is now deprecated” is incorrect in this instance. > > https://github.com/miyako/4d-utility-structure-to-svg-converter-v2 > > 2019/11/25 22:00、Tom Benedict via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: >

Re: Create SQL DB ERD from 4D Export Structure XML File?

2019-11-25 Thread Tom Benedict via 4D_Tech
should have used that time to write code instead. I guess that printing an ERD is not common among 4D developers. Tom Benedict > On Nov 25, 2019, at 00:42, Arnaud init5 imap via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > >> Le 24 nov. 2019 à 18:54, Tom Be

Create SQL DB ERD from 4D Export Structure XML File?

2019-11-24 Thread Tom Benedict via 4D_Tech
I’d like to use an external data modeling tool to display my 4D structure file. Ultimately I want to print the 4D Structure. I’ve tried all the 4D components and scripts and they all seem to have shortcomings. Right now I’m in the middle of a tedious screenshot, export, panoramic merge in

Re: CURL SFTP issues with SSH

2019-11-21 Thread Tom Benedict via 4D_Tech
I second the recommendation. You don’t even need to know much about Postman to use it. It’s got a zillion features, but, at least in my experience, it always seems to know what I want to do after minimal fiddling. Tom Benedict > On Nov 21, 2019, at 13:13, Kirk Brooks via 4D_Tech

Re: Determining if a 4D Write Object has been changed since load.

2019-11-21 Thread Tom Benedict via 4D_Tech
Yes, there are other ways to determine the modified state of a Write Pro object, but they all need to be managed by the developer (store the initial state in a global for later comparison) so it’s not a boolean flag manger by 4DWrite. Jeremy French points out on the 4D Forum that the wk date

Re: Authorize.net integration?

2019-11-20 Thread Tom Benedict via 4D_Tech
> On Nov 20, 2019, at 13:02, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Be sure to note their XML APIs depend on the elements being in a specific > order. I have never seen that before and it took a while to figure out why > things were not working. > That’s too bad,

Re: Authorize.net integration?

2019-11-20 Thread Tom Benedict via 4D_Tech
Hi Joe, I believe that John DeSoi has extensive experience integrating 4D apps with Authorize.net. I’ve copied him on this message. Tom Benedict > On Nov 20, 2019, at 11:08, Joe Dombroski via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Has anyone had any luck integrating Authorize.net or

Re: Log integration failed

2019-11-19 Thread Tom Benedict via 4D_Tech
Hi Mitchell, >My question pertains to this case: Is it worth trying to open the timestamped >damaged database and repair it? Theoretically I would only lose data since the >last cache flush. It’s certainly worth a try. Since you’re in a period of instability which may go on for some time, it

Re: Determining if a 4D Write Object has been changed since load.

2019-11-14 Thread Tom Benedict via 4D_Tech
Thanks for the comment Bernd. I should try again. Tom > On Nov 13, 2019, at 23:27, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Eric Naujock: > >> Initially I tried to add an attribute to the WP object, but wasn’t >> successful. > > What was the problem? It´s as easy as >

Re: Determining if a 4D Write Object has been changed since load.

2019-11-12 Thread Tom Benedict via 4D_Tech
That’s correct. It’s not part of the Write Pro object. Initially I tried to add an attribute to the WP object, but wasn’t successful. I’m a ‘baby programmer’ with objects so I don’t know whether its possible to add attributes to a Write Pro object. My limited efforts failed. Tom > On Nov 12,

Re: Determining if a 4D Write Object has been changed since load.

2019-11-12 Thread Tom Benedict via 4D_Tech
_Information) > C_BOOLEAN($0) > > //$0:=(WP_Information.DocumentInfo.Modification=True) //<— this is redundant > $0:=WP_Information.DocumentInfo.Modification // <— simpler Tom Benedict > On Nov 12, 2019, at 14:20, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Eric, >

Stripe Checkout Experience

2019-11-10 Thread Tom Benedict via 4D_Tech
Anyone have any experience integrating a 4D web app with Stripe Checkout? I have sorted out the HTTP code issues for the redirect to their payment page, but am challenged around handling incoming Stripe events to support fulfillment in 4D. Tom Benedict

Re: 4D Write Pro v17R6 (How to get 2-different layouts on the same page?)

2019-11-02 Thread Tom Benedict via 4D_Tech
Maybe I’m not understanding the question, but this blog post seems to explain how…. https://blog.4d.com/manage-sections-with-code-in-a-4d-write-pro-document/ Tom Benedict > On Nov 2, 2019, at 03:22, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote: > > 4D Tech mailing list wrote >> How would I

Re: Write Pro Hide/clear pictures when printing

2019-10-30 Thread Tom Benedict via 4D_Tech
This just a wild guess, I haven’t tried it, but if you put a “white” (opaque) picture into the logo, does the black rectangle go away? Tom Benedict > On Oct 30, 2019, at 06:32, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi, > > We want to print a Write Pro

Re: Migrating to 4D Write Pro

2019-10-29 Thread Tom Benedict via 4D_Tech
Hi Doug, I’m pretty sure that the .4W7 format for 4D Write arrived long before v15, so you should be OK. You can confirm by creating a Write document on disk and seeing what extension is assigned. You can also validate your conversions by having both a Write Classic and a Write Pro area on a

Re: MySQL connection from 4D

2019-10-28 Thread Tom Benedict via 4D_Tech
The fact that it doesn’t require that you set up an ODBC Source on each machine you want to use it on is easily worth the price. Just pass it a connection string and you’re on your way. Tom Benedict > On Oct 28, 2019, at 12:49, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote:

Re: MySQL connection from 4D

2019-10-28 Thread Tom Benedict via 4D_Tech
One other bit of info is that the mySQL database I’m connecting to is version 8.0.17. Sorry I don’t have any experience with version 3.x. Tom Benedict > On Oct 28, 2019, at 09:11, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The only thing I can add is to m

Re: MySQL connection from 4D

2019-10-28 Thread Tom Benedict via 4D_Tech
The only thing I can add is to make sure your ODBC Driver, ODBC Data Source Administrator and 4D all match with respect to 32bit or 64 bit. I am connecting to a mySQL DB using 4D Native (SQL LOGIN) via mySQL ODBC 8.0 Unicode Driver and 4D v17R4. All 64 bit. HTH, Tom Benedict > On Oct 28,

Re: Responding to an HTTP Request

2019-10-26 Thread Tom Benedict via 4D_Tech
Thanks Narinder and Julio. That did it! Evidently the 4D Web Server knows where to send the header without being explicitly told. Maybe it has a queue? I guess it doesn’t really matter as long as it works. So it appears that I can use HTTP Client commands for ‘outbound’ REST calls and use Web

Responding to an HTTP Request

2019-10-25 Thread Tom Benedict via 4D_Tech
I’m just starting to do some 4D web development and have a simple question. The 4D app I’m working on needs to respond to a REST call by acknowledging it and sending a status (200 would work). When the REST call comes into the 4D Web Server I handle it in On Web Connection. That part is working

Re: How to lookup a value within an object within an object

2019-10-25 Thread Tom Benedict via 4D_Tech
Thanks for the response Kirk. > On Oct 25, 2019, at 14:45, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > OB Get works on any object so you could call > > $value:=OB > Get(myObject.data.object.billing_details.address;"postal_code";Is text) > > and it will work because

How to lookup a value within an object within an object

2019-10-25 Thread Tom Benedict via 4D_Tech
I’m new to objects. I have an object which holds a range of keys and values. Some of the values are objects. I figured I could just use the OB Get command with dot notation to reference a key in a nested object, but that doesn’t seem to be supported. Here’s my example: C_OBJECT(myObject)

Re: 4D Websites (Are they down?)

2019-10-21 Thread Tom Benedict via 4D_Tech
Indeed! Thanks for working your magic Kirk! Tom Benedict > On Oct 20, 2019, at 21:15, roofto...@mac.com wrote: > > The 4D site is working for me as of 9:00 Pacific Time > >> On Oct 20, 2019, at 8:28 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> >> wrote:

Re: 4D Websites (Are they down?)

2019-10-20 Thread Tom Benedict via 4D_Tech
I haven’t had any luck connecting to 4D.com all weekend. Tom Benedict > On Oct 20, 2019, at 10:41, Jeremy French via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > Time: Sunday, October 20th, 2019 around :1:40 pm EST > > > Is anyone finding the 4D websites unresponsive today? > > Each of

  1   2   3   >