Re: Macro question - using project methods in a macro

[Keisuke Miyako via 4D_Tech]

there is no need to use the clipboard.

I don't which example you saw, but I have always used SET MACRO PARAMETER since 
v11 (Macros v2).

One piece of advise is to protect the method called from macro by doing 
something like

Macro_MyMethod(;)

C_TEXT($1;$2)

$methodName:=$1
$methodPath:=$2

If ($methodPath#Current method path)

GET MACRO PARAMETER(Full method text;$methodCode)

//do stuff

SET MACRO PARAMETER(Full method text;$adjustedMethodCode)

End if

you want to exclude the macro method from accidentally editing itself.

2018/07/06 7:08、Kirk Brooks via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
I found some examples on Miyako's github where he would do something
similar but then put the result into the clipboard.



**
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: Macro question - using project methods in a macro

[Wayne Stewart via 4D_Tech]

Kirk,

Download the 4D Pop source code and look at the macros component for
some examples.

Regards,

Wayne




On 6 July 2018 at 10:47, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote:
> Kirk,
>
> I think you are looking for GET MACRO PARAMETER and SET MACRO PARAMETER. In 
> the method called by your macro, that allows you to get/set the selection or 
> the entire method.
>
> John DeSoi, Ph.D.
>
>
>
>> On Jul 5, 2018, at 5:08 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>>
>> I haven't tinkered with my macros in quite a while. Today I was trying to
>> write a project method that returns some text. The idea being to run the
>> method from a macro and plug the result directly into the method being
>> edited. Here's the what I was working with:
>> > version="2"
>> in_menu="true"
>> type_ahead="true"
>> type_ahead_text="rd1">
>> resdoc_macro()
>> 
>
> **
> 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
**

Re: Macro question - using project methods in a macro

[John DeSoi via 4D_Tech]

Kirk,

I think you are looking for GET MACRO PARAMETER and SET MACRO PARAMETER. In the 
method called by your macro, that allows you to get/set the selection or the 
entire method.

John DeSoi, Ph.D.



> On Jul 5, 2018, at 5:08 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I haven't tinkered with my macros in quite a while. Today I was trying to
> write a project method that returns some text. The idea being to run the
> method from a macro and plug the result directly into the method being
> edited. Here's the what I was working with:
>  version="2"
> in_menu="true"
> type_ahead="true"
> type_ahead_text="rd1">
> resdoc_macro()
> 

**
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: Date entry

[Timothy Penner via 4D_Tech]

> I'm using v16r6 and it won't let me revert to 16.3.

Just to clarify, this is likely because object notation has been enabled; which 
essentially upgrades the structure file from v16 to v17, making it unable to be 
opened in v16 afterwards.

See this image and the warning about it not being able to be undone: 
http://kb.4d.com/kbase/assets/images/77824-1.jpg

-Tim



**
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: What Happened to 4D v16 r6?

[Timothy Penner via 4D_Tech]

Yeah, it is safe to continue using v16R6; the removal from the website was 
unintentional.

-Tim




From: Alan Tilson [mailto:alantil...@gmail.com]
Sent: Thursday, July 05, 2018 4:25 PM
To: Timothy Penner 
Cc: 4D_Tech <4d_tech@lists.4d.com>
Subject: Re: What Happened to 4D v16 r6?

Hello Timothy,
Thanks for the info so I can relax and keep using r6!
Alan
sent from my Note 4

On Thu, Jul 5, 2018, 6:56 PM Timothy Penner 
mailto:tpen...@4d.com>> wrote:
Hi Alan,

Looks like a snafu with the web site (perhaps the content got rolled back?)

We are checking with the team on the website content.

In the meantime, here is a direct link for v16R6:
http://download.4d.com/Products/Current/4D_v16R6/Installers/

-Tim




Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States

Telephone: +1-408-557-4600
Fax:   +1-408-271-5080
Email: tpen...@4d.com
Web:   www.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
**

Re: What Happened to 4D v16 r6?

[Alan Tilson via 4D_Tech]

Hello Timothy,
Thanks for the info so I can relax and keep using r6!
Alan

sent from my Note 4

On Thu, Jul 5, 2018, 6:56 PM Timothy Penner  wrote:

> Hi Alan,
>
> Looks like a snafu with the web site (perhaps the content got rolled
> back?)
>
> We are checking with the team on the website content.
>
> In the meantime, here is a direct link for v16R6:
> http://download.4d.com/Products/Current/4D_v16R6/Installers/
>
> -Tim
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose,CA 95113
> United States
>
> Telephone: +1-408-557-4600
> Fax:   +1-408-271-5080
> Email: tpen...@4d.com
> Web:   www.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
**

Re: What Happened to 4D v16 r6?

[Kirk Brooks via 4D_Tech]

On Thu, Jul 5, 2018 at 3:56 PM Timothy Penner via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Looks like a snafu with the web site (perhaps the content got rolled
> back?)
>

​Well, yeah - I've done that too...​

-- 
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: What Happened to 4D v16 r6?

[Timothy Penner via 4D_Tech]

Hi Alan,

Looks like a snafu with the web site (perhaps the content got rolled back?)

We are checking with the team on the website content.

In the meantime, here is a direct link for v16R6:
http://download.4d.com/Products/Current/4D_v16R6/Installers/

-Tim




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

Macro question - using project methods in a macro

[Kirk Brooks via 4D_Tech]

Hi folks,
I haven't tinkered with my macros in quite a while. Today I was trying to
write a project method that returns some text. The idea being to run the
method from a macro and plug the result directly into the method being
edited. Here's the what I was working with:

resdoc_macro()


Is this possible?

I found some examples on Miyako's github where he would do something
similar but then put the result into the clipboard. So, I thought, I guess
that's what I have to do. So I changed the method to put the result into
the clipboard and then attempted to get the clipboard within the macro:

resdoc_macro()





​My thinking here is, put the text into the clipboard and then get the
clipboard. This doesn't work (v15.5).

What does work is running the macro (puts the text into the clipboard) and
the pasting manually. Adequate in this case but I'm thinking I must be
missing something. Here's hoping one of you macro aficionados can help me
out. ​

Thanks

-- 
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: What Happened to 4D v16 r6?

[Kirk Brooks via 4D_Tech]

Just speculating (based on why I would do something like that) - some
really bad thing was found that happens rarely but is very, very bad when
it does.

On Thu, Jul 5, 2018 at 1:43 PM Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Weird...
>
> > On Jul 5, 2018, at 4:14 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hello,
> >
> > I have been working with v16 r6 for a while and I was going to download
> it
> > again on another machine and only r4 is available.
> >
> > Can someone shed some light on this?
>
> **
> 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
> **



-- 
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: Alternating Background Colors in a List form

[Chip Scheide via 4D_Tech]

more flexible...

List form = listbox
OBJECT SET RGB COLORS(Listbox reference ; (foreground) text color; 
background color; alternate background color)

List form = 4D 'standard' type output form. 
not sure

On Thu, 05 Jul 2018 16:52:53 -0400, Jim Medlen via 4D_Tech wrote:
> 
> Is there a way to have alternating background colors for a List Form ?
> 
> Thanks,
> 
> Jim Medlen
> Computer & Information Systems
> Functional Devices, Inc.
> j.med...@functionaldevices.com
> phone (765) 883-5538 x 428
> fax (765) 883-4262
> http://www.functionaldevices.com
> 
> This email was transmitted on 100 percent recycled electrons
> 
> 
> 
> 
> **
> 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
> **
---
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: Alternating Background Colors in a List form

[Wayne Stewart via 4D_Tech]

Jim,

Did you mean an output form (or included form) and not a list box?

Place a rectangle behind the detail area of the form and run the
following code in the on display detail event:

: (Form event=On Display Detail)

If (Displayed line number%2=0)
OBJECT SET RGB COLORS(*;"RowBackground";-1;0x00FF)
Else
OBJECT SET RGB COLORS(*;"RowBackground";-1;0x00EDF3FE )
End if



Regards,

Wayne




On 6 July 2018 at 07:05, Charles Miller via 4D_Tech
<4d_tech@lists.4d.com> wrote:
> Yes, Do you want to know how? Not what you asked, but read down a few blank
> lines
>
>
>
>
>
>
>
>
>
>
>
>
>
> Select list box goto backgound and border in properties
>
>
> Regards
>
> Chuck
> OK here is how
>
> On Thu, Jul 5, 2018 at 4:52 PM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com
>> wrote:
>
>>
>> Is there a way to have alternating background colors for a List Form ?
>>
>> Thanks,
>>
>> Jim Medlen
>> Computer & Information Systems
>> Functional Devices, Inc.
>> j.med...@functionaldevices.com
>> phone (765) 883-5538 x 428
>> fax (765) 883-4262
>> http://www.functionaldevices.com
>>
>> This email was transmitted on 100 percent recycled electrons
>>
>>
>>
>>
>> **
>> 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
>> **
>
>
>
>
> --
> -
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D, Sybase & SQL Server connectivity
>   http://www.informed-solutions.com
> -
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **
> 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
**

Alternating Background Colors in a List form

[Jim Medlen via 4D_Tech]

Is there a way to have alternating background colors for a List Form ?

Thanks,

Jim Medlen
Computer & Information Systems
Functional Devices, Inc.
j.med...@functionaldevices.com
phone (765) 883-5538 x 428
fax (765) 883-4262
http://www.functionaldevices.com

This email was transmitted on 100 percent recycled electrons




**
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: What Happened to 4D v16 r6?

[Jeffrey Kain via 4D_Tech]

Weird...

> On Jul 5, 2018, at 4:14 PM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello,
> 
> I have been working with v16 r6 for a while and I was going to download it
> again on another machine and only r4 is available.
> 
> Can someone shed some light on this?

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

What Happened to 4D v16 r6?

[Alan Tilson via 4D_Tech]

Hello,

I have been working with v16 r6 for a while and I was going to download it
again on another machine and only r4 is available.

Can someone shed some light on this?

Thanks,
Alan
**
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: Quitting without IP var?

[Timothy Penner via 4D_Tech]

Hi Chip,

You don’t need to use an interprocess variable... You can use a process 
variable as described in this tech tip:

Tech Tip: Always make sure your Stored Procedure is able to gracefully quit
http://kb.4d.com/assetid=77839

Quote Chip:
> the method called from exiting the program (menu_Quit) runs the loop over the 
> processes
>
> For count processes
>   resume process
>   call process

This is very important! If you are looping over all process like this then make 
sure you only mess with the processes that you created and do not try to change 
the execution status of the processes you did not create. Check the following 
tech tip for more information and a safe way to wake up your processes (check 
process properties and verify that the origin is greater than 0):

Tech Tip: Waking up processes that are either delayed or paused
http://kb.4d.com/assetid=78077

Kind Regards,

Tim PENNER



**
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: UUID version 4 needed

[Dennis, Neil via 4D_Tech]

> As far as I know most computers generate pseudo random and if so will 
> increase chance of UUID's colliding no?

Correct

> However it would be an advantage to "know" what the limitations (of what we 
> mostly use to generate unique keys) are

For there to be a one in a billion chance of duplication, 103 trillion version 
4 UUIDs must be generated 
(https://en.wikipedia.org/wiki/Universally_unique_identifier)

Neil






--

Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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: UUID version 4 needed

[Keisuke Miyako via 4D_Tech]

I'm not sure how that would solve any uncertainties.

4D is a native Win32/Cocoa/Carbon app,
so it would be natural to assume that it simply calls

UuidCreate on Windows and
[NSUUID UUID] or CFUUIDCreate on Mac.

but will then go on to ask Apple and Microsoft the same question?
as already pointed out, the version is apparent from the value itself.

> 2018/07/06 1:00、Jim Labos - infobase via 4D_Tech <4d_tech@lists.4d.com> のメール：
> This brings up the question of shouldn't 4D confirm what method they are
> using?



**
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: UUID version 4 needed

[Piotr Chabot Stadhouders via 4D_Tech]

Hi Neil,

For some reason I thought it is not version 4. I hope you are right!

@Steven :
Unfortunately the webservice we are talking with demands a message with a UUID 
version 4 generated message ID. Don't ask me why.

Gr,

Piotr

> -Oorspronkelijk bericht-
> Van: Dennis, Neil 
> Verzonden: donderdag 5 juli 2018 17:06
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> CC: Piotr Chabot Stadhouders 
> Onderwerp: RE: UUID version 4 needed
> 
> > Does anybody know how to generate an UUID version 4
> 
> Doesn't 4D already generate version 4 UUIDs? In version 4 the 15th hex digit 
> is
> always a 4, it seems that this is what 4D uses.
> 
> If you need a good explanation, of the various types, wikipedia works
> https://en.wikipedia.org/wiki/Universally_unique_identifier
> 
> Neil
> 

**
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: UUID version 4 needed

[Jim Labos - infobase via 4D_Tech]

This brings up the question of shouldn't 4D confirm what method they are
using?

The random (version 4) does rely on the host computer's system to generate
the randomness I would assume so that becomes the weakness (according to the
definitions). As far as I know most computers generate pseudo random and if
so will increase chance of UUID's colliding no? Albeit the chances are still
astronomical. However it would be an advantage to "know" what the
limitations (of what we mostly use to generate unique keys) are.

Cheers



-
Jim Labos - infobase
--
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: Date entry

[Jody Bevan via 4D_Tech]

Pat:

I was a lot of work. Especially going through a large application and changing 
it all over. We got forced into it by regulation of supporting different date 
formats across different government regulatory regions. So we decided to just 
do it the flexible way and provide many more features than needed. I noticed 
when training new users how I felt  the relief on not having to continually 
remind them of the date format. 

Now with our new business, most certainly starting over with our shell and 
having this from the beginning of each new project is much easier.

Jody


> On Jul 5, 2018, at 9:01 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks Jody - yes I can follow all that, no problem :)
> Sounds like a fair bit of work though, which I would prefer to avoid ...
> 
> PB
> 
> 

**
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: UUID version 4 needed

[Dennis, Neil via 4D_Tech]

> Does anybody know how to generate an UUID version 4

Doesn't 4D already generate version 4 UUIDs? In version 4 the 15th hex digit is 
always a 4, it seems that this is what 4D uses.

If you need a good explanation, of the various types, wikipedia works 
https://en.wikipedia.org/wiki/Universally_unique_identifier

Neil











Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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: Date entry

[Pat Bensky via 4D_Tech]

Thanks Jody - yes I can follow all that, no problem :)
Sounds like a fair bit of work though, which I would prefer to avoid ...

