Re: I'm puzzled...

[Herr Alexander Heintz via 4D_Tech]

Well..

That specific Kangaroo is unstoppably hopping towards Project mode.
New features will only be available there and it makes sense.
Most IDEs rely external libraries for such mundane tasks as compiling, etc.
In the case of 4D, you only need things like X-Code if you belong to these poor 
souls still trying to develop single user applications for the mac…
Stopped doing that ages ago, actually stopped supporting Mac a long time ago.
Wisest decision I ever made.
I still love to develop ON a mac, but I never again would develop FOR mac, 
there is not enough money in the world to persuade me otherwise.
As for wanting to hop on the clicky baity sparkling trail of phone based 
application.
Yes, you will need all that, but seriously if you even think about going that 
way, all hope for you is lost already...
Period!
:-)

> Am 27.10.2021 um 14:58 schrieb Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com>:
> 
> G’day,
> 
> Having watched the "4D World Tour Live 2021”, downloaded the V19 material and 
> checked it and browsed that 4D-Web-Forum, especially 
> https://discuss.4d.com/t/adding-field-or-variable-not-working/20963 
>  started 
> by Tom Dillon with the interesting remark from a responder about some “modern 
> project format”… 
> 
> Those 4D still claims, in a marketing and/or reality capacity, to have an IDE 
> (Integrated Development Environment)?
> 
> To me it looks like that Xcode, MS-Visual-Studio and some additional Editors 
> are mandatory now to create a working application with/in 4D if one 
> mistakenly starts the development in project mode where so much “doesn’t 
> really make sense anymore” according to a post on the mentioned forum.
> 
> It is time for 4D to declare in detail what direction the kangaroo is hoping 
> to give people the chance to make the right decision on time.
> 
> Cheers
> Jörg
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: File Excel created from 4D

[Herr Alexander Heintz via 4D_Tech]

https://github.com/miyako/4d-plugin-xls

> Am 14.09.2021 um 16:20 schrieb stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi All,
> 
> I need to create an excel file from 4D application.
> 
> Someone know how i can do?
> 
> Thanks
> 
> /Ferdinando/
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Count of young new developers after ...

[Herr Alexander Heintz via 4D_Tech]

Am 03.08.2021 um 16:12 schrieb THOMAS BENEDICT via 4D_Tech 
<4d_tech@lists.4d.com>:
> 
> "According to their Sales VP“

relevant words here being

 ACCORDING

and

 SALES VP

…
I would love for this to be true, but I do have serious doubts.
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: 4D Chart replacement

[Herr Alexander Heintz via 4D_Tech]

My current favorite here is Apache eCharts.
Extremely powerful with an export/render to SVG option for all charts.
Some of the documentation is slightly chinese heavy in text, but the examples 
are great and they have an online editor where you can test all settings and 
parameters on the fly, works really great.

Cheers
Alex

> Am 26.05.2021 um 15:53 schrieb THOMAS BENEDICT via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> There are lots of Javascript based charting libraries available. Many years 
> ago I used Google Chart, which is now deprecated, to quickly move some server 
> metrics graphs out of 4D Chart. Basically you pass the data to the library 
> then it sends back the chart which you display in a Web Area.
> 
> HTH,
> 
> Tom Benedict
> 
>> On 05/26/2021 4:13 AM Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> wrote:
>> 
>> 
>> G’day,
>> 
>> Are there any suggestions for a replacement for 4D Chart?
>> 
>> Thanks in advance.
>> 
>> Cheers
>> Jörg
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Remember "Layout Procedure" in 4D v2?

[Herr Alexander Heintz via 4D_Tech]

„During"

actually quite logical isn’t it?

> Am 14.01.2021 um 12:46 schrieb Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com>:
> 
> G’day All,
> 
> Back than we had only 3 “Situations”:
> 
> Before
> 
> ?
> 
> After
> 
> 
> Can someone fill in the question marks - just curious…
> 
> 
> Thanks
> 
> Cheers
> Jörg 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: PING of life...

[Herr Alexander Heintz via 4D_Tech]

Am 14.01.2021 um 08:55 schrieb Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com>:
> 
> 
>> On 14 /01 /2021, at 18:42, Graham Langley via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> I find it odd that a subset of developers on this "forum" is a good thing.
> 
> Let time be the judge of that.

Well, actually in my opinion there is nothing to judge here…

As already stated we are just a few, and splitting that small group by forming 
one rogue tiny group is not helping anyone, neither us, nor them.

So no, splitting off is not a good idea.

Also, the iNug is NOT a „safe space“ insofar, as 4d is (or at least used to) 
monitoring this. Also, I have yet to notice any instance of aggressive 
moderation on the new forum by 4d, and believe me, I would have noticed, being 
somewhat on the aggressive side towards 4d from time to time.

So in short:
I see no compelling case whatsoever for continuing to use the iNug, your 
mileage may vary.
Try to change my mind 

>> I love the discuss site,
> 
> No one forces you to participate here!

A tad agressive, are we? :-)

>> We should also welcome "smart-arse newbies”.
> 
> This would heavily depend on the kind of the newbies.

Well, as already stated, we all were at some point, an I mean WE ALL dear Jörg 
:-)
As you well know, it takes a few years under the belt to become a good 
programmer, knowledge of theory and langauge and algorythms does not make you a 
good programmer.

> Pretty sure we've all whined in the past about the
>> lack of new developers.
> 
> Are we talking about quality or quantity only?

Well, for current lack of quantity, we can only hope for quality…

SMile everyone

Cheers
Alex

> 
> 
> Cheers
> Jörg
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> 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)
New Forum: https://discuss.4D.com
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: Object notation replacement for use of Self in a script — v18

[Herr Alexander Heintz via 4D_Tech]

quite simple actually, just get a pointer to the actual form element
in the object method just call:

OBJECT GET POINTER (object current)

you can even go one further und just put all that into the form method:

If (Form event code=On Data Change)
$p_entry:=OBJECT Get pointer(Object with focus)
If ((Type($p_entry)=Is text) | (Type($p_entry)=Is alpha field))
$p_entry->:=Trim($p_entry->)
End if 
End if 

careful here, you will need to switch to OBJECT GET POINTER(Object with focus) 
as you are not in the objects method anymore...

HTH
Alex

> Am 29.04.2020 um 07:55 schrieb Chris Belanger via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Generic programming of vars on a form is very complicated when one uses 
> object attributes for the data source.
> 
> For example, on screen you make a simple text input object named “enCompany”. 
> It’s data source is Form.en_Company.Name (  i.e. [Company]Name  )
> 
> In ‘classic 4d”, where the data source would be [Company]Name, one can code 
> its script:
> TRIM ( Self )
> 
> And TRIM would simply take a POINTER, and you can perform operations on the 
> data that the user typed into that field. (Such as trim off leading & 
> trailing spaces).
> 
> But with OBJECT NOTATION, that is all screwed up.
> You cannot get a PTR to, for instance, an object named ‘enCompany’ whose data 
> source is  Form.en_Company.Name
> So the script for it cannot be generic.
> It would seem to make sense to be able to do something like:
> 
> TRIM ( Form Event.objectName ) — and have some way to actually do anything 
> with what the user typed into this element on-screen.
> 
> You can’t use TRIM ( Self ) because Self is nil
> 
> And v18r3 does not even have a solution to this in its documentation.
> 
> It seems we should have some way of getting the user-input data of a screen 
> element even if we are using object notation.
> 
> We would expect, at the least, something like  OBJECT Get Value ( ObjectName 
> ) and OBJECT Set Value ( Object Name ) but no!
> 
> Any input? Wait for version 20 of 4D?
> 
> - Chris
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: New Notarization Issues

[Herr Alexander Heintz via 4D_Tech]

Am 28.04.2020 um 17:01 schrieb Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com>:
> 
> I was cursing Apple frequently and for the first time in 20+ years (did I 
> really say that?) seriously considering becoming a Windows only programmer.

I still develop on windows, but: 
Man am I happy that I only hav Windows clients…
So much less headaches, on all fronts.
And there is so much stuff you can do on windows easily that is an incredible 
PITA on Mac.
Examples : CTI, TWAIN, RDP, Virtualisation
Oh, and lets not go down the road of hardware prices, especially server…
I have no pity for anyone using a Mac as server, none whatsoever…
OK, my rant of the day.
Better stop before I start diving into the joys of visiting an apple store with 
a defective 6000 $ laptop.
The give a whole new meaning to the word „customer oriented service“


NOT!
**
4D Internet Users Group (4D iNUG)
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: With v18r2, can 4D display pdf documents?

[Herr Alexander Heintz via 4D_Tech]

Used it for ages.
On Mac no magic required, works out of the box, on Windows you might need to 
install Adobe Reader.
On newer windows systems (win 10) i thinks it works right out of the box, but 
would have to verify...

> Am 21.04.2020 um 18:36 schrieb Chris Belanger via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> That sounds like something I would really like to work. If the web area knew 
> what pdf renderer to use, it sounds like theoretically that should do it. 
> Anyone know of how to get it to work?

**
4D Internet Users Group (4D iNUG)
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: Gmail, LSA, and OAuth

[Herr Alexander Heintz via 4D_Tech]

I just looked into accessing GMail through OAuth2.
From the technical point it is not a problem, I can easily adapt the tools I 
have for MS OAuth2 to work with Google.
The process for app registration however is much more complicated than with MS…
You need to submit you application to Google for verification and depending on 
the type of data you want to access with Google (that includes GMail) you may 
be requested to do an external security audit for you App, costs anywhere from 
15 to 75 k.
I will start that process for my App once I have the Connector going, and will 
keep you posted on what to do.
Most likely I will put it on my blog.

If you want to start reading into the requirements, you might want to start 
here:

https://support.google.com/cloud/answer/9110914 


Chers,
stay safe
stay sane
stay healthy
> 

