Re: How to Determine Field Type from XML Structure Export?

[Keisuke Miyako via 4D_Tech]

if you do an introspection using SQL,

Begin SQL

SELECT * FROM _USER_COLUMNS INTO LISTBOX :L

End SQL

you'd see 2 columns, DATA_TYPE and OLD_DATA_TYPE

c.f.

http://doc.4d.com/4Dv16R4/4D/16-R4/System-Tables.300-3451015.en.html

the "type" attribute in structure xml corresponds to DATA_TYPE except for UUID 
(which is type="10" store_as_UUID="true" instead of type="13")

it helps to have a brute-force bidirectional case-of mapper if you need to use 
Type()...

> 2018/04/20 10:17、Jeremy French via 4D_Tech <4d_tech@lists.4d.com> のメール：
> 1) What does the "type" attribute refer to?
> 2) How do we determine the field type from an XML Structure Export?



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

How to Determine Field Type from XML Structure Export?

[Jeremy French via 4D_Tech]

When we export an XML structure, what does the "type" attribute indicate?

For example, here is a snippet, from an XML Structure Export, for 3-fields: 
date, time and boolean.

---





---

The above "type" attribute values do *NOT* correspond with the values returned 
the 4D command "Type".

For example:

1) Date field: attribute "type" is 8, but the type command returns 4.

2) Time field: attribute "type" is 9, but the type command returns 11.

3) Boolean attribute "type" is 1, but the type command returns 6.

See:
http://doc.4d.com/4Dv16R6/4D/16-R6/Type.301-3547444.en.html

==
Questions
==

1) What does the "type" attribute refer to?

2) How do we determine the field type from an XML Structure Export?

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

Administrator

[Keith Goebel via 4D_Tech]

To the list Administrator:
Would it be possible to eliminate some of the headers shown for each email in 
the digest?

At the moment we see, for each email
Message: 1
Date: Wed, 18 Apr 2018 14:32:01 -0500
From: Tim Nevels 
To: 4d_tech@lists.4d.com
Subject: Re: URGENT:  4D in Citrix or Terminal Server environment
Message-ID: 
Content-Type: text/plain; charset=utf-8

What I (and hopefully other digest recipients) would prefer to see to make the 
posts easier to scan would be
Message: 1
Date: Wed, 18 Apr 2018 14:32:01 -0500
From: Tim Nevels 
Subject: Re: URGENT:  4D in Citrix or Terminal Server environment

Also, I am still receiving digests to the address keit...@clear.net.nz.
That email address is dead and I am unable to stop it from here.
If you “kill” that address for me, it will prevent 2 of every digest from 
coming through.
I haven’t tried to use the <4d_tech-unsubscr...@lists.4d.com> as I suspect it 
will unsubscribe my new email address (this one).
Cheers, Keith
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Setting color print option problem

[Jim Labos - infobase via 4D_Tech]

Unfortunately they are on v13 still. Looks like its available only starting
in v15.

Looks like they will have to live by doing manually each time they change
settings for a print job.

Thanks.

Jim Labos infobase



-
Jim Labos - infobase
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15

[Douglas von Roeder via 4D_Tech]

Mark:

I don't have anything running V16 but the docs for OT state "4D V11.5+" and
it is compatible with 32 bit and 64 bit versions.

