Re: Go watch Thomas Maul's presentation. Now.

[John DeSoi]

Great presentation, I'm also excited about the upcoming features. Here are some 
thoughts about the implementation details. 

CALL WORKER and CALL FORM are adding more 4D commands that take a method name 
as string. 4D does not have anything like closures or procedure pointers, so it 
introduces even more ways to break your code when you change a method name that 
is embedded somewhere as a string (or even a generated string). Don't forget 
about ON ERR CALL, New Process, and EXECUTE METHOD. It seems trivial to fix - 
just add a command, e.g. "Method name", that takes the *tokenized* method name 
and returns the method name as a string for use in any of the above commands. 
Now the design environment can really tell you where the method is referenced. 
If you agree, vote for the future request here:

http://forums.4d.fr/Post/EN/17984703/1/17984704


My second concern is that a method cannot be preemptive if it calls a 
non-preemptive command. Any any callers of that method also cannot be 
preemptive. A compile time error is generated in all cases.

This seems like an extreme limitation when it would be easy to arrange for the 
method to conditionally avoid calling the non-preemptive commands when in 
preemptive mode. Developers do this all the time for generic methods that need 
to be run in different contexts. A method that runs on the server can't show a 
user interface and it is easy to adjust the method to do something different 
when it runs on the server.

The compile time error means that separate methods for the same functionality 
will often need to be created. For example, I have a "NET_Send" method which 
can transport a blob using a plugin or HTTP Post. Assuming the HTTP Post method 
allows preemption but the plugin does not, I now have to split that into two 
separate methods. If there are hundreds of callers to the original method, now 
I have to change all of that code creating duplicate methods just so one option 
can work in preemptive mode.

Why not provide an option to get compile warnings instead of errors? Would it 
be that difficult for the compiler just to emit a runtime error if a 
non-preemptive command was called in a preemptive process?

Looking forward to v16!

John DeSoi, Ph.D.



> On Sep 5, 2016, at 4:53 PM, Cannon Smith  
> wrote:
> 
> I also really enjoyed watching the video. It is a subject that I was really 
> excited about at the Summit and I appreciate the 4DMethod user group making 
> this possible.

**
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: Can't Save Record Mandatory field is null

[Sannyasin Siddhanathaswami]

Solved!

Tech support found that I had “Reject null input values” on by First Name 
field! We must have checked that by accident at some point. Unchecking it fixed 
the issue.


--
Sannyasin Siddhanathaswami

On September 1, 2016 at 11:25:56 PM, Sannyasin Siddhanathaswami 
(sid...@hindu.org) wrote:

Regarding the debug log, I was able to start and stop it from the maintenance 
tab on the 4D Server administration window. That’s good enough as I didn’t have 
any other activity at the logging time. Of course, I don’t understand enough of 
what the log says to see any problem...

--
Sannyasin Siddhanathaswami
**
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: Connecting from Excel to 14.4 via ODBC - El Capitan & Office 2016

[Timothy Penner]

> Aren’t those drivers for 4D accessing other databases? Ie not for retrieving 
> data FROM 4D?
> Or is it for both?

The drivers I provided are for accessing data from 4D where 4D is acting as a 
ODBC Server, like in this text diagram:

Generic ODBC Client Application <- communicates with -> 4D's ODBC Driver <- 
communicates with -> 4D Server's SQL Server Port 19812

If you are using MS Excel, it would be like this text diagram:

MS Excel <- communicates with -> 4D's ODBC Driver <- communicates with -> 4D 
Server's SQL Server Port 19812

-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: v12 - Web authentication & Digest & MD5

[Chip Scheide]

OK 
so now I know  :)
On Wed, 7 Sep 2016 19:08:47 +0200, Keisuke Miyako wrote:
> actually, 16 bytes.
> 
> https://en.wikipedia.org/wiki/MD5
> 
>> 2016/09/08 2:07、Keisuke Miyako  のメール：
>>  any size data to 20 bytes
> 
> 
> 宮古 啓介
> セールス・エンジニア
> 
> 株式会社フォーディー・ジャパン
> 〒150-0043
> 東京都渋谷区道玄坂1-10-2 渋谷THビル6F
> Tel: 03-6427-8441
> Fax: 03-6427-8449
> 
> keisuke.miy...@4d.com
> www.4D.com/JP
> 
> **
> 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: v12 - Web authentication & Digest & MD5

