Re: "Search References" Behavior Change

2021-09-13 Thread John DeSoi via 4D_Tech
What version of 4D are you using? I don't recall seeing this problem in version 18. I just tested 19 and 19R2 - "Search References" only shows the method calls (same as "Search Callers" if the method is open). John DeSoi, Ph.D. > On Sep 13, 2021, at 1:47 PM, Dave Nasralla via 4D_Tech

Re: Syntax Error in a Compiled Database

2021-09-09 Thread John DeSoi via 4D_Tech
I would setup an error handling method (ON ERR CALL) and use GET LAST ERROR STACK and see if it provides more information. If you could update to at least 17R6, you could use the Get call chain command to see exactly where the error is. > On Sep 9, 2021, at 11:05 AM, Eric Asadoorian via

Re: File Transmission to SFTP Server

2021-06-02 Thread John DeSoi via 4D_Tech
There is no SFTP support in any version of 4D. You have to implement it yourself using external tools. I use CURL and LAUNCH EXTERNAL PROCESS. Start here for options: https://discuss.4d.com/search?q=sftp John DeSoi, Ph.D. > On Jun 2, 2021, at 4:18 AM, Tarawerkz via 4D_Tech

Re: PING of life...

2021-01-14 Thread John DeSoi via 4D_Tech
Step 1 is to create an account on the forum if you don't have one. Then login and click on your user account icon at the top right. The rightmost icon in this popup (looks like a person) is for Preferences. Then click "Preferences" in the sublist. Under Notifications/Categories on the left,

Re: PING of life...

