Re: SMTP error 10113 Error with Authentication

[James Brown via 4D_Tech]

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,
> 
> 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 smtp auth password has only lowercase letters and numbers.
>> 
>> It is using SSL (true) SMTP AUTH (true).
>> 
>> I had that problem on another system. Special characters broke it.
>> 
>> David Ringsmuth
>> 
>> From: Timothy Penner via 4D_Tech
>> Sent: Wednesday, May 10, 2017 1:34 PM
>> To: 4D iNug Technical
>> Cc: Timothy Penner
>> Subject: RE: SMTP error 10113 Error with Authentication
>> 
>> David,
>> 
>> Just a wild guess - Is there a strange character in the password?
>> If so, maybe the character is being handled differently on 4D Server?
>> I don't know why this would be the case, I just thought it might give you
>> something to investigate.
>> 
>> -Tim
>> 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://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: http://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: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: SMTP error 10113 Error with Authentication

[Wayne Stewart via 4D_Tech]

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 smtp auth password has only lowercase letters and numbers.
>
> It is using SSL (true) SMTP AUTH (true).
>
> I had that problem on another system. Special characters broke it.
>
> David Ringsmuth
>
> From: Timothy Penner via 4D_Tech
> Sent: Wednesday, May 10, 2017 1:34 PM
> To: 4D iNug Technical
> Cc: Timothy Penner
> Subject: RE: SMTP error 10113 Error with Authentication
>
> David,
>
> Just a wild guess - Is there a strange character in the password?
> If so, maybe the character is being handled differently on 4D Server?
> I don't know why this would be the case, I just thought it might give you
> something to investigate.
>
> -Tim
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Object focusable/tabable properties

[Jim Crate via 4D_Tech]

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

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

Re: Creating .docx files

[Patrick Emanuel via 4D_Tech]

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 document($script)
$script_t:=""
$script_t:=$script_t+"createSection();\r"  // portrait by
default
$script_t:=$script_t+"$section->getSettings()->setPageNumberingStart(1);\r"
$script_t:=$script_t+"$section->addText(htmlspecialchars('"+Export_Echappement
($Texte)+"'));\r"
$script_t:=$script_t+"$objWriter=\\PhpOffice\\PhpWord\\IOFactory::createWriter($PHPWord,
'Word2007');\r"
$script_t:=$script_t+"$objWriter->save('"+$NomSortie+"');\r ?>"


CONVERT FROM TEXT($script_t;"UTF-8";$Blob)
$Texte:=Convert to text($Blob;"UTF-8")
SEND PACKET($PhpCode;$Texte)
CLOSE DOCUMENT($PhpCode)

SET DATABASE PARAMETER(PHP use external interpreter;0)
$OK:=PHP Execute("";"quit_4d_php")
PHP SET OPTION(PHP raw result;True)
$OK:=PHP Execute("";"relaunch_4d_php")
DELAY PROCESS(Current process;20)

ON ERR CALL("PHP_Error")
While (($isOK=False) & ($compteur<3))  // Try 3 times before exit
$Progression:=$Progression+$pas
$compteur:=$compteur+1
$isOK:=PHP Execute($script;"";$result)
DELAY PROCESS(Current process;15)  // 1/4 seconde delay
End while

$isOK:=PHP Execute("";"quit_4d_php")





-
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Creating .docx files

[Pat Bensky via 4D_Tech]

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 2018 at 14:29, Pat Bensky  wrote:

> Oh wow ... I'm going to give phpword a try. thanks for the suggestion.
>
> On 21 January 2018 at 20:47, Dani Beaubien via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> +1 for phpword. I have been using for the last few months and it is fast
>> and works very well.
>>
>> Dani
>>
>>
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
>>
>
>
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889 <+44%2020%207118%207889>
> w: http://www.catbase.com
> skype: pat.bensky
> *
>



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Dialog return value without process variables

[Wayne Stewart via 4D_Tech]

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/waynestewart



On 24 January 2018 at 10:18, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> 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.
>
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
>
>
>
>
> > On Jan 23, 2018, at 6:13 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > 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 back to the method?
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Dialog return value without process variables

[Timothy Penner via 4D_Tech]

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.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Dialog return value without process variables

[Jeffrey Kain via 4D_Tech]

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.

--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Jan 23, 2018, at 6:13 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 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 back to the 
> method?

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

Dialog return value without process variables

[Jim Crate via 4D_Tech]

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 back to the 
method?

Jim Crate

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

Re: SQL CASE statement?

[Tony Ringsmuth via 4D_Tech]

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

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

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

