Re: I'm puzzled...

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

Re: File Excel created from 4D

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

Re: Count of young new developers after ...

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.

Re: 4D Chart replacement

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,

Re: Remember "Layout Procedure" in 4D v2?

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

Re: PING of life...

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.

Re: Object notation replacement for use of Self in a script — v18

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

Re: New Notarization Issues

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

Re: With v18r2, can 4D display pdf documents?

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 >

Re: Gmail, LSA, and OAuth

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

Re: Remote working with 4D networks - what are people using ?

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

Re: Remote working with 4D networks - what are people using ?

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)?

Re: Remote working with 4D networks - what are people using ?

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

Re: Remote working with 4D networks - what are people using ?

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 Ma

Re: Remote working with 4D networks - what are people using ?

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

Re: Remote working with 4D networks - what are people using ?

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

Re: Gmail, LSA, and OAuth

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

Re: Create SQL DB ERD from 4D Export Structure XML File?

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

Re: Create SQL DB ERD from 4D Export Structure XML File?

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/

Re: DOCUMENT LIST : how do I know the documents are valid

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

Printing structures : Update

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/

Printing structures

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

Re: Printing Structure Diagram

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

Re: Resizing text on en Entry form

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

Using the HELP Menu for my own purposes.

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

Re: Project methods vs ...

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

Re: ORDA Limiting number of records returned.

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

Re: Best scripting language to use with LEP (docx to PDF)

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

Re: XLS plugins by Miyako

> 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

Re: XLS plugins by Miyako

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

Re: Reporting progress

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

Re: Anybody know what's going on at Heubach Media?

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

Re: xml to array

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

Re: 4D data on the web - what do you use?

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

4D Called from AppleScript

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

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

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

Re: Win32API 8.2.2 Release

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

Re: text2picture

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

Re: text2picture

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

[ANN] New Blog Post : Using Curl for SMTP

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

Re: "Goodbye 4D Write" email

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.

Re: BRING TO FRONT for process windows minimized

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 >

Re: Interaction with Microsoft Web Service

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

Re: Interaction with Microsoft Web Service

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

Re: Assign multidimensional array

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

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

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

Re: Working with a 64 bit Integer in an object

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 >

Re: POP3 Email Processing

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

Re: v16x centipedes, trilobites and various other arthropods

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!

Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

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

Re: QUERY BY ATTRIBUTE is slow af

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,

Re: QUERY BY ATTRIBUTE is slow af

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

Re: Arrays vs Object for Key/Value pair lookups

> 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) > > =========

Re: Arrays vs Object for Key/Value pair lookups

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

Re: Function to return the date/time of the next scheduled backup

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

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

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

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

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

Re: v14 and OS Sierra - Any real life issues

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

Re: 4D Web Store Approach...

> 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

[ANN] HotFix of AC_Backup Component

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

[4DTidbits] New Post : Fun with Backups

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

Re: Migrating OS X server to Windows Server

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

Re: Website development path

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

Re: Hex Colour Picker in Listbox

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 >

Re: Preemptive mode flaw

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

[4D Tidbits] - phonetic searches, replacement for SOUNDEX

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

Re: 4D Compiler

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

[Blog News] Accessing remote Log Files

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

Re: Anyone using v16 in WAN

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

Re: Methods starting with a number

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

Re: [4DTidbits Blog] Epoch & Unix Timestamp Conversion

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

[4DTidbits Blog] Epoch & Unix Timestamp Conversion

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

Re: Unique Files Verification Software (Mac)

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 &g

Re: Unique Files Verification Software (Mac)

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

Re: What is Cadran?

„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

DebugLogReader Update 1.01

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:

Re: Better variable names

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…