Distinct Values on Composite Index

2018-12-13 Thread Richard Wright via 4D_Tech
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

2018-09-06 Thread Richard Wright via 4D_Tech
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

2018-09-05 Thread Richard Wright via 4D_Tech
> * 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

2018-09-05 Thread Richard Wright via 4D_Tech
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

2018-08-29 Thread Richard Wright via 4D_Tech
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

2018-08-29 Thread Richard Wright via 4D_Tech
; > > > -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

2018-08-29 Thread Richard Wright via 4D_Tech
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

2018-08-29 Thread Richard Wright via 4D_Tech
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

2018-08-28 Thread Richard Wright via 4D_Tech
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

2018-08-03 Thread Richard Wright via 4D_Tech
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

2018-08-02 Thread Richard Wright via 4D_Tech
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

2018-08-01 Thread Richard Wright via 4D_Tech
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

2018-07-20 Thread Richard Wright via 4D_Tech
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

2018-07-06 Thread Richard Wright via 4D_Tech
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

2018-07-06 Thread Richard Wright via 4D_Tech
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

2018-06-12 Thread Richard Wright via 4D_Tech
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

2018-06-11 Thread Richard Wright via 4D_Tech
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

2018-05-07 Thread Richard Wright via 4D_Tech
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

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

Re: 4D Summit 2018 Comments

2018-04-10 Thread Richard Wright via 4D_Tech
> 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

2018-04-10 Thread Richard Wright via 4D_Tech
> 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

2018-04-09 Thread Richard Wright via 4D_Tech
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

2018-02-01 Thread Richard Wright via 4D_Tech
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

2017-11-01 Thread Richard Wright via 4D_Tech
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

2017-10-10 Thread Richard Wright via 4D_Tech
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

2017-10-06 Thread Richard Wright via 4D_Tech
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?

2017-10-06 Thread Richard Wright via 4D_Tech
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?

2017-10-06 Thread Richard Wright via 4D_Tech
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?

2017-10-06 Thread Richard Wright via 4D_Tech
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?

2017-10-06 Thread Richard Wright via 4D_Tech
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?

2017-10-06 Thread Richard Wright via 4D_Tech
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

2017-10-05 Thread Richard Wright via 4D_Tech
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

2017-10-05 Thread Richard Wright via 4D_Tech
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...

2017-09-28 Thread Richard Wright via 4D_Tech
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

2017-08-02 Thread Richard Wright via 4D_Tech
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. >

Re: can i do the following in v15

2017-03-30 Thread Richard Wright via 4D_Tech
Call REGENERATE MISSING TABLE with the older copy of the structure. The data is still there and this command will recreate the table and you will see your data. Richard Wright DataDomain rwri...@datadomainsoftware.com