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

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>

Re: 4D v16 issues

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

Re: 4D v16 issues

for a long time, although I haven't ever seen a lock reported for a user not connected to the server. Not too worried about it yet. Many of our users report that v16 is noticeably faster, which is good... and the server is stable using the legacy network layer. -- Jeffrey Kain jeffrey.k

Re: PostgreSQL SELECT... RETURNING ID

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

Re: PostgreSQL SELECT... RETURNING ID

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)

Re: PostgreSQL SELECT... RETURNING ID

Thanks everyone - Lee, you were right, there's a PgSQL Get Last Insert Row ID function that's also available in the plug-in. They seem to do the same thing. Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 21, 2017, at 12:54 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com>

Re: 4D v16.2 false record locks

understand a lock for a user that's still technically connected but non-responsive (crashed, hanged, etc.) but not if the server isn't even showing the user in the list. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 19, 2017, at 10:00 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>

Re: 4D v16.2 false record locks

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>

Re: 4D v16.2 false record locks

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

4D v16.2 false record locks

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

Re: Server Process "Frozen"-ish

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

Re: Server Process "Frozen"-ish

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

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

Re: v16x centipedes, trilobites and various other arthropods

Unfortunately keyboard shortcuts don't work in ALP 10 if a cell is being edited, which is even worse. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 1:10 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm using ALP v10.0b10 beta > >

Re: v16x centipedes, trilobites and various other arthropods

Only for 64-bit clients. 9.x works fine in 32-bit. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 12:54 PM, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > To my knowledge you need ALP v 10

Re: v16x centipedes, trilobites and various other arthropods

Which version of ALP? We migrated to 16.2 with ALP 9.4 and it works fine (Mac, 32-bit clients), other than if ALP has the focus, the next click outside the ALP is lost. It's a bug in 4D 16.2 (fixed in R4 I guess) -- 4D isn't sending ALP a deactivate event. -- Jeffrey Kain jeffrey.k

Re: Can system tables be UPDATEd in a compiled database?

Thanks Miyako! -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 13, 2017, at 9:46 AM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > SQL system tables are virtual and read-only, > > but you can enable or disable journaling though other means: > >

Can system tables be UPDATEd in a compiled database?

Can system tables be UPDATEd in a compiled database? I'd like to change the value for 'logged' on a table that's in production, but thought I'd ask first if there's an issue with this. ** 4D Internet Users Group (4D iNUG) FAQ:

Re: QUERY BY ATTRIBUTE is slow af

I agree. I had just read this article the other day, however, and was hoping (expecting) that 4D would provide something similar to Postgres JSONB and GIN indexes: https://compose.com/articles/is-postgresql-your-next-json-database/ -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2

Re: [Off] Remote backup

to do this is with a semaphore. And you can't share a semaphore between the host and the component. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 4:01 PM, Benedict, Tom via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > there is a 4D Tech Note which includes all

Re: QUERY BY ATTRIBUTE is slow af

Yeah, so many caveats to object fields. Bite the bullet, use a related table... -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 5:03 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> I am playing with idea to use object for values that are use

Re: [Off] Remote backup

Yes - you have it correct. > It would seem that Server#1 never runs 4D Backup, because any restoration > would be done using Server#2. Nevertheless, if Server#1 started up and > somehow choked, a "normal" behavior would be to restore from backup and > integrate the log file. Since this

Re: QUERY BY ATTRIBUTE is slow af

So disappointing. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 12:14 PM, Herr Alexander Heintz via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Having worked with 4D since ages long forgotten, I would have to feel very > lucky and outright daring to eve

Re: QUERY BY ATTRIBUTE is slow af

That was my first thought too, but I can change the query string to "Ralph" and it still does a sequential scan of the table, returning no rows. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 12, 2017, at 11:26 AM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com

QUERY BY ATTRIBUTE is slow af

Trying to figure out why our experience with QUERY BY ATTRIBUTE is so different than the demos at the last 4D Summit. We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 9 million rows, and we added an index to the Extra field in this table which is an object field.

Re: [Off] Remote backup

data center gets destroyed. Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 10, 2017, at 3:28 PM, Ronald Rosell via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Ideally we’d like the log files to be backed up remotely far more frequently > than the once-a-day ful

Inconsistency in Begin SQL/End SQL

It seems as though you can’t reference a number as hexadecimal in a Begin SQL block (i.e. id_field=0x)? Throws a runtime error. Anyone notice this before? Anyone care? ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Server Process "Frozen"-ish

New network layer on both platforms? > On Sep 8, 2017, at 5:05 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I’ve seen something odd since upgrading our customers to v16.1 a few months > ago. This is on 64-bit server, both platforms.

