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

2019-11-21 Thread 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

DOCUMENT LIST : how do I know the documents are valid

2019-11-21 Thread Piotr Chabot Stadhouders via 4D_Tech
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

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

2019-11-21 Thread Piotr Chabot Stadhouders via 4D_Tech
Dear Alexander, Unfortunately, I believe the “locked” attribute doesn’t return true when copying is in progress But thanks for your tip. Gr, Piotr could this help? GET DOCUMENT PROPERTIES ( document ; locked ; invisible ; created on ; created at ; modified on ; modified at ) > Am

Re: Sheets on Windows

2019-11-21 Thread John J Foster via 4D_Tech
Hi All, In order to make a “Sheets” like location on windows (so this cross-platform app looks similar) I did the following: If you use Kirk’s code as a starter (which is quite flexible) or your own then all you need to do is to adjust a few properties. On the Windows you can get a Sheet like

Re: Command(s) with column and C-number

2019-11-21 Thread Patrick Emanuel via 4D_Tech
Hi Arnaud, You're absolutely right. Thanks to remind me it and figure out this! - Patrick EMANUEL Administrator www.association-qualisoft.eu (Soft1002, Simply Asso & QS_Toolbox) -- Sent from:

Re: Command(s) with column and C-number

2019-11-21 Thread Arnaud init5 imap via 4D_Tech
> Le 21 nov. 2019 à 07:56, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Thanks Patrick. Hi Jörg, beside code sharing, it's important to tokenise your own formulas if they embed commands or constants "as text". For example, a calculated column in a listbox using hardcoded

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

2019-11-21 Thread Narinder Chandi via 4D_Tech
Piotr, As alternative "hacky" solution you could try is to monitor the "modified at" at property and keep testing it every second or so until it's value no longer changes? There may be other possibilities too by inside using LEP but I'm not sure without further investigation. Regards,

Re: 4D Developer Available

2019-11-21 Thread Magnus Torell via 4D_Tech
Dear Tom, I wonder if you could assist me in an 4D write / 4D write Pro transition / migration. It is a Mac installation currently running v17.3 in 32 bit. I like to go 64 bit and Catalina, but have been waiting for a command "Create Style Sheet". I understand that it comes in v18... So how do one

Quick Report documentation for V17

2019-11-21 Thread Doug Cottrill via 4D_Tech
HI all, There used to be a separate 4D Quick Reports User Manual. There does not seem to be one in V17. What are folks giving to their users to let them know how to use the quick report editor nowadays? Thanks, DKC ** 4D

Re: The specified module could not be found

2019-11-21 Thread Jim Hays via 4D_Tech
This is a note with some info in case it helps someone in the future. This message showed up today on my Windows 10 machine, running 4D v17.2hf1 Remote mode, interpreted. Windows is running under Parallels 14.1.3, macOS is 10.14.6. "The specified module could not be found" It came up when

Re: 4D Write Pro license

2019-11-21 Thread Doug Hall via 4D_Tech
Chuck, I had forgotten that I needed to associate the 4D user (designer) to a group that was allowed access to 4D Write Pro Component. (or 4D Write Plugin, the license works for either one.) I did have the 4D Developer Professional license installed, which includes a license for 4D Write Pro/4D

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

2019-11-21 Thread Chip Scheide via 4D_Tech
try testing for a locked file. something like this: Repeat on err call ("If_File_Locked_Return_True") $Doc_Ref := Open document(New_Scan_Document_Path) on err call("") if (not(On_Err_call_File_Locked_Variable = true)) | ($Doc_Ref # † 00:00:00†) close document($Doc_Ref)

Re: Determining if a 4D Write Object has been changed since load.

2019-11-21 Thread Tom Benedict via 4D_Tech
Yes, there are other ways to determine the modified state of a Write Pro object, but they all need to be managed by the developer (store the initial state in a global for later comparison) so it’s not a boolean flag manger by 4DWrite. Jeremy French points out on the 4D Forum that the wk date

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

2019-11-21 Thread Patrick Emanuel via 4D_Tech
Just an idea I set once on a project: check the size of the document. Until size is changing, consider that the copy/move is not finish and wait 1 second more. - Patrick EMANUEL Administrator www.association-qualisoft.eu

Removing progress window while printing to PDF a 4D write documents.

2019-11-21 Thread Luc Devar via 4D_Tech
I am printing to PDF a 4D-Write document and need to remove the progress window. This is what I am doing: SET PRINT OPTION(Destination option;2;$Filename) OPEN PRINTING JOB MESSAGES OFF WR PRINT ($area;wr print values;1) MESSAGES ON CLOSE PRINTING JOB The

CURL SFTP issues with SSH

2019-11-21 Thread Peter Hay via 4D_Tech
Hi, I'm using Miyako's CURL-FTP plugin to try and connect to an SFTP site using SSH keys, but I keep getting an error 67. I've tried the same settings using CURL from the command line, and get the same error. I've also tried the same thing using FileZilla and it works perfectly, so I know the

Re: CURL SFTP issues with SSH

2019-11-21 Thread John DeSoi via 4D_Tech
I had the same situation recently, everything worked with a SFTP client or SFTP from the command line. I could not get it to work using curl and --key options (curl 7.64.0 (x86_64-apple-darwin18.2.0) libcurl/7.64.0 SecureTransport zlib/1.2.11 libssh2/1.8.0). I finally just gave up and switched

RE: 4D Web Server Security

2019-11-21 Thread Randy Engle via 4D_Tech
Richard, Just a few thoughts: This is a topic that is very near and dear to me. I don't have it completely handled yet, but getting close. More and more organizations are running cyber scans and getting very, very picky about things RE: If I understand things correctly, the outside world only

Re: Removing progress window while printing to PDF a 4D write documents.

2019-11-21 Thread Koen Van Hooreweghe via 4D_Tech
Hi Luc, In my code I have: SET PRINT OPTION(Hide printing progress option;1) Strangely enough, I can't find this option any more in the v17R6 language reference. But I think it is still working. HTH Koen > Op 21 nov. 2019, om 21:06 heeft Luc Devar via 4D_Tech <4d_tech@lists.4d.com> > het

Re: Command(s) with column and C-number

2019-11-21 Thread Jörg Knebel via 4D_Tech
Hi Arnaud, > On 21 Nov 2019, at 22:08 AEDT, Arnaud init5 imap via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > beside code sharing, it's important to tokenise your own formulas if they > embed commands or constants "as text". Thanks for the additional information. Cheers

Re: CURL SFTP issues with SSH

2019-11-21 Thread Kirk Brooks via 4D_Tech
Hey Peter, I can't give you the specific answer but if you haven't already I'd recommend installing Postman . How that may help you is you can look at exactly what is being sent and received from the destination. The first thing I'd do is capture the traffic with

Re: CURL SFTP issues with SSH

2019-11-21 Thread Tom Benedict via 4D_Tech
I second the recommendation. You don’t even need to know much about Postman to use it. It’s got a zillion features, but, at least in my experience, it always seems to know what I want to do after minimal fiddling. Tom Benedict > On Nov 21, 2019, at 13:13, Kirk Brooks via 4D_Tech

4D Web Server Security

2019-11-21 Thread Richard Wright via 4D_Tech
Anyone care to share their experience and insights as to the security of the 4D Web Server? There’s lots of talk these days about DOS and putting in a DMZ, but what is really necessary in 4D land? If I understand things correctly, the outside world only has access to static pages in the web