Re: Server Process "Frozen"-ish

2017-09-13 Thread Jeffrey Kain via 4D_Tech
Just saw this happen to our production server tonight. We have a stored procedure that simply calls New Log File every few minutes. About an hour ago it just stopped working. The process is still there in the process list, and nothing else seems wrong with the server, but this very simple stored pr

Re: Server Process "Frozen"-ish

2017-09-14 Thread Jeffrey Kain via 4D_Tech
I opened a case on the taow today - just FYI. > On Sep 14, 2017, at 8:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Then I’d call and speak to Add and get him involved in this. He knows you. > And you can tell him that others — like Jeff Kain — are experiencing the same >

Re: Server Process "Frozen"-ish

2017-09-15 Thread Jeffrey Kain via 4D_Tech
This one in particular may take awhile. It took about 16 days for us to see the issue for the first time. Who knows when it will happen again? So more people watching for this issue should shorten the amount of time needed to get this identified. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep

4D v16.2 false record locks

2017-09-18 Thread Jeffrey Kain via 4D_Tech
Has anyone who uses v16 run across false record locks being reported? On two occasions now over the past 3 weeks, we've run across locked records where 4D reports that the user locking the record is not even signed in to 4D. Locked Attributes seems to be giving the same information that 4D's us

Re: 4D v16.2 false record locks

2017-09-18 Thread Jeffrey Kain via 4D_Tech
Not in these particular tables. We've never seen this happen before until v16 and now it's happened twice that we know of. > On Sep 18, 2017, at 10:12 AM, Dennis, Neil wrote: > > I have not seen this, could it be that you use an execute on server and do > not unload the record when you are don

Re: 4D v16.2 false record locks

2017-09-18 Thread Jeffrey Kain via 4D_Tech
Not in our case. The stored procedure that stopped running the other day doesn't access or lock any records, it just calls NEW LOG FILE in a loop (mirror backup). -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 18, 2017, at 10:57 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: 4D v16.2 false record locks

2017-09-19 Thread Jeffrey Kain via 4D_Tech
The client timeout will remove a dead user after that period of activity. In these cases, the user isn't even showing in the list of connected users on the server, yet 4D reports the lock in that user's name. It's pretty weird. I guess others have seen this before, but it's new to me. I can und

PostgreSQL SELECT... RETURNING ID

2017-09-21 Thread Jeffrey Kain via 4D_Tech
We're using the Pluggers PostgreSQL plug-in, and trying to capture the ID of newly inserted rows. It seems like the best way to do this is to put the insert into a Select. The following seems to work, but we've just never done this before and it seems weird... :) Anything to worry about here?

Re: PostgreSQL SELECT... RETURNING ID

2017-09-21 Thread Jeffrey Kain via 4D_Tech
> John DeSoi, Ph.D. > > >> On Sep 21, 2017, at 9:37 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> We're using the Pluggers PostgreSQL plug-in, and trying to capture the ID of >> newly inserted rows. It seems like the bes

Re: PostgreSQL SELECT... RETURNING ID

2017-09-21 Thread Jeffrey Kain via 4D_Tech
Sorry- typo... > On Sep 21, 2017, at 1:01 PM, Alfonso Zafon via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The line > $rowset:=PgSQL Select ($lConnection;"";$lStatement) > > > is wrong ** 4D Internet Users Group (4D iNUG) FA

Re: PostgreSQL SELECT... RETURNING ID

2017-09-21 Thread Jeffrey Kain via 4D_Tech
Ahh, thanks for the clarification (and to Dave Adams). That makes sense. We'll stick with the 'returning' clause. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 21, 2017, at 1:23 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > PgSQL Get Last Insert Row ID is not the same thing

Re: 4D v16 issues

2017-09-22 Thread Jeffrey Kain via 4D_Tech
Hey Drew - We reported the stored procedure frozen issue... it's only happened once so far. We're going to get a procdump from the server the next time it happens. The record lock issue has only happened twice. From what others have written here, it sounds like it's been an issue for others fo

Re: 4D v16 issues