**
4D Internet Users Group (4D iNUG)
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: Remote working with 4D networks - what are people using ?

[Herr Alexander Heintz via 4D_Tech]

Thanks Tim,

live and learn…
Will look into this over the weekend.

Cheers
Stay safe
Alex

> Am 19.03.2020 um 20:44 schrieb Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>:
> 
> On Mar 19, 2020, at 2:00 PM, Alexander Heintz wrote:
> 
>> OsX is as much a UNIX flavor as we are basically primates.
>> 
>> BSD split in 75 from UNIX and NEXTSTEP in 86 from BSD.
>> 
>> don't know why, but AFAIK the MacOS is not suited for multiple concurrent 
>> user sessions.
> 
> Good that you prefaced your statement with “AFAIK”, because you don’t know. 
> 
> macOS has supported multiple simultaneous users on the same machine with each 
> having their own U macOS Lion 10.7. So it’s been around for a long time. Very 
> easy to use from one Mac to another using built in Screen Sharing 
> application. 
> 
> You can also do it from a Windows machine but you need to get the right VNC 
> app that supports the new protocol and user login. VNC Viewer works.
> 
> https://www.realvnc.com/en/connect/download/viewer/
> 
> Apple put a limit of 5 simultaneously connected users with macOS 10.13 High 
> Sierra. Before that you could do many more if you had a powerful Mac — same 
> as if you were doing this on Windows with Terminal Server. 
> 
> Here’s a link with a lot of details, for those that want to know more:
> 
> https://superuser.com/questions/125636/can-a-mac-be-used-by-multiple-users-at-same-time
> 
> Also, here are a couple of screenshots I took from my Mac Mini server running 
> 10.13 with 2 Screen Sharing sessions active at the same time. Two users: 
> “Administrator" and “Screen User” are configured. Just to show an example of 
> how it works. 
> 
> When you connect to a Mac with Screen Sharing you have to specify a user name 
> and password. You can get the dialog box below if you are trying to connect 
> with an account that it already knows. Just select another account to log in 
> again with a new Screen Sharing connection:
> 
> https://dl.dropboxusercontent.com/s/0x3gvnasf57otz3/ScreenShare%20Connect%20Confirm.PNG
> 
> Then you get the macOS login screen. Select the user account and enter the 
> password. (You can save all this to the Keychain so you don’t have to double 
> login every time.) 
> 
> https://dl.dropboxusercontent.com/s/tpsjwvzb7t96ql2/LoginScreen.PNG
> 
> Here are the 2 sessions running side-by-side on my iMac Pro. Notice it is the 
> same Mac Mini computer, but with two users. Each has it’s own Desktop, Dock 
> and all that stuff. 
> 
> https://dl.dropboxusercontent.com/s/9x3xm5zpt1lgu2x/TwoUserScreenShare.PNG
> 
> It is super easy to set this up and use. A lot easier than doing the same 
> thing on Windows with Terminal Server and using RDC. But then you would 
> expect that since it is a Macintosh… right? 
> 
> Tim
> 
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.com
> *
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Remote working with 4D networks - what are people using ?

[Herr Alexander Heintz via 4D_Tech]

Am 19.03.2020 um 16:52 schrieb kculotta via 4D_Tech <4d_tech@lists.4d.com>:
> 
> I remember connecting a terminal to the serial port on Apple's Lisa, and 
> running a second user.  We must have installed Unix or Xenix at the time.  
> Aren't "terminal services" already a part of Unix (or macOS)?  I put that in 
> quotes because, apart form being a terminal services user on occasion, I am 
> not familiar with the workings of it.

OsX is as much a UNIX flavor as we are basically primates.

BSD split in 75 from UNIX and NEXTSTEP in 86 from BSD.

don't know why, but AFAIK the MacOS is not suited for multiple concurrent user 
sessions.

Windows only is because the brought in the DEC people in the late 80es to 
create what was then known as Windows NT.
Multi-User capabilities were there from the start, the underlying architecture 
coming form OS/2.

All ancient history now.
**
4D Internet Users Group (4D iNUG)
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: Remote working with 4D networks - what are people using ?

[Herr Alexander Heintz via 4D_Tech]

Am 19.03.2020 um 16:19 schrieb James Crate via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Logging in as myself creates a virtual instance and allows me to use that 
> machine without disturbing anyone who maybe be sitting at the machine or 
> screen sharing.

Live and learn, remembered differently, but ist been a while that i really dug 
into macOS.
So what is the reason Apple is not offering a terminal server?
maybe because people might get the idea to access i via a windows machine (like 
apple users do to MS).
I think the problem here is the fact, that MS makes money with the operating 
System and Software, whereas Apple makes money by selling ridiculously 
overpriced hardware (got one myself, so i am allowed to say it), so a terminal 
server solution would be detrimental to their sales?
**
4D Internet Users Group (4D iNUG)
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: Remote working with 4D networks - what are people using ?

[Herr Alexander Heintz via 4D_Tech]

It’s not about slamming the mac, i work with a Mac since they exist (1984) and 
absolutely love my MacBook Pro, although I do have grievances concerning the 
ludicrous pricing policy (come on, I am willing to pay a premium, but 450% of 
market price for SSD or RAM?).

I just stated why Apple lost the corporate market.
And the reason for companies to forgo Apple are valid and understandable.
AFAIK the MacOS cannot be changed to allow multiple concurrent user sessions on 
one Computer, the OS simply lacks the necessary tools to do it.
When you switch users on a Mac, you need to first switch off the user you are 
currently logged in to.
On Windows I can have as many user sessions in parallel as I want to.
Terminal Servers are absolutely essential for the corporate market, it is a 
non-negotiable showstopper.
And corporate clients are not willing to pay quadruple price for standard 
commodities.

I will continue using Macs as long as I can afford them (and can work on them), 
but I have no corporate clients with Mac left.
And I know not ONE SINGLE corporation that uses Mac (but for the marketing 
department, maybe…).

Fact of life man!

> Am 19.03.2020 um 16:05 schrieb Lee Hinde via 4D_Tech <4d_tech@lists.4d.com>:
> 
> 1997 called and want their Slam-The-Mac back.  :-) 
> 
>> On Mar 19, 2020, at 4:34 AM, Herr Alexander Heintz via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Complete lack of a remote terminal solution for Macs is the primary reason 
>> why most businesses have switched to Windows in the last 8-10 years.
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Remote working with 4D networks - what are people using ?

[Herr Alexander Heintz via 4D_Tech]

Am 19.03.2020 um 13:05 schrieb Peter Jakobsson via 4D_Tech 
<4d_tech@lists.4d.com>:

>> I have a client who has a huge Windows Server machine and they run all 
>> instances of 4D client on it.  Everyone connects via RDP to those clients 
>> and it’s fast.
> 
> 
> You mean server + multiple clients on the same machine ? How do screen 
> sharers connect to a particular instance of a 4D Client in that case if 
> they’re all on the same machine ?

Ah, a question from a MacTotaller :-)

Its called Terminal Server and multiple user sessions.
Windows can do that since NT.
MacOS cannot do that...

The Server runs as many sessions as users log on.
They just log onto the server with username and password and get their user 
session.
The user sessions are all separate from each other.
WIth their own application instances, etc.

Its what most businesses use nowadays as you can use the cheapest simplest 
desktop machines, only need to administrate the server, nothing, and i mean 
NOTHING is on the client machine, it only drives the network and screen.


**
4D Internet Users Group (4D iNUG)
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: Remote working with 4D networks - what are people using ?

[Herr Alexander Heintz via 4D_Tech]

Well, the problematic point here is „MACS“

Complete lack of a remote terminal solution for Macs is the primary reason why 
most businesses have switched to Windows in the last 8-10 years.

I know it is not helping you to hear this…

Maybe you can set up a MS Terminal server (or much cheaper compatible tools, 
like TSPlus, even works on Windows 10).
Then have the Mac Users use MS RDP to access the Terminal Server und run the 4D 
Client on Windows.
May be unaccustomed to them and not always comfy, but works.

If a provider blocks RDP, then they are not suitable for business use and you 
should switch to someone else, BT ?

Most of my clients, and my employer have rolled out Terminal Services for just 
that purpose.
We just switched 35 Users to Home Office without a glitch.


> Am 19.03.2020 um 12:20 schrieb Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi
> 
> Due to impending “lockdown” situations I have users asking me how they can 
> work from home. I was wondering what solutions others were finding worked 
> well.
> 
> The service provider that many of the key users have at home (Talk-Talk in 
> the UK)  blanket blocks all screen sharing software so will probably have to 
> look into some kind of cloud hosting solution. The question is, how to set up 
> network in the cloud (only needs 2 clients for now). Their office network 
> runs on Macs, including the 4D server.
> 
> Regards
> 
> Peter
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: Gmail, LSA, and OAuth

[Herr Alexander Heintz via 4D_Tech]

Am 18.03.2020 um 22:43 schrieb David Rose via 4D_Tech <4d_tech@lists.4d.com>:

> How is this done in 4D in conjunction with the 4D SMTP commands?

NOT
AT
ALL

we apologize for the inconvenience…

but in all seriousness:

Everybody is currently switching to other system standards.
Office 365 still supports imap/smtp with plain authentication, but that will go 
away as well.
We currently use office 365 vi Exchange Web Services, with MS OAuth2.
It was a pain to implement…
There is some good stuff from Keisuke concerning OAuth2, but a lot more needs 
to be done in order to continue using IMAP.
SMTP will live a little longer, IMAP will force you to switch from palin 
authentication to bearer authentication where you send a token.
It sadly requires interaction by the user from time to time, no idea if Google 
has any system for Admin impersonation in place like MS Azure does.

I might release component in the near future that does MS OAuth against Azure.

As for Google and others, I will have to find the time to get into that.

