Re: sending mail through Office365 using SMTP

The solution for sending email through Office 365 (as it worked for me). You would need to adjust according to taste. Hopefully enough detail is provided to make it helpful. — Chris Belanger INTERPROCESS VARS: <>eHOST — in this instance, is smtp.office365.com <>eFROM — default email

Re: sending mail through Office365 using SMTP

thanks, Spencer. I neglected to include that in the sample code. Above it is the line: $error:=IT_SetPort (2;587) > On Nov 20, 2018, at 4:15 PM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > in the docs for Send there is an Exchange example that set Port >

Re: Audit File Updates via Triggers...

John, Sure you can - you make a method to extract the data you want. In selection based listboxes you can put the method in a column formula. It's definitely easier in v17 but I've been using this in v15 for a long time. On Tue, Nov 20, 2018 at 1:14 PM John DeSoi via 4D_Tech

sharing a method for converting a list into a menu. Handles hierarchical ones.

Hi fellow programmers, As a effort to give back to the community for its help to me, I thought I should share a piece of code that can be very helpful. I found that I could not use a hierarchical list as a ‘choice list’ in a listbox’s column. when clicked, only the top-level items show. So I

Re: Redrawing List Subform...

Problem solved. The record was being added but was not part of the current selection. A query was added that performs the same duty as the automatic Relate Many. So the problem was not one of object redraw it was data related. FWIW, Robert Sent from my iPhone > On Nov 20, 2018, at 12:37

Re: sending mail through Office365 using SMTP

in the docs for Send there is an Exchange example that set Port 587. Spencer > On Nov 20, 2018, at 2:58 PM, Chris Belanger via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi, > > I have a client that has switched its email provider to use Office365. > My app sends emails using SMTP_Send( )

Re: Audit File Updates via Triggers...

As always sql does not see object fields. So if you use sql to move data around. Sent from my iPhone > On Nov 20, 2018, at 3:56 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Wow, you guys are the best—GREAT idea! I think we all need to use objects > more often and this

Re: Audit File Updates via Triggers...

Just note that you won't be able to see any of the data in an object field if you are displaying records in a list box. Some possible options now in version 17 if you are using collections/entity selections. John DeSoi, Ph.D. > On Nov 20, 2018, at 2:56 PM, Robert ListMail via 4D_Tech >

Re: Selection-based Listbox Deletions...

"current selection" obviously needs qualification; of which table. the table is implied in the context of a list form (modify/display selection), but for list subforms it is the master table of the subform object, as defined in its property list. you can have multiple sub forms on the same form,

Re: Audit File Updates via Triggers...

Kirk, since I don't have objects yet... Trigger actions - 1 method tracking actions (including created and modified) - 4 methods On Tue, 20 Nov 2018 12:48:01 -0800, Kirk Brooks via 4D_Tech wrote: > Robert, > My thoughts on the created by/modified by stuff: > > 1) I moved all this to a single

Re: Selection-based Listbox Deletions...

thank for the correction, I was wrong; I had totally missed that piece of information. so the delete "subrecord" standard action applies to selection based list boxes too. I should have read between the lines in the original post that if the button was active, it must be responding to the

Re: Audit File Updates via Triggers...

Wow, you guys are the best—GREAT idea! I think we all need to use objects more often and this is a great example—thanks Kirk. > On Nov 20, 2018, at 2:48 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > Robert, > My thoughts on the created by/modified by stuff: > 1) I moved all this

Re: Selection-based Listbox Deletions...

Hi Keisuke, thanks for your response…. Just trying to get clarification here. > On Nov 20, 2018, at 2:32 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > ...selection-based list box did not exist back then, > and it was never further updated to work for list boxes. > using it

Re: Audit File Updates via Triggers...

Robert, My thoughts on the created by/modified by stuff: 1) I moved all this to a single object field. I call it '_meta' and it's on every table I want to manage. 2) At a minimum the field has: {"created"; {"name: "", "date": ""}, "modified"; {"name": "", "date": ""}} 3) I wrote a few (I

Re: Explorer bottom toolbar not displaying...

or, just close the Explorer and bring it back while holding down the shift key. Open form window (...;*) window bounds are reset with the shift key. 2018/11/21 4:37、Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com>のメール: First guess is to quit 4D and throw out the

Re: Selection-based Listbox Deletions...

the "delete subrecord" standard action was updated to work as "delete selection" in v2004, which works on list forms and list subforms (with focus). but selection-based list box did not exist back then, and it was never further updated to work for list boxes. using it outside the context of a

Re: Audit File Updates via Triggers...

I use 2 fields (nearly) every table, some linking (many to many) tables do not have this. [Table]Created_Who [text] [Table]Modifed_Who [text] both fields track the same info Current User, Date, time (in that order and that format) This info is updated, most often by a trigger, using the

Re: Audit File Updates via Triggers...

Hi Chuck, I think in this case, this makes sense. I never thought about tracking all record updates or going further… all updates on chosen fields. I recall in the past that other developers that cared about such things had a 3-4 fields added to each record and could easily see who created and

Re: Audit File Updates via Triggers...

I think the strategy depends upon need. If all you need to to know who created, data and time created and last modified by, last modified date and time, then I would add fields to table in question. If you have a need to track who made every modification, I would put that in a sperate table. You

