Re: 4D Integration with Microsoft Dynamics AX 2012 "cube"

2018-07-02 Thread Dan Ivy via 4D_Tech
Let me simplify this query.

Has anyone connected any version of 4D directly to Microsoft Dynamics AX ERP
for any reason?

I would love to hear about it.

Thank you!

Dan Ivy
ivyleaf systems








--
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: 4D Write, pictures in page, frozen document, to 4D Write Pro

2018-07-02 Thread Keisuke Miyako via 4D_Tech
The "Tip" was based on macOS native PICT to PDF conversion.

Write Pro does not use PICT to store previews,
in fact, it does not store renderings of any kind,
so one must use WP PRINT and invoke the printing mechanism in order to generate 
PDF.
http://doc.4d.com/4Dv17/4D/17/WP-PRINT.301-3726306.en.html

this would be your choice if your WP is formatted as a document.
table support is limited (truncated at the end of page)
perhaps it will get better in 17Rx.

you can also use PRINT SELECTION or PRINT RECORD and variable frame
http://doc.4d.com/4Dv17/4D/17/Printing-4D-Write-Pro-documents.200-3726277.en.html

this would be your choice if you prefer to present the document in embedded 
mode (super styled text)

but it seems the feature is not suited for tables, as the left-most column 
always decides the page break
(i.e. adjacent columns are truncated prematurely)
and the process enters an infinite loop if the overflow content of a column 
exceeds page hight.
(presumably the engine keeps on breaking pages, carrying over the same content 
forever)

> 2018/06/27 9:15、JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> のメール:
>
> I have tested his tip in my situation and it works perfectly.
>
> Keisuke, if you are monitoring this thread, is there a way to easily do the 
> same thing with a 4D Write Pro document? I am researching this now, but 
> thought you might be able to save me sometime.




**
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: FORM GET OBJECTS and getting info about Subforms

2018-07-02 Thread Kirk Brooks via 4D_Tech
Bob,
First off what version are you working in?

On Mon, Jul 2, 2018 at 12:29 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I can't seem to figure out how to get the form name and table name of the
> ​​
> Subform.
>
​
Have you had a look at
OBJECT GET SUBFORM ( {* ;} object ; tablePtr ; detailSubform {;
listSubform} ) ​
  

-- 
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: FORM GET OBJECTS and getting info about Subforms

2018-07-02 Thread Patrick Emanuel via 4D_Tech
Hi Bob,

in QS_Toolbox, you have a module that give you information about form
objects, included subform.
Have a look on the method FORMS_GetObjectDetails, you will find what you are
looking for.

Patrick



-
Patrick EMANUEL

Administrator
www.association-qualisoft.eu 
(Soft1002, Simply Asso & QS_Toolbox)
--
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: FORM GET OBJECTS and getting info about Subforms

2018-07-02 Thread Matt Wennerlund via 4D_Tech
It seems that Object Get Subform would give you what you want.  It looks 
like you pass the object name or the variable name and it can return the 
table pointer and detail and list subform names.  I have not used it 
personally, however.



Matt Wennerlund

Bob Miller via 4D_Tech wrote:

Hi Everyone,

I'm taking inventory of a form using FORM GET OBJECTS and I come upon an
object that is "Object Type Subform".  I can get the object name of
subform from the point of view of the current form, but what I want is the
name of the form and the table to which it belongs so I can in turn then
"drill in" to it by doing a FORM LOAD and another FORM GET OBJECTS, to
take inventory of what is in the subform.  But to call FORM LOAD I need
the table name and the form name of the Subform.

I can't seem to figure out how to get the form name and table name of the
Subform.

Thoughts?

Many thanks,


Bob Miller
Chomerics, a division of Parker Hannifin Corporation


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It only 
should be used or disseminated for the purpose of conducting business with Parker. If you 
are not an intended recipient, please notify the sender by replying to this message and 
then delete the information from your system. Thank you for your cooperation."
**
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
**

FORM GET OBJECTS and getting info about Subforms

2018-07-02 Thread Bob Miller via 4D_Tech
Hi Everyone,