Cheers
Alex
**
4D Internet Users Group (4D iNUG)
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: Create SQL DB ERD from 4D Export Structure XML File?

[Herr Alexander Heintz via 4D_Tech]

Am 25.11.2019 um 14:00 schrieb Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Alexander’s code ended with a number of black tables.

Hi Tom,

sorry for that, I take the color commands from the xml structure definitions.
If you like, you could send me the XML structure and I check if I can correct 
this in code.
In the list of tables you should see a preview of the color it will render 
with, although I do not remeber if I added the option to change the color.
I did it with a structure of 374 tables und a truckload of relations and it 
worked.
Also you can export as SVG and this can be edited in some drawing apps (I use 
Illustrator).

Regards,
Alex
**
4D Internet Users Group (4D iNUG)
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: Create SQL DB ERD from 4D Export Structure XML File?

[Herr Alexander Heintz via 4D_Tech]

Am 24.11.2019 um 18:54 schrieb Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>:
> 
> I have a 4D method which generates a SQL DDL, but it doesn’t include 
> relations. So now I’m looking at the XML structure file as a possibility. 

Look at my Blog
http://blog.heintz.net/sql-structure-access/ 

This does export your structure as SQL table definitions, although without the 
relations (Foreign Key Constrains in MySQL speak).
Source available for a small donation.

Adding the export of the constrains should not be too hard, maybe I could do it 
if you really want to, otherwise here is the syntax:

FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)

Easy as pie :-)

**
4D Internet Users Group (4D iNUG)
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: DOCUMENT LIST : how do I know the documents are valid

[Herr Alexander Heintz via 4D_Tech]

could this help?

GET DOCUMENT PROPERTIES ( document ; locked ; invisible ; created on ; created 
at ; modified on ; modified at ) 

> Am 21.11.2019 um 11:20 schrieb Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi,
> 
> We use DOCUMENT LIST and COPY DOCUMENT to handle scans
> The documents are copied by a scanner to a certain folder on a Windows 
> server, where we are picking them up and process them
> It seems that because of slow copying the documents are picked up too early 
> by us
> How can I ensure that the documents are totally copied by the scanner? COPY 
> DOCUMENT to an temporary folder doesn’t seem to solve the problem
> 
> Gr,
> Piotr
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Printing structures : Update

[Herr Alexander Heintz via 4D_Tech]

I was told there are countries out there that use the „.“ as decimal separator…
This lead to interesting results when parsing the xml.
Made a small change to the code, new version is online and can be downloaded 
here:

http://blog.heintz.net/wow-i-cant-believe-it/ 


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

Printing structures

[Herr Alexander Heintz via 4D_Tech]

Hi folks,

been a while, i know…
needed something to print structures in a moderately configurable way.
May have gone a bit overboard with the config options…
It takes a XML structure dump and can stare presets and parsed structures.
Also export to SVG, PNG and JPG
Its V17Rx and you will find it here:

http://blog.heintz.net/wow-i-cant-believe-it/ 


Have fun!
**
4D Internet Users Group (4D iNUG)
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: Printing Structure Diagram

[Herr Alexander Heintz via 4D_Tech]

Salut Patrick

Am 18.04.2019 um 08:45 schrieb Patrick Emanuel via 4D_Tech 
<4d_tech@lists.4d.com>:
> 
> In QS_Toolbox, I've implemented the Vincent solution.
> You can view inside the component the diagram and also export it as picture.

nice, but a tad blurry for a large strcuture, actually nothing is readable.
Is there a setting somewhere to define the size and resolution of the picture 
created?

Merci
A+
**
4D Internet Users Group (4D iNUG)
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: Resizing text on en Entry form

[Herr Alexander Heintz via 4D_Tech]

Wow…
Its basically not that complicated, BUT…
It would require not only changing the font size, but also resizing and moving 
all objects accordingly.
Again technically quite simple…

Resize: 125%
for each object
get coordinate, multiply with 1.25 and set then move object, 
set font to size*1.25

Furthermore you will have to adjust the dimensions of the form, as well as of 
the window, unless your form has scroll bards for both directions (which IMHE 
user hate…).

GET WINDOW RECT, SET WINDOW RECT, etc.

It gets funnier once subforms are involved )
But again, just a recursive call (EXECUTE METHOD IN SUBFORM)

Also make sure you do it for all form pages.

Might write this in the next few days and post it on my BLOG...

If your form window already fills the screen, it would overflow and make 
scrolling necessary, something that is AFAIK not possible with DIALOG, only 
with MODIFY and ADD.
Both are regarded as obsolete.

So before doing it you must check if the result will overflow the available 
screen space.

Cheers
Alex


> Am 01.05.2019 um 06:09 schrieb Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I have code to resize the font in a listbox/listing form.
> 
> I was wondering if there anyone has code they would share to resize all 
> text on an entry form?  something like command/control + (or -) on a 
> web page.
> 
> Thanks
> Chip
> ---
> Hell is other people 
> Jean-Paul Sartre
> **
> 4D Internet Users Group (4D iNUG)
> 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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Using the HELP Menu for my own purposes.

[Herr Alexander Heintz via 4D_Tech]

Hi everyone,

My clients are sometimes distracted by the HELP menu.
Amongst calling documentation for several Plugins (i know how to get rid of 
that) it also shows stuff like License Management, Online Documentation (4D), 
Welcome Assistant, etc…
I NEED to get rid of all that and only have 3 options in there:

Online Support (opening TeamViewer)
Application Manual
-
About XYZ

Is there any way out there (can be a Plugin) to do this?
In the current version the HELP menu is utterly useless to my users.

BTW: V17 Rx

TIA
Alex

**
4D Internet Users Group (4D iNUG)
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: Project methods vs ...

[Herr Alexander Heintz via 4D_Tech]

I absolutely agree with Chip!
For quite some time I have made sure all code called by objects is 1 line only!
Now, with ORDA and the Form. object, it gets even easier to do this!
Also in many cases there is no neeed for parameter passing:
Using 

OBJECT Get name(Object current 
)
and
Current form name

makes life so much simpler...

Also:
No form object should have an „on load“ event!!!
The call order of the On Load event makes it quite difficult, especially if 
some things rely on others.
Run it all in the Forms On Load event.
BTW: Using the Form.whatever notation for Checkboxes and Radio Buttons will 
accept Boolean values.
You can assign From.myBoolean to a checkbox…
Oh how much easier would life have been with all the V17 Stuff…

Cheers
Alex


> Am 25.04.2019 um 16:22 schrieb Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Chris B made the below statement about project methods.
> 
> from a 'classic' 4D pogromming view, IMHO - which may mean nothing :), 
> this is not the approach I use or advocate.
> 
> I do use object methods - but - only to call project methods which do 
> all of the actual work.
> ex: accept button script
>// accept button script <[table].form.object>
> tablename_entry_accept
>   // end accept button script <[table].form.object>
> 
> the project method tablename_entry_accept will do data entry 
> validation, messaging about entry failures, related record existence, 
> calculations that need to be done etc. and usually an ACCEPT
> 
> 
> Why?
> Deduplication of code. Code should NOT be repeated. In the above 
> example, the code to accept the form maybe reusable or be made more 
> generic (with parameters). If the code for this accept button was 
> placed in the object script - I might end up re-creating/repeating the 
> code elsewhere (even to the point of copy/paste). 
> 
> At some point in the future I might need to change the logic/code. Then 
> I would need to find all instances of the code through out the system, 
> to make the change. If the system is NOT one I wrote, or it has been a 
> long time (3 days?) since I worked on that section I would/might not 
> know where all instances of the duplicated code are.
> 
> If the code is in a project method, I can make the changes needed in 
> one place, done.
> Also - code in scripts is harder to find/maintain.
> 
> Some people in the past have advocated for removal of all object 
> scripts, placing the code instead into the form method (or better the 
> project method called by the form method). I do not personally do this, 
> as I looked at it once and, to me, the resulting code was too long and 
> not clear -- of course maybe I was not implementing the idea correctly 
> or completely :)
> 
> just my 2 cents
> 
> Chip
> 
> 
> On Wed, 24 Apr 2019 22:37:51 -0600, Chris Belanger via 4D_Tech wrote:
>> 
>> Another use for it that I have not explored yet is to have a chunk of 
>> code that gets run under several different circumstances, but which I 
>> don’t want to make a dedicated Project Method for it.
>> I prefer to reduce the number of Project Methods while, of course, 
>> creating ones that make logical sense (as they can be called in 
>> several places in my code). But you understand that as a programmer.
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: ORDA Limiting number of records returned.

[Herr Alexander Heintz via 4D_Tech]

Am 10.04.2019 um 16:09 schrieb Eric Naujock via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Related to the note about 4D Write Pro documents slowing things u. Would it 
> help to move all the 4D Write documents to a 4D Write table containing the 
> Write and Write Pro records? 

YES!
I have done this for all BLOB or OBJECT heavy tables.
Just created a table called DOC_BLOBS
And only get the records in demand.
A world of difference )
**
4D Internet Users Group (4D iNUG)
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: Best scripting language to use with LEP (docx to PDF)

[Herr Alexander Heintz via 4D_Tech]

For conversion to and from doc/docx (pdf/html/rtf/etc.) we have been using an 
external tool (with command line interface).
It does not require MS Word but you need to install the Office compatibility 
library from MS (free).
It works well as service and is quite stable, the results are good enough for 
us.
The tool is called Total Document Converter by CoolUtils.
Easy to find on the web.