[Keisuke Miyako via 4D_Tech]

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



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

Re: v16 List Box Set Enterable not working?

[Jim Crate via 4D_Tech]

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 item"
> OBJECT SET ENTERABLE(ar_invBalance{$row};True) 
> EDIT ITEM(ar_invBalance;$row) 

When I went back to the code to try OBJECT SET ENTERABLE, I noticed I was using 
a reference to the listbox, not the column. I corrected that and now it works.

Jim Crate

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

Re: v16 List Box Set Enterable not working?

[Kirk Brooks via 4D_Tech]

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'm trying to think of how I deal with these sorts of things. I never seem
to bump into this issue so it must be something about the way I go about
adding row. Typically I separate the action of updating a listbox from
navigation and user interaction. Perhaps you can modify the method a little
bit to do the same.

Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*


On Tue, Jan 23, 2018 at 6:22 AM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> On Jan 22, 2018, at 11:30 AM, Kirk Brooks via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> I suspect it is related to calling EDIT ITEM in the same “run loop” when
> the row is added,
>
>
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v16 List Box Set Enterable not working?

[Patrick Emanuel via 4D_Tech]

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



-
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v16 List Box Set Enterable not working?

[Patrick Emanuel via 4D_Tech]

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 array.

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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: User Custom Forms

[Chip Scheide via 4D_Tech]

> *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 to the correct location the .4DA 
file from a (predefined) location.
- edit/create form(s)
- On end of edit session, copy to the .4DA file back to the 
(predefined) location.

you could even keep old versions of the .4DA file(s) to allow backing 
out one or more changes.

P.S. -
(hopefully) within the next 2 weeks I'll be releasing a file 
manipulation component which includes auto numbering of files during 
copy/move.

Chip
---
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SQL CASE statement?

[Tony Ringsmuth via 4D_Tech]

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:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: User Custom Forms