PB

On Thu, 5 Jul 2018 at 15:37, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Pat:
>
> In Canada every possible date format was used by different clients.
> Therefore we had to write our own date handler. Essentially we handle it
> this way:
>
> 1. We let the system administrator set the format for all dates to be
> displayed. This includes all the ways 4D has built in way, but also in
> other ways that silly Canadians have dreamt up.
>
> 2. Where ever a date is displayed we use a Alphanumeric variable. We take
> the date as stored by 4D and we run it through our utility method to create
> a string in the format that the system administrator has set it to display.
> In this way no matter how a workstation is configured, the date is always
> displayed in a consistent format in our system.
>
> 3. The next nasty issue is date entry. For this we permit two options:
>
> a) The system administrator sets up an entry filter using our
> interface. Nothing fancy, the user must enter a fully formatted date, OR
> b) They decide to use our date entry system which makes for very
> quick entry of dates. I may be attributing this feature to the wrong person,
>  but I think I read about  it in a Dimensions article by
> Dave Baton (anyone correct me if I am wrong).
> Over the years we have enhanced it a lot to make date
> entries very quick.
> The variable on screen where it is entered is a Alpha
> variable. They can enter things like T, 5d, 6m, -1W, etc to get a fully
> formatted date that
> our system will accept to turn into a 4D Date. They can
> also enter 2016, or 16 and tab out to get todays date but in 2016. If they
> enter 2018-12, they will get
> a date for December 12, of the current year.
> c) We also have a button to take them to a Calendar ‘widget’ for
> the mousers in the user base.
>
> In all the entry examples above we have a method that runs and
> makes a properly formatted date that 4D will accept, place that date in the
> database.
> The system takes that 4D formatted date, and makes the display
> date.
>
> This certainly adds processing time when displaying thousands of
> record in a listbox (i.e. our 1 form Listbox for an output of all tables).
> We have fine tuned this
> code in our v16 shell so that once compiled it runs along nicely.
> 4D version 17 with it’s more intelligent Listbox will speed this up as it
> only deals with the rows
> that are visible on screen.
>
> If that makes sense great - if not let me know where I lost you and I will
> try to explain better.
>
> Jody
>
>
> > On Jul 5, 2018, at 4:50 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Jody,
> > I'm using v16 and having the following problem with date formats:
> > On a UK system, dates in fields and list boxes are incorrectly displayed
> in
> > the US format. But when you click into a date field, it changes to the UK
> > format!
> >
> > How do you manage this?
> >
> > Pat
> >
> > On Sun, 10 Jun 2018 at 15:46, Jody Bevan via 4D_Tech <
> 4d_tech@lists.4d.com>
> > wrote:
> >
> >> Bob:
> >>
> >> Nasty date formats. About 15 years ago we created our own tool for the
> >> date entry, and display in 4D. The dates are always stored in date
> fields,
> >> but we let the user define the way the dates get displayed. This way it
> >> does not matter what the computer’s region or date settings are. The
> format
> >> set in the application controls the display of the date. It also
> resulted
> >> in some great tools for quick entry of dates. Still loving that way of
> >> doing thing in v16.
> >>
> >> Jody
> >>
> >>
> >>> On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech <
> >> 4d_tech@lists.4d.com> wrote:
> >>>
> >>> 4D V15.4, Mac OS 10.13.4
> >>>
> >>> A site that uses 4D Server. Mostly mini’s as clients. Has been working
> >> fine for years. Then growth, so someone brought in some PC’s. Then they
> >> scrounged around and now all minis. But, since we are in Canada,
> sometimes
> >> when the OS is loaded anew, this select Canadian English keyboard
> instead
> >> of US. So, date entry gets set to -MM-DD instead of MM-DD-.
> >>>
> >>> Dates display fine, regardless of format. But, on a couple of machines,
> >> you can not enter dates. I take my record, place the cursor in the
> field,
> >> and type - it moves the cursor along the character string, but nothing
> >> changes. So, they just go to another machine that ‘works’ and does the
> >> entry there. Started a couple of weeks ago.
> >>>
> >>> So, why, and how to fix it?
> >>>
> >>> Changing the date format in the system preferences changes the way it
> is
> >> displayed, but still no entry.
> >>>
> >>> _
> >>> Bob McKeever  