> Am 05.04.2019 um 13:32 schrieb Epperlein, Lutz (agendo) via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Regarding the topic: MS Word on the server
> 
> In the past we use the following approach to generate native .doc files:
> - The application on the server generated reports as html files
> - These files got an extension .doc
> These files were able to open in MS Word.
> But there were problems e.g. if you wanted to forward these generated .doc 
> files via e-mail. They lost the property to render as a MS Word document, 
> they 
> were plain .html files again.
> So we did the following trick:
> - We installed MS-Word on the server.
> - And then we started a script (VBS in this case) ...
> - .. to open the document in MS Word and to save it as a native MS 
> Word-document in format .doc
> - (It could be possible to generate PDF documents as well this way.)
> 
> Now we use another approach (see the thread "Creating Word docs in 4D").
> Installing and using MS Word on a server in a context of Windows services is 
> a 
> rather bad idea. This is anything else but reliable.
> 
> The in the mentioned thread described process to generate .docx documents 
> works well and is reliable. Now we have the requirement to convert these 
> rather complex MS Word documents to PDFs. We didn't found a good solution yet.
> 
> Regards
> Lutz
> 
> 
> 
>> -Original Message-
>> Subject: Re: Best scripting language to use with LEP (docx to PDF)
>> 
>> Good questions Lutz :)
>> I'd like to think that it will work when running as a service as long as a)
>> it runs silently and b) Word is installed on the server. But that is
>> certainly something that will need to be tested.
>> 
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: XLS plugins by Miyako

[Herr Alexander Heintz via 4D_Tech]

> I was quite surprised to learn about releasing objects. When does one have
> to do that? The release commands do not appear in my command list in 4D.


$cell:=XLS WORKSHEET Set cell text ($sheet;$row;$col;$format;$text)
XLS CELL RELEASE ($cell)  //we don't need this reference any more, so release 
it.
If you do not RELEASE the references, your application will leak memory like a 
bucket without bottom…
If your excel sheets are not too big, this might not matter, but...
**
4D Internet Users Group (4D iNUG)
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: XLS plugins by Miyako

[Herr Alexander Heintz via 4D_Tech]

Am 03.04.2019 um 16:52 schrieb Foucauld Perotin via 4D_Tech 
<4d_tech@lists.4d.com>:
> 
> So, if you tried and use those, which one do you prefer? I’m not asking to 
> Miyako, since I know he will answer "oh, I justed wrapped the libraries, I 
> can’t tell which one is the best!" :)

I am using the first one XLS (4d-plugin-xls)
It is a bit more complex to program as you need to release objects etc, but is 
is far more stable, especially on mac.
And also more versatile when it comes to formatting cells.
XLS II tends to crash a lot, at least on mac.
On windows it is quite reliable.
So unless you require Mac, the choice is yours, compare the features and decide 
what you need.

My 2ct (2.25¢)
**
4D Internet Users Group (4D iNUG)
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: Reporting progress

[Herr Alexander Heintz via 4D_Tech]

ONLY sensible solution:

Just use the 4D Progress Component!
Everything else is just reinventing the wheel for nothing, an utter waste of 
time.
Pass the process id variable to whatever process needs to update it and Bob's 
your uncle.

My 2 ct. (Euro cent that is, roughly 2.3 US cent)

> Am 20.03.2019 um 12:47 schrieb Peter Mew via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Hi Jeremy
> I start a new process <>NewProcess and open a window with a text variable,
> vProgress, on a form.
> When ever I want a new message displayed I Do
> <>Message:= "Hello World"+char(13)
> Call Process(New Process)
> Then in the form method for New Process I do
> IF(Form event = on outside call)
> vProgress:=<>Message+vProgress
> end if
> New Messges are added at the top of the message list vProgress
> cheers
> -pm
> 
> 
> On Wed, Mar 20, 2019 at 11:15 AM Jeremy Roussak via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> v17. I’d not looked at the component; my memory is that it provides a
>> progress bar, which isn’t really what I want (I have my own component to do
>> that). I just want line-by-line text feedback, with each line remaining
>> visible as new lines are added.
>> 
>> Jeremy
>> 
>> 
>>> On 20 Mar 2019, at 10:06, Charles Miller via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> What version. Can you use progress component
>>> 
>>> On Wed, Mar 20, 2019 at 6:00 AM Jeremy Roussak via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
 I’d like to give feedback about the process of a multi-step task -
 something like
 
 Contacting server…
 Signing in…
 Getting obligations…
 Submitting data…
 Done.
 
 appearing one line at a time.
 
 Updating a text field in my process’s own window won’t work, as I don’t
 leave the process and no form events are received while the task is
>> under
 way. Another process, with a global variable and CALL PROCESS(-1),
>> perhaps?
 
 I’m sure this must have been done often before and I don’t want to
 re-invent the wheel. Any suggestions gratefully received.
 
 Jeremy
 
 **
 4D Internet Users Group (4D iNUG)
 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)
>> 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)
> 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)
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: Anybody know what's going on at Heubach Media?

[Herr Alexander Heintz via 4D_Tech]

Hi Pat,

school holidays started last week in germany and as we germans tend to have 
some 30 days paid leave every year, it is quite possible that they are closed 
for a week or two of holidays )

Cheers

Alex

> Am 20.07.2018 um 16:22 schrieb Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>:
> 
> I ordered an upgrade for HMBarcode 3 days ago and despite numerous phone
> calls and emails I haven't received my licence number. Nobody responds to
> any emails and the person who answers the phone is becoming increasingly
> impatient and downright rude!
> 
> I'm getting desperate as I can't deploy my latest version!
> Anybody have any inside info? What's going on over there?
> 
> And secondly ...
> Anybody know of an alternative to HMBarcode?
> 
> Thanks
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> 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)
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: xml to array

[Herr Alexander Heintz via 4D_Tech]