2021-01-14 Thread John DeSoi via 4D_Tech
The new forum supports email and it works well. I rarely visit the forum unless I want to post something with with code or attachments. Simply reply to the forum email to participate in the conversation. This list and the new forum go to my same mailbox with no real difference other than [4D

Re: Record locking woes

2020-12-09 Thread John DeSoi via 4D_Tech
Are you using LOCKED BY to determine which user/process has the record locked? In version 17 through 18R3 I have seen an intermittent bug where Locked returns true but LOCKED BY indicates there is no lock. Only one process uses the record, so it should not be locked. But I'm only seeing this in

Re: SFTP & PGP Encryption

2020-10-14 Thread John DeSoi via 4D_Tech
Public keys would need to be exchanged one time. Then the encrypted CSV files could be sent. The sender would encrypt the file with the recipient's public key. John DeSoi, Ph.D. > On Oct 13, 2020, at 11:20 PM, Tarawerkz wrote: > > Hi John, > > Thanks for the confirmation with regards to

Re: SFTP & PGP Encryption

2020-10-13 Thread John DeSoi via 4D_Tech
> On Oct 13, 2020, at 8:03 PM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 1. to provide an external facing SFTP through which the enterprise SAP can > connect to ? 4D has no direct support for SFTP as a client or a server in the latest version. HTTPS is probably the best

Re: Drag and drop replacement command(s)?

2020-09-14 Thread John DeSoi via 4D_Tech
As far as I know, _O_DRAG AND DROP PROPERTIES is depreciated but still works in the latest version of 4D. Putting this off until 4D removes the command is also an option. John DeSoi, Ph.D. > On Sep 13, 2020, at 5:35 PM, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Seems we

Re: "Optimal" 4D Server hardware

2020-09-11 Thread John DeSoi via 4D_Tech
> On Sep 11, 2020, at 3:38 PM, Randy Kaempen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have a client with about a dozen users and a 230GB data file. They > upgraded their server and we got a top of the line Mac Mini. Since we expect > to use it for a number of years, we got the best

Re: Change list values in a listbow coloumn

2020-08-05 Thread John DeSoi via 4D_Tech
Yes, you can get all the forum messages as emails and respond to posts by replying to the email. I don't know if there is a way to start a new thread via email. John DeSoi, Ph.D. > On Aug 5, 2020, at 12:29 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have visited the

Re: PDF Documentation

2020-07-07 Thread John DeSoi via 4D_Tech
See the download links on the right side of the page to download the HTML documentation. https://doc.4d.com/4Dv18/index.en.html Note they are FTP links which may not work correctly with all browsers. John DeSoi, Ph.D. > On Jul 7, 2020, at 9:55 AM, Dave Tenen via 4D_Tech

form radio buttons broken in project mode

2020-05-04 Thread John DeSoi via 4D_Tech
I just noticed that form radio buttons are no longer handled automatically when converting to version 18 project mode. For example, with radio button variables r1, r2, r3, the other two radio buttons are unselected when any one is clicked on. In version 18 project mode, they all stay

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

2020-05-02 Thread John DeSoi via 4D_Tech
> On May 1, 2020, at 1:13 PM, James Crate via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> Here is an idea which seems to work, but needs more evaluation. What if you >> named the form object with the property path in the form data? Even if >> periods are not allowed (they seem to be),

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

2020-05-01 Thread John DeSoi via 4D_Tech
Here is an idea which seems to work, but needs more evaluation. What if you named the form object with the property path in the form data? Even if periods are not allowed (they seem to be), another character could be used. I think the maximum length of an object name is 255 characters which

Re: iNUG -Archive

2020-04-29 Thread John DeSoi via 4D_Tech
https://kb.4d.com There is a button on the right for "iNug Messages". John DeSoi, Ph.D. > On Apr 29, 2020, at 7:50 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I used to download all the posts via NNTP from "gmane.comp.lang.inug-4d.tech >

Re: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

2020-04-10 Thread John DeSoi via 4D_Tech
Sorry if I missed it, but I still did not see in your messages that you reproduced the slow startup with conversion on a separate non-VM machine. Also wondering if there is any difference between 4D single user and 4D Server. I have not used 4D Server to convert structures to project mode. I

Re: 4D Server v18.1LTS - Startup Takes 10-15 Minutes

2020-04-10 Thread John DeSoi via 4D_Tech
Have you tried it using binary mode to see if there is any difference? Is there anything unusual about your project, e.g. a really large number of methods or forms? You get the same results on different computers? Is it a regular server or a merged server application? I assume your application

Re: New Mail Command 17r6

2020-04-03 Thread John DeSoi via 4D_Tech
It looks like several attachment related bugs have been fixed after 17r6. https://bugs.4d.fr/fixedbugslist?branch=18_R2 John DeSoi, Ph.D. > On Apr 3, 2020, at 6:32 AM, UKVetDerm via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The following code has been working really well, much faster than

Re: Mac LAUNCH EXTERNAL PROCESS permissions issue

2020-04-03 Thread John DeSoi via 4D_Tech
Same error. Thanks for the idea. John DeSoi, Ph.D. > On Apr 2, 2020, at 11:55 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > just guessing, but what if you add /usr/bin/tmutil to full disk access? ** 4D

Mac LAUNCH EXTERNAL PROCESS permissions issue

2020-04-02 Thread John DeSoi via 4D_Tech
I upgraded a single user merged application from 17R6 to 18R2 (project mode). It is signed with a developer certificate. I can launch a time machine backup with "tmutil startbackup --auto", but if I try to find out when the last backup happened using "tmutil latestbackup", I get this error back

Re: Display entity selection time fields in a list box?

2020-03-27 Thread John DeSoi via 4D_Tech
No, that is a compatibility setting for older 4D versions where time values were converted to milliseconds instead of seconds. Hoping some day there will be an option to just use time values instead of numbers. That was done for dates (instead of strings), seems like it should be possible for

Re: Worker and UI

2020-03-27 Thread John DeSoi via 4D_Tech
I don't see why it would not work. I'm not aware of any real difference between a worker and a regular 4D process except that a worker has queue of requests and lives until killed whereas a regular process executes one request and exists. I tend to use the 4D progress component with some

Display entity selection time fields in a list box?

2020-03-27 Thread John DeSoi via 4D_Tech
I'm replacing some record based list boxes with entity selection list boxes. I want to see HH MM SS format which was easy and the default with selection list boxes. But since ORDA treats time as a number, the only way I see to do that is to wrap the field property path with the Time function,

Re: Time to work on this task..

2020-03-24 Thread John DeSoi via 4D_Tech
Hi Nigel, Do you mean old plugins that store information in resource (rsrc) files? I think anything recent uses a JSON file (manifest.json). John DeSoi, Ph.D. > On Mar 24, 2020, at 6:08 AM, Nigel Greenlee via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Also..whilst i am at..anyone written

Re: gitignore for projects

2020-03-19 Thread John DeSoi via 4D_Tech
Yes, it shows differences in whitespace near comments in the .4DCatalog file. John DeSoi, Ph.D. > On Mar 19, 2020, at 12:38 PM, Mike Kerner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > did you diff the versions to see what changed in the .4dcatalog file?

Re: gitignore for projects

2020-03-17 Thread John DeSoi via 4D_Tech
I ignore anything in the settings directory, but you could argue against that. For example, you might want to track changes in your build settings file. You can't ignore catalog.4DCatalog if you want to track table and field changes to your structure. I'm currently exporting structure changes

Re: Why did 4D kill the Solutions Guide?

2020-03-13 Thread John DeSoi via 4D_Tech
I'm also curious because I previously used the link below to go to the partner site and create tech support requests. This seemed like the only avenue to report bugs for a non-beta version. Now it just redirects to https://us.4d.com. http://partnercentral.4d.com/ John DeSoi, Ph.D. > On Mar

Re: [off-ish] v17 or 18 - Exported forms

2020-03-11 Thread John DeSoi via 4D_Tech
Yes, forms are exported in JSON format. In project mode, CSS files are used for some of the style information. Converting a form into something usable by a web browser is certainly possible, but it will not be a small or simple project. John DeSoi, Ph.D. > On Mar 11, 2020, at 3:22 PM, Chip

Re: Trouble with Comment Blocks v18

2020-03-10 Thread John DeSoi via 4D_Tech
What build version are you using? This was supposed to be fixed after version 18.246179. See https://forums.4d.com/Post/EN/33231346/1/33265607 (if you are in the partner program). John DeSoi, Ph.D. > On Mar 10, 2020, at 3:18 PM, Sannyasin Siddhanathaswami via 4D_Tech >

Re: Trouble with Comment Blocks v18

2020-03-09 Thread John DeSoi via 4D_Tech
I think there was a bug related to this late in the beta cycle. I'm not sure if the fix made it in to 18.0. Seems to work fine in 18.0 HF1. John DeSoi, Ph.D. > On Mar 9, 2020, at 3:24 PM, Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Aloha, > > I’m having

Re: Convert Object to shared object.

2020-03-05 Thread John DeSoi via 4D_Tech
https://kb.4d.com/assetid=78197 John DeSoi, Ph.D. > On Mar 5, 2020, at 1:40 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Does anyone know of a way to simply convert an object to a shred object. I > have tried numerous methods to get this done but I have found that nothing

Re: atom/st indent/lex file

2020-02-28 Thread John DeSoi via 4D_Tech
I'm working on something for TextMate and/or BBEdit. I'll post it, hopefully in the next week or two. Note 4D is a lot more difficult to syntax color than other languages because you can't disambiguate many tokens without the structure file information. Having "code with tokens" helps

Re: customize find results

2020-02-28 Thread John DeSoi via 4D_Tech
I'm not aware of any built-in feature to do that. I would export a copy to 4D 18 project mode and use something like BBEdit or TextMate where you have grep and other features. John DeSoi, Ph.D. > On Feb 28, 2020, at 9:43 AM, Mike Kerner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 4d 17

Re: Printing Excel Document to PDF from 4D - Windows

2020-02-21 Thread John DeSoi via 4D_Tech
The best PDF generation I have found is using Chrome headless via Puppeteer (https://developers.google.com/web/tools/puppeteer). For most reports, I generate a single source document in HTML that works with web browsers, Excel, and PDF. Since you are already generating Excel documents,

SCAN INDEX broken 18.0 client/server?

2020-02-13 Thread John DeSoi via 4D_Tech
Just started 18.0 client/server testing and was hoping to deploy sooner rather than later. But SCAN INDEX seems to be broken returning zero records in client/server mode. The other thing I'm not seeing is what I need to do with the users and groups directory.json for built client/server

Re: Component methods not properly recognized in parent database

2020-02-13 Thread John DeSoi via 4D_Tech
What behavior are you expecting? I thought components from the host (even interpreted) are read only. 4D does not do the right thing, but I thought the only thing it should do is maybe show the method preview in the explorer. It would be really nice to edit the component from the host, but I

Re: New Notarization Issues

2020-02-12 Thread John DeSoi via 4D_Tech
Hi Tim, Do you mean there is currently a way to use an offscreen web area (without creating an invisible form process), or is this something just happening internally? That would be really nice to have in order to take advantage of Javascript libraries. Thanks, John DeSoi, Ph.D. > On Feb

Re: Google reCaptcha - Verifying a Response in 4D

2020-02-09 Thread John DeSoi via 4D_Tech
I'm not doing this, but maybe the link below has a clue. I don't think 4D has a built in URL encoding function, so I would double check to ensure that is formatted correctly. https://stackoverflow.com/questions/52416002/recaptcha-error-codes-missing-input-response-missing-input-secret-when-v

Re: View Pro - How to protect a sheet

2020-01-30 Thread John DeSoi via 4D_Tech
With 4D 18 zip commands and the XML parser, Excel integration is easier than ever. It took very little time to convert CSV only import procedures to also support direct from Excel (xlsx) import. John DeSoi, Ph.D. > On Jan 30, 2020, at 11:40 AM, Douglas von Roeder via 4D_Tech >

Re: 4D Application as a 3-tier System

2020-01-28 Thread John DeSoi via 4D_Tech
NGINX is also a popular option as a load balancer. Free and open source. https://docs.nginx.com/nginx/admin-guide/web-server/reverse-proxy/ It can also proxy non-http protocols. I wonder if the silly "must be 3 tier" requirement could be satisfied by putting NGINX in in between 4D Client and 4D

Re: Dates and 4 digit years.

2020-01-18 Thread John DeSoi via 4D_Tech
Does your query look like this QUERY([Table];[Table]Date_Field<=!1919-12-31!) or this QUERY([Table];[Table]Date_Field<="12/31/19") Using a string can cause issues with date interpretation. If you are showing 4 digit years and you query using a date constant and get the wrong results, maybe

Re: Dates and 4 digit years.

2020-01-17 Thread John DeSoi via 4D_Tech
I don't see how the pivot year could have anything to do with it - that just controls data entry when two digit years are entered. I don't have 17R5, but I don't see any problems with 17.3 or 18.0. Are you searching with date constants or using a string? John DeSoi, Ph.D. > On Jan 17, 2020,

Re: problems with SSL cert/SOLVED

2020-01-10 Thread John DeSoi via 4D_Tech
Glad to hear you solved it. The initial setup can be a bit complex, but I highly recommend automating the whole SSL certificate thing with Let's Encrypt. The certificate cost goes to zero and you never have to worry about it again unless your logging script says you have an issue. It

Re: problems with SSL cert

2020-01-09 Thread John DeSoi via 4D_Tech
> On Jan 9, 2020, at 8:14 AM, Rebecca Bryant via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > When I > try to start the app I get an error on the first line of the startup > routine; it lists the 'key.pem' file with the error 'Access denied'. Compare the file permissions on the old key to the

Re: HTTP Upload file size too low

2020-01-09 Thread John DeSoi via 4D_Tech
This is what I was trying to get at a few messages ago. Maybe WEB GET BODY PART does support chunked encoding, but that is irrelevant if the client side does not support it. As best I can tell from Jim's description is he is using a standard HTML multipart form with a file input. Javascript is

Re: HTTP Upload file size too low

2020-01-08 Thread John DeSoi via 4D_Tech
> On Jan 8, 2020, at 4:15 PM, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > No I am using just plain File object to send file. On the 4D side I use WEB > Get body part count and WEB GET BODY PART. No chunking that I know of unless > 4D is doing itself (which by the way I

Re: HTTP Upload file size too low

2020-01-08 Thread John DeSoi via 4D_Tech
> On Jan 8, 2020, at 3:03 PM, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > The only way to upload consistently without getting any errors supposedly is > to do it in chunks. I am trying to find a way to do that. So far I could not > find any code examples. What client

Re: gitignore for projects

2020-01-06 Thread John DeSoi via 4D_Tech
> On Jan 6, 2020, at 12:13 PM, Tom Benedict wrote: > > Just to clarify, you’re talking about the “Comments” page in the Explorer, > not inline comments in code, right? It’s been a few months, but when I > exported the structure in 17R4 inline comments were preserved. Yes, comments in the

Re: gitignore for projects

2020-01-06 Thread John DeSoi via 4D_Tech
> On Jan 6, 2020, at 9:38 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > So inside of this folder I exclude the Preferences, > userPreferences and Logs. Here's a recent one: That's another 4D 18 upgrade issue. 4D 18 renames Preferences to Settings and rewrites various

Re: gitignore for projects

2020-01-06 Thread John DeSoi via 4D_Tech
> On Jan 6, 2020, at 8:48 AM, Mike Kerner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > @Tom - I get an error for 3d buttons, too "3D button style is not > supported." I was thinking of writing a quick tool to fix all the button > types, since parsing and editing the JSON should be

Re: gitignore for projects

2020-01-06 Thread John DeSoi via 4D_Tech
Hi Jeremy, One I used to use (GitX, I think) would sometimes take forever or spin the beach ball of death for large commits. I'm now using Fork (which I really like). Sometimes I get various commit or other operation errors. No problems from the command line. Here is another issue to watch

Re: gitignore for projects

2020-01-05 Thread John DeSoi via 4D_Tech
Hi Jim, > On Jan 5, 2020, at 7:31 AM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> In this model, I'm only making structure and form changes in the 17 master >> branch. Methods can be changed in both branches. > > Are there any problems with functionalities can’t be used in v18

Re: gitignore for projects

2020-01-05 Thread John DeSoi via 4D_Tech
Hi Tom, > On Jan 4, 2020, at 10:13 PM, Tom Benedict wrote: > > How large is your structure? I ask, because our structure has around a > million lines of code and probably 15,000 forms and when I’ve tried exporting > under 17r5 it takes many minutes. Roughly 150,000 lines of source code and

Re: gitignore for projects

2020-01-04 Thread John DeSoi via 4D_Tech
Hi Jeremy, > On Jan 4, 2020, at 1:53 PM, Jeremy French wrote: > > Did you create the v17 Master Branch by: > > 1) Open a copy of the v17 structure and then open the copy in v18 to convert > v17 to v18; and > 2) Commit the conversion to v18 as the v17 Master branch; and > 3) Create a new