[Pat Bensky via 4D_Tech]

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.
>
> 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 AM, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > (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 place ALL fields from the table
> on
> > the form, and set them as Invisible. Then have a list of fields that the
> > user can choose from and make the selected field(s) visible. Then if they
> > want to delete a field, we just make it invisible again. Is there a
> better
> > way to manage this?
> >
> > *​2. Stability*
> > ​I'm currently working with v16r5 and I am finding these editable forms
> to
> > be very unstable. Many crashes and strange behaviour. Is this usual or
> just
> > because it's a beta version?
> >
> > *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.
> >
> > *4. Any other comments?*
> > Any suggestions, or gotchas, you would like to share about this topic?
> >
> >
> > Thanks!
> >
> > Pat
> >
> > --
> > *
> > CatBase - Top Dog in Data Publishing
> > tel: +44 (0) 207 118 7889
> > w: http://www.catbase.com
> > skype: pat.bensky
> > *
> > **
> > 4D Internet Users Group (4D iNUG)
> > FAQ:  http://lists.4d.com/faqnug.html
> > Archive:  http://lists.4d.com/archives.html
> > Options: http://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: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: User Custom Forms

[Keith Culotta via 4D_Tech]

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 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> (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 place ALL fields from the table on
> the form, and set them as Invisible. Then have a list of fields that the
> user can choose from and make the selected field(s) visible. Then if they
> want to delete a field, we just make it invisible again. Is there a better
> way to manage this?
> 
> *​2. Stability*
> ​I'm currently working with v16r5 and I am finding these editable forms to
> be very unstable. Many crashes and strange behaviour. Is this usual or just
> because it's a beta version?
> 
> *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.
> 
> *4. Any other comments?*
> Any suggestions, or gotchas, you would like to share about this topic?
> 
> 
> Thanks!
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

User Custom Forms

[Pat Bensky via 4D_Tech]

(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 place ALL fields from the table on
the form, and set them as Invisible. Then have a list of fields that the
user can choose from and make the selected field(s) visible. Then if they
want to delete a field, we just make it invisible again. Is there a better
way to manage this?

*​2. Stability*
​I'm currently working with v16r5 and I am finding these editable forms to
be very unstable. Many crashes and strange behaviour. Is this usual or just
because it's a beta version?

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

*4. Any other comments?*
Any suggestions, or gotchas, you would like to share about this topic?


Thanks!

Pat

-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v16 List Box Set Enterable not working?

[Jim Crate via 4D_Tech]

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 enterability of the 'object'
> which is the listbox column.
> To control the enterability of an individual cell you use the On Before
> Data Entry form event.

In my case, the column is marked Enterable in the property list, and editing 
items works. What doesn’t work is calling EDIT ITEM to place the user in 
editing mode. In my case I want to add an item to the end of the list, scroll 
to it, and start editing (cursor is active, user just has to type). 

I suspect it is related to calling EDIT ITEM in the same “run loop” when the 
row is added, but the scroll works, and 4D makes it too obnoxious to run code 
“later” to bother trying. I did try wrapping EDIT ITEM in a method so I could 
use CALL FORM, but it didn’t change anything; maybe CALL FORM does not actually 
queue the message to run “later” in the case where it is being called from the 
form to run something on. SET TIMER is too annoying to use in all but the most 
necessary cases, and an extra click from the user wasn’t necessary enough.

Jim Crate

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

Re: 4D SQL Question

[John DeSoi via 4D_Tech]

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 quickly create a 
selection with the number of rows in the query. The columns are filled with the 
query results from the cache (using formula columns). If the user scrolls 
passed the cached values, the listbox automatically refills the cache with new 
records based on the displayed row number.

It is somewhat complicated to implement, but provide a seamless interface for 
scrolling large record sets without loading everything into memory.

John DeSoi, Ph.D.



> On Jan 23, 2018, at 7:22 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 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?

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

Re: 4D SQL Question

[Jim Dorrance via 4D_Tech]

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

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

[Florian Pöck via 4D_Tech]

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 are not part of those exports.



Any help is appreciated


Best regards

Florian

--
 - Stromversorgungen für industrielle Anwendungen -
 - Power supplies for industrial applications -

Kniel System-Electronic GmbH
Postfach/Postbox 210849 - 76158  Karlsruhe - Deutschland/Germany
Telefon/Phone +49 721 95920 - Fax +49 721 9592100
www.kniel.de
-
Geschäftsführer/Managers:
Dipl. Ing. (FH) Helmut Kniel
Dipl. Ing. (FH) Dieter Bretschneider
Hannelore Gob
USt-ID/VAT-ID: DE 143 598 834
Amtsgericht Mannheim, HRB 101538

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

Re: 4D SQL Question

[Jim Dorrance via 4D_Tech]

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 [myTable] LIMIT 0 into LISTBOX :myListbox;
>
> End SQL
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



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

Re: 4D SQL Question

[Jim Dorrance via 4D_Tech]

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



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

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

[Tilman Haerdle via 4D_Tech]

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 instead 
of the blocked cell. Clicking more or less should lead to nothing, of course 
any indication that the individual cell is locked would be nice. But then when 
tabbing we can reach the cell from two directions which makes things more 
complicated. This is manageable through keeping tabs on which cell the user 
edited last but still imagining doing that work manually seems a bit off since 
it is rather easy for 4D to provide something like a "next cell" information 
given the tab order the cells are in and whether the user tabbed or 
shift-tabbed into a locked cell.

Tilman

Am 23.01.2018 um 04:30 schrieb Lloyd SIgler via 4D_Tech 
<4d_tech@lists.4d.com>:

Okay, it works as expected when you make area ‘Enterable’ in Property List. No 
requirement  to to put it in the  “On Before Data Entry”.

Evidently, v14 allowed overriding that setting in code, which I personally 
prefer since it eliminates the need to add code to make it unenterable.

Lloyd


On Jan 22, 2018, at 1:19 PM, Lloyd Sigler via 4D_Tech 
<4d_tech@lists.4d.com> wrote:

I will try that approach, but seems that the code 'should' work since the row 
and column are specified. Makes cleaner code to deal with it all in one place, 
in this case I have a boolean that gets ‘checked’ if we are paying an invoice, 
and it then ‘unlocks’  the ‘amount’ in that row and puts cursor there to edit 
the amount being paid on the open invoice.

Lloyd Sigler
4...@siglergroup.com




On Jan 22, 2018, at 8: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 enterability of the 'object'
which is the listbox column.
To control the enterability of an individual cell you use the On Before
Data Entry form event.

It may seem a bit odd to have an object method return a value but that's
how it works.


Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*


On Mon, Jan 22, 2018 at 8:07 AM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com
wrote:

On Jan 21, 2018, at 10:41 PM, 4d--- via 4D_Tech <4d_tech@lists.4d.com>
wrote:

The following works fine in v14, but in v16 doesn’t work. Is this a
known issue??

OBJECT SET ENTERABLE(ar_invBalance{$row};True)
EDIT ITEM(ar_invBalance;$row)

I tried EDIT ITEM in v16 last week and it didn’t work for me either.

Jim Crate

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