RE: UUID version 4 needed

[Stephen J. Orth via 4D_Tech]

Piotr,

I'm curious why you would need a V4 version, because the only difference 
between the two types is "uniqueness" versus "randomness".

Best,


Steve


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Piotr Chabot 
Stadhouders via 4D_Tech
Sent: Thursday, July 05, 2018 9:54 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Piotr Chabot Stadhouders 
Subject: UUID version 4 needed

Hi all,

I need to generate an UUID but it MUST be version 4
I know in 4D there is the command Generate UUID and the NTK plugin has the 
command NTK Create UUID but as far as I know they both are not UUID version 4

Does anybody know how to generate an UUID version 4?

Thanks,

Piotr

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

UUID version 4 needed

[Piotr Chabot Stadhouders via 4D_Tech]

Hi all,

I need to generate an UUID but it MUST be version 4
I know in 4D there is the command Generate UUID and the NTK plugin has the 
command NTK Create UUID but as far as I know they both are not UUID version 4

Does anybody know how to generate an UUID version 4?

Thanks,

Piotr

**
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: Date entry

[Jody Bevan via 4D_Tech]

Pat:

In Canada every possible date format was used by different clients. Therefore 
we had to write our own date handler. Essentially we handle it this way:

1. We let the system administrator set the format for all dates to be 
displayed. This includes all the ways 4D has built in way, but also in other 
ways that silly Canadians have dreamt up.