Re: gitignore for projects

2020-01-04 Thread John DeSoi via 4D_Tech
You can keep your project in binary mode (even keep it in version 17) and still take advantage of version 18, project mode, and git. Here is what I'm doing. "Master" branch is version 17. When I want to commit a new version I have a 4D method that copies the structure, opens it in 4D 18, and

Re: Object from row in selection listbox

2020-01-02 Thread John DeSoi via 4D_Tech
Hi Jeremy, I don't think there is a way to do that without using GOTO RECORD. ORDA does not use record numbers, you need the primary key to do a direct entity lookup (dataClass.get). John DeSoi, Ph.D. > On Jan 2, 2020, at 12:27 PM, Jeremy Roussak via 4D_Tech > <4d_tech@lists.4d.com> wrote:

Re: Object from row in selection listbox

2019-12-28 Thread John DeSoi via 4D_Tech
By "selection based listbox" I assume you mean traditional record selection listbox and not an entity selection/collection listbox. I have not tested this, but I think it will work without changing the highlighted records or scroll position. COPY SET("UserSet";"MySet") CUT NAMED

Re: High Sierra or Mojave?

2019-12-10 Thread John DeSoi via 4D_Tech
Mohave works fine with 4D 17 including Mac Mini configurations older than 2014. Catalina will be another story... John DeSoi, Ph.D. > On Dec 10, 2019, at 5:14 PM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm upgrading my 4D structure from 4D v15 to v17, to gain 64 bit >

