Re: 2 plugins with the same ID

2017-02-27 Thread John DeSoi via 4D_Tech
> On Feb 26, 2017, at 5:07 AM, Bertrand SOUBEYRAND via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > What happens if two plugins have the same ID? Apparently nothing. I suppose 4D internally maps them some other way. I see third party plugins using the same ID (15000 for API Pack and NTK) and

Re: Component Capabilities

2017-03-23 Thread John DeSoi via 4D_Tech
> On Mar 23, 2017, at 11:54 AM, Nigel Greenlee via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > What i am really interested in is to know what others who have undertaken > this kind of thing have done to get around : > > > METHOD GET CODE($_Txt_MethodName;$_t_MethodText;*) ... (ETC) > > This

Re: CALL FORM: Some notes on a command that's easy to misunderstand

2017-03-20 Thread John DeSoi via 4D_Tech
> On Mar 20, 2017, at 12:45 PM, James Crate via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It would be nice if the tokenized method name could be used; We need this in a lot of places. I think it could be as simple as a "Method name" command that takes the tokenized name and returns the

Re: Off topic, sending binary files

2017-04-09 Thread John DeSoi via 4D_Tech
A disk image might work, but it will still likely be quarantined. You'll have to execute a command to remove that, but I don't think it requires sudo. Applescript Editor and Automater can create stand-along executables. There is also this: https://sveinbjorn.org/platypus John DeSoi, Ph.D.

Re: Anyone using v16 in WAN

2017-04-04 Thread John DeSoi via 4D_Tech
Are folks having trouble with the new network layer using it in 32 bit mode or 64 bit mode? Just wondering if 64 bit mode is also problematic. John DeSoi, Ph.D. > On Apr 4, 2017, at 10:56 AM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Of the sites we are running at, all but the

Re: Migrating Tables with Relations Between Structures

2017-04-05 Thread John DeSoi via 4D_Tech
Hi Peter, I have not implemented this, but I'm contemplating it for a component that would need to initially create some table structure in the host component. If you want to export/import a subset of tables, it seems not too hard to export the XML structure and then parse it to create a new

Re: Unclear distinction between web server session and process

2017-04-14 Thread John DeSoi via 4D_Tech
Hi Kirk, > On Apr 14, 2017, at 11:33 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > But that's not the way I see it actually work. ​A new process spins up each > time new request comes in and gets assigned a new web session id which > replaces whatever the 4DSID cookie is.

Re: Methods, Components, Comments, and Tooltips

2017-04-21 Thread John DeSoi via 4D_Tech
I recently embarked on an automated testing project and implemented the advantages you mention by automatically generating *one* project method per form that contains all of the object method and form method code. The only other task was to create wrappers for Form event and OBJECT Get pointer

Re: Components: How do you reuse utility code?

2017-04-21 Thread John DeSoi via 4D_Tech
I'm fairly new to components also, and what you describe below is pretty much how I'm doing it. Anything reusable goes in one component library. But I want to use different subsets of this for different projects. I have "build methods" which specify which methods (modules) should be shared for

Re: Methods, Components, Comments, and Tooltips

2017-04-21 Thread John DeSoi via 4D_Tech
> On Apr 21, 2017, at 9:59 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > What does this project method look like? > > Case of > :(form event=) > case of > :(Last object = ) > do stuff Example below. All calls to Form event in the database are replaced with a wrapper

Re: Unclear distinction between web server session and process

2017-04-15 Thread John DeSoi via 4D_Tech
No direct experience on that, but here are some debugging ideas: - Do you have all the parameters declared in On Web Connection and on Web Authentication? - Put a trace in On Web Session Suspend to see if the session is getting suspended. Might be a bad timeout setting? - Are you changing any

Re: Bug or feature?

2017-03-03 Thread John DeSoi via 4D_Tech
Bug in my opinion that 4D shows any error dialog while the error handler is active. This is a huge problem for execution on 4D Server or a web server. And if it happens in front of a user they can just hit abort and you have no way to know about the problem unless they complain about it. John

Re: Bug or feature?

2017-03-03 Thread John DeSoi via 4D_Tech
There is no way to recover, but the 4D dialog can capture the exact error and line number and give the user two options, Abort and Continue? I would be fine with 4D aborting the process and writing the error information to the event log. Showing the dialog on the on the server or web server

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-08 Thread John DeSoi via 4D_Tech
> On Mar 8, 2017, at 9:09 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Currently, let's say a user begins a transaction ​and the new record gets > the sequence number. Before that transaction is completed another user > starts a new record (or that user starts another process