2017-09-22 Thread Jeffrey Kain via 4D_Tech
15.4, which seemed to be about the same as v13. At first I just discounted the early reports, but more and more came in that things were a lot snappier in v16. > On Sep 22, 2017, at 4:17 PM, Stephen J. Orth > wrote: > > Jeff, > > When you say V16 is noticeably faster, compared to what versio

Re: 4D v16 issues

2017-09-22 Thread Jeffrey Kain via 4D_Tech
Tim - > And since you are using the legacy network that means you are still running > 32bit 4D Client. If you want to run 64bit client — macOS or Windows — you are > required to use the new network layer. Is that your understand too? Correct. I’m thinking 2Q of 2018 that we will start looking

Re: [OFF] Mac OS High Sierra PHP and Apache Versions & 15.4 compatibilty

2017-09-26 Thread Jeffrey Kain via 4D_Tech
php 7.1.7 Doesn’t look like Apache is installed on my system. I’ve been testing High Sierra at work for awhile since we have some very early adopters, and 4D 15/16 and ecosystem all seem fine. Jeff > On Sep 25, 2017, at 10:09 PM, Perkins, Bradley D via 4D_Tech > <4d_tech@lists.4d.com> wrote

Programmatic control of accept/reject new connections

2017-09-27 Thread Jeffrey Kain via 4D_Tech
Can this be done in code? Or is there a way to default it to rejecting connections when you start the server? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html O

Re: Programmatic control of accept/reject new connections

2017-09-27 Thread Jeffrey Kain via 4D_Tech
> Spencer > >> On Sep 27, 2017, at 7:38 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Can this be done in code? Or is there a way to default it to rejecting >> connections when you start the server? >> ***

Re: [offish]Volume of mail

2017-10-05 Thread Jeffrey Kain via 4D_Tech
Correlation does not imply causation. We have a lot of 4D developers working here, but I'm on the only who participates actively in the list. Also, 4D has a lot fewer "issues" these days than in the old days. The user base is definitely a lot smaller compared to the gay 90s, but we've all know

Re: San Fransisco Font

2017-10-09 Thread Jeffrey Kain via 4D_Tech
Sujit- You need to refer to it in your style sheets as “System Font.” > On Oct 9, 2017, at 1:09 AM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Does the SF font replace Lucida Grand on macOS Sierra? If so I don't seem > to find it on my Mac? > > Has SF become the standard defau

Re: San Fransisco Font

2017-10-09 Thread Jeffrey Kain via 4D_Tech
> Still does not explain why I cannot see the SF font in the fonts library. Apple locks it down. You can’t see it in Word either. > I will avoid System Font as the user can manipulate this. How? I suppose you could manipulate any font really... ***

Re: San Fransisco Font

2017-10-09 Thread Jeffrey Kain via 4D_Tech
In my experience, the Default style sheet doesn't work correctly. On El Capitan and Sierra, it uses the Yosemite system font no matter what. But if you make a new style sheet that refers to "System Font" you'll end up the correct font on each OS. Not sure why "Default" doesn't work properly... I

Re: San Fransisco Font

2017-10-09 Thread Jeffrey Kain via 4D_Tech
You can use any size. -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 9, 2017, at 6:30 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thanks for the insight. The system font on Mac Appears small (says size > 10). Can the size be increased to 11? Will each user need to add a s

Re: Deprecated Constants

2017-10-10 Thread Jeffrey Kain via 4D_Tech
We've left a few "During"s in place where it wasn't entirely clear how to replace it. Still works fine... Most of them were easy to replace, but for a few of them it seemed best to leave the old code alone and flag it for a future rewrite. -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 10

Re: Min/Max for Date Fields in 4D

2017-10-11 Thread Jeffrey Kain via 4D_Tech
It probably depends on what the server is doing, and the load it’s under, etc.. > On Oct 11, 2017, at 6:55 PM, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It seems that sorting the table is faster than using an array, even after > returning the selection to it's original order, o

Re: v15.4 Compiler Crashes

2017-10-15 Thread Jeffrey Kain via 4D_Tech
Ken - some things to try: Try changing your compiler options to something else, like type the variables. Try deleting the .4DIndy file next to your structure. Try deleting 4D’s preferences file. Run a Verify of the structure file in Maintenance and Security Center. > On Oct 15, 2017, at 1