2. Where ever a date is displayed we use a Alphanumeric variable. We take the 
date as stored by 4D and we run it through our utility method to create a 
string in the format that the system administrator has set it to display. In 
this way no matter how a workstation is configured, the date is always 
displayed in a consistent format in our system.

3. The next nasty issue is date entry. For this we permit two options:

a) The system administrator sets up an entry filter using our 
interface. Nothing fancy, the user must enter a fully formatted date, OR
b) They decide to use our date entry system which makes for very quick 
entry of dates. I may be attributing this feature to the wrong person,
 but I think I read about  it in a Dimensions article by Dave 
Baton (anyone correct me if I am wrong). 
Over the years we have enhanced it a lot to make date entries 
very quick.
The variable on screen where it is entered is a Alpha variable. 
They can enter things like T, 5d, 6m, -1W, etc to get a fully formatted date 
that
our system will accept to turn into a 4D Date. They can also 
enter 2016, or 16 and tab out to get todays date but in 2016. If they enter 
2018-12, they will get
a date for December 12, of the current year.
c) We also have a button to take them to a Calendar ‘widget’ for the 
mousers in the user base.

In all the entry examples above we have a method that runs and makes a 
properly formatted date that 4D will accept, place that date in the database.
The system takes that 4D formatted date, and makes the display date.

