Re: Sending mail in 4D v11 on Mac

[Two Way Communications via 4D_Tech]

I was afraid this would be the answer.

I hope this customer is now convinced he has to upgrade ;-)


Regards,

Rudy Mortier
Two Way Communications bvba 



> On 14 May 2019, at 01:03, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> that won't work.
> 
> besides, STARTTLS is not just about starting with the 587 port instead of 25.
> 
> a transition to TLS must follow.
> 
> not possible in v11 Internet Commands unless you implement SMTP using 
> low-level TCP commands.
> 
> 2019/05/14 7:05、Tom Dillon via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> Is it possible to pass the port with a ":587" added to the host?
> 
> 
> 
> **
> 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
**

Re: Sending mail in 4D v11 on Mac

[Keisuke Miyako via 4D_Tech]

that won't work.

besides, STARTTLS is not just about starting with the 587 port instead of 25.

a transition to TLS must follow.

not possible in v11 Internet Commands unless you implement SMTP using low-level 
TCP commands.

2019/05/14 7:05、Tom Dillon via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Is it possible to pass the port with a ":587" added to the host?



**
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
**

Re: Sending mail in 4D v11 on Mac

[Tom Dillon via 4D_Tech]

Bruno LEGAY via 4D_Tech wrote:

>There is no way port 587 will work with older versions of 4D.

Is it possible to pass the port with a ":587" added to the host?

-- 
   --
   Tom Dillon  375 S Main St #405
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
  Sometimes the only choice is to shoot oneself
  in the other foot. --- Sunastar
   --


**
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
**

Re: Sending mail in 4D v11 on Mac

[Bruno LEGAY via 4D_Tech]

Hi,

Port 587 is smtp with START_TLS.
The connexion start in clear (un encrypted) and upon smtp protocol negotiation 
the connexion will be switched to secured/SSL/TLS.

This feature was added in 4D IC v13.2. 

There is no way port 587 will work with older versions of 4D.

You can try explicit SSL/TSL on port 465 with 
SMTP_Send( ... ;1)

Having said that, you are facing a problem of an old tool with outdated 
security protocols and it could be that the ssl/tls version in 4D IC v11 are 
not compatible with current smtp servers (or rejected because considered 
outdated/unsafe). 

HTH
Bruno

**
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
**

Re: AreaList Pro Column Background Color

[Tim Nevels via 4D_Tech]

On May 13, 2019, at 9:00 AM, Armin wrote:
 
> the ALP v9 pdf manual shows you the different options at page 127
> 
> for column 6 and 7
> AL_SetColumnLongProperty (eList;6;ALP_Column_BackColor;0xFFAAEECC)
> AL_SetColumnLongProperty (eList;7;ALP_Column_BackColor;0xFFAAEECC)

Thanks to everyone that replied. My problem was that this database is very old 
and still runs in ALP “compatibility” mode. So I was referencing the ALP 8.5 
User Manual which does not have these new commands. That’s why I couldn’t 
figure out how to do it. I’d forgotten all about compatibility mode. 

I like that you can switch out of compatibility mode, use new commands and then 
switch back into compatibility mode. Very convenient and saves having to do a 
lot of code rewriting. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

Sending mail in 4D v11 on Mac

[Two Way Communications via 4D_Tech]

Hi guys,

This is a mystery to me.

I use a simple peace of code to send an e-mail message. This code works 
perfectly in v15 and higher.

$vError:=SMTP_Charset (1;1)
$vError:=SMTP_SetPrefs (1;1;0)
$result:=IT_SetPort (12;587)
$result:=SMTP_New ($smtp_id)
$result:=SMTP_Host ($smtp_id;[Settings]EMA_smtp)
$result:=SMTP_From ($smtp_id;[Settings]EMA_adres)
$result:=SMTP_To ($smtp_id;[Settings]EMA_adres;0)
$result:=SMTP_Subject ($smtp_id;$EMAsubject)
$result:=SMTP_Body ($smtp_id;$EMABody)
$result:=SMTP_Auth ($Smtp_id;[Settings]EMA_login;[Settings]EMA_paswoord;0)  
//0=highest available, 1=plain, 2=LOGIN, 3=CRAM-MD5
$result:=SMTP_Send ($Smtp_id)