Re: Server Process "Frozen"-ish

2017-10-18 Thread Jeffrey Kain via 4D_Tech
Hey Cannon - we had this happen twice last week... once each on our two mirror servers a few days apart. The journal integration stored procedure wakes up every 60 seconds and integrates whatever files have accumulated. This just stopped. Also the 4D Server animated user interface for CPU use h

QUERY into variable vs. Records in Table

2017-10-19 Thread Jeffrey Kain via 4D_Tech
Does anyone know the relative performance impact on a server of calling a QUERY wrapped inside a SET QUERY DESTINATION (Into Variable...), compared to calling Records In Table? If you had to do one a hundred times a minute or more, which would you choose? I'm guessing the server can get the rec

Re: QUERY into variable vs. Records in Table

2017-10-19 Thread Jeffrey Kain via 4D_Tech
I was thinking that I could just create a semaphore instead of creating a record. The code that would otherwise be querying would just be calling Test Semaphore... but a method to clear that semaphore would be tricky since only the process that creates it can kill it. And I kind of wonder if Se

Re: QUERY into variable vs. Records in Table

2017-10-19 Thread Jeffrey Kain via 4D_Tech
We've been using the new Get Database Measures command to take a look at what our application is actually doing, and plotting some of these metrics to our dashboard... for example, most frequently run queries. This particular query popped to the top, executing a few hundred times per minute. A

Re: QUERY into variable vs. Records in Table

2017-10-19 Thread Jeffrey Kain via 4D_Tech
Decided to test it. Here are the results, running interpreted, client-server against a server under very low load: Records in table: 565 ms Semaphore polling: 2482 ms Query into variable: 2749 ms Here's my test code: C_LONGINT($msRIT;$msSEM;$msQUERY;$x;$n) C_BOOLEAN($b) $n:=1000 $msRIT:=Millis

Re: QUERY into variable vs. Records in Table

2017-10-19 Thread Jeffrey Kain via 4D_Tech
Great idea - I think that would actually work for what I need... Thanks! -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 19, 2017, at 2:45 PM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > maybe i don't understand but what about: > > `trigger > execute on client("@";"flagPo

Re: Base 64 broken in 4DIC 16.x?

2017-10-21 Thread Jeffrey Kain via 4D_Tech
Thanks - I'll have to check on that! -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 20, 2017, at 7:48 PM, James Bareman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I am seeing this as well with build 16R4.216142. > From my testing, it seems that when you specify the default encoding with >

Move a progress bar before it opens

2017-10-21 Thread Jeffrey Kain via 4D_Tech
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)? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/f

Re: Move a progress bar before it opens

2017-10-21 Thread Jeffrey Kain via 4D_Tech
Nope- you can set it invisible after it opens... lol. Why would you want to do that?? > On Oct 21, 2017, at 11:41 AM, Stephen J. Orth > wrote: > > I've not used this, however... > > Can you have it set as invisible initially, move it, then show it? ***

Re: Move a progress bar before it opens

2017-10-21 Thread Jeffrey Kain via 4D_Tech
ly move it elsewhere. -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 21, 2017, at 11:53 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > >> On Oct 21, 2017, at 10:26 AM, Jeffrey Kain via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >>

Re: Move a progress bar before it opens

2017-10-21 Thread Jeffrey Kain via 4D_Tech
http://doc.4d.com/4Dv15/4D/15/4D-Progress.100-2399688.en.html Very easy to use and they look nice. I need to find the source for this so I can tweak the window position and update the font from Lucida Grande. > On Oct 21, 2017, at 12:15 PM, Stephen J. Orth > wrote: > > Jeff, > > Hum... >

Re: Server Process "Frozen"-ish

2017-10-25 Thread Jeffrey Kain via 4D_Tech
Did you also see the 4D Server UI stop updating? I'm referring to the server monitor user interface that graphs the CPU time, etc. When this has happened to our mirror servers, those graphs stop updating. The server can still be manipulated, but those graphs don't update and the stored procedur

Re: Server Process "Frozen"-ish