This certainly adds processing time when displaying thousands of record 
in a listbox (i.e. our 1 form Listbox for an output of all tables). We have 
fine tuned this
code in our v16 shell so that once compiled it runs along nicely. 4D 
version 17 with it’s more intelligent Listbox will speed this up as it only 
deals with the rows
that are visible on screen.

If that makes sense great - if not let me know where I lost you and I will try 
to explain better.

Jody


> On Jul 5, 2018, at 4:50 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Jody,
> I'm using v16 and having the following problem with date formats:
> On a UK system, dates in fields and list boxes are incorrectly displayed in
> the US format. But when you click into a date field, it changes to the UK
> format!
> 
> How do you manage this?
> 
> Pat
> 
> On Sun, 10 Jun 2018 at 15:46, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Bob:
>> 
>> Nasty date formats. About 15 years ago we created our own tool for the
>> date entry, and display in 4D. The dates are always stored in date fields,
>> but we let the user define the way the dates get displayed. This way it
>> does not matter what the computer’s region or date settings are. The format
>> set in the application controls the display of the date. It also resulted
>> in some great tools for quick entry of dates. Still loving that way of
>> doing thing in v16.
>> 
>> Jody
>> 
>> 
>>> On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> 4D V15.4, Mac OS 10.13.4
>>> 
>>> A site that uses 4D Server. Mostly mini’s as clients. Has been working
>> fine for years. Then growth, so someone brought in some PC’s. Then they
>> scrounged around and now all minis. But, since we are in Canada, sometimes
>> when the OS is loaded anew, this select Canadian English keyboard instead
>> of US. So, date entry gets set to -MM-DD instead of MM-DD-.
>>> 
>>> Dates display fine, regardless of format. But, on a couple of machines,
>> you can not enter dates. I take my record, place the cursor in the field,
>> and type - it moves the cursor along the character string, but nothing
>> changes. So, they just go to another machine that ‘works’ and does the
>> entry there. Started a couple of weeks ago.
>>> 
>>> So, why, and how to fix it?
>>> 
>>> Changing the date format in the system preferences changes the way it is
>> displayed, but still no entry.
>>> 
>>> _
>>> Bob McKeever  http://www.mswl.com <
>> http://www.mswl.com/>
>>> McKeever's Software Wizardry
>>> Port Coquitlam, B.C.
>>> bobmckee...@mac.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
>> 