However, a customer of mine who still uses 4D v11 (yes, I know…) is running the 
same code, but gets an error 10113 (Error with Authentication)

Any idea how I can get this to work in v11?


Regards,

Rudy Mortier


> On 13 May 2019, at 15:59, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> you could set the highlight row, 
> then do whatever,
> then set the scroll position back
> and (if needed) un set the highlight row
> 
> Chip
> On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
>> Hello again,
>> What I meant if it wasn't clear is can I get this to work with an Output
>> Form showing a list of records?
>> Thanks!
>> Alan
>> 
>> On Fri, May 10, 2019 at 5:31 PM Alan Tilson > > wrote:
>> 
>>> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
>>> haven't.
>>> Alan
>>> 
>>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson >> > wrote:
>>> 
 Hello out there,
 I cannot get OBJECT GET SCROLL POSITION to work with a list form.
 OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
 scrollPosition at zero, wherever I have scrolled.
 Thanks!
 Alan
 
 On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
 4d_tech@lists.4d.com > wrote:
 
> Thanks, Miyako, that works!
> 
> 
>> From: Keisuke Miyako > >
>> To: 4D iNug Technical <4d_tech@lists.4d.com 
>> >
>> Subject: Re: Scroll position of display-type subform
>> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com 
>> >
>> Content-Type: text/plain; charset="utf-8"
>> 
>> 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_Tech <4d_tech@lists.4d.com>
> のメール：
>>> I need to get the position of an object on a display-type subform in
> global coordinates and the subform may be scrolled.
>> 
> 
> **
> 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)
>> Archive:  http://lists.4d.com/archives.html 
>> 
>> Options: https://lists.4d.com/mailman/options/4d_tech 
>> 
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
>> 
>> **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 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 
> 
> **



Met vriendelijke groeten,

Rudy Mortier
Two Way Communications bvba 



**
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
**

Re: Scroll position of display-type subform

[Chip Scheide via 4D_Tech]

you could set the highlight row, 
then do whatever,
then set the scroll position back
and (if needed) un set the highlight row

Chip
On Sat, 11 May 2019 10:06:22 -0400, Alan Tilson via 4D_Tech wrote:
> Hello again,
> What I meant if it wasn't clear is can I get this to work with an Output
> Form showing a list of records?
> Thanks!
> Alan
> 
> On Fri, May 10, 2019 at 5:31 PM Alan Tilson  wrote:
> 
>> If I have selected a record HIGHLIGHT RECORDS works fine, but often I
>> haven't.
>> Alan
>> 
>> On Fri, May 10, 2019 at 5:30 PM Alan Tilson  wrote:
>> 
>>> Hello out there,
>>> I cannot get OBJECT GET SCROLL POSITION to work with a list form.
>>> OBJECT GET SCROLL POSITION([table]field;scrollPosition) leaves
>>> scrollPosition at zero, wherever I have scrolled.
>>> Thanks!
>>> Alan
>>> 
>>> On Tue, Jun 12, 2018 at 6:31 PM Richard Wright via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 Thanks, Miyako, that works!
 
 
> From: Keisuke Miyako 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Scroll position of display-type subform
> Message-ID: <30f1fc18-68d9-4b1b-9413-aba4d7db5...@4d.com>
> Content-Type: text/plain; charset="utf-8"
> 
> 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_Tech <4d_tech@lists.4d.com>
 のメール：
>> I need to get the position of an object on a display-type subform in
 global coordinates and the subform may be scrolled.
> 
 
 **
 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)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Developer needed

[Uist Macdonald via 4D_Tech]

Hi

I am part of a consortium which is installing and running three biometric 
laboratories, part of which is a laboratory information management system.
This is in a fairly advanced state, however I need another pair of hands and a 
brain to complete it.  This would be a contract position, initially for three 
months subject to probationary period.