2017-10-27 Thread Jeffrey Kain via 4D_Tech
Yes. On Oct 27, 2017, at 3:23 AM, Epperlein, Lutz (agendo) via 4D_Tech <4d_tech@lists.4d.com> wrote: >> I am confident that 4D will find this bug and get it fixed. If it takes 6 >> months, then my >> upgrade plans will be on hold for 6 months. I’m in no hurry to upgrade right >> now. > > Is

Re: Server Process "Frozen"-ish

2017-10-27 Thread Jeffrey Kain via 4D_Tech
Ours are normal, non-built servers. -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 27, 2017, at 2:02 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > For those that have experiences this issue, has anyone experienced it on a > server that wasn’t a “built” server? All mine are

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

2017-10-29 Thread Jeffrey Kain via 4D_Tech
What are you trying to do? > On Oct 29, 2017, at 1:38 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I thought I had such a method but it seems I don't. Before I re-invent this > particular wheel does anyone have this already and are willing to share? **

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

2017-10-29 Thread Jeffrey Kain via 4D_Tech
We built one using a couple of JavaScript files and a CSS file that opens in a web area. Read-only of course, but interactive and collapsible/expandable. Let me know if you’re interested and I’ll post it here. > On Oct 29, 2017, at 5:26 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrot

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

2017-10-29 Thread Jeffrey Kain via 4D_Tech
I thought it was clever too. That’s why we like hiring the young’ns... 1. Create a form named JSON_Viewer that has: - a system web area with On Load enabled - a button labeled “Save as JSON” with On Clicked enabled 2. Create two project methods: - JSON_Display - JSON_Display_Initialize 3

Re: [Warning] Settings properties values on object field by object notation

2017-10-31 Thread Jeffrey Kain via 4D_Tech
Quackers. > On Oct 31, 2017, at 9:17 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > "standard behaviour" is a specific term that means the result is "expected, > if not intended" by design or specification. ***

Re: Slow characters visualization

2017-11-06 Thread Jeffrey Kain via 4D_Tech
This happens in 4D Remote development as well, so it's not cache related. Seems a lot better in v16.2. -- Jeffrey Kain jeffrey.k...@gmail.com > On Nov 6, 2017, at 4:44 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > during development, it is normally not necessary to reserv

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

2017-11-13 Thread Jeffrey Kain via 4D_Tech
Sorry, I haven't really been following the thread, but have you tried protecting the backup and your 3 a.m. code with a semaphore? Or turned on detailed logging on the 4D Remote side to see what it's trying to do? -- Jeffrey Kain jeffrey.k...@gmail.com On Nov 12, 2017, at 11:09 PM, Tim Nevels v

Server HyperThreading

2017-12-27 Thread Jeffrey Kain via 4D_Tech
Is there any conventional wisdom out there (or better yet some 4D Server benchmark) regarding whether HyperThreaded cores help or hurt 4D Server performance? Thanks! Jeff ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4

Re: Slow RECEIVE PACKET for serial

2018-01-02 Thread Jeffrey Kain via 4D_Tech
FWIW, it's easy to write a RECEIVE PACKET wrapper using RECEIVE BUFFER. In an outer loop, periodically call RECEIVE BUFFER and append that data into a process text variable which is the buffer that your RECEIVE PACKET variable will read from. Once you get this done, then you can easily support

Re: Update from v12.6 to v16.3-64 (Mac)

2018-01-04 Thread Jeffrey Kain via 4D_Tech
We skipped v14 and had no problems, FWIW. We did our primary key changes in v13, and then moved to v15 without any issues. And our v16 upgrade had almost zero issues whatsoever (32-bit)... you could probably do 12->13->16 and save a few steps. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan

Re: Log File does not correspond to data file after compacting

2018-01-04 Thread Jeffrey Kain via 4D_Tech
Log files are invalidated after a compact prior to 4D v11. Your only choice is to make a new one after a full backup. > On Jan 4, 2018, at 12:50 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Did any of those dialogs give you the option of creating a new log file? > > >> On J

Re: DELAY PROCESS bug

