Re: 4D Web Server Security

I’m only interested in serving through On Web Connection, no static pages. So why do I need anything in front of 4D? Are there known vulnerabilities in 4D other than bad programming? Is there anyway to “break” into the data? Or “break” into files that don’t exist in the web folder? What does

4D Web Server Security

Anyone care to share their experience and insights as to the security of the 4D Web Server? There’s lots of talk these days about DOS and putting in a DMZ, but what is really necessary in 4D land? If I understand things correctly, the outside world only has access to static pages in the web

Re: v16 - Verify & Repair log files

Wouldn’t it be far better to have a few options? 1) Errors only 2) Errors and Warnings 3) Everything Having tens of thousands of lines in the log that report that something is OK is useless and a hindrance to developers in almost all situations. And it’s gotten much worse in v17.

Re: Thread_Safe SQL

OK, so the online documentation is wrong. https://docs.4d.com/4Dv17/4D/17.2/Preemptive-4D-processes.300-4386982.en.html Thanks. > Date: Tue, 6 Aug 2019 18:02:54 + > From: Timothy Penner mailto:tpen...@4d.com>> > Hi Richard, > > Beginning with 4D v17 R4, Begin SQL, End SQL, and the

Thread_Safe SQL

According to the v17.2 docs: > All SQL statements are thread-safe, except for REPLICATE > > or SYNCHRONIZE > . >

Distinct Values on Composite Index

Is there anyway to get the unique values of a composite index like we can do with Distinct Values for a regular index on a field? Richard Wright DataDomain rwri...@datadomainsoftware.com

Re: table/field token

I thought you were saying that these characters were not allowed as of v16 R4 even without enabling the new feature. I’m just hoping that 4D will never require us to enable the new feature or, if they do, that they give us plenty of advance notice. It’s not trivial to make changes like this to

Re: table/field token

> * Starting with 4D v16 R4, "." and "[]" characters are no longer allowed in > names of tokenized objects. I take that to mean they are no loner allowed in “new” names of tokenized objects. > Date: Wed, 5 Sep 2018 18:50:28 + > From: Timothy Penner > >> Surely something to do with dot

Re: [v16.3 64 IC on El Capitan] Receive file

Can you clarify "in fairness, it is legacy software, free to use and not part of the main product line.” There is a 64 bit version 4D Internet Commands which tells me it’s being updated and I see nothing to indicate that it is considered legacy.

Re: 4D Write to 4D Write Pro

That’s a great idea, Tim (and I remember you showing me that code). It might not be that much work for us to do for the subset of 4D Write commands that we use. Or maybe just create wrapper functions directly in the application that contain a switch telling whether to use 4D Write Pro or 4D

Re: 4D Write to 4D Write Pro

; > > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Richard > Wright via 4D_Tech > Sent: Wednesday, August 29, 2018 9:45 AM > To: 4d_tech@lists.4d.com > Cc: Richard Wright > Subject: 4D Write to 4D Write Pro > > Is t

Re: 4D Write Pro WP feature request - need your support

You’re kidding, right? 4D Write Pro can’t read and write Word documents? > Date: Wed, 29 Aug 2018 05:56:51 -0700 (MST) > From: ADeeg > > > FR from Alfonso: 4D Write Pro Import-Export Word > link: http://forums.4d.com/Post/DE/25361165/1/25361166 >

4D Write to 4D Write Pro

Is there a cross reference of language commands between 4D Write and 4D Write Pro or do we have to all figure it out for ourselves? I’m mystified as to why wrappers for the old commands could not have been created so as to make the move to 4D Write Pro relatively painless. E-node did this

Re: New record numbering system and CALL WORKER

It allows you to work with related records as if they were subrecords. For example, you open an Invoice and start a transaction so that changes to line items can be rolled back if the Invoice is cancelled (something that automatically happened with subrecords). But then you want to drill down

Re: Query by Formula bug Client/Server with Automatic Relations

query executed from a UI (i.e. running the query on a > table form)? > > what is the status of the "execute formula on server" compatibility setting? > > 2018/08/03 2:47、Richard Wright via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com><ma

Re: Query by Formula bug Client/Server with Automatic Relations

mes current, it automatically > changes the current record on the 1 table. > > isn't that how automatic relations are supposed to work? > > 2018/08/02 7:46、Richard Wright via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: &g

Query by Formula bug Client/Server with Automatic Relations

I just ran into a problem where running a Query By Formula bug in Client/Server that has apparently been around for a long time: Client/Server Two related tables and automatic many-to-one is turned on 1. Select a record in the One table 2. Run a standard query to get the related records in

Re: [Odd] Compiler directives

Just think what might have happened if it had been C_POINTER(ARYLSTBX_UPDATE_DISPLAY;${SQRT(-1)}) > Date: Fri, 13 Jul 2018 11:24:19 -0400 > From: Chip Scheide <4d_o...@pghrepository.org > > > > I came across this compiler directive: > >

Re: Macro question - using project methods in a macro

o that compiled in any event. What you could do is write > code that runs scripts external to the compiled structure using Process > Tags. > > On Fri, Jul 6, 2018 at 9:47 AM Richard Wright via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Yeah, but how am I supposed

Re: Macro question - using project methods in a macro

