RE: V15.4 & Shy Server Syndrome?

[Timothy Penner via 4D_Tech]

Awesome! Thanks for the update, glad to hear it is all sorted out now.

-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: V15.4 & Shy Server Syndrome?

[Douglas von Roeder via 4D_Tech]

Tim:

"99.% of all 4D bugs are self-inflicted"

A code change lead to code running on the server that should not have:

SET WINDOW RECT(-20;-20;-10;-10)

Thanks for your suggestion.


And *another* ticket gets closed…



--
Douglas von Roeder
949-336-2902

On Thu, May 18, 2017 at 4:08 PM, Douglas von Roeder 
wrote:

> Tim:
>
> Excellent suggestions!
>
> This is reminiscent of the "zoom" feature but it zooms toward the upper
> left vs upper right and it's almost like there's a Hide process call.
>
> I'll work through your suggestions ASAP.
>
> Thank you.
>
> --
> Douglas von Roeder
> 949-336-2902 <(949)%20336-2902>
>
> On Thu, May 18, 2017 at 4:02 PM, Timothy Penner  wrote:
>
>> Hi Doug,
>>
>> You mention it happens with the source code too, so with regular 4D
>> Server.exe - but what about a new blank structure file (this is to
>> determine if the issue is specific to the structure or the application)?
>>
>> If it does not happen with a new structure file then try commenting out
>> the On Server Startup code in your structure file then test again. If it
>> goes away then re-enable half of it and repeat until the offending code is
>> found.
>>
>> If it does happen with a new database then try clearing your preferences,
>> maybe it is something in the Window Bounds folder?
>> http://kb.4d.com/assetid=77026
>>
>> hope that helps narrowing it down - give us a call or open a case on
>> taow.4d.com if you need additional help.
>>
>> Tim
>>
>>
>> Timothy Penner
>> Technical Services Engineer
>>
>> 4D Inc
>> 95 S. Market Street, Suite #240
>> CA 95113 San Jose
>> United States
>>
>> Telephone : +1-408-557-4600
>> Standard :  +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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Primary key contains duplicate values

[Ronald Rosell via 4D_Tech]

I ran into this on a conversion once.  Turned out, I was using a Sequence 
Number field as the PK field, and somewhere along the way some code had been 
introduced that led to duplicates.  Usually this was because records were being 
created by multiple methods, and one of them was doing it differently from 
another (one might assign the sequence number, another might be sequence number 
+ 100.  Goofs like that.)  Fortunately there were few records affected, but all 
it takes is one duplicate for the indexing to fail.

If you write a little utility method that collects a Distinct Values array for 
your intended PK in one of the affected tables, then searches all records 
looking for for more than one instance of each value in the Distinct Values 
array, you’ll likely find that you’ve got some duplicates in there.

Ron Rosell
r...@streamlms.com

__

Ron Rosell
President
StreamLMS

301-3537 Oak Street
Vancouver, BC V6H 2M1
Canada

Direct phone (all numbers reach me)
Vancouver: (+1) (604) 628-1933  |  Seattle: (+1) (425) 956-3570  |  Palm Beach: 
(+1) (561) 351-6210 
email: r...@streamlms.com  |  fax: (+1) (815) 301-9058  |  Skype: ronrosell

> On May 19, 2017, at 1:54 PM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I'm hitting the same issue that Gary ran into though I'm trying to convert
> a 2004 data file to run agains the V15.4 structure file.
> 
> I added PK's using the code from Bob Miller's Summit presentation (many
> thanks for a superb presentation Bob!) so I'm comfortable that the PK's are
> done right.
> 
> The issue - when I convert the 2004 data file, 4D reports that 53 out of
> 105 tables have duplicate PK values. What are my options for resolving this
> issue?
> 
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> On Sat, Aug 29, 2015 at 3:09 AM, Ortwin Zillgen  wrote:
> 
>> 
>>> Am 28.08.2015 um 19:37 schrieb Gary Boudreaux :
>>> 
>>> FYI, this issue has been resolved. When I put my "live" data file into
>> the folder with the new structure, I didn't think to delete the old indx
>> file. Once I deleted that file and restarted 4D, the problem went away when
>> 4D rebuilt the index file. So the issue was actually duplicates in the
>> _index_ file, not in the data itself.
>> 
>> thx a lot.
>> Did you tell 4D about that? Suppose, they want to know.
>> 
>> 
>> Regards
>> O r t w i n  Z i l l g e n
>> -
>>    
>>  
>> member of developer-network 
>> 
>> **
>> See how easy it is to extend your 4D solutions to Web and mobile. New
>> opportunities await you with 4D v14!
>> 
>> 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: Exploring CALL WORKER vs New process