Re: Date entry

[Chip Scheide via 4D_Tech]

I am not using anything near v16... but have you tried to explicitly 
set the display format for the date areas during On Load, using code?
set object format(*"object_name";Date_format)

On Thu, 5 Jul 2018 12:43:55 +0100, Pat Bensky via 4D_Tech wrote:
> Thanks Wayne.
> I'm using v16r6 and it won't let me revert to 16.3. I don't think v17 is
> ready for prime time yet ... Grrr! So, anybody got a suggestion for a
> workaround?
> 
> PB
> 
> On Thu, 5 Jul 2018 at 12:23, Wayne Stewart via 4D_Tech 
> <4d_tech@lists.4d.com>
> wrote:
> 
>> Pat,
>> 
>> There’s a 4D bug regarding dates.
>> 
>> What version of v16 are you using?  The latest nightly builds of v16 dot
>> releases should be fine.
>> 
>> If you’re using 16r something, then it’s fixed in v17.
>> 
>> Wayne
>> 
>> On Thu, 5 Jul 2018 at 20:50, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>> 
>>> Jody,
>>> I'm using v16 and having the following problem with date formats:
>>> On a UK system, dates in fields and list boxes are incorrectly displayed
>> in
>>> the US format. But when you click into a date field, it changes to the UK
>>> format!
>>> 
>>> How do you manage this?
>>> 
>>> Pat
>>> 
>>> On Sun, 10 Jun 2018 at 15:46, Jody Bevan via 4D_Tech <
>> 4d_tech@lists.4d.com
 
>>> wrote:
>>> 
 Bob:
 
 Nasty date formats. About 15 years ago we created our own tool for the
 date entry, and display in 4D. The dates are always stored in date
>>> fields,
 but we let the user define the way the dates get displayed. This way it
 does not matter what the computer’s region or date settings are. The
>>> format
 set in the application controls the display of the date. It also
>> resulted
 in some great tools for quick entry of dates. Still loving that way of
 doing thing in v16.
 
 Jody
 
 
> On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech <
 4d_tech@lists.4d.com> wrote:
> 
> 4D V15.4, Mac OS 10.13.4
> 
> A site that uses 4D Server. Mostly mini’s as clients. Has been
>> working
 fine for years. Then growth, so someone brought in some PC’s. Then they
 scrounged around and now all minis. But, since we are in Canada,
>>> sometimes
 when the OS is loaded anew, this select Canadian English keyboard
>> instead
 of US. So, date entry gets set to -MM-DD instead of MM-DD-.
> 
> Dates display fine, regardless of format. But, on a couple of
>> machines,
 you can not enter dates. I take my record, place the cursor in the
>> field,
 and type - it moves the cursor along the character string, but nothing
 changes. So, they just go to another machine that ‘works’ and does the
 entry there. Started a couple of weeks ago.
> 
> So, why, and how to fix it?
> 
> Changing the date format in the system preferences changes the way it
>>> is
 displayed, but still no entry.
> 
> _
> Bob McKeever  http://www.mswl.com <
 http://www.mswl.com/>
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.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
 **
>>> 
>>> 
>>> 
>>> --
>>> *
>>> 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: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **
>> 
>> --
>> 
>> Regards,
>> 
>> Wayne
>> **
>> 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
>> **
> 
> 
> 
> -- 
> *
> 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:  

Re: Date entry

[Pat Bensky via 4D_Tech]

Thanks Wayne.
I'm using v16r6 and it won't let me revert to 16.3. I don't think v17 is
ready for prime time yet ... Grrr! So, anybody got a suggestion for a
workaround?

PB