Re: The future of output forms

2019-12-10 Thread John DeSoi via 4D_Tech
Hi Rudy, Here is some code to get you started. It uses a table with a single indexed boolean field to quickly generate any size selection you need to manage scrolling. I used this technique with list boxes before it was possible to use collections to manage scrolling. C_LONGINT($1;$count)

Re: The future of output forms

2019-12-09 Thread John DeSoi via 4D_Tech
> On Dec 9, 2019, at 4:34 PM, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > But this brings me to this question: Will output forms keep being supported > by 4D? I doubt they will be depreciated. The same implementation model is used for print forms, and it would not

Re: How to Modify a column using SQL

2019-12-04 Thread John DeSoi via 4D_Tech
Untested, but with version 18 in source mode you could modify Project/Sources/catalog.4DCatalog. John DeSoi, Ph.D. > On Dec 4, 2019, at 2:42 PM, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > No I meant the field definition as in the original post. I cannot alter 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: Authorize.net integration?

2019-11-20 Thread John DeSoi via 4D_Tech
> On Nov 20, 2019, at 2:35 PM, Joe Dombroski via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > thanks. I will take a look. I was curious about creating an embedded link > with 4D that has the billing information. That looks like this API:

Re: Procedural printing HTML or a WebArea

2019-11-03 Thread John DeSoi via 4D_Tech
I'm not aware of a way to do that in native 4D. I use Node with Puppeteer and headless Chrome. This provides a way to specify parameters such as headers, footers, and orientation. I have it setup to run on the server and clients can call a server procedure to convert HTML to PDF. Very fast and