Re: 4D v15.4: Sequence number issue / Duplicate key error

2017-03-08 Thread John DeSoi via 4D_Tech
> On Mar 8, 2017, at 6:26 AM, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I have exported the data to a tab delimited file, truncated the table, and > imported the data. Problem is still there. > I have compacted the data file. Same problem. After doing this import

Re: osx open url vs osascript FYI

2017-03-10 Thread John DeSoi via 4D_Tech
Hi David, > On Mar 10, 2017, at 5:04 PM, David Ringsmuth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > It should be “open”. (SORRY) Applescript is a good option if you need to do something complicated. If you just want to open an application or document (or application with a document),

Re: Question about SET and GET WEB OPTIONS

2017-03-06 Thread John DeSoi via 4D_Tech
Kirk, > On Mar 5, 2017, at 10:41 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > This may be specifically talking about this particular option but it's the > same behavior I'm seeing. So I'm concluding the options I'm looking at > aren't changed in the database settings (hence

Re: Question about SET and GET WEB OPTIONS

2017-03-06 Thread John DeSoi via 4D_Tech
I just retested the problems with WEB SET OPTION in 15.1 are corrected in 15.4. > Where is the Web inactive session time in the db settings? I am only able > to find the process timeout. Correct, I only see the process timeout. John DeSoi, Ph.D.

Re: Question about SET and GET WEB OPTIONS

2017-03-05 Thread John DeSoi via 4D_Tech
Hi Kirk, > On Mar 5, 2017, at 5:19 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > When I moved on to writing a setter method. I notice some options either > don't change or the database settings panel shows different values. > Specifically Web inactive process timeout. I have

Re: Migrating Tables with Relations Between Structures

2017-04-05 Thread John DeSoi via 4D_Tech
You could export the XML structure definition and then edit it to only include the tables and relations you want. Then import it into the target structure. John DeSoi, Ph.D. > On Apr 5, 2017, at 5:34 AM, Peter Jakobsson via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Let’s say you have a

Re: Preemptive execution question

2017-04-06 Thread John DeSoi via 4D_Tech
> -- You've got a preemptive thread. > -- It can't run a variety of commands. > -- You push over some illegal code via CALL WORKER. > -- 4D's is meant to EXECUTE the cooperative (illegal) code in the > preemptive (multi-core) context. > > What happens? Not what I feared, not what I expected, not

Re: Blob to Record

2017-08-03 Thread John DeSoi via 4D_Tech
It would be very handy for a lot of different reasons. A few months ago, I added a feature request for it: http://forums.4d.com/Post/EN/17757394/1/17757395#17757395 Please vote for it if you think it would be useful. John DeSoi, Ph.D. > On Aug 3, 2017, at 8:45 AM, Chip Scheide via 4D_Tech

Re: Fastest way to get text into a BLOB?

2017-08-01 Thread John DeSoi via 4D_Tech
For example, if you want to represent any type of 4D variable in an object, each property ($oValue below) is an object with the (1) the type, and (2) the value OR the index of the value in the blob array. So if I pass a pointer to store a text property, it might be simply OB

Re: Fastest way to get text into a BLOB?

2017-08-01 Thread John DeSoi via 4D_Tech
If you want the best performance and don't have a requirement to use the plugin, I'd bet the fastest way to bulk load with Postgres is going to be using files. If you are on the same machine, you can COPY directly from a file if you have superuser access. If not, you can still launch psql and

Re: Get Info from a 4D Client - aka Interclient communication

2017-08-13 Thread John DeSoi via 4D_Tech
Maybe just SET PROCESS VARIABLE(-1;<>webServerInfoObject) to put the information on the server. Then a process on the server can monitor it or you can use a different client to read it using GET PROCESS VARIABLE. John DeSoi, Ph.D. > On Aug 13, 2017, at 8:18 PM, Randy Engle via 4D_Tech

Re: Thinking through object/text fields: Findings summarized, advice solicited

2017-07-17 Thread John DeSoi via 4D_Tech
Note: PostgreSQL automatically and transparently compresses large variable length column values. https://www.postgresql.org/docs/9.6/static/storage-toast.html John DeSoi, Ph.D. > On Jul 17, 2017, at 12:10 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The jsonb type