Re: Convert 4D data MSSQL

I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You might have some issues with date/time fields as well as object fields. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: Getting image from JSON

It's probably base64. I think the commands in 4D are base64 encode and base64 decode -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 6, 2017, at 9:15 AM, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hopefully this is a simple one for many people ou

Re: OB Copy, New Object, or $1

Whew… that’s a relief... :) > On Sep 3, 2017, at 11:11 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I just went back and tested the same code I started this thread with and > found that $oCallerObject:=$1 works. Not sure why it did not work before. I > am certain that the

Re: OB Copy, New Object, or $1

More examples of special, arbitrary rules for objects vs. every other data type in 4D. This is not progress. > On Sep 2, 2017, at 5:43 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > In order to use dot notation a c_object must have been initialized. So when > passing a

Base 64 broken in 4DIC 16.x?

Anyone else seeing Base64 encoding not working correctly in the version 16 of 4D Internet Commands? We haven't debugged this 100% yet, but it seems to be adding some incorrect padding characters to the base64 text depending on the length of the source message, which causes mail clients to not

Problems with new defaults in 4D Internet Commands (Base64)?

Anyone else seeing problems viewing mail messages sent with 4D Internet Commands v16.x, when using the new default in SMTP_Prefs of 1 which means utf-8 + base64 encoding? Many of these messages seem to be unreadable on mail clients, including macOS Mail. It seems that utf-8 + quoted printable

Re: 4D server "pausing" every 15 minutes

Thanks, Jody - I will dig into these... -- Jeffrey Kain jeffrey.k...@gmail.com > On Aug 24, 2017, at 11:51 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Jeff: > > We love dashboards too. At Jonoke we had a dashboard that would display > info

4D server "pausing" every 15 minutes

I just made a very interesting discovery and thought I'd share it with the group -- it's timely given the recent blog post by 4D about dashboards. We're huge fans of dashboards here at Sweetwater, and our dashboard tool of choice is Prometheus. We use this on all our major servers -- Exchange,

Re: 4D server "pausing" every 15 minutes

From Steve: > On Aug 24, 2017, at 11:11 AM, Stephen J. Orth > wrote: > > We have experienced a similar type of situation when using 4D SQL (to extract > data from a MS SQL server). As best we can tell, the SQL call is blocking, > locking out all other

4D server "pausing" every 15 minutes

I just made a very interesting discovery and thought I'd share it with the group -- it's timely given the recent blog post by 4D about dashboards. We're huge fans of dashboards here at Sweetwater, and our dashboard tool of choice is Prometheus. We use this on all our major servers -- Exchange,

Re: Unable to Compile - Crash - looking for ideas

Change your compiler options? Maybe it will flag an error. Also maybe trash your .4DIndy file ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

Re: How to show / hide all on Property List in v16?

Never knew about this shortcut... -- Jeffrey Kain jeffrey.k...@gmail.com On Aug 14, 2017, at 5:04 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote: > >> In prior versions when working with a form and the Property List is >> displayed I could show/hide all panes o

Re: Recommendations?

I wouldn't recommend a plug-in (or PHP) for PDF creation for just 100-200 PDFs a month. It's a real pain in the backside. The printer driver-based solutions are perfectly reliable and are so much easier to maintain. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 30, 2017, at 6:41 PM, K

Re: "Inspect Element" in 4D web area

Perfect - thanks! -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 28, 2017, at 11:15 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Jeff, > Web area set preference is what you want - > http://doc.4d.com/4Dv16R4/4D/16-R4/WA-SET-PREFER

Re: 4D Forums no longer accessible -- too many redirects

Hey Tim -- > forums.4d.com is the new way. This also gives me the "too many redirects" error in Safari. > Here is a direct link to login page referenced in the banner, please try > using this to start the migration process: >

Re: 4D Forums no longer accessible -- too many redirects

I think I tried that yesterday, and then also ended up with redirect errors. What URL did you use to get in for the migration? I'm using forums.4d.fr -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 27, 2017, at 11:39 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > w

4D Forums no longer accessible -- too many redirects

Is there a new way to access forums.4d.fr? For the past few days I haven't been able to reach this site -- Safari displays an error saying too many redirects. ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Bug with Open Document on macOS Sierra

Thanks for the heads up. This was going to be the #1 project after upgrading to v16... creating workers to handle logging. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 25, 2017, at 7:01 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It took me about 15

Re: C-objects and memory use

object references if a child object 10 layers deep got modified. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 25, 2017, at 6:57 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Is that potentially confusing? Can it lead to hard-to-figure-out b