[David Adams via 4D_Tech]

> A method called by CALL WORKER
>  $w:=Open Form Window("ShowRecord")
>  Dialog("ShowRecord";*)

> So this is why when using CALL WORKER, the Dialog(*) windows hang around
after the method has been exited.
> This means moving the process ExitCode from the lines after Dialog into a
form's "On Unload" event.

The worker would still be alive even if your dialog is closed - or if you
never even displayed a dialog - that's in the nature of a 4D worker. There
is more to say here about killing/starting/restarting workers and what
happens to their contexts. Try and start them, leave them running, and kill
them only when you're shutting down. That's a good first approach while
sorting through the mechanics.

Fair warning: I haven't done much (anything?) with UI displayed by a
worker, so I may make mistakes. I use workers in their naked/headless form
so that they don't get gummed up with form stuff. If I need UI, I use a
form and use CALL FORM. Why not? A form (window) or a worker can receive
calls, so I pick the version that matches what I need. Forms when I need
UI, Workers when I don't.

Keep in mind that it is the nature of a worker to stay alive when its work
is done...it just waits for new work to arrive. That's in the docs, it's a
deliberate part of their design. That means that if you have, for example,
a loaded record in read write, it blocks any other process from getting a
write on that record. If you want to clear out a worker, you can use KILL
WORKER on the worker itself and that does the trick.


> > but there are functionally two loops
> A forms execution environment could be visualized as:
> If (Worker called)
>   // do worker method
> Else
>   // do form method
> End if
>

I know absolutely nothing about the 4D internals, I'm only offering a
description based on observable behavior. The things to keep in mind here
are that

1) CALL FORM doesn't trigger a form event.
2) Form methods do *not* catch CALL FORM calls.


> > The method has
> > access to all of the process values (variables, etc.) and the "form
> > variables" of the specific form in the specified window.
>
> If several forms were open in a process, would it matter which form was
> called?


You call a window, not a form, not process. That's precisely so that you
can specify which window in a process you're trying to send the code to for
execution. If you aren't using multiple windows in a single process or if
you aren't using 'form variables', then it makes no difference.

* The code executes in the context of the _process_ holding the
window/form. No matter which window/form it is.
* The code has access to the form variables of the form in the specified
window, if you want them.

 A form's local variables are outside the purview of the "Worker called".
> No event is triggered.  Any variable changed need a Call Process (-1) for
> their display to change.
> On the other hand, this is where form object names make the context
> significant?
>

I don't think that I follow what you're saying here.


> Handy use example:
> A method that saves a file, processes it, and deletes the file got a
> significant performance boost when the delete part was handed off to a CALL
> WORKER invoked method.
>

Delegating various file system calls to a worker is, in my opinion, a solid
idea. Particularly if the operation is blocking, or if you find yourself
constantly fighting/waiting for a read lock on the file. (Like the log
example I go back to all of the time.)
**
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 on OSX Application licence

[Timothy Penner via 4D_Tech]

Hi Chuck,

> > > If that is so easy, why does 4D itself not do this
.
> > What do you mean?
> > The apps and DMGs released by 4D are signed with our private certificate.
> > However the apps you build are not signed unless you acquire and add your 
> > certificate to the BUILD APPLICATION dialog.
.
> Perhaps I am remembering older versions, but it often asks if I want to open 
> the first time I launch
.