Am 27.03.2018 um 14:50 schrieb Peter Mew via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Is there a 4D command that will take a block of xml, and turn it into a
> number of arrays (or pairs of arrays (attribute and value)
> Or is this a stupid question

No 
and 
No

Cheers
Alex
**
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: 4D data on the web - what do you use?

[Herr Alexander Heintz via 4D_Tech]

Am 14.03.2018 um 09:08 schrieb Keith Goebel via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Hi all. 
> We have an extensive 4D system to which we want to provide summary overviews 
> and drill-downs via the web.
> I have a couple of questions I'm hoping somebody will be able to answer...
> 
> Are you using 4Dv16 in a client server environment as well as providing a web 
> interface to the data?
> If so, we would like to know what software and plugins do you use to make the 
> web environment happen?

EASY

> - software and plugins for development?

Active4D and TextMate with A4D Syntax Plugin

> - software and plugins for deployment?

Active4D and TextMate with A4D Syntax Plugin

> - are you able to do the web development without getting the 4D programmer(s) 
> involved (apart from describing the data structure)?

If that is desired, Active4D requires 4D knowledge s….
Might need to write your own REST API ?

CHeers

Alex

**
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 Called from AppleScript

[Herr Alexander Heintz via 4D_Tech]

Hi Folks,

does anyone know, if it is possible to talk to 4D from AppleScript?
I have a small application that receives information form a phone system and 
can launch an AppleScript.
Now I would like this to „talk“ to 4D.
Any ideas, is it even possible?

Thanks
Alex

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

[SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen

[Herr Alexander Heintz via 4D_Tech]

Fellow 4D developers,

it is with great sadness, that I have to inform you, that Ortwin Zillgen has 
passed away end of last week.
Suddenly, unexpectedly and far to early at the young age of 64.

Ortwin was known to many of us for his interesting and innovative ideas for 
interfaces, anything to do with cartography and mastery of subforms, his garish 
striped shirts and baggy yellow jacket, but most of all, as an all-around great 
guy to hang out with and talk of 4d, art, and anything that comes to mind.
I have known him for many years and never saw him without that wide friendly 
grin on his face, I will miss it.

4d tech support all over the world will painfully feel his absence and an 
urgent need to stock up on staff.

He will be missed dearly and we wish him godspeed whichever tricky subform he 
may be heading to.

All the best to y’all and stay safe

Alex Heintz

PS: I will pass on any condolences from the nug to his family
**
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: Win32API 8.2.2 Release

[Herr Alexander Heintz via 4D_Tech]

Am 14.02.2018 um 19:12 schrieb Seth Leeper via 4D_Tech <4d_tech@lists.4d.com>:
> 
> * Updated Orchard Utilities to v1.18.125.0.

Howdy, 
where would I find these?
Cannot seem to get them on GitHub?
Cheers
Alex
**
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: text2picture

[Herr Alexander Heintz via 4D_Tech]

>> Most likely a wrapper for 4 lines of SVG code…
> 
> Was SVG around 157 month ago?

SVG as a format?
Most likely
in 4D, I don’t think so…
But why not use SVG if available?
Its blinding fast

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

[Herr Alexander Heintz via 4D_Tech]

Most likely a wrapper for 4 lines of SVG code…

> Am 14.02.2018 um 08:53 schrieb Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Hi All,
> 
> I read in the iNug archive about a free routine by JPR using only native 4D 
> commands to accomplish that.
> 
> Does someone know where I can find that method?
> 
> Much appreciated.
> 
> Cheers
> Jörg
> **
> 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
**

[ANN] New Blog Post : Using Curl for SMTP

[Herr Alexander Heintz via 4D_Tech]

G'day everyone,

being a bit frustrated with the SMTP commands in 4DIC, I created a replacement 
using Keisukes CUrl plugin.

http://blog.heintz.net/curly-mail-fun/ 

It can easily replace 4DIC SMTP commands as it is mostly command compatible, 
but you will see in the documentation.

Feedback, error reports, etc. always welcome, Source available for a donation 
of any kind.

Cheers

Alex
**
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: "Goodbye 4D Write" email

[Herr Alexander Heintz via 4D_Tech]

I have been using 4D Write Pro for quite some time now as an editor for E-Mails.
Porting the functionality I had before using 4d Write (mostly dynamic access to 
data) was quite simple.
Nevertheless, there is quite a lot missing for it to replace 4D Write for those 
who need a „real“ text editor.
4D Write has been ignored by 4D for ages and the new 4D Write Pro falls short 
on a lot of things.
On the other hand, functionality like 4D Write is used only ba a small 
percentage of developers, and I am quite baffled, that it is the only special 
functionality where no plugin developer has come up with something optional 
(OK, 4D Chart qualifies as well).
Could developing a Plugin like 4D Write with modern functionality really bee so 
difficult as not to be commercially viable?
I mean there are (huge) plugins for
- Reporting
- Drawing
- Scheduling
- GridTools
- Graphics
- etc
- etc

Come on you plugin developers, give us a real Word processing Plugin and there 
will be a market for it.
Sadly this kind of development is out of my league, or i’d do it.

My 2ct

Cheers
Alex
**
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: BRING TO FRONT for process windows minimized

[Herr Alexander Heintz via 4D_Tech]

Always use the commands in Win32 API to determine windows mimize state!
Also to restore it
Providing you are on windows that is…

> Am 10.01.2018 um 16:18 schrieb John DeSoi via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Not sure if this is a new problem in version 16 (16.3 64-bit Mac) or just 
> something I never realized. BRING TO FRONT does nothing if the window is 
> minimized in the dock. You need to call SHOW PROCESS first even though 
> PROCESS PROPERTIES indicates the process is visible. 
> 
> Also, windows minimized in the dock are not included in the WINDOW LIST. All 
> of this makes it a lot more complicated to use CALL FORM when all you have is 
> a process number and need to determine the window reference.
> 
> John DeSoi, Ph.D.
> 
> **
> 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: Interaction with Microsoft Web Service

[Herr Alexander Heintz via 4D_Tech]

Am 07.12.2017 um 15:26 schrieb npdennis via 4D_Tech <4d_tech@lists.4d.com>:
> 
>> Thank you for the response. What i was omitting to say is that i was looking
>> for a solution for the v12 version of 4D and i'm dealing with a SOAP
>> comunication.
> 
> 
> The commands haven’t changed much that I know of between version. Check the 
> v12 manual for web services (web services are SOAP services)

Sorry Neil,
No offense intended:
But:

Won’t ever work!

You cannot use the 4D SOAP Commands with EWS, as EWS requires different 
(unsupported) authentication mechanisms (like NTLM) along with a heavily 
modified SOAP header, wich again cannot be done as required with 4D internal 
tools.

In addition to that, communicating with Exchange Web Services is a dark art, 
tedious, only partly documented, overly complicated!
Took me 2 Months to get it going, as understanding the concepts behind 
creation/modification and deletion of Items is a nightmare.
Look at the introductions to my component and a few of the command descriptions 
and you might understand why.

http://manual.4d-exchange.com/doku.php

You are of course welcome to re-invent the wheel, if not, feel free to contact 
me.

Cheers

Alex


> 
> Neil
> 
> --
> Neil Dennis
> 4D Developer since 1990
> 
> GreaText - Designing Software for the Way You Work
> 716 East 1850 N
> North Ogden, UT 84414
> 
> mailto:npden...@greatext.com
> http://www.greatext.com/
> 
> 
> Neil
> **
> 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: Interaction with Microsoft Web Service

[Herr Alexander Heintz via 4D_Tech]

Well, 
I might have something for you:

I wrote a component a few years ago to communicate with Exchange Web Services 
and it still works quite well.

The Manual is here:

http://manual.4d-exchange.com/doku.php 

Sadly, NO Version 12, as it makes good use of C_Objects.
Also it is not possible to bring it to V12 without a huge amount of work, and I 
do not see that happening unless it’s paid for. Actually, I do not even have a 
V12 installed anymore!
I know, I know, hat it myself when people tell me to update, but nevertheless: 
Update :-)
V16 is a real and true progress compared to 12 or 13 or 14 or 15….
And that from someone who has been working with 4D since the late 80ies and who 
for good reason used to stay 2 versions behind, for my and my clients sake…
Feel free to contact me by PM.

Cheers
Alex

> Am 07.12.2017 um 10:17 schrieb STARDATA via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Hey Neil, 
> Thank you for the response. What i was omitting to say is that i was looking
> for a solution for the v12 version of 4D and i'm dealing with a SOAP
> comunication.
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: Assign multidimensional array

[Herr Alexander Heintz via 4D_Tech]

What about COPY ARRAY ?

> Am 04.12.2017 um 10:45 schrieb stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi All,
> 
> I need to copy a multidimensional array ($A) into another of the same 
> dimension ($B).
> Is necessary do a cicle and assign every single position or is possible to do 
> other?
> 
> ARRAY TEXT($A;1;2)
> ARRAY TEXT($B;0;2)
> $A{1}{1}:="1"
> $A{1}{2}:="2"
> $P:=Size of array($B)+1
> INSERT IN ARRAY($B;$P;1)
> $B{$P}{1}:=$A{$P}{1}
> $B{$P}{2}:=$A{$P}{2}
> 
> 
> Thanks
> Ferdinando
> 
> **
> 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
**

[BLOG] Something new in my Blog : Exporting Listboxes the easy and powerful way

[Herr Alexander Heintz via 4D_Tech]

Hi there everybody,

been away on a longer trip to some warm place so it’s been a bit quiet in here.
But the wait is over and so here is my latest contribution:

http://blog.heintz.net/i-can-grab-your-listbox-believe-me 


It is a component (V14 onwards) that can export the content of a listbox as 
displayed or based on your instructions into text, csv or Excel (requires a 
Plugin by Keisuke - thanks). 
Either into a file or into clipboard.
Works with array and selection based Listboxes and even exports calculated 
columns.

Have fun with it, feedback appreciated.

Cheers

Alex

**
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: Working with a 64 bit Integer in an object

[Herr Alexander Heintz via 4D_Tech]

Hi Justin,

in this case, use low-level routines for the communication (receive BLOB for 
example or some equivalent using Keisukes cUrl Plugin) and parse the received 
data „by hand“.
Tedious, but you have full control.

> Am 03.11.2017 um 00:12 schrieb Justin Leavens via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Keisuke Miyako wrote
>> it seems correct that a number is mapped to real, according to JSON
>> specification
>> ...
>> 
>> if you must exchange Int64, I think it is the responsibility of the sender
>> to use string.
>> 
>>> 2017/11/03 3:56、Justin Leavens via 4D_Tech <
> 
>> 4d_tech@.4d
> 
>>> のメール：
>>> Unfortunately, 4D seems to munge the value immediately within the object
>>> when the HTTP response is returned in an object.
> 
> I'm sure you are correct. Unfortunately, I don't have the power to force a
> change from the provider.
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: POP3 Email Processing

[Herr Alexander Heintz via 4D_Tech]

Yep, parsing complex mails is a pain in the you know where…

Keisuke helped somewhat with his GMime plugin:

https://github.com/miyako/4d-plugin-gmime 


I intended to write a component making it easier to use, but did not get around 
to it yet.
Either you wait for me to get around to it, or PM me ( awheint(at)gmail.com 
 ) and i will drop you a bunch of code that you can use as 
starting point.

Cheers

Alex

> Am 27.10.2017 um 15:35 schrieb Douglas Cryer via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi folks,
> 
> After many years using OTRS for our help ticketing and change control we have 
> recently decided to roll our own 4D based solution.  This is partly a cost 
> thing; partly a support/functionality thing and partly to get our teeth into 
> a project where we can get used to the latest version of 4D while we wait for 
> v17 R3 :-).
> 
> The core of a system like this is reading in Email messages.  I have done 
> simple parsing of emails in the past (long past) but looking at it now I was 
> surprised at how little the internet commands actually do for you before you 
> have to get down and dirty with loads of parsing.
> 
> Essentially we need to create a HTML file with the email body and inline 
> images.  Plus all the attachments; recipients; subject; dates and other info.
> 
> We are looking at using a 3rd party product called "EAGetMail POP3/IMAP4 
> Component” - https://www.emailarchitect.net/eagetmail 
>  to do all the heavy lifting.  
> Before I go ahead and purchase this is does anyone else have any other ideas 
> or options?
> 
> 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
> **

**
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: v16x centipedes, trilobites and various other arthropods

[Herr Alexander Heintz via 4D_Tech]

Am 13.09.2017 um 18:07 schrieb Randy Engle via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Takes 2 Ctrl-V's to paste in.  Not a show stopper, very annoying

Somehow reassuring to know they are consistent across platforms, this is 
driving me nuts on Mac as well!
**
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: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

[Herr Alexander Heintz via 4D_Tech]

Hi Bob,

i will tell a little story that aligns perfectly with what you told:

I have a huge database system for managing car spare parts. 
each part can be of a specific type, thus having specific descriptive criteria
each part can be linked to any number of vehicles, sometimes with a specific 
set of limiting criteria (age range, chassis numbers, etc)

articles are categorized using what we call a generic article (you might call 
it a template) and for this article type there is a definition wich criteria 
need to be filled and wich ones are optional, also if criteria have a defined 
enumeration list, it can be limited for that specific use.

we have long ago decided against using any kind of object for setting these 
criteria, as we loose flexibility:

Finding articles based on generic article and criterium is quite fast in 
standard tables, but when it comes to mass application of criteria or mass 
modifications a separate table is much more flexible, also on im- and export, 
data aggregation, reporting, etc. etc..

The data structure is quite complex, granted, but I have yet to find a 
compelling reason to use anything else, as there is nothing I cannot do with a 
separate table. 

And that is my main argument: IMHO it only makes sense to switch to another 
tool if there is a distinct benefit, and that is something I do not see yet, on 
the contrary, there are a lot of things i cannot do easily when using object 
fields.

So for now, until a compelling reason comes along, I use objects only as a kind 
of „attic“ for the record, keeping complex data I only need from time to time 
(audit trail, source file references, record history, etc. etc.) and that never 
will be used for any business logic.