Re: Bug with Open Document on macOS Sierra

There was no code at all in the debug log prior to the reception of the outside call event. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 25, 2017, at 6:55 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If there are object scripts they run

Bug with Open Document on macOS Sierra

Has anyone else seen some really strange bugs with the Open Document command on Sierra? One manifestation: Process 1: Display a form From the form, open a dialog box ("d1") Call open document Close the document Close the dialog ("d1") (Now you're back at the form) Process 2: Do a

Re: C-objects and memory use

s yourself which most people wouldn't like. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 25, 2017, at 2:29 AM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > As I understand it, there is one 'heap' of objects, what means all objects > are IP (where by obj

Re: Serious 4D Internet commands issue in v15.4 with SMTP on Mac OS X

What character set are you using? > On Jul 24, 2017, at 7:33 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The mails are sent to the desired destination but the subject and the body > are often truncated, with a “?” at the end of the subject or body where the > rest of the

Re: Wiki software: Confluence

in the process of writing our own Jira replacement. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 13, 2017, at 4:22 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > What do you like? > > On Thu, Jul 13, 2017 at 6:22 AM, Jeffrey Kain via 4D_Tech < &g

Re: Wiki software: Confluence

That was meant as a joke. Emacs sucks. No vi sucks. Windoze sucks. That said, I think Jira is overly complex, but that's just my opinion. :) Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 13, 2017, at 11:12 AM, Tilman Haerdle via 4D_Tech > <4d_tech@lists.4d.c

Re: Wiki software: Confluence

Jira sucks. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jul 13, 2017, at 5:26 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > ...Wow, thanks for all of the information about the features of Confluence > and Jira. I'm new to them, so pretty much everything

Re: Array Range Check Issue

Have you tried clearing your local cache? It's an answer that I hate, but one that actually does work from time to time, even in 2017. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jun 30, 2017, at 10:12 AM, Stephen J. Orth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Anyo

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

4D's search widget works pretty well as a type-ahead alternative, and it's very easy to integrate with any listbox. > On Jun 28, 2017, at 6:04 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I primarily use 4D to crunch up stuff and spit it out for other programs to > consume,

Re: [Ann] 4D Set Component

Never heard of this. I'd be interested to know. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jun 24, 2017, at 9:41 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I keep meaning to test this out or ask...is wildcard set clearing still > supported? Deep int

Re: Contextual Cut, Copy & Paste...?

Yes, if the text box is multi-style there's a checkbox in the property list to enable this. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jun 21, 2017, at 10:05 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Is there a way to use the contextual menu o

Re: Linux in the future?

clients) and not usable. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jun 16, 2017, at 10:31 AM, Dennis, Neil via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Granted none of these are rack mountable and don't have things like dual > power supplies so they don't count as "se

Re: How to create Object field via SQL

This bit me again yesterday too. I tried to do a SELECT * from a simple table. I forgot that I had used an object field. So annoying. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: So about that Geneva font...

Definitely good to know. Not having to deal with Geneva (yet) saved us a huge amount of time in this old application that pre-dates style sheets in its oldest parts. -- Jeffrey Kain jeffrey.k...@gmail.com > On Jun 13, 2017, at 6:13 PM, Timothy Penner via 4D_Tech > <4d_tech@lis

So about that Geneva font...

I remember reading in 4D's release notes a long time ago that old Macintosh QuickDraw fonts like Geneva would no longer work once 4D made the transition to 64-bit mode. Something seems to have changed. Geneva works in all 64-bit apps including TextEdit, Word, and 4D. Did Apple come out with a

Re: Programmatically scroll a web area

Just tried that... no luck. Also tried from a timer that fires shortly after the form loads. Jeff > On Jun 11, 2017, at 2:49 PM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > maybe - > Post Key - Home or command/control Home > >> Stupid question I hope -- >> >> I'm displaying a PDF in

Programmatically scroll a web area

Stupid question I hope -- I'm displaying a PDF in a web area (4D 15.4/Mac) but the web area always scrolls to the end of the document when it initially displays. How can I have it display at the start of the PDF (scroll bar all the way to the top)?

Re: [off] Textwrangler

Nice... > On Jun 2, 2017, at 4:47 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I accidentally dragged a folder into blank document. > > Text wrangler then proceeded to give me a complete directory listing of > the folder, and all of its sub folders > as text > Cr delimted

Re: Favorite tricks and keystrokes: Please take one and leave on

Nice... didn't know these three after all these years thanks! > On May 28, 2017, at 3:27 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > - Right click process or IP process variable in a method and choose Rename. > Does what it says with the option of doing it everywhere in