I think you are talking about this: https://support.apple.com/en-us/HT201940
I think the OP was talking about this: https://support.apple.com/kb/PH25088 
(also discussed here: 
https://www.howtogeek.com/205393/gatekeeper-101-why-your-mac-only-allows-apple-approved-software-by-default/)

To be clear about the signing status of 4D apps & DMG -

The apps for MacOS released on 4D.com have been signed for a long time.
Gatekeeper originally only required the app to be signed.
Gatekeeper was updated in 10.12 Sierra to have stricter rules and now requires 
the DMG to also be signed: http://kb.4d.com/assetid=77688
So we adapted and starting around Mid-December 2016 any new DMG for MacOS we 
create has also been signed. If you have a DMG for a 4D product that was 
created prior to December 2016 then it is probably not signed (this would 
include the DMG for v13.6 or 15.0 because they were released prior to 
mid-December 2016).

Hopefully this clears things up.

-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: What prevents Web Server from Starting?

[David Adams via 4D_Tech]

No, no, no! The preferred response when you finally figure out a @$@#$%#
stupid mistake is to mutter under your breath, "Darn 4D bugs!" If another
programmer is nearby to hear you, that much the better.

;-)
**
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 on OSX Application licence

[Tim Nevels via 4D_Tech]

> On May 19, 2017, at 10:54 PM, Chuck Miller wrote:
> 
> If that is so easy, why does 4D itself not do this

On macOS when you sign an app it embeds the developer info in the app and it 
does some kind of checksum on the app to verify it is not tampered with and 
virus infected. 

So it is not possible for 4D to do the because then they would be signing every 
app made by any 4D developer and basically certifying that app will do no harm 
to a macOS computer. 4D, Inc. does not trust all developers of the world that 
much. And the first rogue 4D app a 4D developer created would point back to 4D, 
Inc. and then Apple would revoke 4D's developer license and turn the block so 
that any 4D app signed by that cert could never run on any macOS computer 
again. 

Each developer must have his own cert so, he/she cannot contaminate others in 
the event of a problem. 

You get the picture now of how it works Chuck?

Tim

Sent from my iPad
**
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: Primary key contains duplicate values

[Douglas von Roeder via 4D_Tech]

I'm hitting the same issue that Gary ran into though I'm trying to convert
a 2004 data file to run agains the V15.4 structure file.

I added PK's using the code from Bob Miller's Summit presentation (many
thanks for a superb presentation Bob!) so I'm comfortable that the PK's are
done right.

The issue - when I convert the 2004 data file, 4D reports that 53 out of
105 tables have duplicate PK values. What are my options for resolving this
issue?


--
Douglas von Roeder
949-336-2902

On Sat, Aug 29, 2015 at 3:09 AM, Ortwin Zillgen  wrote:

>
> > Am 28.08.2015 um 19:37 schrieb Gary Boudreaux :
> >
> > FYI, this issue has been resolved. When I put my "live" data file into
> the folder with the new structure, I didn't think to delete the old indx
> file. Once I deleted that file and restarted 4D, the problem went away when
> 4D rebuilt the index file. So the issue was actually duplicates in the
> _index_ file, not in the data itself.
>
> thx a lot.
> Did you tell 4D about that? Suppose, they want to know.
>
>
> Regards
> O r t w i n  Z i l l g e n
> -
>    
>  
> member of developer-network 
>
> **
> See how easy it is to extend your 4D solutions to Web and mobile. New
> opportunities await you with 4D v14!
>
> 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: V16 on OSX Application licence

[Chuck Miller via 4D_Tech]

Perhaps I am remembering older versions, but it often asks if I want to open 
the first time I launch

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase 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. 

> On May 19, 2017, at 4:24 PM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Chuck,
> 
>> If that is so easy, why does 4D itself not do this
> 
> What do you mean?
> 
> The apps and DMGs released by 4D are signed with our private certificate.
> 
> However the apps you build are not signed unless you acquire and add your 
> certificate to the BUILD APPLICATION dialog.
> 
> -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
**

Re: Include in Log File Scan

[Cannon Smith via 4D_Tech]

Hi Arnaud,