2018-01-05 Thread Jeffrey Kain via 4D_Tech
Hmmm... another issue with DELAY PROCESS. We have the issue in v16 where stored procedures that are delayed will sometimes never wake up. In our case, it's our mirror process. Sometimes the stored procedure just stops, forever delayed. It is possible to resume it by opening the Runtime Explorer

Re: DELAY PROCESS bug

2018-01-05 Thread Jeffrey Kain via 4D_Tech
Yeah, that's a pretty significant bug. Hopefully they fix it! I tried it on a Windows Server 2012R2 machine running 4D Remote, and did a ctrl-S over the DELAY PROCESS line and then minimized -- same thing. RESUME PROCESS did nothing. > On Jan 5, 2018, at 1:40 PM, Drew Waddell wrote: > > Hey

Re: Mirror design question

2018-01-08 Thread Jeffrey Kain via 4D_Tech
Well, what happens if production crashes and you need to copy the mirror datafile over to production? Is it OK that those records owned by production haven't been updated in a long time from the mirror? There's no technical reason you can't exclude that table... and like you wrote, if you do, y

PDFs in web areas & High Sierra broken?

2018-01-09 Thread Jeffrey Kain via 4D_Tech
Has anyone else had problems previewing PDFs in macOS 10.13.2 and 4D v16 32-bit? I've tried 16.2 HF1 and 16.3 with High Sierra and I just get a blank web area using both the embedded and system web areas. Verified the PDF file exists, that the web area is configured correctly, etc.. Running th

Re: PDFs in web areas & High Sierra broken?

2018-01-09 Thread Jeffrey Kain via 4D_Tech
Great - thank you! -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 9, 2018, at 6:15 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hello, > > the issue is mentioned in the release note. ** 4D Internet Use

Re: PDFs in web areas & High Sierra broken?

2018-01-10 Thread Jeffrey Kain via 4D_Tech
Yeah, "only" the current OS on the Mac side in the versions most of are deploying... lol. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 10, 2018, at 2:38 AM, Alfonso Zafon via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It's a new bug, High Sierra 10.13.2 and only for 4D 32 bits. **

Parsing output from EXPORT STRUCTURE

2018-01-17 Thread Jeffrey Kain via 4D_Tech
How do I parse the XML returned from Export Structure? When I try using DOM Parse XML variable I get the error message 'The XML file is not valid or is not well-formed. (no declaration found for element 'index_ref' : Line #1, Column # 478.) *

Re: Parsing output from EXPORT STRUCTURE

2018-01-17 Thread Jeffrey Kain via 4D_Tech
Thanks John - We actually figured it out by running the exported data through a different XML validator, and there were several Char(0x0001) characters in the exported document. We cleaned it up before running it through 4D's parser: // Strip out the Start of Header characters

Anyone been using R5 for real work?

2018-01-19 Thread Jeffrey Kain via 4D_Tech
Just wondering how it's going... there's so much new stuff it's tempting to jump on the "R" train. But 16.3 is so extremely solid... ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists

Re: 4D SQL Question

2018-01-22 Thread Jeffrey Kain via 4D_Tech
Just make sure you have no object fields in that table, or 4D will give you a runtime error and fail. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 22, 2018, at 1:30 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Not so dissimilar from your idea but you could do > > B

Re: SQL CASE statement?

2018-01-23 Thread Jeffrey Kain via 4D_Tech
Yes. http://doc.4d.com/4Dv15/4D/15/case-expression.300-2288083.en.html -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 23, 2018, at 10:44 AM, Tony Ringsmuth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I’ve been asked if 4D SQL supports CASE statements. ***

Re: Dialog return value without process variables

2018-01-23 Thread Jeffrey Kain via 4D_Tech
In v16.x, you could use a hidden object variable on the form (process variable) that collects the form data you need to access outside the form that gets populated with your OK button's code or whatever accepts the dialog. In r5, there's the nifty Form function that solves this problem. -- Jeff

Re: Print settings Crash

2018-01-24 Thread Jeffrey Kain via 4D_Tech
If it's a Touch Bar MacBook Pro you'll probably need to upgrade to a compatible version of 4D. v15R5 is very old at this point. I'd move to 16.3 if you can. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 24, 2018, at 7:52 AM, Magnus Torell via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I