Re: Determining object content types

2019-10-21 Thread John DeSoi via 4D_Tech
You can't determine the type of the array. I think you can load any type into a text array, but then you would have to convert it. The best option for internal use is to include a property that indicates the type, i.e. use "type" and "value" pairs. John DeSoi, Ph.D. > On Oct 21, 2019, at

Re: HTTP Request and x-www-form-urlencoded

2019-10-12 Thread John DeSoi via 4D_Tech
No easy way in 4D because there is no built in function to do url encoding. See feature request at the link below along with some code to implement it. https://forums.4d.com/Post/EN/17578327/1/17591881 John DeSoi, Ph.D. > On Oct 12, 2019, at 1:54 PM, Tom Benedict via 4D_Tech

Re: HIDE MENU BAR in On Startup database method

2019-10-12 Thread John DeSoi via 4D_Tech
Are you a partner? If so, I would test it with the latest beta and report it directly on the forum if it is still not fixed in 17R6. Otherwise, the only "voting" I'm aware of is for feature requests on the 4D forum. John DeSoi, Ph.D. > On Oct 12, 2019, at 1:25 AM, Piotr Chabot Stadhouders >

Re: HIDE MENU BAR in On Startup database method

2019-10-11 Thread John DeSoi via 4D_Tech
Reported as a bug in January 2018 - ACI0097822. John DeSoi, Ph.D. > On Oct 11, 2019, at 8:24 AM, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > When starting an 64-bit Engined Application, the 4D menu bar is visible for a > moment, even while I call HIDE MENU BAR in