That works like a charm! Thank you very much.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On May 19, 2017, at 2:44 PM, Arnaud de Montard via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> See here:
> 
> 
> array boolean($logged_ab;0)  //>>>this one
> array longint($table_al;0)
> array text($name_at;0)
> begin sql
>   SELECT LOGGED, TABLE_NAME, TABLE_ID
>   FROM _USER_TABLES 
>   INTO :$logged_ab, :$name_at, :$table_al;
> 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
**

Re: Include in Log File Scan

[Arnaud de Montard via 4D_Tech]

> Le 19 mai 2017 à 21:12, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I’d like to programmatically loop through all the tables in a database and 
> see whether they have the “Include in Log File” property set. Does anyone 
> know of a way to do this?

See here:


array boolean($logged_ab;0)  //>>>this one
array longint($table_al;0)
array text($name_at;0)
begin sql
SELECT LOGGED, TABLE_NAME, TABLE_ID
FROM _USER_TABLES 
INTO :$logged_ab, :$name_at, :$table_al;
end sql

Not available in v14. 

-- 
Arnaud de Montard 




**
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 on OSX Application license

[Timothy Penner via 4D_Tech]

Hi Steve,

App signing in 4D is for Mac only. It is accomplished via a XML key in the 
project file: http://doc.4d.com/4Dv16/4D/16/SignApplication.201-3130130.en.html

You cannot sign the windows exe with this feature, sorry.

-Tim



On May 19, 2017 1:31 PM, "Stephen J. Orth"  wrote:
Tim,

I apologize as I have not been following this thread, but noticed something 
interesting in your response.  Are you saying we can sign our builds?

If so, is there a way to accomplish this if your building procedurally and not 
using the BUILD APPLICATION dialog?

We sign our installer EXE when building it with Install Shield...


Steve
*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner 
via 4D_Tech
Sent: Friday, May 19, 2017 3:25 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Timothy Penner 
Subject: Re: V16 on OSX Application licence

Hi Chuck,

> If that is so easy, why does 4D itself not do this

What do you mean?

The apps and DMGs released by 4D are signed with our private certificate.

However the apps you build are not signed unless you acquire and add your 
certificate to the BUILD APPLICATION dialog.

-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: V16 on OSX Application license

[Stephen J. Orth via 4D_Tech]

Tim,

I apologize as I have not been following this thread, but noticed something 
interesting in your response.  Are you saying we can sign our builds?

If so, is there a way to accomplish this if your building procedurally and not 
using the BUILD APPLICATION dialog?

We sign our installer EXE when building it with Install Shield...


Steve
*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner 
via 4D_Tech
Sent: Friday, May 19, 2017 3:25 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Timothy Penner 
Subject: Re: V16 on OSX Application licence

Hi Chuck,

> If that is so easy, why does 4D itself not do this

What do you mean?

The apps and DMGs released by 4D are signed with our private certificate.

However the apps you build are not signed unless you acquire and add your 
certificate to the BUILD APPLICATION dialog.

-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: V16 on OSX Application licence

[David Porter via 4D_Tech]

Been there, done that, it is not easy.

Tim was a great help to me when I was struggling to get this sorted out.
He knows what he is talking about.

Dave Porter
Tailored Solutions, Inc.
Business Management Software for Label Converters

> On May 19, 2017, at 2:12 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> If that is so easy, why does 4D itself not do this
> 
> Regards
> 
> Chuck
> 
> Chuck Miller Voice: (617) 739-0306
> Informed Solutions, Inc. Fax: (617) 232-1064   
> mailto:cjmillerinformed-solutions.com 
> Brookline, MA 02446 USA Registered 4D Developer
>   Providers of 4D and Sybase 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. 
> 
>> On May 19, 2017, at 12:31 PM, Timothy Penner via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi Nigel,
>> 
>> If "the application can't be opened" because of the unidentified developer, 
>> you can usually bypass this by right-clicking on the application and 
>> choosing "Open" or by moving the application to the root of the 
>> /Applications/ folder (i.e. /Applications/YourApp.app).
>> 
>> However the best way to work with this behavior is to become an identified 
>> developer by signing your application. To do this you must first join the 
>> Apple Developer Program to obtain a application signing certificate, and 
>> then sign your application. And preferably distribute your application via a 
>> Signed DMG. See here: http://kb.4d.com/assetid=77688 
>> 
>> 
>> -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
**