Re: Print settings Crash

2018-01-24 Thread Jeffrey Kain via 4D_Tech
There is a printer defined/installed, right? Eons ago having no default printer would crash 4D in various ways. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 24, 2018, at 9:51 AM, Magnus Torell via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thinking what to try next... *

The writing is on the wall

2018-01-25 Thread Jeffrey Kain via 4D_Tech
We all need to be testing the new network layer and getting our feedback to 4D... https://arstechnica.com/gadgets/2018/01/apple-prepares-macos-users-for-discontinuation-of-32-bit-app-support/ ** 4D Internet Users Group (4D iNUG

4D v13 and Windows 10

2018-01-28 Thread Jeffrey Kain via 4D_Tech
Hey everyone - in a nutshell, what's the current wisdom on 4D v13.5 compatibility with the different flavors of Windows 10? I've been in a Mac-only universe for the past few years (so nice... lol) and haven't been keeping up with the Windows side of things. Thanks... -- Jeffrey Kain jeffrey.k.

Re: 4D v13 and Windows 10

2018-01-29 Thread Jeffrey Kain via 4D_Tech
Thanks, Alan! -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 28, 2018, at 1:55 PM, Alan Chan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We don't know about 13.5. However, with 13.6, we haven't encountered any > issue on Windows 10 so far. > > Alan Chan

Re: Win32API 8.1.2 gui_GetWindowEx("") in v16r5 (Seth Leeper)

2018-01-30 Thread Jeffrey Kain via 4D_Tech
They just announced (on the forums) that it will be available on github. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jan 30, 2018, at 3:32 PM, Seth Leeper via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > To the best of my knowledge, 4D has not released the v16 SDK.

Re: Re(2): "Goodbye 4D Write" email

2018-02-02 Thread Jeffrey Kain via 4D_Tech
On the other hand, the majority who don't need to integrate word processing are probably thinking "why the heck are they spending so much time and resources trying to reinvent word processing when they could be working on "? I can see both points of view, but for 4D Write I do think 4D has shown

Re: "Goodbye 4D Write" email

2018-02-02 Thread Jeffrey Kain via 4D_Tech
Especially with 4D supporting the Blink engine on both platforms. I haven't yet tried doing any web integrations with a version of 4D that uses Blink, but I'm really hopeful that it makes things a lot smoother. -- Jeffrey Kain jeffrey.k...@gmail.com On Feb 2, 2018, at 11:06 AM, Benedict, Tom vi

Re: Re(2): "Goodbye 4D Write" email

2018-02-02 Thread Jeffrey Kain via 4D_Tech
I think 32-bit applications will live on a lot longer than 2 years on Windows. I haven't read anything that even hints that Microsoft is thinking about ending 32-bit application support. Heck, they still support 16-bit apps on 32-bit Windows. I would expect 32-bit versions of Windows operatin

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

2018-02-03 Thread Jeffrey Kain via 4D_Tech
Are you able to try on 16.3? Our application mails a LOT of PDFs every day without problems, and a few of the computers are using High Sierra and APFS. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 3, 2018, at 10:28 AM, Stephen Shaw via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > My gut f

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

2018-02-03 Thread Jeffrey Kain via 4D_Tech
This is where our application creates them. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 3, 2018, at 11:05 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It may be worth trying to use something other than Temporary folder. That is > a long and strange path. I have had probl

Re: 4d v14 web area & High Sierra & pdf

2018-02-05 Thread Jeffrey Kain via 4D_Tech
We've modified the open source Mozilla Javascript PDF viewer (the same one Firefox uses) to work inside a web area. It's seamless and looks great. We're tweaking the source code now but drop me a line if you're interested in trying it out. It's just Javascript -- no plug-in required. -- Jeffr

Re: Stored procedures not waking up?

2018-02-05 Thread Jeffrey Kain via 4D_Tech
If no official bug has been filed with France by now, there probably should be. Reproducibility is great, but it's shocking a bug like this has lingered for so long. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 5, 2018, at 3:18 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: Stored procedures not waking up?