Re: Thinking through object/text fields: Findings summarized, advice solicited

2017-07-17 Thread John DeSoi via 4D_Tech
I bought Navicat 11 a few months ago after they made some nice improvements in the SQL editor. I thought it was the most Mac friendly of any PostgreSQL tools. Shortly thereafter Navicat 12 was released. I'm pretty sure it is not Java, but I think they switched to some other GUI library to make

Re: Object Field Questions and Comments

2017-07-09 Thread John DeSoi via 4D_Tech
> On Jul 9, 2017, at 6:00 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Any idea about storage requirements for objects? They're shown as JSON but > are presumably stored in a more efficient binary format of some kind that > takes less space. The last time I examined the

Re: 4D Write Pro interface plug in or component?

2017-07-10 Thread John DeSoi via 4D_Tech
> On Jul 10, 2017, at 5:55 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Pro looks to be a good upgrade, but I hate the fact that it comes without a > typical word processor user interface built in. I just don’t have time to > create the interface. Agree. The application

Re: Thinking through object/text fields: Findings summarized, advice solicited

2017-07-14 Thread John DeSoi via 4D_Tech
If storage space is a primary constraint and object indexing is not needed, you can use a blob to store as UTF-8 text. VARIABLE TO BLOB with object uses UTF-8 text (tested 15.4, not 16). In your example where you basically wanted to store an object array directly, you could stringify the

Re: Thinking through object/text fields: Findings summarized, advice solicited

2017-07-18 Thread John DeSoi via 4D_Tech
Hi Kirk, Navicat is just a GUI tool to view and manipulate PostgreSQL data. It is really that PostgreSQL helps me with 4D. 4D is great, but PostgreSQL is better suited for many tasks. I use it for websites (with Drupal) and sync the necessary data with 4D. I also use it a lot for preprocessing

Re: C-objects and memory use

2017-07-25 Thread John DeSoi via 4D_Tech
> On Jul 25, 2017, at 6:02 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > So why not BLOBs? Why not pictures, or text variables? Why does C_OBJECT > flaunt the limited scoping abilities we have in 4D? The only reason I can > think of is because an object can contain

Re: Optimizing and improving 4D queries.

2017-06-28 Thread John DeSoi via 4D_Tech
ter b-tree indexes for that field? > >> 2017/06/29 9:55、John DeSoi via 4D_Tech <4d_tech@lists.4d.com> のメール: >> >> 4D reports the table is not fragmented. I have not tried compacting or >> rebuilding indexes yet. You might

Re: v13 (+?) - Replace String [warning]

2017-06-29 Thread John DeSoi via 4D_Tech
> On Jun 29, 2017, at 3:33 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have a question.. what does RVLB (at the end of the blob) do? It is at the start of the blob and identifies the byte order. If it was a blob from an old PPC Mac, it would be BLVR. Next byte is the

Re: Optimizing and improving 4D queries.

2017-06-28 Thread John DeSoi via 4D_Tech
Do any of the tables have a large number records? I have noticed recently that large tables (e.g. 20 million records) are very slow with DISTINCT VALUES even on indexed fields with a relatively small number values. For example on a big table and selection of 14,000 records DISTINCT VALUES only

Re: Text Utility

2017-07-06 Thread John DeSoi via 4D_Tech
Hi David, Funny you mention this as I was working on it today. I have been using PostgreSQL's pg_trigram for years and had the interest to implement this in 4D. The code to create n-grams is pretty simple. Putting trigrams in a keyword indexed text field makes it super fast to find matches.

Re: 4D and Git Connection

2017-08-22 Thread John DeSoi via 4D_Tech
> On Aug 22, 2017, at 9:39 AM, Drew Waddell via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Yeah, it's incredibly noisy but we only keep the information around for a > release, then we fire up a new Git repo for the next one. Like I said it's > not perfect, far from it honestly, but it gives

Re: Array Summary Sum Utility Method

2017-06-21 Thread John DeSoi via 4D_Tech
> On Jun 21, 2017, at 2:59 AM, Nigel Greenlee via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > You don’t say if you are displaying these arrays on screen-obviously the 2D > arrays can’t be displayed on screen. Each array of a 2D array can be a column in a listbox. John DeSoi, Ph.D.

Re: Automatic type-ahead on single-column listbox?