[Keisuke Miyako]

actually, 16 bytes.

https://en.wikipedia.org/wiki/MD5

> 2016/09/08 2:07、Keisuke Miyako  のメール：
>  any size data to 20 bytes


宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

**
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: v12 - Web authentication & Digest & MD5

[Spencer Hinsdale]

it's a hash (not the kind you're smoking); is not reversible

> On Sep 6, 2016, at 10:18 AM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> Anyone have an MD5 decoder they would be willing to share?
> 

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

v12 - Web authentication & Digest & MD5

[Chip Scheide]

I can get and 4D to talk enough to get BASIC user/name password 
functions to work.
I can get iCal to reply with DIGEST user/name password - but - 
I can not get Validate Digest Web Password to work...

So... I can extract the MD5 encoded password from the digest, passed as 
part of the HTML header
(look at me talking like I know what the hell I am doing ).

I realize I don't have an MD5 decoder.
Anyone have an MD5 decoder they would be willing to share?
or
Anyone have tips on making Validate Digest Web Password work?

Thanks
Chip
**
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: Running 32bit Script

[Keisuke Miyako]

in my experience,
you should remove the //u option (for unicode) on windows 10 or 2012r2.
cscript doesn't seem to return a value to stdOut and stdErr if you do.

- solution

#1 don't use //u, use ANSI

or

#2 use //u, but wrap the entire script with an "on error"

On Error Resume Next

{whatever}

Wscript.StdErr.Write Err.Description

On Error GoTo 0

> 2016/09/07 19:37、Douglas Cryer  のメール：
>
> How do I alter : $vt_Command:="CScript //nologo //U \""+ +Document+"\""
> To force it to run the 32bit CScript?



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

**
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: Design Environment Jankyness in 15.2 Mac

[Chip Scheide]

this is a classic sign of memory leaks

Things work for... a while, then start to slow down.
restarting the app, often, solves this - BUT - if the app is not 
releasing something it could still appear locked to the OS which 
couldn't clear it; requiring a computer restart.

2 things :
- use task manager/Activity monitor to look at memory usage both for 
the system and the specific (4D) application
- after quitting 4D, rather then immediately restarting wait a bit* 
then try a restart of the 4D app.

* how long is 'a bit', I do not know , but I would say 2-5 minutes. 
This *should* give the OS enough opportunity to determine that whatever 
memory is locked up can be freed.

if this is actually the case, memory leak, screen captures, and maybe 
4D debug logs sent to 4D inc would help them locate and resolve it/them.

Chip

On Wed, 7 Sep 2016 08:38:03 -0500, Keith Culotta wrote:
> There is a speed issue in v15+ that appears in much of the Design 
> environment.  Moving objects on forms, and editing the Properties 
> List are areas that can display a big slowdown.  It appears randomly 
> and rarely.  Quitting and restarting 4D does not help.  The computer 
> must be restarted.  I'm not sure what triggers it.  Next time I'll 
> check to see if Time Machine is backing up.
> 
> Keith - CDI
> 
>> On Sep 6, 2016, at 6:01 PM, Lee Hinde  wrote:
>> 
>> I saw some comment recently about speed issues in the design environment,
>> but I can't find it now.
>> 
>> Scrolling property lists and moving around in the layout editor is painful.
>> 
>> Is this just the way it is, or is there something I need to turn on 
>> or off? 
> **
> 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: Design Environment Jankyness in 15.2 Mac

[Keith Culotta]

There is a speed issue in v15+ that appears in much of the Design environment.  
Moving objects on forms, and editing the Properties List are areas that can 
display a big slowdown.  It appears randomly and rarely.  Quitting and 
restarting 4D does not help.  The computer must be restarted.  I'm not sure 
what triggers it.  Next time I'll check to see if Time Machine is backing up.