The web site (https://www.aparajitaworld.com/downloads) reads "What you
will need: 4D V11 or later" and it confirms the 32 and 64 bit
functionality.

--
Douglas von Roeder
949-336-2902

On Thu, Apr 19, 2018 at 2:53 PM, Mark Zinke via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi All,
>
> I was wondering if anyone knows if ObjectTools supports 4D V16?
>
>
>
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15

[Jim Hays via 4D_Tech]

Yes ObjectTools works with v16.  We are on 16R6.  It is 64bit as well.

Jim

On Thu, Apr 19, 2018 at 5:53 PM, Mark Zinke via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi All,
>
> I was wondering if anyone knows if ObjectTools supports 4D V16?
>
>
>
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Upgrading 2004 to v15

[Mark Zinke via 4D_Tech]

Hi All,

I was wondering if anyone knows if ObjectTools supports 4D V16?



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Setting color print option problem

[Keisuke Miyako via 4D_Tech]

you can use print settings to BLOB

we have been using it to switch colour / BW since 4D 2004.

v16:

http://doc.4d.com/4Dv16/4D/16.2/Print-settings-to-BLOB.301-3432852.en.html

legacy:

http://doc.4d.com/4Dv15/4D-Pack/15.1/AP-Print-settings-to-BLOB.301-2787500.en.html

2018/04/20 3:06、Jim Labos - infobase via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
Has anyone had a similar problem and found a more elegant solution?


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

Re: list box on a subform

[Keisuke Miyako via 4D_Tech]

Hello,

there should be nothing special about using a listbox in a widget (non-list) 
subform.

here is an example:

https://github.com/4D-JP/event-world-tour-japan-2015/blob/master/5.%20hierarchical-list/hierarchical-list.4dbase.zip

2018/04/20 3:48、Charles Miller via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
Can anyone advise how to make sure colors and other settings work on a subform



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

list box on a subform

[Charles Miller via 4D_Tech]

Hi All,

Version 15.5. I have a list box which we have moved to a subform as it is
used in more than one place. When directly on the form, lines get displayed
with the approriate color, but on the sub form, they do not. Can anyone
advise how to make sure colors and other settings work on a subform

Thanks and regards,

Chuck

-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Setting color print option problem

[Jim Labos - infobase via 4D_Tech]

A customer is using a Xerox printer where customer is charged on a per page
printed basis. There are 2 tariffs, the cheaper one is the black and white.
Since the customer mostly does not need the color options I set him up with
a way to set his print settings at startup so tha he does not have to do it
for every print job. The difference in cost is hundreds of dollars per
month, easily over $1000 per year. So I can understand his concern.

On v13 Mac you cannot use the color settings option for Set Print Option. It
only works on Windows and they are a mac only shop. The only way to have a
setting that is maintained is to use Print Settings to bring up the system
Print Dialog and make settings in there. That seems to work most of the
time. Not sure why yet, but the customer says the settings do not always
maintain for the entire 4D session.

Has anyone had a similar problem and found a more elegant solution?

Thanks

Jim Labos - infobase





-
Jim Labos - infobase
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Service Call in 4Dv15

[Epperlein, Lutz (agendo) via 4D_Tech]

Not sure, but maybe there is an issue with the certificates on the v15 server. 
If I remember correctly, it isn't necessary to have a pub key file in the 
database folder, it could even be harmful to https connections.

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

SMTP_Sender, SPTP_From, SMTP_ReplyTo

[David Rose via 4D_Tech]

In a 4D v15 app I am sending emails that have an email address for 
authentication that is different than the SMTP_Sender, SMTP_From, and 
SMTP_ReplyTo values. I am finding that with the following values, the recipient 
sees the authentication username in his/her email client, and I don't want that:
SMTP_Auth: myauthem...@gmail.com
SMTP_Sender: sen...@gmail.com
SMTP_From: My Sender Office Name
SMTP_ReplyTo: same as SMTP_Sender

For example, in Outlook, the recipient sees "My Sender Office Name" in the From 
column of the list screen (that's fine), but "My Sender Office Name 
" at the top of the detail screen. SMTP_ReplyTo works 
fine - if a user clicks Reply, the ReplyTo email address is used.

What do I need to hide the authentication username from the recipient?
David

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

Re: Web Service Call in 4Dv15

[Ronnie Teo via 4D_Tech]

Hi All,

I raised this question a week ago and am still stuck on the same problem.
A quick refresh, I am unable to consume a web service from a 4Dv15.5 
application (converted from 4Dv11).
The v15 application is running on a Windows 2012 server, say Server1.

The 4D v11 application running on the same server (Server1) is able to call the 
web service to transmit an XML document with no issues.

I have also verified with a separate v15 application running at another 
installation (Server2) that is able to transmit successfully.
So it seems not to be an issue with any v15 coding issue.

In all applications (v11 and v15), the same web service call is made :
WEB SERVICE 
CALL($txtSOAP_URL;$txtSOAP_Action;txtSOAP_Method;$txtSOAP_Namespace;Web Service 
manual)
 

The only difference between the soap URL on Server1 and Server2 is that on 
Server 1, the URL begins with “https://“ - a secured connection, while on 
Server2, it starts with “http://“.   

On Server1, however v11 does not have any problem with the “https://“ 
connection. 
Could it be s security certification issue for the v15 app, that’s why the soap 
server is deemed not reachable every time the web service call is made?

Seems like there is very little left to be done on the 4D-end.  
Does anyone have any other ideas how to troubleshoot and solve this?  

Regards,
Ronnie
Tarawerkz




> On 11 Apr 2018, at 1:57 pm, Ronnie Teo  wrote:
> 
> Hi All,
> 
> I would like to seek some help/advise on an XML issue in 4Dv15 on Windows.
> 
> I have an app that is currently running in v11.  XML transmission via the 
> consumption of a hosted web service is working well.
> User decides to upgrade their server from Windows Server 2008r2 to 2012 and 
> from v11 to v15.
> 
> XML transmission from the v11 database when ported over to the new staging 
> server continues to work well.  For the converted v15 application, running on 
> the same staging server, everything works except the XML transmission.  Same 
> server, same port, soap URL, same web service yet it works on v11 works but 
> not v15.
> 
> On v15, the Web Service Call command returns with the OK variable not equal 
> to 1  and a soap server not reachable response.
> 
> Have tried comparing all the settings between the two 4D versions to make 
> them similar but to no avail.  Does anyone have any encounters with this 
> issue or what could possibly have gone awry with the Web Service Call command 
> in v15?
> 
> 
> Thanks,
> Ronnie
> Tarawerkz

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

Re: What happened to LISTBOX Get Information?

[Kirk Brooks via 4D_Tech]

Ah ha! - it's been renamed: LISTBOX Get property

On Thu, Apr 19, 2018 at 7:26 AM, Kirk Brooks  wrote:

> LISTBOX Get Information isn't in the language ref for v16r or v17 and
> doesn't appear in v16r6 code. I can't find any mention of it being
> deprecated.
>
> Is this an oversight or is it gone?
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *We go vote - they go home*
>
>


-- 
Kirk Brooks
San Francisco, CA
===

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

What happened to LISTBOX Get Information?

[Kirk Brooks via 4D_Tech]

LISTBOX Get Information isn't in the language ref for v16r or v17 and
doesn't appear in v16r6 code. I can't find any mention of it being
deprecated.

Is this an oversight or is it gone?

-- 
Kirk Brooks
San Francisco, CA
===

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

Re: Signed emails to the list?

[Matthias Schmidt via 4D_Tech]

Ah, that’s good news :-)
Matthias

On 5 Apr 2018, at 10:26, Epperlein, Lutz (agendo) via 4D_Tech wrote:


Hi Tim,

thanks, it seems to work, the signed email is delivered via iNUG.

Lutz


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of 
Epperlein,

Lutz
(agendo) via 4D_Tech
Sent: Thursday, April 5, 2018 9:42 AM
To: Timothy Penner ; 4D iNug Technical
<4d_tech@lists.4d.com>
Cc: Epperlein, Lutz (agendo) 
Subject: RE: Signed emails to the list?

Hi Tim,

Ok, here is a signed one ...
Background: It is a S/MIME-signed email using MS Outlook.

Regards
Lutz


-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com]
Sent: Thursday, March 29, 2018 6:36 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Epperlein, Lutz (agendo) 
Subject: [Junk released by User action] RE: Signed emails to the 
list?


Hi Lutz,


it seems signing of emails prevents the delivery ...


I don't think that sending signed emails to the iNUG has ever 
worked...

However, I just
made a small modification to the list settings that may start to 
allow it

to
work;  would
you like to retry sending a signed message?

Kind Regards,

Tim PENNER



Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Telephone : +1-408-557-4600
Standard :  +1-408-557-4600
Fax :   +1-408-271-5080
Email : tpen...@4d.com
Web :   www.4D.com



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