Re: V16 on OSX Application licence

[Timothy Penner via 4D_Tech]

Hi Chuck,

> If that is so easy, why does 4D itself not do this

What do you mean?

The apps and DMGs released by 4D are signed with our private certificate.

However the apps you build are not signed unless you acquire and add your 
certificate to the BUILD APPLICATION dialog.

-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: What prevents Web Server from Starting?

[Randy Engle via 4D_Tech]

As per usual,

I was being a meatball.

Figured it out egg on my face.

;-)

Randy Engle
XC2 Software LLC


***

**
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: Disable close button on Splash screen windows v12

[truegold via 4D_Tech]

Hi Tim,

Ok, will experiment and see how ti works out.

I will then need to suppress and 4D dialog and handle it programmatically.

Thanks for the help,
John...

> Hi John,
> 
> I just ran some quick tests and I think the most likely scenario here is that 
> you still need to assign a password to Designer (which is required to enable 
> the 4D password system).
> 
> Enabling the 4D Password System is a requirement for many features in 4D that 
> pertain to the users and groups, this includes managing plugin access, 
> preventing users from cancelling the backup while it is running, and also the 
> "Default User".
> 
> The "Default User" setting will be ignored if the 4D Password System is not 
> enabled; meaning that anyone who opens the application will be automatically 
> logged in as Designer.
> 
> -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: Tags in record on 4d.

[Keith Culotta via 4D_Tech]

I have used Text fields and have considered using Objects for that kind of 
storage, but they both give me a hint of that old Subtable feeling.  The data 
is buried in a field within a record.  Objects have some tools to help with 
this, and it's easier to build a complex tag structure.

A related table gives access to all the convenient built in query, reporting, 
and display features of 4D.  

Keith - CDI

> On May 19, 2017, at 9:25 AM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Has anybody come up with a good way add tags records in a table?
> 
> For instance I have a table of contacts, but I would like to be able to tags 
> them with labels and then be able to filter on those labels. Kind of like the 
> usage of tags in osx. 
> 
> In this case I would like to be able to add tags created by users to tag 
> contacts. I have my contacts table, I am thinking I should use objects to 
> handle this. Any suggestions?
> 
> I am running under 4D v15.4 on mac OSX.

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

Include in Log File Scan

[Cannon Smith via 4D_Tech]

I’d like to programmatically loop through all the tables in a database and see 
whether they have the “Include in Log File” property set. Does anyone know of a 
way to do this?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




**
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 on OSX Application licence

[Chuck Miller via 4D_Tech]

If that is so easy, why does 4D itself not do this

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase 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. 

> On May 19, 2017, at 12:31 PM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> 
> If "the application can't be opened" because of the unidentified developer, 
> you can usually bypass this by right-clicking on the application and choosing 
> "Open" or by moving the application to the root of the /Applications/ folder 
> (i.e. /Applications/YourApp.app).
> 
> However the best way to work with this behavior is to become an identified 
> developer by signing your application. To do this you must first join the 
> Apple Developer Program to obtain a application signing certificate, and then 
> sign your application. And preferably distribute your application via a 
> Signed DMG. See here: http://kb.4d.com/assetid=77688 
> 
> 
> -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: What prevents Web Server from Starting?

[Randy Engle via 4D_Tech]

Just to make things interesting:

I tried this:

OK:=0

WEB START SERVER