dragging an object

Hi Any ideas on how to implement the following Click on an object on a form(a Picture) Drag it to a new location Have it stay at the new location a bonus would be if it could be shown being dragged Ive tried various combinations of form events involving the mouse (Mouse Enter Mouse Move etc) in

Audit File Updates via Triggers...

At a minimum, I just have the simple need of recording “CreatedBy” and “ModifiedBy” values (username or ID) for one particular table. I do have extra fields already in that table that could be repurposed and I would probably add “DateModified” to that. However, that’s three fields used just

Re: Explorer bottom toolbar not displaying...

Didn’t know that one. Thanks Regards and happy bird day to all but the birds;) Regards Chuck On Tue, Nov 20, 2018 at 2:42 PM Douglas von Roeder via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Gary: > > Getting rids of the window bounds file will do the trick but there's also > the trick of

RE: Explorer bottom toolbar not displaying...

Or use this code: http://kb.4d.com/assetid=77586 Note: make sure the explorer is closed when running the code. Or just hold SHIFT when opening the Explorer window to reset it. -Tim -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Randy Jaynes via 4D_Tech

Re: Explorer bottom toolbar not displaying...

Gary: Getting rids of the window bounds file will do the trick but there's also the trick of holding down the Shift key as you open a window - http://kb.4d.com/assetid=78092 Very handy, especially with V15. -- Douglas von Roeder 949-336-2902 On Tue, Nov 20, 2018 at 11:37 AM Randy Jaynes via

Re: Explorer bottom toolbar not displaying...

Ar bottom of method, you should be able to add a list Regards Chuck On Tue, Nov 20, 2018 at 2:33 PM Garri Ogata via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello, > > 4D v15.3 explorer is not displaying the bottom toolbar. There is no add, > minus (delete), or arrow for preview or comments

Re: Explorer bottom toolbar not displaying...

First guess is to quit 4D and throw out the folder "4D Window Bounds v15” in your 4D folder. On Mac, this is ~/Library/Application Support/4D/4D Window Bounds v15/ In Windows it’s somewhere in the C:/ProgramData folder I think. Randy

Re: Redrawing List Subform...

a listbox (selection) has to have it's content updated to show a change in display. Use set, use named selection, query <[table]>. if you: - delete a record from the list - but do not remove it from the current selection (which seems to force the redraw) the listbox still shows the deleted

Explorer bottom toolbar not displaying...

Hello, 4D v15.3 explorer is not displaying the bottom toolbar. There is no add, minus (delete), or arrow for preview or comments button. How do you get these to reappear? Thanks, Garri Ogata ** 4D Internet Users Group (4D

Re: Redrawing List Subform...

Also, I forgot to mention: > On May 14, 2016, at 1:59 PM, David Belote wrote, > Re: redrawing subform: > Keisuke, Thank you for that nugget. I have been confused for a long time > about REDRAW. In the past, when I’m coding and something doesn’t display or > doesn’t display like I think it

Redrawing List Subform...

I have a list subform showing related records and when a record is added via programming the list does not update. So, I tried to use Redraw using the: object name; variable name, table name as a parameter and the redraw did not occur. Also, Redraw window had no affect either. Any ideas on how

Re: Transferring Build Mac Client via Google Drive Web Interface Fails

Thanks Jeremy, I like your idea of integrating into your build code. I saw an old tech note on that, but it seems out of date. I am currently using an Applescript for code signing: set theDocument to choose file with prompt "Select the 4D Client application:" set filepath to POSIX path of

Re: Selection-based Listbox Deletions...

the old sub records are no longer sub records. make the button no action Confirm with the user use set() delete selection([table]) repopulate the listbox if you are using a set to track the originally displayed records (I do this), difference the selected set from the tracking set use original

Re: Form Scaling & Optimal Fonts...

Yes - referring to the built in style sheet called Automatic. You need to make a new style sheet that uses the system fonts to get the correct one. > On Nov 19, 2018, at 9:50 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > are you sure? > > just tested, OBJECT Get font on

Re: Transferring Build Mac Client via Google Drive Web Interface Fails

Dave, FWIW, I found information on signing hard to unearth and harder to understand. Eventually, I managed to sign my compiled application using these commands at the end of my build method: LAUNCH EXTERNAL PROCESS("xattr -cr "+$appPath) LAUNCH EXTERNAL PROCESS("codesign --deep

Re: LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

for sure you can open word or excel documents. what you can't do is specify which version of Word (if there are multiple installations) is launched. 2018/11/20 18:42、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com>のメール: Yes, I could. But sometimes it

Re: LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

Hi Keisuke, Yes, I could. But sometimes it concerns excel or word documents, so that wouldn’t work, at least not on a Mac. Or am I wrong? Regards, Rudy Mortier Two Way Communications bvba > On 20 Nov 2018, at 05:54, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > could you

Re: http get, error 30 when ran as service (v15 windows)

in our office, when we use the local internet service provider's DHCP, we randomly get error #30 when trying to access some large U.S. services such as Google. if we use Google's DHCP 8.8.8.8. the call succeeds. apparently some ISPs fail to resolve certain foreign domain names. haven't tried,