Re: SMTP error 10113 Error with Authentication

This bug has existed since 15.1. It’s still there in 15.5. Has anyone filed it with 4D? Any indication of when it will be fixed? Thanks, James. > On 24 Jan 2018, at 2:15 pm, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > Did this sort the problem? > > > Regards, > >

Re: SMTP error 10113 Error with Authentication

Hi, Did this sort the problem? Regards, Wayne [image: --] Wayne Stewart [image: http://]about.me/waynestewart On 11 May 2017 at 05:08, David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com> wrote: > Tim, > > Great suggestion. At first I thought it did. > > The sm

Object focusable/tabable properties

Is it possible to programmatically set the Focusable or Tabable properties on a form object (specifically a listbox)? I found the OBJECT SET FOCUS RECTANGLE INVISIBLE command but nothing to actually prevent an object from being tabable. Jim Crate

Re: Creating .docx files

Hi, I've extract and compile code lines for you. If you have able to participate to the next Summit, you will get special gift containing some example of phpword code. It works with the v0.12.1 here the code, and let me know. C_BLOB($Blob) $NomSortie:="DocumentName.docx" $PhpCode:=Create doc

Re: Creating .docx files

Patrick and/or Dani ... I wonder if you would be willing to share some basic code to create a Word document with phpword? I am having trouble getting it to work. If you could share just a snippet that creates a very simple document, that would be very much appreciated! Thanks Pat On 22 January 201

Re: Dialog return value without process variables

Hi, What I do is create one process variable object in the initialisation of every process. I then use that throughout the process for all that sort of stuff. It's really easy with dot notation but you don't need it. Regards, Wayne [image: --] Wayne Stewart [image: http://]about.me/wayneste

RE: Dialog return value without process variables

Hi Jim, > In r5, there's the nifty Form function that solves this problem. See this: https://blog.4d.com/passing-data-back-and-forth-between-forms/ -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.ht

Re: Dialog return value without process variables

In v16.x, you could use a hidden object variable on the form (process variable) that collects the form data you need to access outside the form that gets populated with your OK button's code or whatever accepts the dialog. In r5, there's the nifty Form function that solves this problem. -- Jeff

Dialog return value without process variables

If I have a dialog to allow the user to choose a value (like from a listbox), and I’m using the object names only without process variables, is it possible to determine from the method that calls DIALOG which value the user chose? Or do I need a process variable to pass that value from the form

Re: SQL CASE statement?

Thanks! I had looked, but missed that. On 1/23/18, 9:57 AM, "4D_Tech on behalf of Jeffrey Kain via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: Yes. http://doc.4d.com/4Dv15/4D/15/case-expression.300-2288083.en.html -- Jeffrey Kain

Re: v13 - Is it possible to find all forms with letter as defined print settings

I suppose you can iterate over all forms http://doc.4d.com/4Dv16R5/4D/16-R5/FORM-GET-NAMES.301-3481424.en.html call page setup http://doc.4d.com/4Dv16R5/4D/16-R5/PAGE-SETUP.301-3482297.en.html and look up print settings http://doc.4d.com/4Dv16R5/4D/16-R5/GET-PRINT-OPTION.301-3482277.en.html

Re: v16 List Box Set Enterable not working?

On Jan 23, 2018, at 10:19 AM, Patrick Emanuel via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I never had any issues with EDIT ITEM > > Did you try something like this in your code: > > $Row:=size of array(ar_invBalance)+1 > LISTBOX INSERT ROWS (*;"ListBoxName";$Row) > ar_invBalance{$row}:="New i

Re: v16 List Box Set Enterable not working?

Jim, I think you are correct. Miyako also talked about this in another post some weeks ago. As I recall the deal is 4D needs to redraw the listbox but I don't recall the specifics, I'm afraid. Reminds me of a joke on an old CSNY album: "I didn't think you could tune and start on the same note." I'

Re: v16 List Box Set Enterable not working?

Hi, I never had any issues with EDIT ITEM Did you try something like this in your code: $Row:=size of array(ar_invBalance)+1 LISTBOX INSERT ROWS (*;"ListBoxName";$Row) ar_invBalance{$row}:="New item" OBJECT SET ENTERABLE(ar_invBalance{$row};True) EDIT ITEM(ar_invBalance;$row) Patrick

Re: v16 List Box Set Enterable not working?

Hi , did you try something like this: $Row:=size of array(ar_invBalance)+1 LISTBOX INSERT ROWS (*;"ListBoxName";$Row) ar_invBalance{$row}:="New item" OBJECT SET ENTERABLE(ar_invBalance{$row};True) EDIT ITEM(ar_invBalance;$row) the command LISTBOX INSERT ROWS adds the row(s) at the end of each

Re: User Custom Forms

> *3. The .4DA file* > This file containing the custom forms is saved into the .4DA file next to > the structure. Is there any way to store it in a different location? Say, > next to the .4dd? Staring it next to the .4dc file makes updating a bit of > an issue. - On start of the edit session, copy

Re: SQL CASE statement?

Yes. http://doc.4d.com/4Dv15/4D/15/case-expression.300-2288083.en.html -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 23, 2018, at 10:44 AM, Tony Ringsmuth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I’ve been asked if 4D SQL supports CASE statements. ***

SQL CASE statement?

I’ve been asked if 4D SQL supports CASE statements. I don’t see it in the docs:  but does anyone know definitively? Thanks, -- Tony Ringsmuth Business Brothers Inc. 763-420-8686 ** 4D Internet Users Group (4D iNUG) FAQ

Re: 4D SQL Question

Thanks, I'll try that... Jim Dorrance jim.dorra...@gmail.com 4...@dorrance.eu www.4d.dorrance.eu PS: If you know of anyone that needs an experienced 4D programmer to add energy and experience to their team, please let me know. I have experience in many areas. Reasonable rates. Remote or Paris onl

Re: User Custom Forms

Hi Keith, Yes, we could use OBJECT DUPLICATE. Pat On 23 January 2018 at 14:49, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com > wrote: > I used an inherited form in the user enterable form, so some changes could > be made in the development environment without destroying the User's > changes. >

Re: User Custom Forms

I used an inherited form in the user enterable form, so some changes could be made in the development environment without destroying the User's changes. Also, could OBJECT DUPLICATE be used during On Load to give a new object a name like "[Table1]Field1"? Keith - CDI > On Jan 23, 2018, at 8:41

User Custom Forms

(Using v16) I'm experimenting with allowing users to create their own forms with editable forms. I have one or two questions ... *1. Displaying/deleting objects such as fields* I need to allow the user to choose which fields to display on the form. The only way I can see to manage that is to plac

Re: v16 List Box Set Enterable not working?

On Jan 22, 2018, at 11:30 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote: > The link Miyako included to the section on Managing Entry does actually > talk about this. (I confess I hadn't read it very carefully before now > myself.) > > You use OBJECT SET ENTERABLE to manage the enterab

Re: 4D SQL Question

I do something like this with Postgres: If the query returns more than X records, these rows become the starting cache. Then a second query is performed to determine the total number of rows that would be returned. The list box is a selection based listbox for a simple 1 field table where I can

Re: 4D SQL Question

What I am doing now is Begin SQL SELECT * FROM [myTable] LIMIT 1 into LISTBOX :myListbox; End SQL if Records in table > 1 I then fill the rest of the arrays manually starting at goto record (1) on successive outside calls Any other ideas? -- Jim Dorrance jim.dorra...@gmail.com 4.

v13 - Is it possible to find all forms with letter as defined print settings

Hi, is it possible to search all 4D forms in a v13 based project which have a configured paper-size defined as "letter" (in its print-settings)? If so how could i do that? I already checked the .json output of my forms which i do export via the Code Analysis plugin, but the print-settings ar

Re: 4D SQL Question

Anybody have some hints how I could I fill a list box progressively ( LIMIT? OFFSET), or a demo DB... Thanks, Jim On Mon, Jan 22, 2018 at 7:30 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Not so dissimilar from your idea but you could do > > Begin SQL > > SELECT * FROM [myT

Re: 4D SQL Question

Thank you. Perfect. On Mon, Jan 22, 2018 at 7:30 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Not so dissimilar from your idea but you could do > > Begin SQL > > SELECT * FROM [myTable] LIMIT 0 into LISTBOX :myListbox; > > End SQL > > >

Re: Fixed: Re: v16 List Box Set Enterable not working?

The other thing that would need some clarification is the alternativ methode to prevent a single cell from editing: The event On Before Data Entry. There are several ways to reach a cell, either by tabbing or by clicking. What I'm struggling with is how to determine which cell needs to be edited