Re: 4D Server Hosting - The Future ?

2019-10-10 Thread John DeSoi via 4D_Tech
I don't see how "cloud" hosting can be the future of 4D when LAN execution is great but WAN execution is horribly slow for the same application. Yes, you can rewrite in various ways (harder to write, understand, and maintain) but it is not an easy task. John DeSoi, Ph.D. > On Oct 10, 2019,

Re: 4D v17 Property List Issues - is this only me?

2019-10-01 Thread John DeSoi via 4D_Tech
I think the fastest way to a resolution would be to verify you have the same problem in 17R6 beta. If it is fixed, likely nothing will be done about it in R5. If it is not fixed, you can file a bug report directly on the forum. John DeSoi, Ph.D. > On Oct 1, 2019, at 10:44 AM, Daniel

Re: [repost - desperate]What runs before ON STARTUP?

2019-10-01 Thread John DeSoi via 4D_Tech
On Host Database Event database method? See the Security tab in the database settings to disable it. https://doc.4d.com/4Dv15/4D/15.6/On-Host-Database-Event-database-method.301-3818546.en.html John DeSoi, Ph.D. > On Oct 1, 2019, at 9:16 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> >

Re: HTTP AUTHENTICATE - how to know if the authentification worked

2019-09-30 Thread John DeSoi via 4D_Tech
Hi Paul, Start here and see the linked RFCs. https://en.wikipedia.org/wiki/Digest_access_authentication I probably have some old code somewhere that implemented this, I'll see if I can dig it up and send it to you. John DeSoi, Ph.D. > On Sep 29, 2019, at 11:42 AM, Paul Lovejoy wrote: > >

Re: HTTP AUTHENTICATE - how to know if the authentification worked

2019-09-27 Thread John DeSoi via 4D_Tech
Using a HTTP tracing tool where you could see all of the request/response values with headers might provide useful clues. My other idea would be to drop HTTP AUTHENTICATE and just build the authentication digest headers yourself. John DeSoi, Ph.D. > On Sep 27, 2019, at 12:47 PM, Paul Lovejoy

Re: HTTP AUTHENTICATE - how to know if the authentification worked

2019-09-27 Thread John DeSoi via 4D_Tech
The documentation says: > If you omit the authMethod parameter (or pass 0), you let the program choose > the appropriate method to use. In this case, 4D sends an additional request > in order to negotiate the authentication method. Are you omitting the authMethod parameter? If so, I suspect

Re: Silent Failure when Constructing an Object

2019-09-20 Thread John DeSoi via 4D_Tech
Yes, for a certain class of errors, 4D sends a HTTP 500 error response and a HTML body with the error information. You should try your test locally to verify. Of course, you should have a error handler and be able to capture any error and log it if you are using the HTTP server. Unfortunately,

