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: 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: 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: [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: 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: 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: 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: Anyone using Thomas Maul's Email Component in v16.x?

2018-04-18 Thread John DeSoi via 4D_Tech
Maybe this change in 16.3 HF2? > > ACI0097778"BASE64 ENCODE" command inserts CRLF characters every 4 > characters. The new behaviour is that no more CRLF is inserted by the > command. If CRLF is needed, it's up to the develop to insert it.

Re: Web Server Freeze

2018-04-11 Thread John DeSoi via 4D_Tech
ech@lists.4d.com> > wrote: > > 15.2 Windows > > On Thu, Apr 12, 2018 at 10:26 AM, John DeSoi via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> What 4D version? Mac or Windows? ** 4D Inte

Re: Web Server Freeze

2018-04-11 Thread John DeSoi via 4D_Tech
What 4D version? Mac or Windows? > On Apr 11, 2018, at 6:55 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We are having random occasional freezing of the Web Server with several > SOAP call processes accumulating on the Server Process window with a > "waiting for flag" state.

Re: When your Extreme router is too slow... (5N)

2018-03-23 Thread John DeSoi via 4D_Tech
After the last big company router stopped getting software and security updates, I switched to using routers that support pfSense. It is a highly regarded open source router implementation which includes OpenVPN. Lots of hardware options are available including running it on your own. Here is a

Re: Collections

2018-03-21 Thread John DeSoi via 4D_Tech
Tim, I was not convinced that proves it. Internally, it could just keep track of the largest value and return null for any values in between that are not assigned. But I thought of a test that likely proves you are right: C_COLLECTION($test) $test:=New Collection $test[MAXLONG-5]:=5 You'll be

Re: Collections

2018-03-21 Thread John DeSoi via 4D_Tech
In the 4D case and in the cases below (plus PHP), I suspect a collection is really just an "object" (hash table) with numeric keys instead of string keys. For example, if I write $collection := New collection() $collection[247] := "fred" I doubt that it creates 247 (indexes 0-246) empty

Re: Where can I find 4D Internet Commands (for v16)?

2018-03-21 Thread John DeSoi via 4D_Tech
In the full version download I see both 4D Internet Commands and 4D Pack in the Plugins folder. Also, 4D Internet Commands seems to be installed by default in the 4D application. So you don't really have to install it at all if you want to use the version that matches the 4D version you have.

Re: Using a Web Area as a Data Entry Area

2018-03-17 Thread John DeSoi via 4D_Tech
Bob, I did not see anything in your image or description that could not easily be done with a listbox. Native HTML tables don't have any enterability features, so you'll have to pick a Javascript library to do that. Any library that can edit tables is going to have a fairly high learning

Re: 4D 16.3 Backup hanging

2018-03-13 Thread John DeSoi via 4D_Tech
I seem to have it stabilized now, but I changed it to initiate the backup on the server. Before I discovered the display issue, I could never get it to work from the client without it hanging. I have not re-tested that. I'm also having problems quitting a registered client from the server - it

Re: 4D 16.3 Backup hanging

2018-03-12 Thread John DeSoi via 4D_Tech
I have experienced a lot of problems with backup after years of zero problems in all previous 4D major versions. I also noticed that operations would suddenly start working when I connected to the Mac via screen sharing. The Mac was set not to sleep, but the display did sleep. On a whim, I set

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

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

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: Print settings Crash

2018-01-24 Thread John DeSoi via 4D_Tech
> On Jan 24, 2018, at 8:51 AM, Magnus Torell via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > However Client still shows a license info that my license expire in 7 > days... I'm getting this too with 16R6 beta. Not sure why. I deleted my old developer licenses but still get it. Maybe you have

Re: 4D SQL Question

2018-01-23 Thread John DeSoi via 4D_Tech
I do something like this with Postgres: If the query returns more than X records, these rows become the starting cache. Then a second query is performed to determine the total number of rows that would be returned. The list box is a selection based listbox for a simple 1 field table where I can

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

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: Re(2): Curious about "functional programming"

2017-12-22 Thread John DeSoi via 4D_Tech
> On Dec 22, 2017, at 1:44 AM, Don Lapin via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Do the difficulties of a functional approach apply to almost any > database-type application, or is it more the issues with error handling in > 4D? Difficulties implementing a functional approach arise

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

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

<    1   2   3   4   >