Keith - CDI

> On Sep 6, 2016, at 6:01 PM, Lee Hinde  wrote:
> 
> I saw some comment recently about speed issues in the design environment,
> but I can't find it now.
> 
> Scrolling property lists and moving around in the layout editor is painful.
> 
> Is this just the way it is, or is there something I need to turn on or off? 
**
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: 4Dv15 and El Capitan

[B.Bippus]

We had almost the same issue a few month ago: Upgraded a long standing
application from v13 to v15.2, near 80 Clients, 99% Mac Clients and a
Windows 7 Workstation as 4D Server (VMware esxi; central Storage). Every
2nd day the 4D Server App  stands still, Clients gets no response. After
restarting the 4D Server App everything runs normal (until ist stopps again
after one or two days). Half the time, we could quit 4D Server App via
menue, half the time we had to kill the 4D Server App process via Task
manager.
We´ve done a lot of things to find the Error, Thomas Maul´s focus was at
the Storage Speed (IOPS, see his Summit Presentation). I suspect that a
complete Maintenance of the 4DD and full rebuild of the Index (trash the
.4DInx)  has fixed the problem. Previous checks of the 4DD via MSC has
shown no Problems before.

2016-09-07 14:50 GMT+02:00 Jeffrey Kain :

> I suppose you've looked at your OS X crash logs already, and turned on
> client-side debugging to find out at what line(s) of code the application
> crashes? Any clues there?
>
> > On Sep 6, 2016, at 10:53 PM, Ronnie Teo  wrote:
> >
> > Hi All,
> >
> > I had a client who recently upgraded a long standing application from
> v13 to v15.2 running in a pure Mac environment.
> > What used to be a very stable application, now crashes almost every
> alternate day under El Capitan, Mac OS 10.11.5.
> > Both the server and all workstations are running the same OS.
> >
> > I wonder if anyone has experienced this and what remedies, if any are
> available?
>
> **
> 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: 4Dv15 and El Capitan

[Jeffrey Kain]

I suppose you've looked at your OS X crash logs already, and turned on 
client-side debugging to find out at what line(s) of code the application 
crashes? Any clues there?

> On Sep 6, 2016, at 10:53 PM, Ronnie Teo  wrote:
> 
> Hi All,
> 
> I had a client who recently upgraded a long standing application from v13 to 
> v15.2 running in a pure Mac environment.
> What used to be a very stable application, now crashes almost every alternate 
> day under El Capitan, Mac OS 10.11.5.
> Both the server and all workstations are running the same OS.
> 
> I wonder if anyone has experienced this and what remedies, if any are 
> available?

**
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 DLL Plugin Issue

[Douglas Cryer]

Many thanks to everyone who input into my issue.  I have eventually found a 
solution.

I wrote a VBScript that calls the ActiveX object and that works now.  Initially 
it was not working when I tested it on the desktop but it works from within 4D 
v15.

Here is my crude understanding of what was happening:
When the script was double clicked it is running WScript and given the platform 
it is probably running the 64 bit version which could not create the ActiveX 
object.
When I write and run the script file from within 4D I am using CScript and this 
is working.  I am assuming because it is running 32bit version of CScript.
 
What ever the reason I now have a working solution with the COM object and 
LAUNCH EXTERNAL PROCESS

Thank you everyone who gave input as knowing I had other minds on it helped 
keep me sane.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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: How to find 2 digit years in legacy Database.

[JPR]

[JPR]

Hi Tim,

Sorry for the delay, I was in holidays.

On disk, 4D use 8 bytes for a Date, and 8 bytes for a Time. 

A Time is a duration, so it's just a number. On disk, it's a Long-64 of 
milliseconds (584 million years, probably enough until next version). In 
memory, it's a Long-32 of ms, (around 23 days)

On Disk, a Date is build with:
- Word Year 
- Byte Month
- Byte Day
- Long-32 Milliseconds.

HTH,

My very best,

JPR



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