2017-06-27 Thread John DeSoi via 4D_Tech
> On Jun 27, 2017, at 8:54 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Have 36 buttons that trigger to the 26 characters and 10 numerals. > > These are combined into a string and if that text is found (in the current > sorted column) that line is highlighted. > > If

Re: SFTP - Native to 4D?

2017-09-13 Thread John DeSoi via 4D_Tech
> On Sep 13, 2017, at 10:27 AM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Does 4D have any native capability to do SFTP file transfers and/or generate > a SSH-2 RSA public and private key pair? 4D does not have any native capability to SFTP. For the Mac I ended up using

Re: Server Process "Frozen"-ish

2017-09-14 Thread John DeSoi via 4D_Tech
> On Sep 14, 2017, at 7:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > This is a big problem that must get addressed and fixed or it will do harm to > v16’s reputation. I was planning on upgrading one of my clients to v16 in a > few months. That is not going to happen now.

Re: 4D v16.2 false record locks

2017-09-18 Thread John DeSoi via 4D_Tech
Yes. In my case it is a single user merged application and in a long running "cron" process. No one else is using the database and no other process accessed the records. My error handler would randomly report the record was locked by process 0. I had to restart to fix it. I don't think I have

Re: 4D v16.2 false record locks

2017-09-19 Thread John DeSoi via 4D_Tech
> On Sep 19, 2017, at 3:21 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> If a record wasn't unloaded in trigger properly, the record would be locked >> even after the invoking client user left the system (no longer signed in). >> The only way is to restart the server. > >

Re: 4D v16 issues

2017-09-22 Thread John DeSoi via 4D_Tech
> On Sep 22, 2017, at 3:19 PM, Tony Ringsmuth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Only thing I would shy-away from is the new network layer: I’m dealing with > a case right now where if you have larger numbers of users (20+): things get > slow. Mac, Windows or mixed? Is the

Re: PostgreSQL SELECT... RETURNING ID

2017-09-21 Thread John DeSoi via 4D_Tech
That should work without problems. PgSQL Select and PgSQL Execute mostly do the same things except Execute does not return rows. The "returning" clause makes it a set returning SQL command so PgSQL Select is the right plugin command. John DeSoi, Ph.D. > On Sep 21, 2017, at 9:37 AM, Jeffrey

Re: SFTP - Native to 4D?

2017-09-13 Thread John DeSoi via 4D_Tech
Hi Janet, > On Sep 13, 2017, at 3:18 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > What do you launch with LEP? You launch "curl". Type "man curl" in Terminal to see the details. This is installed by default on macOS. Not sure if this is fixed in more recent macOS versions,

Re: SFTP - Native to 4D?

2017-09-13 Thread John DeSoi via 4D_Tech
Hi Janet, > On Sep 13, 2017, at 3:40 PM, Janet Jonas via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I was familiar with the encryption command, we used it to generate a key for > securing a website hosted by a copy of 4D, however the documentation talks > about browsers. We would want to be

Re: Procedurally adding attributes to ST SET ATTRIBUTES