On Thu, 5 Jul 2018 at 12:23, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Pat,
>
> There’s a 4D bug regarding dates.
>
> What version of v16 are you using?  The latest nightly builds of v16 dot
> releases should be fine.
>
> If you’re using 16r something, then it’s fixed in v17.
>
> Wayne
>
> On Thu, 5 Jul 2018 at 20:50, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > Jody,
> > I'm using v16 and having the following problem with date formats:
> > On a UK system, dates in fields and list boxes are incorrectly displayed
> in
> > the US format. But when you click into a date field, it changes to the UK
> > format!
> >
> > How do you manage this?
> >
> > Pat
> >
> > On Sun, 10 Jun 2018 at 15:46, Jody Bevan via 4D_Tech <
> 4d_tech@lists.4d.com
> > >
> > wrote:
> >
> > > Bob:
> > >
> > > Nasty date formats. About 15 years ago we created our own tool for the
> > > date entry, and display in 4D. The dates are always stored in date
> > fields,
> > > but we let the user define the way the dates get displayed. This way it
> > > does not matter what the computer’s region or date settings are. The
> > format
> > > set in the application controls the display of the date. It also
> resulted
> > > in some great tools for quick entry of dates. Still loving that way of
> > > doing thing in v16.
> > >
> > > Jody
> > >
> > >
> > > > On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech <
> > > 4d_tech@lists.4d.com> wrote:
> > > >
> > > > 4D V15.4, Mac OS 10.13.4
> > > >
> > > > A site that uses 4D Server. Mostly mini’s as clients. Has been
> working
> > > fine for years. Then growth, so someone brought in some PC’s. Then they
> > > scrounged around and now all minis. But, since we are in Canada,
> > sometimes
> > > when the OS is loaded anew, this select Canadian English keyboard
> instead
> > > of US. So, date entry gets set to -MM-DD instead of MM-DD-.
> > > >
> > > > Dates display fine, regardless of format. But, on a couple of
> machines,
> > > you can not enter dates. I take my record, place the cursor in the
> field,
> > > and type - it moves the cursor along the character string, but nothing
> > > changes. So, they just go to another machine that ‘works’ and does the
> > > entry there. Started a couple of weeks ago.
> > > >
> > > > So, why, and how to fix it?
> > > >
> > > > Changing the date format in the system preferences changes the way it
> > is
> > > displayed, but still no entry.
> > > >
> > > > _
> > > > Bob McKeever  http://www.mswl.com <
> > > http://www.mswl.com/>
> > > > McKeever's Software Wizardry
> > > > Port Coquitlam, B.C.
> > > > bobmckee...@mac.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
> > > **
> >
> >
> >
> > --
> > *
> > 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: https://lists.4d.com/mailman/options/4d_tech
> > Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> > **
>
> --
>
> Regards,
>
> Wayne
> **
> 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
> **



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

Re: Date entry

[Wayne Stewart via 4D_Tech]

Pat,

There’s a 4D bug regarding dates.

What version of v16 are you using?  The latest nightly builds of v16 dot
releases should be fine.

If you’re using 16r something, then it’s fixed in v17.

Wayne

On Thu, 5 Jul 2018 at 20:50, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Jody,
> I'm using v16 and having the following problem with date formats:
> On a UK system, dates in fields and list boxes are incorrectly displayed in
> the US format. But when you click into a date field, it changes to the UK
> format!
>
> How do you manage this?
>
> Pat
>
> On Sun, 10 Jun 2018 at 15:46, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com
> >
> wrote:
>
> > Bob:
> >
> > Nasty date formats. About 15 years ago we created our own tool for the
> > date entry, and display in 4D. The dates are always stored in date
> fields,
> > but we let the user define the way the dates get displayed. This way it
> > does not matter what the computer’s region or date settings are. The
> format
> > set in the application controls the display of the date. It also resulted
> > in some great tools for quick entry of dates. Still loving that way of
> > doing thing in v16.
> >
> > Jody
> >
> >
> > > On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> > >
> > > 4D V15.4, Mac OS 10.13.4
> > >
> > > A site that uses 4D Server. Mostly mini’s as clients. Has been working
> > fine for years. Then growth, so someone brought in some PC’s. Then they
> > scrounged around and now all minis. But, since we are in Canada,
> sometimes
> > when the OS is loaded anew, this select Canadian English keyboard instead
> > of US. So, date entry gets set to -MM-DD instead of MM-DD-.
> > >
> > > Dates display fine, regardless of format. But, on a couple of machines,
> > you can not enter dates. I take my record, place the cursor in the field,
> > and type - it moves the cursor along the character string, but nothing
> > changes. So, they just go to another machine that ‘works’ and does the
> > entry there. Started a couple of weeks ago.
> > >
> > > So, why, and how to fix it?
> > >
> > > Changing the date format in the system preferences changes the way it
> is
> > displayed, but still no entry.
> > >
> > > _
> > > Bob McKeever  http://www.mswl.com <
> > http://www.mswl.com/>
> > > McKeever's Software Wizardry
> > > Port Coquitlam, B.C.
> > > bobmckee...@mac.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
> > **
>
>
>
> --
> *
> 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: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 

Regards,

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

Cannot delete if related many issue

[Arnaud de Montard via 4D_Tech]