2018-02-05 Thread Jeffrey Kain via 4D_Tech
Tim, For us, it's happened as recently as 16.3 in compiled mode. Really surprised your test database wasn't able to reproduce it... it definitely had all of the ingredients. We're on 16.3 HF1 now. We'll see how it goes. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 5, 2018, at 3:48 PM,

Re: 4d v14 web area & High Sierra & pdf

2018-02-05 Thread Jeffrey Kain via 4D_Tech
The download button in the viewer crashes 4D. That seems to be the only glitch. We've modified the source to hide that button. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 5, 2018, at 4:13 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 4D language documentation is 2

Re: 4D Parameter

2018-02-07 Thread Jeffrey Kain via 4D_Tech
I think a preemptive worker would be the way to go. Normally a stored procedure is limited to "core 0" along with anything else that can't be multithreaded. If you could do your task in a preemptive worker or a SQL process you'd probably get better response time from your clients. -- Jeffrey K

Re: Can't Paste into Request Dialog in V15 Local Process

2018-02-07 Thread Jeffrey Kain via 4D_Tech
Does the active menu bar have an Edit menu with the standard actions? I've seen this to. The solution has something to do with the menus but the exact details escape me. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 7, 2018, at 4:40 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d

Re: Moving picture resources from one database to another

2018-02-08 Thread Jeffrey Kain via 4D_Tech
Don't be using Mac resources anymore. Get those pictures into files and put them into the Resources folder next to your structure file (there's even a drag and drop GUI (Design menu->Tool Box->Resources) where you can drag pictures from your desktop into the window and 4D will copy them to Res

Re: Can't Run Method In Design Environment

2018-02-11 Thread Jeffrey Kain via 4D_Tech
Did you exit the runtime environment and drop into user mode first, or did you just breakpoint your way into the design environment? -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 11, 2018, at 6:18 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have access to the design env

REST server component?

2018-02-12 Thread Jeffrey Kain via 4D_Tech
Anyone have a full-featured, debugged REST server component for 4D? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options

Re: .tmp files created by 4D Server

2018-02-28 Thread Jeffrey Kain via 4D_Tech
What are the full names of the files? -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 28, 2018, at 3:48 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We have a 4D Server v15 application running which has recently started > leaving 2 or 3 .tmp files in the Temporary files

Delay process bug

2018-03-31 Thread Jeffrey Kain via 4D_Tech
So, the Delay Process bug hit two servers within an hour of each other this morning, after months of not having the issue. It was weird that both of them hit the bug this morning within a short period of time of each other. This was on 16.3 HF2, so the latest and greatest... ***

Re: Bug or feature?

2018-04-07 Thread Jeffrey Kain via 4D_Tech
This is what we do everywhere now. In our case, we're never gonna JSON Parse a longint, so we just wrapped it. -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 5, 2018, at 7:39 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We have a ton of calls to *JSON Parse* that would > n

Thousands of invalid processes - Delay Process issue?

2018-04-08 Thread Jeffrey Kain via 4D_Tech
I posted last Saturday that we were hit by the DELAY PROCESS bug in v16 three times in one day - once on each of our two mirrors, and also on our production server in (at least) the stored procedure that generates the journal files. I resumed the mirror process without any problem and let the pr

Re: 4D Server Fail When Converting from v15.2 to v16R5

2018-04-12 Thread Jeffrey Kain via 4D_Tech
Kirk, According to 4D, the problem is due to the new cache design in v16. We've also seen this on our servers that have a large amount of memory installed. We're working with 4D on a solution to this. The problem, according to 4D, is that the new cache manager allocates a lot of very small bloc

Re: 4D Server Fail When Converting from v15.2 to v16R5

2018-04-12 Thread Jeffrey Kain via 4D_Tech
Another solution might be to convert to v15R4 first, which will do the required reindexing but still use the old cache manager. Then convert to v16 so it won't have to index. > On Apr 12, 2018, at 12:49 PM, Jeffrey Kain wrote: > > Kirk, > > According to 4D, the problem is due to the new cac

Re: 4D Server Fail When Converting from v15.2 to v16R5

