Re: Looking for 3rd party SQL query tool

2020-03-30 Thread Tony Ringsmuth via 4D_Tech
a Mac-Tool? I am using SQLPro for MSSQL/mysql from there: https://www.macsqlclient.com -- Grüße/Regards, [heubach-media] | Christian Sakowski christian.sakow...@heubach-media.de Tel: +49/(0)40/41 455 455 > Am 30.03.2020 um 17:53 sc

Looking for 3rd party SQL query tool

2020-03-30 Thread Tony Ringsmuth via 4D_Tech
Can anyone recommend a good 3rd party SQL query tool, to connect to 4D via ODBC, and perform general SQL queries? I used to use “SqlDbx” free version, but the free version is 32 bit only.  Their 64 bit version is a bit spendy. Thanks, -- Tony Ringsmuth Business Brothers Inc. 763-420-8

Re: Windows Server Machine TCP Overload?

2018-12-17 Thread Tony Ringsmuth via 4D_Tech
Thanks Miyako, This link: https://serverfault.com/questions/648424/windows-server-2012-r2-runs-out-of-ephemeral-ports-though-it-shouldnt ... seems like it's leading me on the right path. I'm having our IT guys follow up on that. On 12/14/18, 8:26 PM, "4D_Tech on behalf of Keisuke Miyako v

Windows Server Machine TCP Overload?

2018-12-14 Thread Tony Ringsmuth via 4D_Tech
(Sorry: I haven’t been on the nug for quite a while: but in real need of some ideas at the moment) I’m having what I think is Machine TCP overload. Here’s the situation: >4D V16.4 64-bit >Windows, server 2012r6, 48GB Ram, 11 fast processors, Fast SSD disks I have machines that host n

Re: SQL CASE statement?

2018-01-23 Thread Tony Ringsmuth via 4D_Tech
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. *

SQL CASE statement?

2018-01-23 Thread Tony Ringsmuth via 4D_Tech
I’ve been asked if 4D SQL supports CASE statements. I don’t see it in the docs:  but does anyone know definitively? Thanks, -- Tony Ringsmuth Business Brothers Inc. 763-420-8686 ** 4D Internet Users Group (4D iNUG) FAQ

Re: 4D v16.2 false record locks

2017-10-04 Thread Tony Ringsmuth via 4D_Tech
David, In my opinion, Stability has improved A LOT since the R-release program. I was able to put my OEM base of clients on 16.0 HF2. There are new features I really look forward to: in some ways – they’re getting fewer & farther between: just because 4D has advanced. I think the idea of aski

Re: 4D v16 issues

2017-09-22 Thread Tony Ringsmuth via 4D_Tech
-Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tony Ringsmuth via 4D_Tech Sent: Friday, September 22, 2017 3:19 PM To: 4D Nug <4d_tech@lists.4d.com> Cc: Tony Ringsmuth Subject: Re: 4D v16 issues Drew, I’m h

Re: 4D v16 issues

2017-09-22 Thread Tony Ringsmuth via 4D_Tech
Drew, I’m happy to report that my users are on 16.2, and things are going quite well. I have users to the tune of about 500,000 man-hour/month using instances of the database that I work-on. Only thing I would shy-away from is the new network layer: I’m dealing with a case right now where if y

Re: What happens if 4D attempts to use a Web Service with an expired cert?

2017-08-17 Thread Tony Ringsmuth via 4D_Tech
emembered it now. Has anyone else seen that? (v16.1, Mac, 64-bit for both issues.) -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Aug 17, 2017, at 12:50 PM, Tony Ringsmuth via 4D_Tech <

What happens if 4D attempts to use a Web Service with an expired cert?

2017-08-17 Thread Tony Ringsmuth via 4D_Tech
Can anyone tell me… Scenario: 4D Server (or client) attempts to act as a web service client to a Web service that’s running with an expired cert. Will 4D proceed and connect? Or, will it stop, with errors feedback of some kind? TIA, -- Tony Ringsmuth Business Brothers Inc. 763-420-8686

Can 4D Objects create memory leaks?

2017-07-28 Thread Tony Ringsmuth via 4D_Tech
>v16 Is it possible to create memory leaks using 4D Objects? If so, how? (I’m wanting to make sure that I’m NOT creating leaks) TIA, -- Tony Ringsmuth Business Brothers Inc. 763-420-8686 ** 4D Internet Users Gr

Re: Function to return the date/time of the next scheduled backup

2017-07-12 Thread Tony Ringsmuth via 4D_Tech
the xml get last backup date and time The get backup frequency and perform a calculation I do not think backup save next date in the xml Hope this helps chuck On Wed, Jul 12, 2017 at 4:42 PM, Tony Ringsmuth via 4D_Tech < 4d_tech@lists.4d.com> wrote:

Function to return the date/time of the next scheduled backup

2017-07-12 Thread Tony Ringsmuth via 4D_Tech
Does anyone have code that correctly calculates, from the /preferences/Backup.xml file, the Date/Time of the next scheduled 4D Backup? If so, could you please share it? Thanks! -- Tony Ringsmuth Business Brothers Inc. 763-420-8686 *

Emails sent from 4DIC showing garbage in Mac Outlook

2017-07-06 Thread Tony Ringsmuth via 4D_Tech
Since upgrading a 4D system from v15 to v16, some automated emails that I send out of that 4D system are showing garbage characters in Mac Outlook - after the first couple of lines. Like this: First line of Body Second line of Body Th`���٥��́ѥ���51���Mх} �ѕ|���ܴ�ش�""���