I'm taking inventory of a form using FORM GET OBJECTS and I come upon an 
object that is "Object Type Subform".  I can get the object name of 
subform from the point of view of the current form, but what I want is the 
name of the form and the table to which it belongs so I can in turn then 
"drill in" to it by doing a FORM LOAD and another FORM GET OBJECTS, to 
take inventory of what is in the subform.  But to call FORM LOAD I need 
the table name and the form name of the Subform.

I can't seem to figure out how to get the form name and table name of the 
Subform.

Thoughts?

Many thanks,


Bob Miller
Chomerics, a division of Parker Hannifin Corporation


ll
"PLEASE NOTE: The preceding information may be confidential or privileged. It 
only should be used or disseminated for the purpose of conducting business with 
Parker. If you are not an intended recipient, please notify the sender by 
replying to this message and then delete the information from your system. 
Thank you for your cooperation."
**
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: v13 - Text entry area, Returns, and Filters

2018-07-02 Thread Chip Scheide via 4D_Tech
Thanks Jeremy,
that is the general pattern I am using.
it seems that as long as I apply a filter the return character will not 
be accepted, as entry into the field.

Chip
On Fri, 29 Jun 2018 19:32:45 -0400, Jeremy French wrote:
> Hi Chip,
> 
> Try defining the filter using the following pattern:
> 
> 1) first character is the tilde character; then
> 2) starting quote character (escaped); then
> 3) allowed characters in filter, separated with semicolons; then
> 4) ending double quote character (escaped).
> 
> The following example allows only:
> 
> 1) uppercase A thru Z; and
> 2) space; and
> 3) carriage return.
> 
> Call on form load event:
> ---
> C_TEXT($filter_t)
> $filter_t:="~\"A-Z; ;"+Char(Carriage return)+"\""
> OBJECT SET FILTER(*;"objNameOfTextBox";$filter_t)
> ―
> 
> Does this work for you?
> 
> - Jeremy French
> 
>> On Jun 29, 2018, at 12:39 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Not working  :(
>> I can not entry a return into the text area.
>> 
>> I have this line of code in my form method:
>> utl_text_Text_Entry_Filter (->[Department]Address)
>> 
>> 
>>  //(m) utl_text_Text_Entry_Filter
>>  //$1 - pointer - to text entry area
>> 
>> C_POINTER($1;$Text_Area)
>> C_TEXT($Filter;$0)
>> 
>> $Text_Area:=$1
>> $Filter:="&"+Quote_Char+Char(13)
>> $Filter:=$Filter+Semi_Colon_Char+Text_Filter
>> $Filter:=$Filter+Semi_Colon_Char+(2*BackSlash_Char)+Quote_Char
>> $0:=$Filter
>> OBJECT SET FILTER(($Text_Area->;$Filter)
>> 
>> Text_Filter = 
>> a-z;A-Z;0-9;_;-;:;`;.;&;^;%;@;(;);[;{;];};<;>;,;/;#;|;~;=;+;*;$;?;!;';_;.;,
>> 
>> 
>> - I can enter all of the characters listed in the text filter, except a 
>> return
>> - There is no button tied to return
>> - I removed the original filter I had on the address field
>> - I removed the code behind the address field
>> - I cleared the key short cut (enter) for the accept button
>> - There is no object accepting return as a shortcut
>> - (debugging) after Object Set Filter, Object Get Filter returns a 
>> filter which includes '\r'
>> - I placed the return at the front of the filter
>> - I placed the return at the end of the filter
>> - I added Char(10), just in case.
>> - The final filter looks correct in the debugger
>>  4Final_Filter : = 
>> 
&"\r;\n;a-z;A-Z;0-9;_;-;:;`;.;&;^;%;@;(;);[;{;];};<;>;,;/;#;|;~;=;+;*;$;?;!;';_;.;,;\\"
>> 
> 
> 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: STARTTLS - send secure email 4D v15.5

2018-07-02 Thread Bruno LEGAY via 4D_Tech
Hi,

Generally (convention) smtp on port 25 is unencrypted.

C_LONGINT($vl_error;$vl_ssl;$vl_port;$vl_protocol)

$vl_port:=25
$vl_protocol:=2  //2 = SMTP or SMTP with STARTTLS
$vl_error:=IT_SetPort ($vl_protocol;$vl_port)

$vl_ssl:=0   // sessionParam Longint 0 or omitted = Do not use SSL but 
switchover allowed
$vl_error:=SMTP_Send ($vl_smtpId;$vl_ssl)

NOTE : if the SMTP server supports the option STARTTLS, the connexion will 
switch to  SSL/TLS secured connexion (see below). Otherwise the connexion is 
not secured.



SMTP on port 465 is explicit ssl. ie. The tcp connexion starts with a SSL/TLS 
handshake.

C_LONGINT($vl_error;$vl_ssl;$vl_protocol;$vl_port;$vl_protocol)

$vl_port:=465
$vl_protocol:=12  //12 = SMTP SSL
$vl_error:=IT_SetPort ($vl_protocol;$vl_port)

$vl_ssl:=1   // sessionParam Longint 0 or omitted = Do not use SSL but 
switchover allowed
$vl_error:=SMTP_Send ($vl_smtpId;$vl_ssl)


With SMTP on port 587, the connexion starts unencrypted. If the SMTP server 
replies that it can support option STARTTLS (on port 587 it should), then the 
tcp connexion switches from unencrypted to SSL/TLS secured connexion (SSL/TLS 
handshake), and then the login/password are exchanged. 
This is automatic and transparent (since 4D v13.2).


C_LONGINT($vl_error;$vl_ssl;$vl_port;$vl_protocol)

$vl_port:=587
$vl_protocol:=2  //2 = SMTP or SMTP with STARTTLS
$vl_error:=IT_SetPort ($vl_protocol;$vl_port)

$vl_ssl:=0   // sessionParam Longint 0 or omitted = Do not use SSL but 
switchover allowed
$vl_error:=SMTP_Send ($vl_smtpId;$vl_ssl)


Note that the SSL/TLS handshake on an open unencrypted tcp connexion (switching 
a connexion from unencrypted to secured) is impossible to do with 4D IC tcp 
commands (or NTK AFAIK)...


HTH
Bruno
**
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: STARTTLS - send secure email 4D v15.5

2018-07-02 Thread jarosz via 4D_Tech
Hello Keisuke


Thank you for your clarification. You imply that the only way to request a
secure TLS connection is by using "0" and hope that the server requests a
switch to SSL.

How is it possible to tell that the email was sent securely?

Is it possible to ensure that the email is ONLY sent if the connection is
secure?
And not sent if a secure connection is not available.

Thanks

Michael




--
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: Command name but what about Keywords?

2018-07-02 Thread Patrick Emanuel via 4D_Tech
4D Tech mailing list wrote
> Yes, I wondered about that. I'm not certain how well it work in the
> METHOD SET CODE context.
> 
> Ideally I would like something like the new syntax:
> Count parameters:C259
> 
> or with a constant:
> Carriage return:K15:38

I tried to keep method code lile you described and never be able to display
the "token" information after a METHOD SET CODE execution. May a solution is
to use an object where the property would be "the method name" and the
content of the property would be the code. Reading it at the lastest moment
and assign to the value of the METHOD SET CODE.
Just an idea, not tested



-
Patrick EMANUEL

Administrator
www.association-qualisoft.eu 
(Soft1002, Simply Asso & QS_Toolbox)
--
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: Command name but what about Keywords?

2018-07-02 Thread Wayne Stewart via 4D_Tech
> #4DCODE which is always English (If, End if) regardless of the method 
> language and easier to maintain?

Yes, I wondered about that. I'm not certain how well it work in the
METHOD SET CODE context.

Ideally I would like something like the new syntax:
Count parameters:C259

or with a constant:
Carriage return:K15:38



Regards,

Wayne




On 2 July 2018 at 16:52, Keisuke Miyako via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> As Patrick pointed out,
> the idea is to test the current language (use something like "True", which to 
> know to have different tokens)
> once you run METHOD SET CODE (well actually, you should run twice to tokenise 
> forward-referenced project methods)
> then keywords such as "If" will automatically reconvert when the method 
> language flips.
>
> ---
>
> another option is to set the %meta line in the code to inject in order to 
> explicitly declare the method language.
>
> ---
>
> but why not use #4DCODE which is always English (If, End if) regardless of 
> the method language and easier to maintain?
>
>
>
> **
> 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
**