Re: V16 Server Issue

2019-09-12 Thread John DeSoi via 4D_Tech
This happened to me also with version 16.3, 64-bit Mac. I gave up on the built-in scheduler and implemented my own to have more control and better error reporting. There were a number of reported issues with version 16 where delayed processes would become "stuck" and never continue. I would

Re: Paypal IPN Integration

2019-09-03 Thread John DeSoi via 4D_Tech
Sam, See this in the documentation: https://doc.4d.com/4Dv17/4D/17.2/Executing-PHP-scripts-in-4D.300-4386504.en.html#187748 Are you using Mac or Windows? If Mac, the built in PHP might have a version of CURL that is recent enough. You might also consider using a NodeJS library instead of PHP.

Re: Regex expert needed??

2019-08-24 Thread John DeSoi via 4D_Tech
See https://en.wikipedia.org/wiki/Longest_common_substring_problem John DeSoi, Ph.D. > On Aug 24, 2019, at 10:48 AM, Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > This version stands alone, and runs a little more efficiently. It's not been > tested in every way, but the

Re: _ as first character in Method Name [was 64 bit...]

2019-08-19 Thread John DeSoi via 4D_Tech
Why is 64 bit 4D not going to like it? Spaces are still allowed in method names. You could also use animal__Module_Info (2 underscores) to keep it at the top. John DeSoi, Ph.D. > On Aug 19, 2019, at 10:38 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > This causes the

Re: Sequential search of indexed field

2019-08-15 Thread John DeSoi via 4D_Tech
Seems way off. Are the values unique or clustered around a few values? I'm seeing a few milliseconds to search 46 million records with a unique index value. Have you tried DESCRIBE QUERY EXECUTION? John DeSoi, Ph.D. > On Aug 15, 2019, at 2:26 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>

Re: Confused array type in an object

2019-08-09 Thread John DeSoi via 4D_Tech
> OB Get Array($ObjData;$attributeName;$aTextarray) //Where $aTextarray is an > Array of type text > > This indeed gets the values from the object..which would be absolutely > fine(and a work around might be to get both, as neither error, and then look > at whether the values in the object

Re: Prevent Client from Sleeping

2019-08-07 Thread John DeSoi via 4D_Tech
On the Mac you can use "caffeinate" via LEP. NAME caffeinate -- prevent the system from sleeping on behalf of a utility SYNOPSIS caffeinate [-disu] [-t timeout] [-w pid] [utility arguments...] DESCRIPTION caffeinate creates assertions to alter system sleep behavior. If no

Re: Managing multiple windows in the same process (v17r5)

2019-08-02 Thread John DeSoi via 4D_Tech
You can use the Window process command to determine that both windows are in the same process. John DeSoi, Ph.D. > On Aug 2, 2019, at 11:18 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I also have a question about this ... > In our database we require at least one user

Re: v17R5 bug?

2019-07-29 Thread John DeSoi via 4D_Tech
om> wrote: > > why not use a key value pair instead of a flat collection of pointers? > >> 2019/07/29 2:16、John DeSoi via 4D_Tech <4d_tech@lists.4d.com>のメール: >> Disappointing because you can search for pointers in a pointer array, but >> not in a collection. An

Re: v17R5 bug?

2019-07-28 Thread John DeSoi via 4D_Tech
Changed the subject, I assume you mean 17R5, version 15 does not have dot notation. > On Jul 28, 2019, at 11:20 AM, Jeremy Roussak via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Is searching for pointers not allowed? I would assume no because 4D can't search collections for a pointer:

Re: Importing from camera

2019-07-08 Thread John DeSoi via 4D_Tech
Searching the knowledge base for "camera" turns up some tech notes. ftp://ftp.4d.com/ACI_TECHNICAL_NOTES/2015/TN_2015/15-01_CameraInterfaceR1.zip ftp://ftp.4d.com/ACI_TECHNICAL_NOTES/2016/TN_2016/16-16_CameraSurveillanceIn4D.zip John DeSoi, Ph.D. > On Jul 7, 2019, at 10:25 PM, JOHN BAUGHMAN

Re: The set does not exist

2019-07-07 Thread John DeSoi via 4D_Tech
There is the answer: "the data source is arrays". The highlight set only applies to selection (table) based list boxes. To get the highlighted rows of an array listbox, you use the True/False value of the boolean array representing the listbox. See the "Managing Selection" section on the page

