John,

We opened a case with 4D.

WritePro optionally displays expressions, or their calculated values.

We may have to parse the converted WritePro objects to replace queryies with a 
call formatted like:

Query_ (->[Student];->[Student]AccountNo;"=";->[Account]AccountNo)
…which does…
QUERY($Table_p->;$Field_p->;$Operator_t;$Value_p->)

It’s a bug. WritePro should not show “Undefined” as the result of a embedded 
query expression.

SET ALLOWED COMMANDS should also work for 4D commands, since if a user is 
allowed to enter expressions, than those expressions should be restrictable.

David Ringsmuth

From: John DeSoi via 4D_Tech
Sent: Thursday, December 20, 2018 11:43 AM
To: 4D iNug Technical
Cc: John DeSoi
Subject: Re: WritePro expression undefined

I see two options:

1. Submit a bug/feature request to 4D and hope they change it to return nothing 
instead of "Undefined".

2. Replace all of your QUERY commands with a method that returns an empty 
string.

I don't use 4D Write Pro, but I think automating the replacement in 4D Write 
before conversion should not be too difficult. I also think it would be a win 
over the way you are doing it because having the project method shows the 
queries, tables, and fields in the design environment referencing. You lose 
that visibility by embedding queries directly in 4D Write documents.

Maybe that does not work if you have end users writing their own queries for 4D 
Write. That seems dangerous to me.

John DeSoi, Ph.D.


> On Dec 20, 2018, at 11:01 AM, David Ringsmuth <davidi...@gmail.com> wrote:
> 
> We have hundreds of converted documents with queries in them that worked 
> correctly in 4D Write. There they executed and did not display “Undefined” in 
> the 4D Write document. These should not have to be wrapped commands to work 
> without an “Undefined” appearing in the WritePro document.
>  
> This in new and apparently wrong behavior in WritePro.
>  
> If this is not an error in WritePro, and if it is the intended operation of 
> WritePro, then it is a warning to everyone converting from 4D Write documents.
> 

**********************************************************************
4D Internet Users Group (4D iNUG)
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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to