Yeah, but how am I supposed to implement AI in 4D without self-modifying code? ;-) > Date: Fri, 6 Jul 2018 01:08:17 + > From: Keisuke Miyako > > there is no need to use the clipboard. > > I don't which example you saw, but I have always used SET MACRO PARAMETER > since v11 (Macros v2).

Re: Scroll position of display-type subform

t; > > haven't tried, > but I wonder if CONVERT COORDINATES would be smart enough to take into > account the scrolled amount of a detail subform. > > http://doc.4d.com/4Dv16/4D/16.3/CONVERT-COORDINATES.301-3651760.en.html > >> 2018/06/12 7:37、Richard Wright via 4D

Scroll position of display-type subform

Does anyone know how to get the scroll position of a display-type subform? OBJECT GET SCROLL POSITION apparently works only for list-type subforms. I need to get the position of an object on a display-type subform in global coordinates and the subform may be scrolled.

Re: SQL Date Math

So it would seem that while there are numerous functions to extract parts of a timestamp into it’s component parts, there is no function to create a date from a piece of text, no date operators nor any date functions by which you can add or subtract days or other component parts of a time

SQL Date Math

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

Re: 4D Summit 2018 Comments

> Date: Mon, 09 Apr 2018 23:03:31 -0500 > From: Tim Nevels > > The 4D SQL engine is a layer above the 4D database engine. SQL statements > must be translated into a form that the 4D database engine can process. And > that can take many forms. Some would work but be super

Re: 4D Summit 2018 Comments

> Date: Mon, 9 Apr 2018 21:46:17 -0400 > From: Jim Crate > > On Apr 9, 2018, at 10:06 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: >> So you want an example of ORDA and changes to the 4D language? Here’s one >> form JPR’s advanced class. (Hope I am not doing

Re: 4D Summit 2018 Comments

I’ll be interested in learning how this differs from Views, not necessarily 4D’s rather simplistic implementation, but something like Oracle’s, along with their very powerful SQL implementation. Richard Wright DataDomain

Re: "Goodbye 4D Write" email

If 4D Write Pro doesn’t, and won’t, have all the features of 4D Write then 4D should give it a different name instead of pretending that it’s a replacement. I’ve been totally baffled by this seemingly endless piecemeal rollout of a “pro” product. I remember getting an email a couple years ago

RE: SQL error

May I kindly suggest reading a basic primer on SQL. > Date: Wed, 1 Nov 2017 17:15:01 + > From: Timothy Penner > > I think you have multiple issues with this SQL Statement. > > I don’t think you can select a COUNT(*) along with other fields in the same > SQL Statement; >

Re: San Fransisco Font

I don’t recall seeing any such recommendation or discussion in the manuals. I’ve been using the System Font in a couple of style sheets for years without issues, for generic dialogs and buttons. It doesn’t make sense that one can select it for a Style Sheet if 4D is recommending not to select

Re: What happened to 4D documentation in R releases - found some of them

It turns out you can still get the upgrade manuals for v14R and v15R here: ftp://ftp-public.4d.fr/Documents/Products_Documentation/ But no such luck for v16R. For these, just bug fixes. Please 4D, give us real reference manuals for

Re: What happened to 4D documentation in R releases?

Ad, The blogs are fine and are helpful but they’re no substitute for a proper reference of changes for each version. It’s really important for us to be able to clearly and easily see which changes are in each R version, not just major versions. And you can’t do this from the blog. Jeremy

Re: What happened to 4D documentation in R releases?

I couldn’t agree more. Each version needs it’s own document that lists it’s changes. I also agree about keeping an archive of documentation for each R release. There’s new stuff in each one, that’s the whole point, and an R release is no different than a major version release - once you get to

Re: What happened to 4D documentation in R releases?

Thanks, Jeremy, that’s a big help. > Date: Fri, 06 Oct 2017 12:20:56 -0400 > From: Jeremy French > > Hi Richard, > > There is a link titled “What’s New”. > > This link appears **only** when you view the Language Reference “Table of > Contents”.That’s the page that

Re: What happened to 4D documentation in R releases?

I’m looking for the documentation of new features and other upgrade info. All they have in the doc center for this is a link to their blog which is not the same thing at all. > Date: Fri, 6 Oct 2017 15:48:23 + > From: Michael McCall > > Content-Type:

What happened to 4D documentation in R releases?

I’m trying to get the upgrade documentation for v16 R2-R4. The only thing that I can find in the doc center is a link to their blog for new features in v16R4. It’s really annoying that I seemingly can’t download or even view online a single document for each version that lists what’s new. There

Re: [offish]Volume of mail

Perhaps it’s partially due to the fact that some post mysteriously never get through and also do not bounce back. I’m having that problem right now with another message I’ve tried posting twice and am waiting to hear back from the list boss. In between, I posted a “test” message which went

Test

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

RE: Love 4D's math interpretation...

So you’re saying there’s been a bug for at least 14 years in 4D math operations when running compiled and it’s never been fixed. How hard can it be? Saying to use parenthesis to ensure the order of operations is a workaround. Are we supposed to use parenthesis around every single math operation

Re: Encrypted Data at Rest

Not sure why you say for personal use only. FileVault supports 256 AES and benefits from hardware acceleration in the CPU. I’ve never done timing comparisons but there are no noticeable performance effects at all. Some people have tested, years ago, and found at most only 2-3% degradation. >