OTOH I love c_objects variables in the language and make heavy use of these, 
they allow for a much cleaner approach to development (from passing parameters, 
to replacing process variables, storing form object settings, etc. etc.).

Hope this helped, available for further questions, also by PM.

Cheers
Alex
  





> Am 13.09.2017 um 16:28 schrieb bob.miller--- via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Along the lines of, "what is an appropriate use of an object field", I've 
> been considering this:
> 
> We are a manufacturing company with lots of tools and lots of products. 
> Each tool has various attributes, but each tool type has a different set 
> of characteristics. 
> 
> Silly example that I hope everyone can follow: if the tool type is 
> "screwdriver" then the attributes might be:
> 
> Tip Type (blade, Phillips, Torx, etc.)
> Tip Size (#1 or #2)
> Shank length (in mm)
> Handle diameter (in mm)
> 
> 
> ...If the tool type, however, is "hammer" then the attributes might be:
> 
> Head type (claw, peen, sledge, etc.)
> Claw shape
> Head weight
> Shank material
> Shank length
> Grip Type
> ...and many more
> 
> 
> Common to all tools, regardless of tool type are attributes such as:
> 
> Tool ID
> Tool Type - which determines the format and contents of the object field 
> that contains the attributes
> Storage Location
> Purchase Date
> Condition (good, fair, poor, unusable)
> Status (ready to use, in use, lost)
> 
> 
> 90% of the time users want to enter a Tool ID to retrieve the Storage 
> Location, Condition, and Status.  10% of the time they know the tool type 
> but don't know the tool ID and want to query for a tool to do the job, 
> using one or several attributes.  I've been thinking that because there 
> are so many tool types and so many attribute "collections", an object 
> field might be a good place to store the attribute data in name-value 
> pairs.  This way I don't have to have a table with every single attribute 
> name, which would be a problem because I don't know them in advance (users 
> want to be able to specify the attributes themselves, along with the 
> attribute value of course) and many tools do not share many attributes, so 
> a big mostly-empty record would result if I used fields.
> 
> The object field on a record with Tool Type = "screwdriver" would contain 
> attributes for a screwdriver, while the object field on a record with a 
> different Tool Type would contain a different set of attributes.  A table 
> for "Tool Type" would have one record for each tool type and could also 
> use an object field to contain the attribute names, since this would be 
> more handy than having multiple records for each tool type, one for each 
> attribute name.  The normalized, relational model isn't really needed 
> here, though of course it could be used.
> 
> An object field seems ideal for this kind of application, and 'Query by 
> Attribute' certainly makes it possible.
> 
> There are always LOTS of ways to solve a problem, but do you agree that an 
> object field is a good way to solve this one?  If it is a mediocre way to 
> solve it, I'd like to hear your comments!
> 
> 
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation 
> 
> 
> 
> 

Re: QUERY BY ATTRIBUTE is slow af

[Herr Alexander Heintz via 4D_Tech]

Absolutely.
I exclusively use object fields for additional data and storage of connected 
information to a specific data row, such as record and field history, specific 
item settings etc.
All of these will NOT be queried on.
There are cases where I use object fields for variable data structures, but 
limit this to basic 1-level objects that can be queried rapidly.
Also bear in mind, that accessing data embedded in objects is far more 
complicated (for example for mass editing) than using a related table. It might 
sound like an intriguing concept to store, say keywords, in an object array, 
but even if these were quick to query, modifying a bunch a of keywords is far 
more complicated when they are stored in objects than just using an APPLY TO 
SELECTION for a „normal“ related table.
Just my 2 ct, your mileage may vary


> Am 12.09.2017 um 18:58 schrieb Jeffrey Kain via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> So disappointing.

**
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: QUERY BY ATTRIBUTE is slow af

[Herr Alexander Heintz via 4D_Tech]

Am 12.09.2017 um 17:22 schrieb Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Trying to figure out why our experience with QUERY BY ATTRIBUTE is so 
> different than the demos at the last 4D Summit.
> 
> We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 
> 9 million rows, and we added an index to the Extra field in this table which 
> is an object field.
> 
> The following query always runs sequentially - i.e. very very slowly. 
> Thinking it might be a wildcard issue with the email we also tried strings 
> with no '@', but no matter what we do the query runs sequentially.
> 
> QUERY BY ATTRIBUTE \
>  ([Invoices];\
>   [Invoices]Extra;\
>   „gift_card_line_items[].to_email";=;"desig...@sweetwater.com")

If Memory serves me right: the demos at the summit only queried on first level 
object fields:

QUERY BY ATTRIBUTE ([table]; [table]object;“name“;=;“fred“)

You, sir, are trying to get to a second level value from an array

Having worked with 4D since ages long forgotten, I would have to feel very 
lucky and outright daring to even assume such a thing might work :-)

Not helpful I know….
Try searching for a first level direct value if you have such a thing.

Cheers
Alex
**
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: Arrays vs Object for Key/Value pair lookups

[Herr Alexander Heintz via 4D_Tech]

That’s basically it.
only I don not need the wrapper anymore, i go directly to 
word:=OB Get(<>Dict;$t_MyKey;is Text)
Using arrays I sorted the key array and used my own optimized array query 
routine (same as the new Find in sorted array introduced in V16).
With object, no need to sort, the object system optimizes it by itself.
Only no need to calculate as my dictionary table is quite simple:

WordKey
Language
Word

so I queried for the language I needed and then

apply to selection([dict];ob set(<>Dict;[dict]WordKey;[dict]Word)

ready
set
go

could not be conceivably easier

cheers

> Am 17.07.2017 um 16:45 schrieb Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Thanks Alexander.
> 
> Which style of implementation did you use ? Did you use the old array lookup 
> key as the new object key in the key/value pair ? i.e. did you enumerate the 
> keys like this: ?
> 
> === OLD WAY ===
> 
> ARRAY LONGINT(vArrKeysID; 1000)
> ARRAY LONGINT(vArrKeysNames; 1000)
> 
> $x:=Find in Array(vArrKeysID;345)
> 
> If($x>0)
> $0:= vArrKeysNames{$x}
> End if
> 
> === NEW WAY ===
> 
> C_OBJECT($myOBJECT)
> 
> For($i;1;1000)
> 
> $key:=String($i)
> $value:=$i
> OB SET($myOBJECT;$key;$value)
> 
> End For
> 
> …then for finding (passing the ID in $1:
> 
> $key:=string($1)
> 
> $0:=ob get($myOBJECT;$key)
> 
> ==========
> 
> Is that how you did it ? (i.e. with calculated/hashed keys).
> 
> Peter
> 
> 
> On 17 Jul 2017, at 13:17, Herr Alexander Heintz via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> Using objects was MAGNITUDES faster than synchronised arrays
> 
> **
> 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: Arrays vs Object for Key/Value pair lookups

[Herr Alexander Heintz via 4D_Tech]

I did a lot of testing for this as I need to keep a dictionary of words 
identified by word IDs with some 300 000 items around.
I need to retrieve the words based on their ID.
Using objects was MAGNITUDES faster than synchronised arrays (Cannot find the 
number anymore but we are talking measurable differences here, 1ms to several 
hundred), so I immediately trashed the old array based code and rewrite with 
objects.
Never looked back :-) 

Cheers
Alex

> Am 17.07.2017 um 12:46 schrieb Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi
> 
> I remember at last year’s summit, JPR was emphasising how objects were far 
> more optimised than arrays for doing lookups over large numbers of key value 
> pairs.
> 
> e.g. we usually do this:
> 
> $x:=find in array(myKEYS;”product_code_x”)
> 
> if($x>0)
>  $0:=myPRICES{$x}
> end if
> 
> How do people prefer to do this with objects ? Enumerate the keys in some 
> systematic way and then populate the object like this >
> 
> For($i;1;$SIZE)
> 
>  $key:=string($i)
>  $value:=myarrayVAL{$i}
>  OB SET($object;$key;$value)
> 
> End For
> 
> Then for retreiving:
> 
> $key:=string($1)
> 
> $0:=OB Get($object;$key)
> 
> …or was JPR suggesting we use object arrays and do some kind of “find” over 
> the object arrays ?
> 
> Best Regards
> 
> Peter
> 
> **
> 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: Function to return the date/time of the next scheduled backup

[Herr Alexander Heintz via 4D_Tech]

have a look at my blog post:

http://blog.heintz.net/to-backup-or-not-to-backup/ 


should do what you are looking for, the command

ScheduleObject:=BACKUP_GetSchedule(xmlBupReference)

should help here

cheers

Alex

> Am 12.07.2017 um 22:42 schrieb Tony Ringsmuth via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Does anyone have code that correctly calculates, from the 
> /preferences/Backup.xml file, the Date/Time of the next scheduled 4D Backup?
> 
> If so, could you please share it?
> 
> 
> 
> Thanks!
> 
> --
> 
> Tony Ringsmuth
> 
> Business Brothers Inc.
> 
> 763-420-8686
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: v13+ - How to do a 'Find in array' with a picture array?

[Herr Alexander Heintz via 4D_Tech]

use a parallel array with hashes of the pictures.

$MD5_1RF:=Generate digest($FirstBlobRF;MD5 digest 
)

one problem though: you will need to set the pictures into blobs first

PICTURE TO BLOB ( Bild ; BildBlob ; Codec )

should do the trick,
so the digest (a rather short string) will be identical for 2 identical 
pictures and thus easy to compare:

for each array element calculate the hash and keep it in a parallel text array

then calculating the hash for each picture to compare, you can even search in 
array!

Hope this helps,
cheers
Alex


> Am 12.07.2017 um 19:03 schrieb Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I have a picture array which has icons
> I want to use it as a key to the contents of other (parallel) arrays.
> 
> basically 
> if icon{1} = pic1 - do something
> if icon{1} = pic2 - do something else
> etc
> .
> .
> .
> 
> 
> any ideas? code?
> 
> Thanks
> Chip
> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

[blog] new post concerning de- and encoding of IMAP Mailbox names (modified UTF-7)

[Herr Alexander Heintz via 4D_Tech]

Hi Folks,

in case anyone ever encountered the fun of having to decode funny mailbox names 
as used in IMAP, here may be something useful for you:

http://blog.heintz.net/holy-imap-folder-batman/ 


Cheers
Alex
**
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: v14 and OS Sierra - Any real life issues

[Herr Alexander Heintz via 4D_Tech]

Am 16.06.2017 um 07:17 schrieb Ronald Rosell via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Main issue I ran into was running it on a new MacBook Pro with touch bar; you 
> need 4D 15.4 or higher for that to work.  4D v 14.x just quits on you on a 
> touch bar Mac.   (The workaround is to bring up a VM in a program like 
> Parallels running El Capitan;  that will work, even on a touch bar Mac.)

Although it is a bit tedious, you can work 14 on Sierra with Touch Bar.
It does crash from time to time (from 5 times in a day, to sometimes not at 
all), and whenever it does:
- Open MSC - Repair Structure
In 90% of the cases you will be able to work on. 
Just save that 590 line method frequently…

As for accessing Servers, create an empty structure, open it and then connect 
to the server.



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

Re: 4D Web Store Approach...

[Herr Alexander Heintz via 4D_Tech]

> Am 09.06.2017 um 21:40 schrieb Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> So, I have Mac-based 4D v15 desktop application that’s supporting about 10 
> users via client/server on a local LAN. There is a need to create a 
> public-facing web presence that would allow access to the data managed by 4D 
> (254 GBs of externally referenced TIFFs).  The client wants to sell access to 
> these documents where each page is a separate TIFF. The web customer would 
> need to do a search on the documents index in 4D and then view the chosen 
> image (page). At this point, I’d like to work out the best way to accomplish: 
> customer login (account creation), searching the database, loading the TIFF 
> images. For now, the billing and working out how to charge can come later. 
> The data is very valuable so it must be kept secure. So, how would you 
> structure this? 
> 
> Plan A: My original though was to activate the 4D web server and let the 
> local server become the web server. Currently the 4D server is not using a 
> public IP….  What would need to change regarding ports being opened and such 
> to allow the LAN users and the 4D web server to operate too? The client is 
> very security conscious about incoming connections.
> 
> Plan B: move the whole system to the cloud. I have another system running on 
> MacMiniVault which is 100% web access and it has it’s own public IP. With 
> this approach, the current LAN users could possibly connect with 4D over the 
> internet…. Possible security and performance problems with that idea.
> 
> Plan C: Something super-awesome that you suggest that I never thought about!  
> :)