I have a database in which Deletion Control is set as in the object for a lot 
of relations. Today, deleting 10 records in a table having ~2 billion records 
took an incredible time, cache as shark teeth, unable to connect and so on. 
Finally we had to kill the server. After setting Deletion Control to "none", 
DELETE SELECTION becomes instantaneous. The deleted records had no "sons". 
Searching if there are sons with QUERY(sons;foreign key=primary key) takes a 
few milliseconds. MSC says everything's OK. 4D v14r5. 

Does someone have noticed issues with Deletion Control as "Cannot delete if 
related many"?

-- 
Arnaud de Montard 



**
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: Date entry

[Pat Bensky via 4D_Tech]

Jody,
I'm using v16 and having the following problem with date formats:
On a UK system, dates in fields and list boxes are incorrectly displayed in
the US format. But when you click into a date field, it changes to the UK
format!

How do you manage this?

Pat

On Sun, 10 Jun 2018 at 15:46, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Bob:
>
> Nasty date formats. About 15 years ago we created our own tool for the
> date entry, and display in 4D. The dates are always stored in date fields,
> but we let the user define the way the dates get displayed. This way it
> does not matter what the computer’s region or date settings are. The format
> set in the application controls the display of the date. It also resulted
> in some great tools for quick entry of dates. Still loving that way of
> doing thing in v16.
>
> Jody
>
>
> > On Jun 9, 2018, at 5:49 PM, Robert McKeever via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > 4D V15.4, Mac OS 10.13.4
> >
> > A site that uses 4D Server. Mostly mini’s as clients. Has been working
> fine for years. Then growth, so someone brought in some PC’s. Then they
> scrounged around and now all minis. But, since we are in Canada, sometimes
> when the OS is loaded anew, this select Canadian English keyboard instead
> of US. So, date entry gets set to -MM-DD instead of MM-DD-.
> >
> > Dates display fine, regardless of format. But, on a couple of machines,
> you can not enter dates. I take my record, place the cursor in the field,
> and type - it moves the cursor along the character string, but nothing
> changes. So, they just go to another machine that ‘works’ and does the
> entry there. Started a couple of weeks ago.
> >
> > So, why, and how to fix it?
> >
> > Changing the date format in the system preferences changes the way it is
> displayed, but still no entry.
> >
> > _
> > Bob McKeever  http://www.mswl.com <
> http://www.mswl.com/>
> > McKeever's Software Wizardry
> > Port Coquitlam, B.C.
> > bobmckee...@mac.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
> **



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

Code Signing Failing

[Eric Asadoorian via 4D_Tech]

I have had little success attempting to code sign a C/S built app.

This issue has always been a problem, but one way or another, I have found a 
method to get it to work.

Previously, I had a v13 DB working in Mountain Lion.  I signed the application 
with a Self Signed Cert.  Presently, trying to do the same with the same 
database upgraded to v14 installing in a Yosemite environment.

I have read quite a number of posts on the iNug and elsewhere.  I am aware of 
how the process is failing, but can't seem to understand why.

First, let me say that failure equates to first having success with the code 
signing, but upon first launch of the application, something is written to the 
4DC and 4DIndy files.  Subsequently, checking codesign in Terminal no longer 
reports success.  In addition to those file modifications, codesign also 
reports that

a sealed resource is missing or invalid

My ultimate goal is to stop GateKeeper needing to ask each time the Server part 
of the C/S app is loaded whether or not to accept incoming network connections.

I had thought the problem was due to the fact that Server could not locate the 
data files and once specified, it would note the change, and then that would 
break the code signing.

I resolved that by adding the  XML key.  Now, it does not stop to 
ask.  Yet it still breaks.

Given that I am familiar with having to accept the incoming network connection 
once, I expect to see that on the first start.  After quitting the Server 
application and attempting subsequent loads, it continues to ask.

The first thing that I am curious about is whether or not I can expect to do 
this any longer with a self signed certificate.

Certainly, I can't be the only one installing a C/S built app on to a machine 
with the Firewall Active.  It seems that 4D is going to continue to write 
things somewhere in the package.  It doesn't seem to take much to make the code 
sign break.  Just how does the initial code signing hold up?

FWIW, I attempted to code sign several ways.  First I get rid of the extended 
attributes with xattr -cr, then I run the shell script from the 4D v14 app, 
SignApp.sh, specifying the cert I created for code signing.  I check it once it 
is completed and it shows success.  I have tried it with having the trust 
settings set to System Defaults prior to the code signing and also set to 
Always Trust prior to the code signing, as well as setting to Always Trust 
after the fact.  Nothing has made a difference.

I do not use the built-in code signing feature in v14 build since I need to use 
the self signed cert on the target machine.  Maybe this is the problem?

I am sure there are other details that I am leaving out that I can respond to 
if asked.

Any help would be greatly appreciated. 

Thank you,
Eric Asadoorian

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