2017-09-21 Thread John DeSoi via 4D_Tech
The easiest way would be to put your style attributes and values in an object (or arrays) and then loop over them calling ST SET ATTRIBUTES. For example, here is what I use to clear all font styles: ARRAY LONGINT($aStyle;0) ARRAY_Append_integer (->$aStyle;Attribute bold style;Attribute italic

Re: PostgreSQL SELECT... RETURNING ID

2017-09-21 Thread John DeSoi via 4D_Tech
PgSQL Get Last Insert Row ID is not the same thing - it returns the OID (object identifier) for the row. OIDs are depreciated and not created by default for a table unless you include WITH OIDS in your CREATE TABLE statement (or change the parameter default). Assuming what you are after is the

Re: 4D v16.2 false record locks

2017-10-03 Thread John DeSoi via 4D_Tech
Hi Tim, I have not opened a tech support case for this issue. But I have opened my share of them. The only way to get something fixed is to provide a reproducible example or perhaps a log with some detail that can help 4D fix it. Even with these details provided, many problems remain unsolved.

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

2017-10-10 Thread John DeSoi via 4D_Tech
Hey David, Right, CALL FORM will fix a lot of work-arounds needed for previous 4D versions. But my goal here is to have a single stable code base in 15 until making the move to version 16. I don't want to maintain two versions if I can avoid it. That said, I already have some v16 features

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

2017-10-10 Thread John DeSoi via 4D_Tech
Ken, I just ran into a problem with POST KEY in 16.2 that works without problems in 15.4. An outside call message is sent from another process and POST KEY is used in in the outside call event to activate a menu item. For some reason it does not seem to work right unless I add DELAY

Re: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread John DeSoi via 4D_Tech
> On Sep 12, 2017, at 5:48 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Exciting stuff. I've read a ton about it and done some tests. Rob's plugin > doesn't have an explicit command for transferring object fields, but you > can stringify them and send them as text. Most

Re: [OFF] PCI/DSS compliance

2017-09-08 Thread John DeSoi via 4D_Tech
Experian did this as well (on a smaller scale) a few years ago. Same response, "sorry about that, we will give you a year of free credit monitoring". When I looked into what they asked for to sign up for "free" credit monitoring, it just looked like another opportunity to have my data hacked

Re: 4D v16.2 false record locks

2017-10-03 Thread John DeSoi via 4D_Tech
> On Sep 19, 2017, at 7:33 PM, John DeSoi wrote: > > I still think there is a new bug in version 16, but I have not seen it happen > again since upgrading to 16.2. This is a single user application with one > process accessing the record. There is a trigger, but it just

Re: 4D v16.2 false record locks

2017-10-03 Thread John DeSoi via 4D_Tech
Not the case here. Table is set to READ WRITE at the start of the process and never changed. John DeSoi, Ph.D. > On Oct 3, 2017, at 10:25 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > one thing that bit me in earlier versions (not v16) is Read Only. > A record is locked when it is

Re: 4D v16.2 false record locks

2017-10-03 Thread John DeSoi via 4D_Tech
> On Oct 3, 2017, at 3:56 PM, Dennis, Neil via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The ones that I have submitted that are reproducible I include a small > database demonstrating them. The bug is filed, I get email notifications as > it is updated and accepted, then I get an email

Re: Min/Max for Date Fields in 4D

2017-10-12 Thread John DeSoi via 4D_Tech
There are plenty more variables to consider that could make a huge difference in performance. If the table is large (say 20 million records) and the selection size is above a certain size (roughly 15,000 records), DISTINCT VALUES is very slow for b-tree indexed fields. I'm seeing times over 10

Re: PDF in Web Area not displaying on a Mac

2017-10-18 Thread John DeSoi via 4D_Tech
> On Oct 18, 2017, at 6:22 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > There is nothing in the path names that require encoding ie.. WA OPEN > URL(waDocument;"file://"+$posixPath) and WA OPEN > URL(waDocument;"file://"+$posixPath;*) return the same thing. For example >

Re: Anyone using 4D Write Pro with a semblance of success?

2017-10-17 Thread John DeSoi via 4D_Tech
> On Oct 17, 2017, at 2:25 PM, Tom DeMeo via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If you want to build emails or edit different types of text files that are > kept server side, the Ace editor embedded in a web area is a better library > than Tiny MCE. They seem to be shooting for a web

Re: 4D Server / Remote 16.2 64-bit macOS 10.12.6 or 10.13

2017-11-30 Thread John DeSoi via 4D_Tech
Jody, What big problems are you referring to with the 10.13 file system? Seems fine for development with 16.2. I have a test server running 10.13 with 16.2HF1, just waiting for the company to make time for testing. If there are no complaints, the plan is to move to production with this

Re: Strange problem with v16 and Launch External Process in a component

2017-12-04 Thread John DeSoi via 4D_Tech
Anything unusual about the LEP call -- just using locals and specifying all of them? That alone should make it execute in blocking mode. E.g. LAUNCH EXTERNAL PROCESS($cmd;$in;$out;$err) Lots of bugs have been fixed since 16.0. Have you tried 16.2? John DeSoi, Ph.D. > On Dec 4, 2017, at 10:36

Re: Menus and components

2017-12-18 Thread John DeSoi via 4D_Tech
DeSoi, Ph.D. > On Dec 18, 2017, at 7:59 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > This is working for me in version 16 (16.3). I set the main menu bar with a > callback to the host. Then the component appends some additional menus > created in the co

Re: Menus and components

2017-12-18 Thread John DeSoi via 4D_Tech
> On Dec 17, 2017, at 1:01 PM, Jeremy Roussak via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > In v16, things have changed. The parent menu bar doesn’t appear; and if I > make it appear, by supplying a callback routine in the parent which calls SET > MENU BAR(“Main”), while the menu bar and

Re: HTTP Get and HTTP Request Blocking Server?

2017-12-15 Thread John DeSoi via 4D_Tech
Cannon, > On Dec 15, 2017, at 10:18 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thanks, Arnaud. I was hoping to find someone that could say “Hey, we do that > now and it isn’t a problem” to give me some confidence going forward. But > you’re right, there are other

Re: 4D Backup causes 4D Remote to hang (15.4)

2017-11-14 Thread John DeSoi via 4D_Tech
Are there database requests coming in via the web server at the time of the backup? Have you tried turning off the web server during backup? Or at least return an error response if access to the database is needed when backup is running. John DeSoi, Ph.D. > On Nov 14, 2017, at 8:40 AM,

Re: Slow characters visualization

2017-11-20 Thread John DeSoi via 4D_Tech
Previously, I only had problems on the Mac with version 15.4 if I had many large methods open. Closing everything would solve the problem. Then I upgraded the Mac from 10.11 to 10.13 High Sierra. Now a single large method open is enough to make typing code very frustrating. No problems with

Re: wa open url command in v15

2017-11-16 Thread John DeSoi via 4D_Tech
Is there an Acrobat PDF plugin in /Library/Internet Plug-ins/ or ~/Library/Internet Plug-ins/? Try removing it. http://osxdaily.com/2014/10/05/delete-adobe-acrobat-reader-safari-plugin/ John DeSoi, Ph.D. > On Nov 16, 2017, at 11:13 AM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com>

Re: 4D Remote hanging at 3am after upgrading to Hi Sierra. Need logging advice.

2017-11-05 Thread John DeSoi via 4D_Tech
You may have said so earlier, but is the machine set to never sleep in the Energy control panel? RE: caffeinate If you launch 4D using caffeinate /path/to/4d, the machine should not go to sleep until 4D quits. See also the -w option where you can have 4D set it up after it has started. John

Re: Slow characters visualization

2017-11-06 Thread John DeSoi via 4D_Tech
On the Mac I notice a significant slowdown if I have more than a few methods open that have a lot of code. Closing the big methods seems to fix the problem. John DeSoi, Ph.D. > On Nov 6, 2017, at 3:03 PM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I use 4D V15.5 on

Re: Move a progress bar before it opens

2017-10-21 Thread John DeSoi via 4D_Tech
> On Oct 21, 2017, at 10:26 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Using 4D's progress bar component for the first time... > > How can you have it open at a specific position, instead of opening it first > and then relocating it (ugly)? I don't think it is possible

Re: Access to Runtime Explorer

2018-05-04 Thread John DeSoi via 4D_Tech
Hi Jody, I had a case where I wanted non-admin users to be able to open runtime explorer. I was able to do this by temporarily switching their access to designer, opening runtime explorer, then switching back their access. I had to use Apple Events to send the keystrokes to open up runtime

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

2018-04-27 Thread John DeSoi via 4D_Tech
$localRegex:="\\$[0-9_\\p{Letter}]+" //Includes parameters. Assumes locals do not have spaces. A simple way to ensure you are not matching within strings is to split the method into lines and then on each line collapse the strings so they are empty. You only need to do this on lines that have

Re: Access to Runtime Explorer

2018-05-05 Thread John DeSoi via 4D_Tech
Here is the LAUNCH EXTERNAL PROCESS line for command-shift-F9 osascript -e 'tell application "System Events"' -e 'key code 101 using {shift down, command down}' -e 'end tell' If the current user needs to be reset, I use the loop below to wait until the Runtime Explorer window is up.

Re: Amazon Simple Email Service (SES) with 4D Internet commands

2018-05-21 Thread John DeSoi via 4D_Tech
d receiver addresses to be verified before you can use them. John DeSoi, Ph.D. > On May 21, 2018, at 9:47 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Has anyone successfully used SES with 4D IC's SMTP commands? SMTP_Send always > fails with error cod

Amazon Simple Email Service (SES) with 4D Internet commands

2018-05-21 Thread John DeSoi via 4D_Tech
Has anyone successfully used SES with 4D IC's SMTP commands? SMTP_Send always fails with error code 10046 (SMTP 554 - Transaction failed). I'm using 16.3HF2 Mac. I know the SES SMTP interface is working because I can send emails from the same computer using PHP. Thanks, John DeSoi, Ph.D.

Re: Auto Positioning Print Forms

2018-05-21 Thread John DeSoi via 4D_Tech
r settings? > > On Mon, May 21, 2018 at 11:09 PM, John DeSoi via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> All the MOVE OBJECT code I have runs in the form event for the area being >> printed (On Printing Detail, Form Foote

Re: Ten Year Old Self Help Tutorials. Really?

2018-05-15 Thread John DeSoi via 4D_Tech
ftp://ftp-public.4d.fr/Demos Has a lot of demo databases including a big collection for version 17. Not really "training" material, but might be helpful. John DeSoi, Ph.D. > On May 15, 2018, at 9:56 PM, Allan Udy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I appreciate that creating

Re: Web App on iPhone - Returns gobblydygook

2018-05-16 Thread John DeSoi via 4D_Tech
What is the purpose of the "Vary" header? Usage seems incorrect here, especially since nothing should be cached. Wonder if that can mess up content negotiation somehow. See the link below for details about the Vary header. https://www.smashingmagazine.com/2017/11/understanding-vary-header/

Re: Musing on creating PDFs in 4D

2018-06-14 Thread John DeSoi via 4D_Tech
To make the upgrade to 4D 16 64-bit, I replaced 4D Write with a Markdown editor using a rich text area with some expression editing features. HTML generated from Markdown is converted to PDF using PhantomJS. Seems to work well and no complaints from users. PhantomJS is losing future support,

Re: How does one detect that Cookies are disabled?

2018-06-05 Thread John DeSoi via 4D_Tech
Jim, Hard to help here without some additional information. By "session" do you mean you are using 4D's automatic session management? What version? You might also show a bit of your code. So you are sending your first response with a "Set-Cookie" header and the *next* request from the browser

Re: How does one detect that Cookies are disabled?

2018-06-05 Thread John DeSoi via 4D_Tech
> On Jun 5, 2018, at 12:28 PM, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I think that it's a question of the Browser not actually creating the Cookie > until 4D ends the connection/method. If one traces the browser's actions one > only sees the Cookie existing only

Re: How does one detect that Cookies are disabled?

2018-06-05 Thread John DeSoi via 4D_Tech
I don't know anything about Xojo, but from the code you posted all it seems to do is set a value on the server and immediately read it back. There is no way for the browser to have it yet. The browser only sets a local cookie from a HTTP response containing a "Set-Cookie" header. If cookies are

Re: Creating Tables by running a method

2018-06-23 Thread John DeSoi via 4D_Tech
Pat, Not in the XML, but you could import the table structure (with trigger properties enabled) and then set the trigger code using METHOD SET CODE. My approach would be to enable all the trigger properties even if there is not an immediate need to have a trigger. I don't think there is any

Re: Creating Tables by running a method

2018-06-23 Thread John DeSoi via 4D_Tech
The triggers won't run until you set the trigger properties on the table. I'm not aware there is any way to do that via SQL. You can set the trigger properties if you create the tables via XML and use IMPORT STRUCTURE. John DeSoi, Ph.D. > On Jun 23, 2018, at 11:52 AM, Jody Bevan via 4D_Tech

Re: How do I get the type of a Collection element? (v16r6)

2018-04-26 Thread John DeSoi via 4D_Tech
New command, Value type: $type:=Value type($col[0]) And note if you use the new For each loop in version 17, all collection elements must have the same type. John DeSoi, Ph.D. > On Apr 26, 2018, at 10:36 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If I'm iterating

Re: Object get type no longer returns the Object Array type in v16r6

2018-04-26 Thread John DeSoi via 4D_Tech
Yes, I thought this was interesting. A useful change, but no compatibility setting for this - all previous code that used OB Get type will need to be updated for version 16R/17. OB Get type can now return Is Date for dates, but it has a compatibility setting where it can be controlled. Also

Re: Testing for Null is superior to OB is defined

2018-04-30 Thread John DeSoi via 4D_Tech
This only applies to dot notation you write directly in the method. If you reference properties with brackets [], you can use any property name string you like. One feature that I think is missing is that you can't access a complex property path using a string. For example. $object:=New

Re: [Tip?] Test path name and Posix

2018-04-30 Thread John DeSoi via 4D_Tech
> On Apr 30, 2018, at 11:57 AM, Arnaud de Montard via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > On the new server, the valuable posix path now is something like > "/volumes/sharedFolder-3/subFolder/" (-3 has been added) > I've changed my mind and store system path… :-/ > But I'm wondering

Re: Extra characters

2018-07-03 Thread John DeSoi via 4D_Tech
The extra characters are the Byte Order Mark (BOM) - see the documentation. A BOM is useless with UTF-8, but there is no way to prevent 4D from inserting it when using TEXT TO DOCUMENT. I use this method instead: C_TEXT($1;$2) C_BLOB($blob) TEXT TO BLOB($1;$blob;UTF8 text without length)

Re: DELAY PROCESS bug

2018-01-05 Thread John DeSoi via 4D_Tech
After this discussion I ran a test server for several weeks before upgrading from 15.4 to 16.3 (Mac 64 bit). No problem running jobs on the server interleaved with DELAY PROCESS. After upgrading the production database to 16.3, a client running this same procedure regularly locks up. It seems

Re: Curious about "functional programming"

2017-12-21 Thread John DeSoi via 4D_Tech
> On Dec 21, 2017, at 3:06 PM, Don Lapin via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 4D does not seem to lend itself to the functional approach. Completely true. Changing the database is non-functional. You could try to enforce this discipline, but I think it would be difficult to get

BRING TO FRONT for process windows minimized

2018-01-10 Thread John DeSoi via 4D_Tech
Not sure if this is a new problem in version 16 (16.3 64-bit Mac) or just something I never realized. BRING TO FRONT does nothing if the window is minimized in the dock. You need to call SHOW PROCESS first even though PROCESS PROPERTIES indicates the process is visible. Also, windows

Re: DELAY PROCESS bug

2018-01-08 Thread John DeSoi via 4D_Tech
Bernd, Are you having this issue with the server, client, or both? I'm just seeing it with 4D Client. My new theory is that during a long delay 4D Server disconnects the client because there is no activity and 4D Server timeout (selector 13 for SET DATABASE PARAMETER) is reached. This may be

Re: Bug or feature?

2018-02-01 Thread John DeSoi via 4D_Tech
There are no work-arounds for runtime errors. 4D throws up an error dialog and allows the end user to decide what to do, even if executing on 4D Server or in a web process. See feature request and discussion here: http://forums.4d.com/Post/EN/17994245/1/19128922 John DeSoi, Ph.D. > On Feb

Re: Problems installing built application

2018-01-31 Thread John DeSoi via 4D_Tech
You can do this with the default data file. The new model allows you to startup your app and then switch to another database without showing the open database dialog. You can switch to an existing one or create a new one on the fly. John DeSoi, Ph.D. > On Jan 31, 2018, at 1:35 PM, macjimbo

Re: Problem with PDF Creation into Temporary Folder (Follow-up)

2018-02-03 Thread John DeSoi via 4D_Tech
It may be worth trying to use something other than Temporary folder. That is a long and strange path. I have had problems using it with AppleScript as well as displaying PDFs in web areas. One alternative is to create something in ~/Library/Caches. For example, Get 4D folder(Current resources

QuickReports v16 64-bit Mac on a form

2018-02-20 Thread John DeSoi via 4D_Tech
I have a few legacy reports that I have been keeping alive on quick reports. After upgrading to 4D 16.3, it seems you can still have a quick report on a form, but you can't load it or do anything with it in the form On Load phase. For example, QR BLOB TO REPORT fails in On Load (error -9850

RESOLVE POINTER does not work in preemptive processes

2017-12-28 Thread John DeSoi via 4D_Tech
Just spent hours chasing this issue down (16.3). RESOLVE POINTER is marked as preemptive ready, but in a preemptive process the name returned for the process variable is always empty. Example C_TEXT(myTextVar) C_TEXT($varName) C_LONGINT($tableNum;$fieldNum) RESOLVE

Re: RESOLVE POINTER does not work in preemptive processes

2017-12-28 Thread John DeSoi via 4D_Tech
Same problem, always empty. John DeSoi, Ph.D. > On Dec 28, 2017, at 11:57 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > what about: > C_TEXT(myTextVar) > C_POINTER($myPointer) > C_TEXT($varName) > C_LONGINT($tableNum;$fieldNum) > > $myPointer:=->myTextVar > RESOLVE

  1   2   3   4   >