Hi Robert,

Plan C with a twist : Use Active4D as middelware and rite the front-end in a 
standard JS framework ( JQWidgets and Bootstrap are great).
Get a static IP for the server.
Oh, and ditch using Macs as Servers, sorry but they s..k big time as servers…

Done a full WebShop for car spare parts this way and it’s a dream.

Achieving what you intend to is actually not that big a deal, including the 
security part.

Contact me vie PM if you want more specifics : awheintz(at)heintz.net.

I do this for a living, so I offer outsourcing services for 
bringing 4D into the web

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

[ANN] HotFix of AC_Backup Component

[Herr Alexander Heintz via 4D_Tech]

Hi Folks,

in case any of you thought about using my AC_Backup component, please head 
right over to

http://blog.heintz.net/to-backup-or-not-to-backup/ 


There is an essential Update available that you ABSOLUTELY need.
Sorry for the inconvenience,
Alex
**
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
**

[4DTidbits] New Post : Fun with Backups

[Herr Alexander Heintz via 4D_Tech]

Hi Folks,

here is something new from my never ending collection of components:

AC_BackupTools

http://blog.heintz.net/to-backup-or-not-to-backup/ 


Enjoy, feedback welcome.

Cheers
Alex
**
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: Migrating OS X server to Windows Server

[Herr Alexander Heintz via 4D_Tech]

Been there,
done that

When upgrading you licence to, say V15, you can register that license on a 
totally different platform, no hassle.

I advise all my clients to move to Windows for Server, its just so much more 
bang for your buck and far easier to administrate.
Oh, and 64Bit even on V12.
As for moving your V12 Licenses to Windows:
Call your 4D Sales Rep, they can „reset“ the activation of your license and you 
can re-register it on another platform.

Cheers
Alex

> Am 17.05.2017 um 15:12 schrieb Paul Lovejoy via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi,
> 
> We are hitting the limits of our old xServe hardware which is currently 
> running large v12 databases. We are planning a major upgrade to 4D v15 but we 
> are running into difficulties with the stability of these old xServes with OS 
> X 10.10 or more recent, which is required for v15. We are currently 
> attempting to run v12 on OS X 10.10.5 and the results are disastrous, so we 
> have to go back to older OS versions.
> 
> Since Apple has no longer upgraded its server hardware for over 7 years, this 
> is obviously a lost cause. So we will be looking to move to Windows.
> 
> Has anyone done such a move recently? Does 4D have a policy for side-grades 
> from Mac to Win for server licenses?
> 
> 
> Cheers,
> 
> 
> Paul
> **
> 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: Website development path

[Herr Alexander Heintz via 4D_Tech]

To a degree :-)

we use Active 4D to gather data based on the requests coming from the browser.
All data is packaged as JSON and sent back to the browser.
This includes login / queries for products, etc.
The whole interface is rendered in the browser using the tools offered by 
JQWidgets.
There is only one static html page (index.a4d) and this one loads all required 
libraries (JQuery, JQWidgets, etc.) from tehre on, everything is completely 
dynamic.
In order to explain the different concepts behind this and how JQWidgets works, 
I would need to write quite more than would fit in an E-Mail. 
If you have a basic concept of Javascript, JSON and how dynamic DOM 
manipulation works, a quick look at JQWidgets and the examples provided should 
get you going.
If not, either start getting into these things or contact me privately if you 
are interested in outsourcing this work :-)

Cheers
Alex


> Am 13.05.2017 um 03:52 schrieb Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Alex, please tell us more about that—thanks!
> 
> Robert
> 
>> On Jan 19, 2017, at 2:43 AM, Herr Alexander Heintz  
>> wrote:
>> 
>> Recently did a shop for car spare parts with it, a fast and reliable 
>> combination.
> 
> **
> 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: Hex Colour Picker in Listbox

[Herr Alexander Heintz via 4D_Tech]

Hi Doug,

did you see my last blog post „Fun with colors"?

http://blog.heintz.net 

it has some handy tools when it comes to colors, maybe there is something that 
could hep you solve this

Cheers
Alex

> Am 11.05.2017 um 10:47 schrieb Douglas Cryer via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hello all,
> 
> I have a list of colours in my system and I have a corresponding hex colour 
> code field but nobody has really used it.  I want to do a few things:
> Automatically map common colours to hex colours (via a lookup
> Provide a hex colour picker that I can use in a listbox
> Use the returned/edited hex colour to do one of the following:
> Set the text colour to the chosen hex value
> Set the row or cell colour to the chosen hex value
> Is there an example of this anywhere?
> 
> 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
> **

**
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: Preemptive mode flaw

[Herr Alexander Heintz via 4D_Tech]

Am 09.05.2017 um 22:58 schrieb JPR via 4D_Tech <4d_tech@lists.4d.com>:
> 
>> us has said what we think the glass is half full *of* ;-)
> For me, it will be half-full (at least) of Puligny-Montrachet 1961 from 
> Maison Faiveley ;-)

I seem to be doing something wrong, my hourly rates only allow for a 3 liter 
karton of vin de pays :-)
**
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 Tidbits] - phonetic searches, replacement for SOUNDEX

[Herr Alexander Heintz via 4D_Tech]

Hi everyone,
in case someone has struggled with phonetic searches, especially trying to get 
SOUNDEX to work on those pesky foreign names, I may have something for you 
today:

http://blog.heintz.net/soundex-shmockdex/ 


Its free, there is no support, if you change something in the source please 
feel free to send me a mail of what you did and why.
Thanks and cheers,

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

Re: 4D Compiler

[Herr Alexander Heintz via 4D_Tech]

This is where strict variable nomenclature with typing info helps a lot.
You can easily create a method that can gather all locals in a piece of code, 
and add the declarations at the top of a method.
You can even apply that automatically using METHOD GET CODE and METHOD SET CODE.
OTOH if you have no variable nomenclature with typing…
69000 typing errors.
Forget it, seriously...

> Am 07.04.2017 um 18:29 schrieb Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Nigel,
> 
>> I tried David Adams suggestion of trying ‘all vars are declared’ and at 
>> 69000 errors decided that was not the way to go!
> 
> You really should try to fix those...That is 69,000 places that 4D is 
> guessing what the variable type should be - instead of you explicitly telling 
> 4D what the variable type should be. All you need to do is use C_TEXT or 
> C_LONGINT or C_* at the top of your methods to declare what the variables 
> are. This is the best practice after all.
> 
> Just my 2 cents.
> 
> -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
**

[Blog News] Accessing remote Log Files

[Herr Alexander Heintz via 4D_Tech]

Hi Folks,

If you ever needed a system to access the logs folder of any given user of your 
system, here ist you solution:

http://blog.heintz.net/view-log-files-not-only-local-ones/ 


Have fun and feedback is welcome
**
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: Anyone using v16 in WAN

[Herr Alexander Heintz via 4D_Tech]

Am 04.04.2017 um 14:54 schrieb npdennis via 4D_Tech <4d_tech@lists.4d.com>:
> 
>> if you have no issues using the database in user mode over the same network, 
>> then perhaps some methods are choking the network in a way that does not 
>> happen over the legacy layer.
> 
> I found the new net work layer unusable as well. During heavy loads 4D will 
> quit responding. I use legacy network and things work great. This was all 
> done on a LAN not a WAN.

