Re: 4D View - create spans?

2019-05-21 Thread Koen Van Hooreweghe via 4D_Tech
Hi Pat, One trick shown on the World Tour to manipulate 4D View Pro data is to export the data to an object, manipulate the object and then import it back to the View Pro area. Creating a span in the first row merging column 1 to 5, can be done as follows: $vpAreaName:="ViewProArea"

Re: More Engine quesitons

2019-04-24 Thread Koen Van Hooreweghe via 4D_Tech
:17 heeft Compass - Koen Van Hooreweghe via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > Yes. You have to place an icon file next to your structure file having the > same name as your .4DB. Compass bvba Koen Van Hooreweghe Kloosterstraat 65

Re: More Engine quesitons

2019-04-24 Thread Compass - Koen Van Hooreweghe via 4D_Tech
Hi Chip, Yes. You have to place an icon file next to your structure file having the same name as your .4DB. Groeten, Koen Verstuurd vanaf mijn iPhone X > Op 24 apr. 2019 om 20:11 heeft Chip Scheide via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > Custom desktop icon. > >

Re: v17 Print Settings in a form's Property List

2019-04-10 Thread Koen Van Hooreweghe via 4D_Tech
Hi David, Use 'Settings' from the property list. Then in the Print dialog use 'Preferences' button. You will be able to set orientation. Button 'Advanced...' will give you more options (like paper size) depending on the driver. A bit of a hassle, I agree (and that is why I'm working on mac

Re: v17 Print Settings in a form's Property List

2019-04-10 Thread Koen Van Hooreweghe via 4D_Tech
Hi David, AFAIK this is OS behavior difference between 32bit and 64bit. Just try any other 32bit or 64bit windows app and print. As far as those apps don't roll out their own print dialogs (like Word...) HTH Koen > Op 10 apr. 2019, om 04:31 heeft David Rose via 4D_Tech <4d_tech@lists.4d.com>

Re: Problems with Microsoft Print to PDF

2019-04-02 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keith, Just to confirm I've seen issues with PDF's generated from 4D v17R3 using MS PDF driver. This is happening on my Citrix account at a customers site. Acrobat Reader says the document contains an error and cannot be displayed correctly. If I open it on my Mac using Preview, no problem.

Re: Printing a PDF document from 4D

2019-03-19 Thread Koen Van Hooreweghe via 4D_Tech
Hi Julio, There is another plugin from pluggers.nl which handles viewing and printing of pdf documents too: PDFViewer. I have been using it on macOS for years. Excellent support from Rob for the rare occasions I needed it. Kind regards, Koen > Op 19 mrt. 2019, om 12:39 heeft Luc Devar via

Re: Can't get to development mode!

2019-03-13 Thread Koen Van Hooreweghe via 4D_Tech
Hi Doug, Perhaps a typo, but you actually need the Developer license to be able to go to design mode. the Unlimited Desktop license is the one you need to include if you build single user apps. HTH Koen > Op 12 mrt. 2019, om 23:49 heeft Doug Hall via 4D_Tech <4d_tech@lists.4d.com> > het

Re: Looping and control flow

2019-03-11 Thread Koen Van Hooreweghe via 4D_Tech
From the top of my head. What about: something:=true while(something) if(not interested) something:=false else process end if end while HTH Koen > Op 11 mrt. 2019, om 19:41 heeft Sandor Szatmari via 4D_Tech > <4d_tech@lists.4d.com> het

Re: PDF as base 64

2019-03-04 Thread Koen Van Hooreweghe via 4D_Tech
Hi chuck, Create your PDF as usual (set print option...), then read the pdf file into a blob (document to blob), convert the blob to base64 (base64 encode) and finally write the resulting text data (or blob if you want) to disk. HTH Koen > Op 4 mrt. 2019, om 20:42 heeft cjmiller--- via

Re: Printing 4D Write to PDF via Windows 10 "Microsoft Print to PDF"

2019-03-01 Thread Koen Van Hooreweghe via 4D_Tech
Hi Bill, I think the OPEN/CLOSE PRINTING JOB is not needed and perhaps causing problems with 4D Write. HTH Koen > Op 1 mrt. 2019, om 18:01 heeft Bill Hutten via 4D_Tech <4d_tech@lists.4d.com> > het volgende geschreven: > > It works, in that a PDF is created, with the right $fname, at the

Re: Build Application “No License is Installed" and ...

2019-02-25 Thread Koen Van Hooreweghe via 4D_Tech
Hi John, Did you add/update your new licenses in the "Licenses & Certificate" tab of the Build Application dialog? HTH Koen > Op 25 feb. 2019, om 17:07 heeft John J Foster via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I am using my 4D v17 Partner licenses which have been

Re: Base64 Encoded text

2019-02-14 Thread Koen Van Hooreweghe via 4D_Tech
Hi Bob, It is normal the HL7text is longer than the PDF size. As Base64 encoding converts a binary file to be sent by a text protocol. I decoded the starting part of your hl7 record you provided and I get '%PDF-1.4 %' which is the start of a PDF file. Looks good to me. For start you could try

Re: 4D Write Pro Brain Cramp

2019-02-13 Thread Koen Van Hooreweghe via 4D_Tech
Hi Tom, I suppose the problem is that you are copying the reference of your preference_object WP to [invoices] and not the wp content itself. This way ST Freeze is also modifying your original WP and in the next run of the loop there are no more references to be freezed. Afterwards your

Re: v17 conundrum in design

2019-02-08 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chuck, Is it happening on a line of code which is split up in several lines ('\')? I've seen this happening a number of times. Mainly quitting and restarting 4D is enhough to solve this issue. You might try to remove the slash chars, set a breakpoint at the remaining line and remove it right

Re: How to display read-only input form

2019-02-07 Thread Koen Van Hooreweghe via 4D_Tech
Hi Jim, Have you tried MODIFY SELECTION instead of MODIFY RECORD? Set the table in read only mode, make sure only the requested record is in the current selection and then open the record using MODIFY SELECTION. Without the. optional * parameters, this command should open it immediately in the

Re: 4D Write Pro license question

2019-01-14 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chuck, IMHO this is not correct. I recently struggled a lot with 4D View (Pro) licenses. A customer has 40+ users on 4D Server (v16), but only a few of them need 4D View. So they bought a 5 user license. These are my findings : - if there are no user groups, the licenses are assigned upon

Re: Open a document in compiled: ok, but when with standalone get message: invalid path name

2019-01-10 Thread Koen Van Hooreweghe via 4D_Tech
Hi Ernie, Just a wild guess. Could you try without the "*"? Use an empty string or even remove the second parameter (it is optional). $tDocRef:=Open document($DocPath_t;Read mode) Are you building with the same desktop volume version? Have you tried compiled against 4D developer (without

Re: Pasting Spreadsheet Data into 4D Records

2018-12-24 Thread Koen Van Hooreweghe via 4D_Tech
Hi Alan, You'll probably have to start the 'paste' from a button or menu item and write some code. $data:=Get text from pasteboard //you'll probably get a tab delimted text If needed, try to find out what delimiters are used And finally parse the text data and assign to the fields of your

Re: Proper decoding for document returned via SOAP call?

2018-12-12 Thread Koen Van Hooreweghe via 4D_Tech
Hi Bob, PDF documents are binaries, to be able to send them through a text protocol, they are encoded. In your case it is base64 encoded. So you need to decode the data in the getObjectFileReturn tag. If I understand correctly, you ahve the data part in $Value, then use this (from the top of

Re: Compact data file

2018-12-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keith, Considering this issue. Last week I had to repair a v16 datafile. In the MSC, right after the repair I ran a verification. The verification was done on the old datafile. The repaired datafile was still in the subfolder '...repairing...' instead of on the original location as I would

Re: SQL TRIM

2018-11-15 Thread Koen Van Hooreweghe via 4D_Tech
Hi Jim, You are missing the 'from' clause with a table. 4D does not support sql queries without table. Eg in Oracle I would write: select trim(both from :vtext) from dual into :vtext; But it seems 4D sql does not support the dual phantom table either. Koen > Op 15 nov. 2018, om 15:50 heeft

Re: 4D v16.4 Built database won't open in Mojave

2018-11-05 Thread Koen Van Hooreweghe via 4D_Tech
Hi Walt, In the past I experienced a similar issue. Seems to be a some kind of permissions problem. Could you try to zip your app, transfer the zip to your MacBook and unzip it on that machine. HTH Koen > Op 5 nov. 2018, om 02:30 heeft Walt Nelson via 4D_Tech <4d_tech@lists.4d.com> > het

Re: 4d write pro

2018-10-31 Thread Koen Van Hooreweghe via 4D_Tech
Hi Charles, WP EXPORT VARIABLE([table]wpDoc; $blob; wk 4wp) Have not used it myself, but the wk 4wp format is available from v16. Kind regards, Koen > Op 30 okt. 2018, om 20:28 heeft Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > Is there any way > to store

Re: Defining and documenting Objects

2018-10-11 Thread Koen Van Hooreweghe via 4D_Tech
Hi Tom, Objects can be 'exported' to JSON quite easily: $json_text:=JSON Stringify($4Dobject) Then you can expose this text data to the external system. The other way around is: $4Dobject:=JSON Parse($json_text) I really advise the step up to v15 and further. Objects are quite fun to work

Re: PDF generation on Windows - Latest Thinking

2018-09-12 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chuck, Sure it works. We use it with 4D v16 on Windows. It is mentioned in the language reference: http://doc.4d.com/4Dv16/4D/16.4/Integration-of-PDFCreator-driver-under-Windows.300-3978065.en.html But I think the example has a mistake. The second parameter of the SET PRINT OPTION command

Re: PDF generation on Windows - Latest Thinking

2018-09-12 Thread Koen Van Hooreweghe via 4D_Tech
Hi Peter, IMHO 4D vs PDFCreator is end of life as recent versions of PDFCreator are not supported. We also switched to the native Windows 10 PDF driver. If you want to store your print documents directly to disk, you must set the path (as on macOS or with PDFCreator): SET PRINT

Re: Help please - Compiling

2018-08-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, Typo? $Sze:=Size of array($Handle->) If ($Size<=12) $Sze is defined, $Size not. HTH Koen > Op 17 aug. 2018, om 17:18 heeft Chip Scheide via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > $Sze:=Size of array($Handle->) > > If ($Size<=12)

Re: Creating Windows Taskbar Icons with 4D Version Numbers

2018-08-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi all, FWIW, on macOS I'm using a slightly different approach. Instead of renaming the application I change the icon. Copy/paste in Finder File Info window I use the actual 4D icons, but add the version and build number and also a small indicator for 64bit.

Re: v13 - Record to Blob?

2018-07-31 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, No native command as you might have learned from the answers on your post. Not too difficult to implement yourself. Below is what I've been using for a long time. I just noticed that I did not delete the intermediate disk document, but if untouched, the files in the temporary folder

Re: v13 - Konstant problem

2018-06-26 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, Just a wild guess, you don't have by accident a field or method with the same name? Is your constant correctly styled in the method editor? Is your constant typed as longint in 4D Pop? Or as auto? HTH Koen > Op 26 jun. 2018, om 00:14 heeft Chip Scheide via 4D_Tech >

Re: XSLT APPLY TRANSFORMATION Replacement

2018-06-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Doug, Al always, the Miyako well full of plugin magic: https://github.com/miyako/4d-plugin-xslt Kind regards, Koen > Op 22 jun. 2018, om 10:04 heeft Douglas Cryer via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I have a client who has just hit a problem with a deprecated

Re: Error on HTTP request on v16B6

2018-06-21 Thread Koen Van Hooreweghe via 4D_Tech
Hi David, If you have access to the 4D forums, check out: http://forums.4d.com/Post//24265962/1/ You could change the TLS minimum version just before your http request call: SET DATABASE PARAMETER(Min TLS version;TLSv1_1) Its worth a try, but for me it did not work. There seems to be a bug

Re: MySql login problem

2018-06-18 Thread Koen Van Hooreweghe via 4D_Tech
Hi Pat, Could there be an access hosts filtering setup up on the MySql database? Maybe a change in the customers WAN ip address causes the access denial? Just a thought. Kind regards, Koen > Op 15 jun. 2018, om 20:57 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > het volgende

Re: Delay process bug

2018-06-13 Thread Koen Van Hooreweghe via 4D_Tech
Hi Jim, Is there somehow PAUSE PROCESS/RESUME PROCESS involved? I don't know if this has something to do with our issue, but I'd like to share a change in behavior (bug?) between v15 (and older) and v16 (and later). Also struggling with a process not waking up after the delay time, I found

Re: Pointer to field using field name

2018-05-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Alan, If you have the table number, you can loop over the fields of that table and compare the name to the given name to get the field number and thus the field pointer. Something like: //$foundtable is the table number //if pointer given, $foundtable := Table($tablepointer) For ($i;1;Get

Re: Macro to check that local variables are declared in a method?

2018-04-27 Thread Koen Van Hooreweghe via 4D_Tech
Hi Bob, Take a look at 4D Pop. There is such a thing in dhe 4D Pop macros part. HTH Koen > Op 27 apr. 2018, om 17:54 heeft Bob Miller via 4D_Tech <4d_tech@lists.4d.com> > het volgende geschreven: > > Has anyone created a macro to check a method to make sure all its local > variables are

Re: Web Area display PDF

2018-04-23 Thread Koen Van Hooreweghe via 4D_Tech
Hi John, If you keep the pdf way, also check out the excellent PDFViewer plugin from pluggers.nl . I have been using this on Mac for a long time already. No Windows experience. HTH Koen > Op 21 apr. 2018, om 01:04 heeft John Baughman via 4D_Tech > <4d_tech@lists.4d.com>

Re: Downloading files via FTP

2018-04-23 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keisuke, I think Stephanie Tirtiat did a very nice job creating the bug report following my TAOW case and made the regression part pretty clear (see details below). But the most frustrating part is that it took 4D engineering more than 9 months to provide a work around. Bug report was

Re: Downloading files via FTP

2018-04-21 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keisuke, Nope, no different cases. It is that very bug report ACI0096897. This bug report was created following my TAOW report. The issue was confirmed to be reproduced with v15.4 and it was OK with v15.3. Precisions: on MaxOSX 10.12.4 I get the error with both 15.3 (public and HF1) and

Re: Downloading files via FTP

2018-04-20 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keisuke, If something is working fine (for years and different 4D versions) and it doesn’t work any more in a new version (while the old version is still OK). Isn’t that called a bug or regression? Unfortunately it took engineering more then 9 months to provide a valid work around.

Re: Downloading files via FTP

2018-04-20 Thread Koen Van Hooreweghe via 4D_Tech
Hi Pat, Could you try to navigate to the right directory on the ftp server and then call FTP_Receive with only the file name in the filepath. Something like: $hostpath without trailing /, like public_html/Anderson/uploads FTP_ChangeDir(vFTP_ID;$hostpath) FTP_Receive(vTTP_ID;

Re: Downloading files via FTP

2018-04-20 Thread Koen Van Hooreweghe via 4D_Tech
Hi Pat, This might be related to a bug I discovered about a year ago. Started from v15.4 and also happens in v16. No fix yet, but the culprit is according to 4D engineering the 7th (times) parameter in thE FTP_GetDirList command. If you don’t need the modification times, leave out this

Re: Web Area display PDF

2018-04-20 Thread Koen Van Hooreweghe via 4D_Tech
Hi John, If I remember correctly there used to be an issue with the Acrobat plugin and Web areas. This might be old info and the problem might be solved, but maybe its worth to give it a try. Remove the AdobePDFViewer plugin in the Interinet Plug-Ins folder of one of the Library folders

Re: v13 - Custom Constants & 4D Pop

2018-04-12 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, The User Constants.xlf file is located inside your database package in the Resources folder. You can indeed move this file to other databases, just like any other ‘Resources' file. Translation xlf files inside language (.lproj) directories or images. HTH Koen > Op 11 apr. 2018, om

Re: Zip file with password...?

2018-04-10 Thread Koen Van Hooreweghe via 4D_Tech
Hi Robert, I had to investigate a similar request a while ago. As far as I know, ditto can only extract password encrypted zip archives, not create them. But you might try with the zip command (as Chip also mentioned): $command:="zip -r --encrypt --password "+$mypassword+"

Re: Signed emails to the list?

2018-03-29 Thread Koen Van Hooreweghe via 4D_Tech
Hi Tim, I think text signatures used to work, but not graphical ones. HTH Koen > Op 29 mrt. 2018, om 18:36 heeft Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I don't think that sending signed emails to the iNUG has ever worked... > However, I just made a

Re: Test 4D Server using 4D Developer Professional license

2018-03-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Jim, 4D sales people should correct me if I’m wrong. But AFAIK a 4D Develop license does not include a 4D Server license. If you have a partner contract (Silver, Gold), you will get a 4D Developer license as well as a separate 2-user 4D Server license for testing purposes. Kind regards,

Re: What's the easiest way to edit an existing constants file?

2018-03-08 Thread Koen Van Hooreweghe via 4D_Tech
Hi Dave, Is there a reason why you cannot edit your existing constants file using the same 4D Pop component? Kind regards, Koen > Op 8 mrt. 2018, om 00:31 heeft Dave Nasralla via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I found the 4DPop_Constant_Editor for creating a

Re: Import from Excel

2018-03-07 Thread Koen Van Hooreweghe via 4D_Tech
Hi Ferdinando, Export from Excel to text file (comma delimited, tab delimited). And then use the 4D import tool or write your own code (receive packet,…) HTH Koen > Op 7 mrt. 2018, om 11:06 heeft stardata.info via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I use 4D V15 or

Re: Stored procedures not waking up?

2018-02-05 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keith, Last week I discovered a possibly related issue with processes not waking up. I have a process, p1 which runs in a loop, executes some code and delays itself for a certain time. code: //Method1 <>abort:=False <>p1:=Current process $delay:=30*60 //beep every 30 seconds Repeat

Re: localisation (again)

2017-12-13 Thread Koen Van Hooreweghe via 4D_Tech
Hi Peter, FWIW I just tested this on my belgian localized OSX system (using decimal comma) and it is working as expected. Kind regards, Koen > Op 13 dec. 2017, om 12:45 heeft Peter Mew via 4D_Tech <4d_tech@lists.4d.com> > het volgende geschreven: > > The string looks like "12345.12345" and

Re: HTTP Request PATCH

2017-11-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Doug, There is no PATCH constant defined in 4D, but you can use “PATCH” as string for http method as the first parameter: HTTP Request(“PATCH”;$url;…) The other constants are just strings for the other method keywords: GET, POST,... HTH Koen > Op 22 nov. 2017, om 11:15 heeft Douglas Cryer

Re: Debug window messed up

2017-11-14 Thread Koen Van Hooreweghe via 4D_Tech
Hi John, That’s weird. Which 4D, which platform? I tested Vincents trick on Mac in 4D v15.5. My own method color settings persisted. Koen > Op 14 nov. 2017, om 10:42 heeft John Baughman via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > If you do it with a method with a break

Re: Method to put a c-obj (or JSON) into a hierarchical list

2017-10-31 Thread Koen Van Hooreweghe via 4D_Tech
Hi Tim, I’ve been bitten by this a while ago. There is a difference in behavior interpreted and compiled. Eg following piece of code: 1 C_OBJECT($obj) 2 C_TEXT($text) 3 C_LONGINT($long) 4 5 OB SET($obj;"property";"value”) 6 7 $text:=OB Get($obj;"nonexistent") 8 $text:=OB

Re: Method to put a c-obj (or JSON) into a hierarchical list

2017-10-30 Thread Koen Van Hooreweghe via 4D_Tech
Hi Kirk, Thanks for the info. I also think this is not a huge task to get the changed data back into 4D, but or the time being I don’t need this feature. So I haven’t tried it yet. Kind regards, Koen > Op 30 okt. 2017, om 16:50 heeft Kirk Brooks via 4D_Tech > <4d_tech@lists.4d.com> het

Re: Method to put a c-obj (or JSON) into a hierarchical list

2017-10-30 Thread Koen Van Hooreweghe via 4D_Tech
Hi Kirk, Same idea as Jeff. But I'm using jsoneditor (https://github.com/josdejong/jsoneditor ) in a web area to display objects. Its an editor, but I have only used it to display an objects content. Haven’t tried to get the modified data back to 4D.

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread Koen Van Hooreweghe via 4D_Tech
Hi Peter, Select folder allows you to navigate into a package if you add the Package open constant as ‘options’, third parameter. Same for Select document fourth parameter. HTH Koen > Op 24 okt. 2017, om 12:29 heeft Peter Jakobsson via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven:

Re: FORM SET OUTPUT -> project form

2017-10-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Pat, FWIW, to preset the PRINT SETTINGS, you should use PAGE SETUP(“projectformname’). HTH Koen > Op 17 okt. 2017, om 14:27 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > het volgende geschreven: > > This was in a database that was updated from a previous version of 4D. I > think

Re: FORM SET OUTPUT -> project form

2017-10-16 Thread Koen Van Hooreweghe via 4D_Tech
Hi Pat, Why would you want to do that? FORM SET OUTPUT sets the current form for a table. If you don’t pass a table, the command takes the default table, but the form must belong to that table. HTH Koen > Op 16 okt. 2017, om 12:39 heeft Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > het

Re: Import from RTF

2017-10-09 Thread Koen Van Hooreweghe via 4D_Tech
Hi Ferdinando, Open it in 4D Write. HTH Koen > Op 9 okt. 2017, om 17:41 heeft stardata.info via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I use 4D V15 on windows and i need to import from an RTF file. > > Is possible to do using 4D?

Re: Post Key command not working in converted 4Dv16 database

2017-10-09 Thread Koen Van Hooreweghe via 4D_Tech
Hi Ken, Any other buttons on the form mistakingly having the same shortcut? I think 4D is using the object level to determine which button actually gets clicked. Koen > Op 9 okt. 2017, om 15:41 heeft Ken Daniel via 4D_Tech <4d_tech@lists.4d.com> > het volgende geschreven: > > Koen & Steve,

Re: Post Key command not working in converted 4Dv16 database

2017-10-09 Thread Koen Van Hooreweghe via 4D_Tech
Hi Ken, What particular shortcut are you using? Also check the case of the character you are using, as Stephen pointed out. In v14 I discovered a bug when running the command POST KEY(Character code("A");Command key mask). This was fine in v13 and earlier, but crashes v14, v15 and v16. My

Re: Number format

2017-10-04 Thread Koen Van Hooreweghe via 4D_Tech
Space is not needed. But comma and point make a difference in US of EU notation. Koen > Op 4 okt. 2017, om 16:24 heeft Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > het volgende geschreven: > > That's the way I've always been able to make it work - with the space for > the zero condition.

Re: Number format

2017-10-04 Thread Koen Van Hooreweghe via 4D_Tech
> Op 4 okt. 2017, om 14:15 heeft stardata.info via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I know this and i try, but not work. > This format not display the value: 0,85 > ###,##0;-###,##0; Ferdinando, This depends on your regional settings and the 4D compatibility

Re: Server Process "Frozen"-ish

2017-09-25 Thread Koen Van Hooreweghe via 4D_Tech
Dani, We’ve had the same problem. After switching from v15 to v16 (both 64bit) the server crashed regularly upon creation of PDF documents with PDF Creator. We planned to move the batch generation of those pdf docs to a separate client, but forgot to change some settings causing some types of

Re: 4D v16.2 false record locks

2017-09-20 Thread Koen Van Hooreweghe via 4D_Tech
In the case I mentioned, there were no triggers involved. No fancy stuff either. Just a record which is being automatically locked because it was opened in an input form. But I don’t know how the user left the building… Koen > Op 19 sep. 2017, om 22:21 heeft Tim Nevels via 4D_Tech

Re: v13.6 - 2 servers same network, how to make it work

2017-09-19 Thread Koen Van Hooreweghe via 4D_Tech
Hi Alan First of all, if the 2 servers are on the same network but on a different machine, there is no need to change the publication ports. Those 2 machines will have different IP addresses and you will see both in the 4D connection dialog. Changing ports is only needed if you run 2 4D

Re: 4D v16.2 false record locks

2017-09-19 Thread Koen Van Hooreweghe via 4D_Tech
Hi Jeff, FWIW. I had this once in one of the two sites running the same app. A few days after converting from v13 to v16. One user and his processes were still visible in the 4D admin window and there were two records (from different tables) locked. The user was out of the office. No way out.

Re: SFTP - Native to 4D?

2017-09-14 Thread Koen Van Hooreweghe via 4D_Tech
Hi Janet, As others has mentioned, there is no native sftp client (yet?) in 4D. On Mac I’m using the OS built in sftp command which is called using LAUNCH EXTERNAL PROCESS. For my purpose, I create a ‘batch’ file which contains the necessary sftp commands and then run it with sftp. Eg. a

Re: OBJECT get variable type

2017-09-11 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keisuke, Tested with v16R4. Unfortunately this does not work nicely. The entry is indeed limited to the number of chars given. But… 1. when continuously typing, the cursor wraps around from the last char to the first and the already entered text is overwritten 2. you cannot select more than 1

Re: 4D Server v11 License

2017-08-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chuck, Maybe you can ask your 4D rep if you can buy v15 license with maintenance contract and ask for a v11 license as temporary solution? HTH Koen > Op 22 aug. 2017, om 11:54 heeft Chuck Miller via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > They can not be legit buying

Re: 4D Write PRO how to ...

2017-08-22 Thread Koen Van Hooreweghe via 4D_Tech
Rudi, Probably not for the faint-hearted! But I think it is not possible to access a 4D Write Pro object’s contents and you’re limited to the ST and WP commands. I did a quick test: C_OBJECT($wpObject) C_TEXT($jsonText) $wpObject:=WP New ST SET TEXT($wpObject;"Hello World!") TRACE

Re: 4D Write PRO how to ...

2017-08-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Rudi, Same issue, which makes 4D Write Pro for me a no go (yet). Koen > Op 21 aug. 2017, om 13:55 heeft Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > Using the old 4D Write, I loop through all the frames (frames 1-> 7), using > ‘WR SET FRAME’ .

Re: Unable to Compile - Crash - looking for ideas - SOLVED

2017-08-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi all, Just a quick tip. If you get tons of errors on local variables when ‘All variables are typed’ is turned on (like me, when I checked this in a 20 year old project), it might be impossible to continue normal development for a while. 4DPop might be the right tool to make the transition

Re: Save As using memorized path and suggested file name

2017-08-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Steve, Which 4D version? Mac or Windows? There should be no difference, but I tested it on Mac using v15. $path:=“Macintosh HD:Users:myname:Dektop:filename.txt” $path:=Select document($path;”text”;””;File name entry) The Save As dialog opens in this case the desktop and sets the file name as

Re: Expat4D

2017-08-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Andrew, I have a copy from 2002 (Mac and Win). It is coming our way by PM. Koen > Op 17 aug. 2017, om 15:47 heeft Andrew Hobson via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > Could someone send me via e-mail the old plugin "Expat4D" ? Compass bvba

Re: Creating a document error -61 OS X

2017-08-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, Are you sure that is the exact path GET 4D FOLDER returns? The tilde is the posix (uses slashes) equivalent of your home folder, but this does not make sense in a HFS path (uses colons as folder separator). AFIK the 4D commands use HFS paths, not their posix counterpart. One exception

Re: 4D Client/Remote as Web Server

2017-08-14 Thread Koen Van Hooreweghe via 4D_Tech
Hi Arnaud, I’m doing a similar thing, but a little more sophisticated... From my 4D ‘to be watched’ processes, I write the last date and time of execution. Then I have a watchdog AppleScript which checks the datetime and sends an email if something is wrong. Finally a crontab entry launches

Re: Blob to Record

2017-08-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, It depends on what you want to try to achieve with that command. I’m using the code below to copy a complete 4D record binary into a blob. But the only thing you normally can do with the resulting blob is to put it back into a record. AFAIK this is also the case with the API Pack (and

Re: Best way to stash an object array into an object field

2017-07-25 Thread Koen Van Hooreweghe via 4D_Tech
Hi David, What about: OB SET ARRAY([Table]ObjectField";"my_object_array_name";$my_object_array) HTH Koen Op 9-jul.-2017, om 03:47 heeft David Adams via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > ...I've got some summary data I'm storing in a fact table and want to stash > an

Re: Favorite tricks and keystrokes: Please take one and leave on

2017-05-30 Thread Koen Van Hooreweghe via 4D_Tech
Hi everybody, Op 29-mei-2017, om 15:11 heeft Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > I miss the split pane feature too. So useful in long methods. Wish they would > bring it back. > If you have access to the 4D forum, please vote on Davids feature request

Re: Favorite tricks and keystrokes: Please take one and leave on

2017-05-29 Thread Koen Van Hooreweghe via 4D_Tech
Hi all, My all time favorite is of course: cmd-Z. But related to 4D, I love the alt-arrow up or down in the method editor. To move a line or a block of lines up/down in the code. And while we're at it, the thing I miss the most is the split pane in the method editor. Unfortunately 4D

Re: v13 crashes compiled and freezes

2017-05-22 Thread Koen Van Hooreweghe via 4D_Tech
Hi Kirk, Just a thought. Are you sure the array as_localMen is initialized in compiled mode? In the past I've been bitten by that kind of issue. In compiled mode the array variable is always defined, but for some reason the ARRAY ...(myArray;0) line was not called. Then I found that Size of

Re: Tags in record on 4d.

2017-05-19 Thread Koen Van Hooreweghe via 4D_Tech
Hi Eric, I think an object field is what you are looking for. HTH Koen Op 19-mei-2017, om 16:25 heeft Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > Has anybody come up with a good way add tags records in a table? > > For instance I have a table of contacts, but I

Re: How to trap a form save keystroke in an object method ?

2017-05-18 Thread Koen Van Hooreweghe via 4D_Tech
Hi Peter, Are you using the REJECT([table]field) command? Using the field parameter? This should prevent any other object method/form method/automatic action to run. HTH Koen Op 18-mei-2017, om 15:56 heeft Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: >> I think I

Re: built client and versions

2017-05-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Charles, In case of a build client/server app, the 'client' should be able to connect to the server and will be automatically updated. Besides an exception concerning the network protocol (legacy/new network layer) this is also possible between major versions: v14>v15, v15->v16. HTH Koen

Re: 15.3HF1

2017-05-17 Thread Koen Van Hooreweghe via 4D_Tech
Hi Doug, You can find the download link on forums.4d.fr > Forums > Hotfix for 4D v15 ... Kind regards, Koen Op 17-mei-2017, om 00:06 heeft Douglas von Roeder via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > An app deployed (beta testing) on 15.3 and I'm running into the BLOB to >

Re: QR code

2017-04-26 Thread Koen Van Hooreweghe via 4D_Tech
Hi Paul, Check: https://github.com/miyako/4d-plugin-qrencode Kind regards, Koen Op 26-apr.-2017, om 10:23 heeft Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > I spent some time on the partner section looking but I couldn’t find anything > on QR codes. Does

Re: v13 and OS X 10.12

2017-04-13 Thread Koen Van Hooreweghe via 4D_Tech
Hi Chip, With some luck, you might be able to downgrade the new iMac or Mac mini to OSX 10.11.6 One of my customers did that successfully on a number of newly bought machines. HTH Koen Op 13-apr.-2017, om 18:15 heeft Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: >

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-04-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Piotr, I haven't done that in 4D Write, but in a normal (template) text field which contains html tags and is run trough PROCESS 4D TAGS finally being sent as html e-mail body text. In that particular case we fill a 4D object field with some info data. So the user can add the info he likes

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-04-03 Thread Koen Van Hooreweghe via 4D_Tech
Hi Bernard, Right. I should have written: 4D does not support dot notation (yet) natively in the OB Get and Set commands. But if I'm not mistaking, rumors say that it is coming... Koen Op 2-apr.-2017, om 13:53 heeft bernard--- via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > 4D

Re: 4D Write Pro using expressions with XML merge file (or JSON)

2017-03-29 Thread Koen Van Hooreweghe via 4D_Tech
Hi Piotr, I would advise JSON or rather 4D objects. 4D objects and JSON are not exactly the same, but very closely related. JSON is actually a text representation of a 4D object. The 4D debugger handles objects nicely too. You can store your data into a 4D object and then retrieve the values

Re: HTML Editor in 4D

2017-03-28 Thread Koen Van Hooreweghe via 4D_Tech
In my project I created some html templates which are opened in the TinyMCE editor. The 'average' users can edit the content and then send the mail. A few moons ago I tried to make the switch to 4D Write Pro, but got stuck on the first part: the html import. I could update my templates to 4D

Re: HTML Editor in 4D

2017-03-28 Thread Koen Van Hooreweghe via 4D_Tech
Hi Dougie, Have a look at the HTML Email Component by Thomas Maul: http://kb.4d.com/assetid=75229 It is using TinyMCE. The trick to get the html out of the editor is by using a html starting page to open the TinyMCE in a Web Area. This page contains a javascript to set and get the content.

Re: Dynamic PDF Page Extraction...

2017-03-13 Thread Koen Van Hooreweghe via 4D_Tech
Hi Robert, Is this on macOS? If so, you could use OS built in python. There are a few automator scripts which handle PDF documents (extract odd/even pages,...) Actually inside they are python scripts. Eg: /System/Library/Automator/Extract odd & Even Pages.action/Contents/Resources/extract.py

Re: sending mail with Exchange server

2017-03-10 Thread Koen Van Hooreweghe via 4D_Tech
Pretty weird, this message arrived in my spam (Apple Mail)... Kind regards, Koen Op 10-mrt.-2017, om 16:06 heeft Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> het volgende geschreven: > Thanks, Lutz. > > Will look into these. > > I know it’s a Pandora’s box and it gets very frustrating,

Re: Copy or Drag from a listbox?

2017-03-07 Thread Koen Van Hooreweghe via 4D_Tech
Hi Keith, For copy/paste you have to put a tab delimited text on the pasteboard. First of all you'll have to intercept the cmd-c and Copy menu items in 4D to make it run your code when the listbox has focus. Then run over the selected lines (records) to get the data. Finally loop over the