Re: Favorite tricks and keystrokes: Please take one and leave one

Here are a few of mine: - Debugger: in the method you are debugging, you can right click on any line of code and select "Run to cursor" -- easier than setting a breakpoint. - Debugger: Execute commands, not just evaluate expressions. One very useful one -- type SET TEXT TO PASTEBOARD (Json

Re: V15.4 & Shy Server Syndrome?

Is your server running with admin (or sufficiently high) privileges? -- Jeffrey Kain jeffrey.k...@gmail.com > On May 18, 2017, at 6:23 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I *can* go through the rigamarole of fixing the window (it only ha

Re: Is it possible to do a search in the file system from 4D

Which version of 4D are you using? Some versions have a bug in LEP that causes them to use 100% of the CPU when they are waiting for the result, thus drastically slowing everything down. If you repeat it from the command line instead from inside 4D, what happens? -- Jeffrey Kain jeffrey.k

Re: Preemptive mode flaw

Weird that a market large enough for its own branch office doesn't use the same tools as the rest of the world. I have to say that the Taow system works really well, in my experience. If I had to email someone and then have no further contact about an issue until it showed up in a release note,

Re: Preemptive mode flaw

Thanks. Nobody ever mentions that when discussing the feature. > On May 8, 2017, at 8:49 AM, Epperlein, Lutz (agendo) > wrote: > > http://doc.4d.com/4Dv16R2/4D/16-R2.1620/Preemptive-4D-processes.300-3111846.en.html > > look at "Availability of preemptive mode" > >

Re: Preemptive mode flaw

Is it still the case that client/server applications are excluded from running preemptive 4D code? -- Jeffrey Kain jeffrey.k...@gmail.com > On May 7, 2017, at 9:03 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > then there is the second, runtime (

Re: Specifying a type with OB GET

Thanks for the confirmations -- I've been bitten in compiled mode several times where the type seemed obvious, everything was fine in interpreted mode, but 4D generated a runtime error when deployed. I will always use that "optional" parameter from now on... Jeff

Specifying a type with OB GET

Have others experienced 4D being unable to correctly determine the type of a variable when assigning it from an OB GET, if you don't specify the type of variable (i.e. "is text", "is longint", and especially "is object")? I see a lot of runtime errors in simple lines of code such as:

"Placeholder" in property list

Has anyone noticed that in 15.4 (HF2... maybe others) there's a new property for fields and variables called 'Placeholder' that automatically fills an empty field with descriptive text in a light gray font color, which disappears when you type or the variable receives a value? It's been awhile

Re: v15.2 clients logging into v15.4 server

Not aware of any open or fixed bugs there in 15.4... -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 18, 2017, at 11:14 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > My error log was blowing up with issues around queries on c-obj fields, > which are also

Re: v15.2 clients logging into v15.4 server

There's an issue with composite indexes and certain queries that use them. If you have access to the hotfixes, get 15.4 HF2. Otherwise 15.4 is very stable in my opinion. Does your application use composite indexes? -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 18, 2017, at 10:24 AM, K

Re: 4D SQL Implementation

Totally agree with all of that. I was hopeful that since Wakanda uses the same engine that we'd see a lot of improvement in the SQL engine of 4D, but not so much. Another example: a SELECT on an indexed field using a nested SELECT works great until you reach a certain number of rows returned.

Re: How to create Object field via SQL

connection handler' Error code: 1203 The functionality is not implemented. component: 'SQLS' task 9336, name: 'SQL connection handler' Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 13, 2017, at 4:14 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > How d

Re: Unexpected Command Key Shortcuts (15.4)

Good point... a parameter definitely makes sense for this command. There must be something already there internally since Find In Design and the Compiler modules can already do it. -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 10, 2017, at 12:46 PM, Drew Waddell <dwadd...@orchardso

4D unit testing framework

Is anyone using that unit testing framework donated by Mark Schaake in v15/v16? Most of the activity in the Google Group was from 2010 with a few posts from 2014. Just wondering what the current status is with the newer versions of 4D? Thanks, Jeff

Re: Unexpected Command Key Shortcuts (15.4)

And I doubt anyone really needs "Go to line number" when the line numbers are listed in the margin... > On Apr 9, 2017, at 12:55 AM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > it might take a while getting used to using command+K for both forms and > methods, > but you no

Re: Unexpected Command Key Shortcuts (15.4)

Cmd-L is defined as goto line and to open the explorer by default, and by default (on a new install of 4D) the goto line number always wins. I always clear cmd-L from goto line number when I reinstall 4D. > On Apr 7, 2017, at 11:29 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com>

Re: 4D V12.5 OK with Windows 10

I don't remember 4D fixing the "tiny text" thing in v12 -- I thought it was something that ended up getting fixed in Windows. -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 7, 2017, at 4:08 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >

Re: CALL FORM and CALL WORKER ideas (Was: 4D World Tour - Get off the fence)

I also thought the discussion on subforms was excellent too. I have to admit that I've never even looked at them, but they are definitely a game-changer as well. So, not a new feature but definitely new to me. -- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 5, 2017, at 5:49 PM, David Adams

Re: 4D World Tour 2017

-- Jeffrey Kain jeffrey.k...@gmail.com > On Apr 5, 2017, at 11:55 AM, David Porter via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I just saw the 4D World Tour 2017 Day 2 State-of-the-art training > presentation in Chicago. > Jean-Pierre Ribreau and Add Komoncha

Re: Anyone using v16 in WAN

Since you're using a 64-bit Mac server you have to use the new network layer. If you had a 64-bit Windows server with 32-bit clients, you could use the legacy (i.e. reliable) network layer. > On Apr 4, 2017, at 2:13 PM, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > OK I am a

Re: Anyone using v16 in WAN

Yes. You only need the new network layer to support 64-bit 4D on Mac. > On Apr 4, 2017, at 12:54 PM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Tim, > >>> I think it is important to investigate whether the instability is specific >>> to application code or not. >>>

Bug or feature?

ge the JSON Parse line to: $oResponse:=JSON Parse($tResponse;Is object) ... then 4D behaves the same in interpreted and compiled. Both catch an error of -1 in the error handler and no runtime error is generated. Feature or bug?

Re: Has anyone been using the V16 menu editor?

Menu bar editor is for baby programmers... :) > On Feb 24, 2017, at 7:27 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Welcome to the world of the 4D Menu Editor. It works, but it has problems. It > is not the most robust editor window in the 4D Design environment. Same >

Re: Old doesn't work with object fields

Yeah, that's an incredibly good idea. I think it would also be very useful for tables as well - being able to manage metadata for a table without creating a special record has been on my wish list for decades now... > On Feb 22, 2017, at 7:12 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com>

Re: Old doesn't work with object fields

Awesome, thanks Cannon! Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 22, 2017, at 1:27 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Jeff, > >> If ((JSON Stringify($fieldPtr->))#(JSON Stringify(Old($fieldPtr-> > > T

Re: Old doesn't work with object fields

works. Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 22, 2017, at 12:52 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I think this is going to track back to a discussion some time ago about > trying to compare two c-objects, or JSON, to each other.

Old doesn't work with object fields

The subject says it all. It's not documented. Is there a good generic way to see if an object field has changed from within a trigger? -- Jeffrey Kain jeffrey.k...@gmail.com ** 4D Internet Users Group (4D iNUG) FAQ: http

Re: Detecting if 4D is Frontmost App

And I thought the Win32API plug-in had a command to do this, but I'm not 100% certain... Jeff -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 17, 2017, at 4:49 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > If you're on the Mac, you might be abl

Re: Character limit in form text variables?

is on its own line with no word wrapping, I can scroll to the end and see all of the data. Also, if the data is truncated in the display, you can still do a select all/copy and all of the data ends up in the clipboard. Thanks all for the ideas... -- Jeffrey Kain jeffrey.k...@gmail.com

Re: Character limit in form text variables?

Thanks Tim - does it matter if it's a field or a variable on the form? > On Feb 13, 2017, at 8:56 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have a “notes” table that has a text field. Basic input form displayed via > a double-click on a listbox row. Window is set to

Character limit in form text variables?

this? Is there a workaround other than loading the data into a blob or text from a file? I'd like to allow the user to paste this in. In case you're wondering, it's a very long series of SQL INSERT statements generated by another application. -- Jeffrey Kain jeffrey.k...@gmail.com

Re: Error Message

Quit 4D, delete your .4DIndy file, and relaunch. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 13, 2017, at 2:37 PM, Peter Mew <peterm3...@gmail.com> wrote: > > Hi a user of my app on OSX Sierra > is reporting this error on startup > > Circular Reference in record

Re: is unique an index or a field?

the basics of how databases work would never do this on a large, frequently updated table, but 4D still let you fall into that trap. Starting with 13.5, 4D no longer allows this. -- Jeffrey Kain jeffrey.k...@gmail.com > On Feb 4, 2017, at 2:14 PM, Arnaud de Montard <arn...@init5.fr&

<    1   2   3   4   5   >