This work can be carried out mostly offsite, and is not security restricted.

The requirements are 4D V17.x,
MSSQL Server 2017
jQuery
Datatables/ Editor
CanvasJS

If you are interested please PM me with your CV and rates.

I will be at the 4D World Tour in London today and tomorrow if you would like 
to chat about this.

Best regards

Uist Macdonald
-- 

Ceres Computer Consultants Ltd

Registered Office:
South Scotstarvit
Chance Inn
Cupar
Fife KY15 5QJ

+44 (0) 1334 828002

Registered in Scotland : SC107838

An ISO 9001 registered company.

This message including any attachments, is intended and authorized for
the addressee only, and may contain privileged and/or confidential
information.  If you are not the authorized addressee, you are not
authorized to either review or disseminate this message.  Accordingly,
if you are not the intended and authorized recipient, please disregard
this message and notify the sender.  If you are the authorized
addressee, you may use this for the purpose for which it was intended; a
direct, personal communication to you and your legal agents.  You may
not distribute it to or publish it in any public forum without prior,
specific, written permission from the sender.



**
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
**

Re: AreaList Pro Column Background Color

[Philippe Ganter via 4D_Tech]

In addition to Douglas and Armin's replies:

There are seven ways to set colors in AreaList Pro, using numbers or strings. 
See the v9 manual on page 123:
http://www.e-node.net/ftp/AreaListPro/9.9.5_Previous_version/AreaListPro_Manual.pdf

And, as Douglas mentioned, the alpha channel (transparency) is fully supported…

Tim: you could also give a try to CalendarSet (www.e-node.net/cs), which does 
this automatically (and supports drag and drop from/to AreaList Pro).

Regards,
-- 
Philippe Ganter
www.e-node.net


> On 12 May 2019, at 21:13, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Tim:
> 
> ALP gives a lot of control over colorization. In this case, you want to
> color a column so the column commands are used.
> 
> In addition to the docs, under “Working with Color”, the constants are
> listed in the Constants section of the Explorer under ALP Column
> Properties. The one that you’re looking for is ALP_Column_BackColor. That’s
> a text property so your code could look like this:
> 
> $column_L:=-2  //-2 sets all columns when using the new version of ALP - it
> was 0 in ALP V8
> $column_L:=1
> AL_SetColumnTextProperty ($eList;$column_L;ALP_Column_BackColor;"#FFEE")
> 
> That’s a light gray color - “#FF808080” is darker. In addition to
> supporting the color, the first two characters are the alpha channel
> 
> ALP allows you to use some colors by name (“white", “red", "green", etc.)
> as well as the string of the value from the color palette (“P201”)
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
>> On 12 May 2019, at 21:13, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote:
>> 
>> Tim, 
>> 
>> the ALP v9 pdf manual shows you the different options at page 127
>> 
>> for column 6 and 7
>> AL_SetColumnLongProperty (eList;6;ALP_Column_BackColor;0xFFAAEECC)
>> AL_SetColumnLongProperty (eList;7;ALP_Column_BackColor;0xFFAAEECC)
>> 
>> Armin
> 
>>> On Sun, May 12, 2019 at 9:34 AM Tim Nevels via 4D_Tech 
>>> <4d_tech@lists.4d.com>
>>> wrote:
>> 
>>> AreaList Pro question… I have an array based area that has columns for
>>> each day of the week. I want to have the Sunday and Saturday columns show
>>> with a light gray background.
>>> 
>>> I can set the background color for rows that have data, but the area is
>>> not always filled with data. So rows with no data show a white background.
>>> 
>>> What ALP command do I use to set the default background color for a column
>>> so that it draws that color even there is no data in the area, or if the
>>> row has no data?
>>> 
>>> Tim
>>> 
>>> *
>>> Tim Nevels
>>> Innovative Solutions
>>> 785-749-3444
>>> timnev...@mac.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
**