2018-04-12 Thread Jeffrey Kain via 4D_Tech
> On Apr 12, 2018, at 1:26 PM, roofto...@mac.com wrote: > > I’ll run a test convert after hours on the production server and see if it > completes without a problem. We do reboot our 4D app once per week. > (Hold-over habits from past years of less stable 4D products.) You mentioned > this ha

Avalera

2018-04-12 Thread Jeffrey Kain via 4D_Tech
Has anyone done a REST interface with Avalera and 4D? It looks easy enough but thought I’d ask to see if a component may already exist... Thanks, Jeff. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html

Re: 4D running in a Mac-VM

2018-04-16 Thread Jeffrey Kain via 4D_Tech
This is from a Mac VM running in VMWare ESXi: Software: System Software Overview: System Version: macOS 10.12.6 (16G29) Kernel Version: Darwin 16.7.0 Boot Volume: Macintosh Boot Mode: Normal Computer Name: mbatch01 User Name: admin (admin) Secure Vir

Re: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

2018-04-20 Thread Jeffrey Kain via 4D_Tech
Paul - All versions continue to support the legacy network layer for 32 bit applications and Windows 64 bit server. There’s no change here. The new network layer seems hugely improved in 16.3 HF2. We run a few smaller servers (<30 clients) with no problems on this version. We haven’t tried t

Re: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

2018-04-20 Thread Jeffrey Kain via 4D_Tech
I haven’t tried it yet, but I understand that the old network layer is available to all apps in v17. On Apr 20, 2018, at 12:57 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> wrote: >>> Also, in v17 the legacy network layer is available in 64-bit apps if you >>> really need it. > ^ this

Re: Web Area display PDF

2018-04-20 Thread Jeffrey Kain via 4D_Tech
Which OS are you using? PDF display is broken in 4D 32-bit on High Sierra. We got pdf.js to work in 4D on Mac but I haven’t gotten around to componentizing it yet or making it widely available. If you’re interested I could send you a little database and you could copy the methods in. It works

Re: Legacy network layer or not: 4D v15 on Mac OS server and v15.5

2018-04-21 Thread Jeffrey Kain via 4D_Tech
From everything I've heard, the new architecture will be a huge step forward in performance, especially for larger deployments. There's no question that push is better than poll when you have thousands of processes trying to communicate (or not) with a server. I'm really looking forward to flip

Re: A thought on re-indexing of a large database after repairs, compacting etc

2018-04-21 Thread Jeffrey Kain via 4D_Tech
4D implemented this very improvement in the v15 R releases. -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 21, 2018, at 8:04 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I guess you could call this a gripe but I don’t understand why, if a table > has several indexes, 4D c

Re: Detecting 64-bit OS

2018-04-23 Thread Jeffrey Kain via 4D_Tech
String matching is a bad way to do this kind of thing. If you have a plug-in like Win32API that can read the registry, this would probably work: https://support.microsoft.com/en-us/help/556009 HTH, Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 23, 2018, at 2:04 PM, Julio Carneir

Re: Collection.orderBy()

2018-04-27 Thread Jeffrey Kain via 4D_Tech
Well, you have a curly quote in that line of code - maybe that's just a mail artifact? Should the asc be inside the double quotes? -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 27, 2018, at 5:10 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Has anyone else gotten orde

Re: Collection.orderBy()

2018-04-27 Thread Jeffrey Kain via 4D_Tech
Yep - you're right. I was thinking of the other syntax that uses a constant. Does the debugger give you any clues if you trace it? -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 27, 2018, at 5:26 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Yeah, the ending quote must

16.3 HF2 test of the new network layer

2018-05-01 Thread Jeffrey Kain via 4D_Tech
Over the weekend, we ran our production 4D Server using the new network layer. We ran from midnight Saturday until midnight Monday, and we peaked at about 145 users and 1200 processes. I'm very happy to say we had no issues at all! There wasn't a single helpdesk ticket filed against 4D for the

New network layer update

2018-05-02 Thread Jeffrey Kain via 4D_Tech
We flipped the switch on our production server at midnight this morning and ran all day. We peaked at 614 simultaneous users and probably between 4000 and 4500 processes. We had no performance alarms trigger and had no complaints from end users about speed. Early indications are that the serv

  1   2   3   4   5   >