Same here, found the new network layer to be extremely unreliable, switched it 
off everywhere.
Will not try again until 4D tells me they fixed it big time!
The specs and the theory is sure interesting and it would be great, believe me, 
very great, but currently it is at most in a  „proof of concept“ Alpha stage...

**
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: Methods starting with a number

[Herr Alexander Heintz via 4D_Tech]

We have all been pampered by 4D insofar as nomenclature that was strictly 
forbidden in most other languages was permitted.
It already breaks on table and field names when using SQL, many of the other 
things are next.
I never thought it was an especially wise idea to allow spaces and 
diacritical characters in programming language nomenclature…
So yes, I would at one point take the time to clear this up, and while you are 
at it get rid of any spaces in method, table and field names as well.
My 2 ct.
Cheers
Alex

> Am 03.04.2017 um 08:00 schrieb Wayne Stewart via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Hi,
> 
> I just noticed here:
> http://livedoc.4d.com/4D-Language-Reference-16-R3/Language-definition/Identifiers.300-3218655.en.html
> 
> That you can't start a method name (indeed anything) with a number.
> 
> I've done that for years with no problems do I need to do a big global
> find and replace?
> 
> Regards,
> 
> Wayne
> 
> 
> Wayne Stewart
> about.me/waynestewart
> **
> 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: [4DTidbits Blog] Epoch & Unix Timestamp Conversion

[Herr Alexander Heintz via 4D_Tech]

Am 26.03.2017 um 22:14 schrieb Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Avoid using Date() to convert a string to a date because this will rely on 
> the date being formatted according to you current system setting...

Yes and no…

Using DATE() with an ISO Timestring (2017-03-23T22:15:22Z) as returned by 
string(date;ISO Date;time) is safe across all system settings.

For this reason I NEVER use any other date-time string format internally, local 
formats are only used for input and display. never for storage.
**
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
**

[4DTidbits Blog] Epoch & Unix Timestamp Conversion

[Herr Alexander Heintz via 4D_Tech]

Hi Y'all,

just a short one for the weekend, maybe someone can use it:

http://blog.heintz.net/a-quick-one-epoch-unix-timestamp-conversion/

Cheers
Alex
**
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: Unique Files Verification Software (Mac)

[Herr Alexander Heintz via 4D_Tech]

You're welcome.
I need this as we store all attached files of e-mails in our DMS and here we 
find truckloads of duplicates (logos in mail signatures, etc.)
In order to avoid blowing up storage we calculate a hash of every file and only 
store uniques, and then link them to the appropriate source documents.
Of course, when we switched to this system we had to cleanup all the existing 
storage, hence we did somethings similar.
Using the hash has proven to be the best and most secure approach as ist is 
guaranteed to identify identical files no matter what they are named, it even 
finds them if someone mistakenly uses a different suffix (i.e. jpeg instead of 
jpg).

Cheers
Alex

> Am 14.03.2017 um 10:11 schrieb Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Alex, thanks for the input. I thought it might be a good task for 4D.  So how 
> or why do you need such a tool?
> 
> Btw: I don't really need the hash comparison if I had other file attributes. 
> I'll look at this again tomorrow. 
> 
> Thanks,
> 
> Robert
> 
> Sent from my iPhone
> 
>> On Mar 14, 2017, at 3:25 AM, Herr Alexander Heintz via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> 
>> I use a similar Algorithm for optimizing document storage.
>> Pretty simple actually:
>> just troll through all directories recursively and store each file in a 
>> record.
> 
> **
> 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: Unique Files Verification Software (Mac)

[Herr Alexander Heintz via 4D_Tech]

Hi,

I use a similar Algorithm for optimizing document storage.
Pretty simple actually:
just troll through all directories recursively and store each file in a record.
You just need the path and the file hash which you can create with

DOCUMENT TO BLOB($t_DocPath;$x_Content)
$t_FileHash:=Generate digest($x_Content;MD5 digest)
SET BLOB SIZE($x_Content;0)

Then just check for unique hashes and voila!
Using the hash will also find identical files that have different filenames.
The chances of 2 different files generating the same hash are so close to 0 
they are for all practivcal reasons 0.
Now write something that moves unigue data somewehere else or deletes 
duplicates.

Whole thing is quickly written, I guess some 100 lines of code.
120 with progress bars :-)

As for running it, well that will take some time, don’t do it on you main work 
machine, it might be tied up for a while.

Hope that helped.

Cheers
Alex

> Am 14.03.2017 um 07:56 schrieb Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I need a utility that can scan a backup drive (or index) and identify what’s 
> unique to the backup volume without expecting identical pathnames on the 
> other drives... So, the routine would have to query (effectively a Finder 
> Search for each file) all specified drives looking for each file and 
> reporting those that are missing... Basically, I need to know which data on 
> this given backup drive is truly unique and therefore potentially valuable.
> 
> Might there be a 4D solution?  Have you dealt with large directories or many 
> directories from the file system? If there is a utility already built I’m 
> open to that as well.
> 
> Thanks,
> 
> Robert
> **
> 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: What is Cadran?

[Herr Alexander Heintz via 4D_Tech]

„Cadran“ is french for „frame“.

You ran into a bug in 4D itself, as you might know much of 4Ds interfaces are 
programmed in 4D itself!

Most of the time these go away after a restart, otherwise delete all 
preferences and re-install the application.


> Am 08.03.2017 um 11:28 schrieb Douglas Cryer via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I have  number of EPOS tills which use an engined 4D application which has 
> been in place for around 6 years with a few upgrades and version releases.  
> One of the till has just started reporting an error:
> 
> Error when executing the method “Cadran_1” at line number 8
> The method cannot be executed
> Project method cannot be found
> Cadran
> 
> I am baffled as I have no such method?  Does anyone know what might be 
> causing this?
> 
> 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
> **

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

DebugLogReader Update 1.01

[Herr Alexander Heintz via 4D_Tech]

Sorry folks,
had a little bug in hierarchical view, please download fixed version 1.01:
Download DebugLogReader V 1.01 

Have fun
Alex
**
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: Better variable names

[Herr Alexander Heintz via 4D_Tech]

quite interesting read, thanks.

The value of sensible naming never shows more strongly when you have to work 
with OPC (Other Peoples Code) and find generic variables like S_1 or AR1 that 
are used in changing roles throughout the code and are an incredible pain to 
debug, or even replace…

Concerning the descriptor, I have found it more useful to have that up front, 
spearated by underscore:

$t_myText
$al_myLongArray
o_processObject

etc.
Why?
3 reasons:
- when typing and you need a specific local text variable you already have, 
just type the prefix and the editor will show you all text variables you 
already have.
- I can easily check for compiler typing errors by searching (for example) all 
C_LONGINT in compiler declarations where the variable does not start with  l_
and, much more import as I am lazy:
I have a macro and method that automatically declares all my locals in a method 
and puts the block on top.
Easier to recognize the type if you just need to match a starting pattern…

Cheers

Alex

> Am 24.02.2017 um 04:29 schrieb David Adams via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Here's one of those thoughts that I think to repost every few years.
> 
> Many of us use variable naming conventions to carry various bits of
> information about what's in the variable/array. Like this format:
> 
> vtCity
> vlWindow
> 
> Of course, no one uses that particular format as it's use will later
> condemn you to the pits of perdition. Instead, people are probably using:
> 
> Module + Descriptor + Type
> 
> Like
> 
> Customer_City_t
> 
> "Module" being a basic language concept missing from the 4D language. It's
> helpful to group resources into pseudo-modules to prevent pathological use
> of global data. But I digress. What I wanted to say again was something
> about type names: It can really improve the meaningfulness of a name if you
> expand your concept of 'type'. Instead of limiting ourselves to 4D's
> primitives, think of larger types. This can help in a few ways, the first
> being readability:
> 
> $form_name_t
> $tFormName
> $form_name
> 
> It's a name, of course it's text, what else would it be? Why tack _t on
> there? What does it add? It spends a couple of characters without adding
> any information. "Name" carries both the base type and it's type in the
> larger context of your code. The compiler can sort out types no matter what
> their name. 4D's automatic variable being a case in point:
> 
> vRecNum
> 
> It's text. Of course it is. And it almost squeezes maximum value out of the
> 8 character name limit ;-)
> 
> Similar to form name, method name is an even better example:
> 
> $error_method_name_t
> 
> Okay, it's an error method. Well, we can validate method names - I'd prefer
> to think of it as
> 
> $error_MethodName
> 
> To the 4D Compiler, it's a string. That's it. But it isn't. Not any string
> will do, it has to be a string found in the list of project methods. Your
> code makes more sense when you see it that way.
> 
> So, when the primitive type is obvious from context, why not use a 'type'
> abbreviation that tells you more? Here are three different longints:
> 
> log_l
> log_l
> log_l
> 
> Oh. What about
> 
> log_docref
> log_hlist
> log_winref
> 
> That's a lot more information for no real cost.
> 
> I tend to use abbreviations like these as well as
> 
> _name
> 
> for internal names of stuff. Names are text in my universe, if you use
> longints or something - you're on your own.
> 
> Oh, it's helpful to have a currency abbreviation if you apply standard
> rounding to reals-that-are-currency.
> 
> I was reminded of all of this today as I'm doing some work with objects
> where know that the variable is an object tells me close to nothing. I've
> got an object that describes a 'recipient' of a callback from CALL WORKER
> or CALL FORM. So, it's type is "recipient"
> 
> $subscriber_recipient
> $callback_recipient
> 
> This is an object with a specific collection of attributes with rules.
> There's a method to create a recipient, to validate a recipient (make sure
> the window/method exists, etc.) Recipients can be passed around for various
> purposes.
> 
> Right, back to your regular discussions
> **
> 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
**