` OK = 1 !!!

But doesn't actually seem to be running.

Randy Engle
XC2 Software LLC


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy Engle 
via 4D_Tech
Sent: Friday, May 19, 2017 12:01 PM
To: '4D iNug Technical' <4d_tech@lists.4d.com>
Cc: Randy Engle <4d.l...@xc2.us>
Subject: What prevents Web Server from Starting?

I think I must be going bonkers

I can start the 4D Web Server with 5 data files, all exact same structure.

However, in 1 data file, can't start it, in any fashion, using command or menu 
item in design.

Tried different ports, etc. 

No workie

Go back to one of the other data files, works fine, any port.

Go back to the foobar one, no workie.

Whiskey Tango Foxtrot!!!
Checked the dosage on my meds, just to make sure...  ;-)

What would prevent the web server from starting?

Randy Engle
XC2 Software LLC



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

What prevents Web Server from Starting?

[Randy Engle via 4D_Tech]

I think I must be going bonkers

I can start the 4D Web Server with 5 data files, all exact same structure.

However, in 1 data file, can't start it, in any fashion, using command or menu 
item in design.

Tried different ports, etc. 

No workie

Go back to one of the other data files, works fine, any port.

Go back to the foobar one, no workie.

Whiskey Tango Foxtrot!!!
Checked the dosage on my meds, just to make sure...  ;-)

What would prevent the web server from starting?

Randy Engle
XC2 Software LLC



**
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: Tags in record on 4d.

[Kirk Brooks via 4D_Tech]

I'll just add you don't actually need to put the keywords in a separate
table anymore. You can add a text field to your table. Populate the field
with the keywords (or tags) using a space as the delimiter. Then set that
field to have a keyword index and query it using the keyword operator.

I've used this approach since v13 for things like Contact or Partner
records to simplify doing queries for names, for example. In this case a
handy benefit is you can mix in things like the soundex or metaphone codes.
JPR also mentioned this technique in a 4DWT session.

On Fri, May 19, 2017 at 8:04 AM, Guy Algot via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> Eric,
>
> I’ve used this for years and called it Keywords. A separate related table
> stores the Contact Key and the Keyword. You can search on the Keywords and
> then relate that selection to Contacts. This was before objects. But like
> Koen said, objects would work as well. Depends on how flexible you want to
> be.
>
> Did you go to the World Tour? JPR demo’d something like this on Day 1.
>
-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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 on OSX Application licence

[Timothy Penner via 4D_Tech]

Hi Nigel,

If "the application can't be opened" because of the unidentified developer, you 
can usually bypass this by right-clicking on the application and choosing 
"Open" or by moving the application to the root of the /Applications/ folder 
(i.e. /Applications/YourApp.app).

However the best way to work with this behavior is to become an identified 
developer by signing your application. To do this you must first join the Apple 
Developer Program to obtain a application signing certificate, and then sign 
your application. And preferably distribute your application via a Signed DMG. 
See here: http://kb.4d.com/assetid=77688

-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: V16 on OSX Application licence

[Chuck Miller via 4D_Tech]

You will have to go to system preferences as admin, change to allow any program 
(only for a moment). Launch new application. If it launches quit
Change your preferences back. The next time you launch all should be well

I do not think you can easily change to identified app as those come from the 
app store

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase 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. 

> On May 19, 2017, at 12:23 PM, Nigel Greenlee via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi
> 
> I am building a small application for internal deployment in a company. I am 
> trying to deploy using the unlimited desktop(partner programme).
> 
> 
> However when i try to launch that application on OSX it will not launch- just 
> a message
> 
> “The application …can’t be opened"
> 
> After a bit of head scratching(have i included the licence etc) I now think 
> the OS is blocking the application because it is not from an ‘identified 
> develop’. 
> 
> How do i set the developer to an identified one?
> 
> Or does anyone know if maybe my problem is something else
> 
> 
> 
> Nigel Greenlee

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

V16 on OSX Application licence

[Nigel Greenlee via 4D_Tech]

Hi

I am building a small application for internal deployment in a company. I am 
trying to deploy using the unlimited desktop(partner programme).


 However when i try to launch that application on OSX it will not launch- just 
a message

“The application …can’t be opened"

After a bit of head scratching(have i included the licence etc) I now think the 
OS is blocking the application because it is not from an ‘identified develop’. 

How do i set the developer to an identified one?

Or does anyone know if maybe my problem is something else



Nigel Greenlee


**
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: How to trap a form save keystroke in an object method ?

[Chuck Miller via 4D_Tech]

How about disabling the button until all values are OK. This when you enter a 
variable or field on form disable and when you exit enable only if pass.

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase 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. 

> On May 18, 2017, at 12:41 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> How about adding a hidden button to trap for Enter key strokes?
> 
> I run all my active objects into a single project method (the 'form
> controller' I like to talk about). So I'd have that button call the form
> controller and handle the save code the same way the normal save event
> would process. This also makes it easy to add a button to trap for the
> return key.

**
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: Tags in record on 4d.

[Guy Algot via 4D_Tech]

Eric,

I’ve used this for years and called it Keywords. A separate related table 
stores the Contact Key and the Keyword. You can search on the Keywords and then 
relate that selection to Contacts. This was before objects. But like Koen said, 
objects would work as well. Depends on how flexible you want to be.

Did you go to the World Tour? JPR demo’d something like this on Day 1.


> On May 19, 2017, at 8:25 AM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Has anybody come up with a good way add tags records in a table?
> 
> For instance I have a table of contacts, but I would like to be able to tags 
> them with labels and then be able to filter on those labels. Kind of like the 
> usage of tags in osx. 
> 
> In this case I would like to be able to add tags created by users to tag 
> contacts. I have my contacts table, I am thinking I should use objects to 
> handle this. Any suggestions?
> 
> I am running under 4D v15.4 on mac OSX.
> 
> ---
> 


Later,
Guy

--
Guy Algot, Solutions Specialist
Edmonton, Alberta
(780) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
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: Exploring CALL WORKER vs New process

[Keith Culotta via 4D_Tech]

> On May 18, 2017, at 5:38 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:

> * Workers don't die when their work is done, they wait. 

A method called by New Process
  $w:=Open Form Window("ShowRecord")
  Dialog("ShowRecord")
  ExitCode

A method called by CALL WORKER
  $w:=Open Form Window("ShowRecord")
  Dialog("ShowRecord";*)

So this is why when using CALL WORKER, the Dialog(*) windows hang around after 
the method has been exited.
This means moving the process ExitCode from the lines after Dialog into a 
form's "On Unload" event.

> but there are functionally two loops
A forms execution environment could be visualized as:
If (Worker called)
  // do worker method
Else
  // do form method
End if


> The method has
> access to all of the process values (variables, etc.) and the "form
> variables" of the specific form in the specified window.

If several forms were open in a process, would it matter which form was called? 
 A form's local variables are outside the purview of the "Worker called".  No 
event is triggered.  Any variable changed need a Call Process (-1) for their 
display to change.
On the other hand, this is where form object names make the context significant?


Handy use example:
A method that saves a file, processes it, and deletes the file got a 
significant performance boost when the delete part was handed off to a CALL 
WORKER invoked method.

Thanks,
Keith - CDI
**
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: Tags in record on 4d.

[Koen Van Hooreweghe via 4D_Tech]

Hi Eric,

I think an object field is what you are looking for.

HTH
Koen

Op 19-mei-2017, om 16:25 heeft Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
het volgende geschreven:

> Has anybody come up with a good way add tags records in a table?
> 
> For instance I have a table of contacts, but I would like to be able to tags 
> them with labels and then be able to filter on those labels. Kind of like the 
> usage of tags in osx. 
> 
> In this case I would like to be able to add tags created by users to tag 
> contacts. I have my contacts table, I am thinking I should use objects to 
> handle this. Any suggestions?
> 
> I am running under 4D v15.4 on mac OSX.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

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

Tags in record on 4d.

[Eric Naujock via 4D_Tech]

Has anybody come up with a good way add tags records in a table?

For instance I have a table of contacts, but I would like to be able to tags 
them with labels and then be able to filter on those labels. Kind of like the 
usage of tags in osx. 

In this case I would like to be able to add tags created by users to tag 
contacts. I have my contacts table, I am thinking I should use objects to 
handle this. Any suggestions?

I am running under 4D v15.4 on mac OSX.

---

MacCafe
4405 Talmadge  St.
Toledo, OH 43623
Eric Naujock  -  ACSA 10.2, 10.3, 10.4 Apple - ACTC 10.5, 10.6, 10.7, 10.8, 
10.9, 10.10
http://www.mac-cafe.com
email: e r...@mac-cafe.com 
AOL IM: erlic



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