Re: 'Clairvoyance' in listBox (v17r5)

2019-06-21 Thread John DeSoi via 4D_Tech
This was just discussed and requested on the Forums. Some examples were posted on how it can be done. http://forums.4d.com/Post/EN/30170877/1/30278226 Vote for the feature request here http://forums.4d.com/Post/EN/15446498/1/30188166 John DeSoi, Ph.D. > On Jun 21, 2019, at 12:00 PM, Chris

Re: Invalid JSON?

2019-06-02 Thread John DeSoi via 4D_Tech
What version of 4D? JSON Parse on what you provided below does not throw an error with 4D 17.1. John DeSoi, Ph.D. > On Jun 2, 2019, at 8:05 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I am getting the following from zip-codes.com… > > { > "item": { >

Re: Injecting Forms from a component

2019-05-23 Thread John DeSoi via 4D_Tech
> On May 23, 2019, at 10:26 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I expect that you can do the same for table(s) via SQ, I have not tried. In addition to SQL, you can also use IMPORT STRUCTURE which is probably better in a lot of ways because you can do things like

Re: Managing 4D Server as a service

2019-05-10 Thread John DeSoi via 4D_Tech
> On May 9, 2019, at 4:25 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Current 4D recommendations is to not use interact with desktop when running > 4D Server as a service and to handle everything yourself. Always install ON > ERR CALL method on everything that runs on 4D

Re: Capturing workstation timezone from the OS

2019-05-06 Thread John DeSoi via 4D_Tech
This gives the number of seconds offset from GMT. John DeSoi, Ph.D. $zDate:=Current date $str:=String($zDate;ISO date GMT;$zTime) //2010-09-13T16:11:53Z $str:=Substring($str;1;Length($str)-1) //Remove the Z or it gives us back local time. $gmtDate:=Date($str) $gmtTime:=Time($str) Case of

Re: 4D V15 crash

2019-05-03 Thread John DeSoi via 4D_Tech
Look at the crash log (should be in ~/Library/Logs/DiagnosticReports). It often gives helpful clues about what is causing the crash. John DeSoi, Ph.D. > On May 3, 2019, at 8:11 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > My client (4 time zones away), had been

Re: 4D 17.1 network issues

2019-05-03 Thread John DeSoi via 4D_Tech
You > should not have a real IP on ethernet connection and self assigned on > wifi. Something is not adding up > > Regards > Chuck > > On Wed, Apr 24, 2019 at 12:28 PM Peter Bozek via 4D_Tech > <4d_tech@lists.4d.com> wrote: >> >> On Wed, Apr 24, 2019 at 4:06

Re: Connecting to FTP

2019-04-30 Thread John DeSoi via 4D_Tech
h > <4d_tech@lists.4d.com> wrote: > > IT_SetPort returns 0. > > The FTP Login returns 10032 - Unknown or invalid response. > >> On Apr 30, 2019, at 5:32 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Bob, >

Re: Connecting to FTP

2019-04-30 Thread John DeSoi via 4D_Tech
Bob, You need to use the IT_SetPort command. John DeSoi, Ph.D. > On Apr 30, 2019, at 6:49 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I run an FTP server for my clients. All of the connections are secure FTP - > port . > > I can’t get the FTP_Login to work. I

Re: Using the HELP Menu for my own purposes.

2019-04-29 Thread John DeSoi via 4D_Tech
Vote for the feature request at the link below from 2007. I also requested it before the forum existed back in 1998. Don't hold your breath :). https://forums.4d.com/Post/FR/1510042/1/2352980 John DeSoi, Ph.D. > On Apr 28, 2019, at 5:51 PM, Herr Alexander Heintz via 4D_Tech >

Re: 4D 17.1 network issues

2019-04-24 Thread John DeSoi via 4D_Tech
Hi Spencer, > On Apr 24, 2019, at 8:29 AM, Spencer Hinsdale wrote: > > If you go to Apple menu, System Preferences on the mini, for Network do you > see more than one green dot? Each is separate network connection, where you > can click Advanced and go to TCP/IP tab for details. Is not

4D 17.1 network issues

2019-04-24 Thread John DeSoi via 4D_Tech
Since I upgraded from 16.4 to 17.1 (all Mac), users have been complaining about 4D Client disconnects. Messages like: "The current connection to the database has been disrupted. Connection error with the server. Please restart the application." "Unknown Error. Connection error with the server.

  1   2   3   4   >