Vexing, un clear SQL error

2017-02-20 Thread Kirk Brooks via 4D_Tech
**Apologies for double posting - just noticed I neglected to add a subject. I need some help with this from some of you SQL gurus. Here's a simple look up function (Partner_get_name) that uses SQL: If ($partner_id>0) If ([PARTNERS]ID#$partner_id) Begin SQL SELECT Name_dba, Name_display,

How to not close all windows on restart - v16

2017-02-18 Thread Kirk Brooks via 4D_Tech
Hi folks, In v16 when I do a restart (like after adding some constants) the db reopens with all the windows closed instead of the ones I was working with opening back up. What's the option setting that controls this? ​Thanks​ -- Kirk Brooks San Francisco, CA ===

Re: How to not close all windows on restart - v16

2017-02-18 Thread Kirk Brooks via 4D_Tech
is not new. > > do you see the same problem in any structure? > > > 2017/02/19 6:42、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール: > > > > In v16 when I do a restart (like after adding some constants) the db > > reopens with all the windows closed instead of t

Re: How to not close all windows on restart - v16

2017-02-18 Thread Kirk Brooks via 4D_Tech
David, You're right about the Restart Interpreted - and Miyako I was was wrong. Have you also noticed you can't collapse/expand the form palette using Control Click on one of the expand/collapse controls? On Sat, Feb 18, 2017 at 4:27 PM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: >

Re: Vexing, un clear SQL error

2017-02-20 Thread Kirk Brooks via 4D_Tech
Hi Tim, Yeah, I was wondering about that error code too. It hadn't occurred to me the problem could be the transit lag between the client the server but that would account for what I'm seeing. Interesting idea about the wrapper. Maybe I'll make a specific error handling method for these sorts of

Re: Vexing, un clear SQL error

2017-02-20 Thread Kirk Brooks via 4D_Tech
Tim, I am also thinking about setting a semaphore at the start and end - but that seems like the wrong path because I can't believe the SQL server can only accomodate one operation from the entire database at a time. On Mon, Feb 20, 2017 at 12:57 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com>

Re: iNUG List "From" Change

2017-02-17 Thread Kirk Brooks via 4D_Tech
I got the bounce warning too. Do we know what caused it? On Fri, Feb 17, 2017 at 9:08 AM, Douglas von Roeder wrote: > Tom: > > Interesting… > > I got unsubbed from the list last week because of too many bounce backs. > That's sorta weird because I've been using the same

Re: Detecting field properties that can take nulls

2017-02-22 Thread Kirk Brooks via 4D_Tech
This is a really cool set of tools for exploring structure. On Mon, Feb 20, 2017 at 12:48 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > the way forward is EXPORT STRUCTURE, > which gives you an XML representation of the structure in full detail. > > read

Re: Better variable names

2017-02-24 Thread Kirk Brooks via 4D_Tech
Yes! And let's not overlook the ever popular series of process arrays named aTemp1, aTemp2, aTemp3 ... even better because they are referenced by pointers referring to some other pointer initialized - someplace. (Deep breath) Ok, thanks for that moment. On Fri, Feb 24, 2017 at 12:12 AM, Herr

Re: Old doesn't work with object fields

2017-02-22 Thread Kirk Brooks via 4D_Tech
Jeff, 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. It turns out to be really tricky. For instance: JSON a: {key1:1234, key2:"abcd"} is that equal to {key2:"abcd", key1:1234} or {key2:"abcd", key1:"1234"}

Re: Old doesn't work with object fields

2017-02-22 Thread Kirk Brooks via 4D_Tech
Jeff, On Wed, Feb 22, 2017 at 10:03 AM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Doesn't Modified only work in a form event? > ​Yep - my bad. ​ > So it turns out that Old works fine with an object field, but you can't do > an = comparison. I think what I'm going to do is the

Re: Better variable names

2017-02-25 Thread Kirk Brooks via 4D_Tech
I find the forums a throw back to - what, late '90s BBs or Compuserve. I know a lot of you remember Compuserve. We complain about the forums and get told that we're just not doing it correctly. This has been going on for years. If it were actually true we would all be over on the forums because

Re: Better variable names

2017-02-26 Thread Kirk Brooks via 4D_Tech
David, ​Thank you for pointing that out. It was insensitive of me to be so blunt. ​ I've snarked about the design of the forums for about as long as I've been aware of them. I still don't think they are great but I certainly don't mean that as any sort of personal criticism. As this thread was

Re: How to get array index with hierarchical listbox when using on mouse move

2017-02-28 Thread Kirk Brooks via 4D_Tech
Piortr, You might be conflating a hierarchical list with a listbox. The way you've described the listbox (if I understand it correctly) the arrays in the listbox will be: col 1 | col 2 | col 3 parent | child | data === p1 | c1 | data1 p1 | c1 | data2 p1

Can I programatically turn off multi-style on a text object in v13?

2017-02-28 Thread Kirk Brooks via 4D_Tech
Title says it all. thanks -- Kirk Brooks San Francisco, CA === ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

Re: Can I programatically turn off multi-style on a text object in v13?

2017-03-01 Thread Kirk Brooks via 4D_Tech
Tim, Thanks for the code - that's a really good option. I'll propose it. On Wed, Mar 1, 2017 at 9:39 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com > wrote: > On Mar 1, 2017, at 11:15 AM,Kirk Brooks wrote: > > > In this case an record entry field sometimes has data pasted in from > things > >

Re: v12 - Query problem

2017-03-01 Thread Kirk Brooks via 4D_Tech
Chip, I'm generally a big fan of writing really lean code but in a case like this I'd put the date value into a variable first. If it still gives inconsistent results I'd do go to the user mode and call up the IP user set, the one that gives you all 46 records. Do apply to selection and set the

Re: Web server: All page links appear as visited after update

2017-03-23 Thread Kirk Brooks via 4D_Tech
d. A typo in the url or > The work around, of course is to change the style for a a:visited... > > > On Thu, Mar 23, 2017 at 8:26 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > I have 4D web server render a page. The page contains a date picker th

Re: Web server: All page links appear as visited after update

2017-03-23 Thread Kirk Brooks via 4D_Tech
Alright, I got it. I was playing with a couple of datepicker widgets and the CSS for the jQuery datepicker is the culprit. Not sure why - aside from complaining about using IDs in selectors the CSS linters I pasted it in didn't flag anything else. However, when it's in the page the error occurs

Re: How to collapse/expand all panes in Property List (v16)

2017-03-28 Thread Kirk Brooks via 4D_Tech
Hey Wayne, That might well be it - you're right I'm using the 64 bit vers. I'll put in a bug report. On Mon, Mar 27, 2017 at 8:58 PM, Wayne Stewart via 4D_Tech < 4d_tech@lists.4d.com> wrote: > At a guess 64 bits is behaving differently than 32 bits. > > My guess is Kirk is using 64bit. > > Might

How to collapse/expand all panes in Property List (v16)

2017-03-26 Thread Kirk Brooks via 4D_Tech
Hi folks, In v16 it seems I the ability to collapse all panes in the Property List (when editing a form) is removed. Since at least v13 you could control click on a pane arrow to collapse/expand all. Now that doesn't work - at least on a Mac. Is this a bug or a feature? -- Kirk Brooks San

Re: DDOS Attack simulator

2017-03-24 Thread Kirk Brooks via 4D_Tech
Hi Steve, Isn't that just patching for the test instead of the problem the test is trying to identify? Or am I missing something - which is entirely possible? On Fri, Mar 24, 2017 at 9:31 AM, Stephen J. Orth via 4D_Tech < 4d_tech@lists.4d.com> wrote: > To get around this, we did a rather simple

Re: v13 - Converting a v12 data file - missing records

2017-03-29 Thread Kirk Brooks via 4D_Tech
Chip, I'm going to guess the issue was with the Parent records. What is it? It could be a number of things especially if this is a mature project that's already been through several previous upgrades. My first hunch is that there's something in the data of a few fields that's causing some esoteric

Re: How to collapse/expand all panes in Property List (v16)

2017-03-29 Thread Kirk Brooks via 4D_Tech
Keith, Bear in mind I'm only talking about the Properties List that's available in development mode. I haven't seen anything on the end-use side involving this. So it's probably not too big a deal. I think if it were more folks would have seen it and said something. On Wed, Mar 29, 2017 at 11:35

Re: How to collapse/expand all panes in Property List (v16)

2017-03-28 Thread Kirk Brooks via 4D_Tech
Hi folks, It looks like this is a legitimate bug and has been logged by 4D. On Sun, Mar 26, 2017 at 6:02 PM, Kirk Brooks wrote: > Hi folks, > > In v16 it seems I the ability to collapse all panes in the Property List > (when editing a form) is removed. Since at least v13

Re: Unique Files Verification Software (Mac)

2017-03-14 Thread Kirk Brooks via 4D_Tech
Robert, On Tue, Mar 14, 2017 at 2:56 PM, Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Actually, I’ve looked for years and have never found anything that will do > this. It’s not impossible to do what needs to be done manually, it’s just a > royal pain and prone to user errors that

Question about passing JSON to 4D

2017-04-04 Thread Kirk Brooks via 4D_Tech
Hi folks, I need a little guidance here. I have a web form (in a browser) that is submitting data to 4D. I collect the data on the webform into an object then stringify it for passing to 4D - like so: var postData = JSON.stringify(woData); $.post( "/workorder/data", postData)

Re: Replacing - OAuth.bundle

2017-04-11 Thread Kirk Brooks via 4D_Tech
Clive, I'm reading this and thinking you're asking for a little assistance dealing with github's interface. It is a bit obtuse if you're coming to it from a 4D perspective and haven't worked with it before. If you follow this link: https://github.com/miyako it takes you to Miyako's github

Re: Anyone using v16 in WAN

2017-04-04 Thread Kirk Brooks via 4D_Tech
Doug, I've been running a db over WAN since v2004. I've found v15 to be more stable than any of the others but I'm also running it on the legacy setting. I've changed to the new one a couple of times and it always gets complaints from users about responsiveness or sluggishness. I don't have any

Re: Replacing - OAuth.bundle

2017-04-12 Thread Kirk Brooks via 4D_Tech
Miyako, Your github account is an absolute trove of useful information and resources for a 4D dev. Your repos organization reflects, I think, the focus and drive I see when you work so there's nothing to apologize for. Github isn't the optimal format for 4D style resources but like Sujit said

Another woe of compiler complacency in v15.4

2017-04-12 Thread Kirk Brooks via 4D_Tech
I'm using Query by formula with Match regex to search for email addresses. I believe I got this idea from the 4D docs but could have been somewhere else. Anyway, here's what I'm doing: SET QUERY DESTINATION(Into set;"emailMatch") $pattern:="(?i)"+$email QUERY BY FORMULA([WebUser_subMgr];Match

Re: Questions about the 'Sum' function

2017-04-12 Thread Kirk Brooks via 4D_Tech
Peter, Sum works fine on a selection of records or on an array. It used to be a little slow but not now. If you are working on 4D server it's useful to build some functions that will run on the server to speed things up even more. Using your example you could write: // Customer_get_invoiceSum

Re: Copy out of read only variable/field

2017-04-06 Thread Kirk Brooks via 4D_Tech
That would be cool - but the only way I've been able to do it to with a transparent button on top. On Thu, Apr 6, 2017 at 2:16 PM, Dennis, Neil via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I thought there was a setting on a read only variable or field to allow > selecting and copying data but

Re: Question about passing JSON to 4D

2017-04-05 Thread Kirk Brooks via 4D_Tech
Miyako, Thanks very much for pointing me in the right direction. Let me share how I've got this working. It's better but still feels a little kludgey. On the javascript side here's how I changed the post method: var postData = JSON.stringify(woData); $.ajax({ url: '/workorder', type: 'POST',

Re: Question about passing JSON to 4D

2017-04-05 Thread Kirk Brooks via 4D_Tech
On Wed, Apr 5, 2017 at 7:40 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > have you tried... > > C_OBJECT($body) > WEB GET HTTP BODY($body) > ? > it might work if you are lucky... > ​ I did and I'm not. ​In this case it looks like it's undocumented because it doesn't work. In v15

Re: [OFF] Hardware advice Was: 4D World Tour 2017

2017-04-05 Thread Kirk Brooks via 4D_Tech
Yeah, what he said. On Wed, Apr 5, 2017 at 10:52 AM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If it was my personal money, I'd probably find a used MacBook Pro from > 2014 or 2015, fully loaded. If the purchase is part of a budget, I'd wait > for the forthcoming "Kaby Lake"

Re: SVG Text Width and Height

2017-04-13 Thread Kirk Brooks via 4D_Tech
Thanks John. On Tue, Mar 28, 2017 at 11:28 AM, truegold via 4D_Tech <4d_tech@lists.4d.com > wrote: > Hi All, > > 4D v15.2 Mac > > Here is what I discovered. The issue I am having appears to be do to > incorrect results from the following lines of a routine: > > $Dom_Ref:=SVG_New >

Re: Unclear distinction between web server session and process

2017-04-16 Thread Kirk Brooks via 4D_Tech
John, OK, I see where I was getting mixed up. The session timeout can be a different length than the process timeout. But in practice the session ceases to persist on 4D unless it's active in a process. So when the process providing the context for the session expires that 'session id' goes too.

Re: Unclear distinction between web server session and process

2017-04-15 Thread Kirk Brooks via 4D_Tech
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

Re: Why would you do this? (Execute Formula Question.)

2017-04-20 Thread Kirk Brooks via 4D_Tech
I've seen stuff like this in code maintained by folks who are good programmers but not particularly well versed in 4D. I think it makes sense from a different perspective. On Thu, Apr 20, 2017 at 11:52 AM, Lee Hinde via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I got bit last night with this

Re: Top Menu Vs Sidebar (Web Applications)

2017-04-19 Thread Kirk Brooks via 4D_Tech
Sujit, Another factor here is whether your app will be used on mobile devices or not. When I'm building forms for use in web areas or my audience is primarily going to be using a latptop or larger I like nav bars and sidebars for the reasons other folks have mentioned. But if it's going to be

Re: Components: How do you reuse utility code?

2017-04-20 Thread Kirk Brooks via 4D_Tech
David, On Thu, Apr 20, 2017 at 3:22 PM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Thu, Apr 20, 2017 at 16:57 Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: > > > 1) as a repository for a core set of functions > > 2) as m

How can I suppress the web server creating default index.html?

2017-04-14 Thread Kirk Brooks via 4D_Tech
I have my webserver (v15.4) set up to respond to the index page and prompt for login. It seems 4D will crate this page each time it starts up if it's not there. I don't want it there because I want to catch the it manually. Can I suppress 4D's urge to create that page if it's missing? -- Kirk

Re: Methods, Components, Comments, and Tooltips

2017-04-20 Thread Kirk Brooks via 4D_Tech
Lutz, I work as a solo developer for the most part and have tried nearly all the code archiving/management schemes mentioned so far. As everyone is saying they have their pros and cons. For a long time I've been exporting methods grouped by modification date. Basically a one method scheme - set

Re: Methods, Components, Comments, and Tooltips

2017-04-20 Thread Kirk Brooks via 4D_Tech
Tom, This is one place where the 'form controller' approach to managing form code works great. By having all the active objects on a form callback to a process method it's much easier to manage code used on a form than if it's residing in specific objects on the form. Granted you can export that

Re: v13: what causes boolean fields to display radios instead of check boxes

2017-04-20 Thread Kirk Brooks via 4D_Tech
Alan, Umm - this is 13.6... Oh well, not a big thing with the workaround fairly easy and known. And good to know it's a known issue. Thanks On Thu, Apr 20, 2017 at 12:41 AM, Alan Chan via 4D_Tech < 4d_tech@lists.4d.com> wrote: > This was a known problem only happened on Mac. The issue seems

Re: Dynamic Method Creation & Content Changing

2017-04-20 Thread Kirk Brooks via 4D_Tech
Hi John, I just posted earlier today about a method I re-write periodically via code. But I don't think it's a good idea for a production db. For what you describe if you're prior v16 I'd try using Footrunner. If you're v16+ I think you can write and execute code on the fly without needing

Unclear distinction between web server session and process

2017-04-14 Thread Kirk Brooks via 4D_Tech
Since I'm focused on the webserver today, I'm coming back to not being clear on the distinction 4D makes between a 'web session' and the 'web process' when using automatic session management. A web session, as I understand it, is an authorized connection between a browser and the server and

Re: How can I suppress the web server creating default index.html?

2017-04-14 Thread Kirk Brooks via 4D_Tech
Joshua, On Fri, Apr 14, 2017 at 8:02 AM, Joshua Hunter via 4D_Tech < 4d_tech@lists.4d.com> wrote: > a) Use WEB SET ROOT FOLDER to change the web root on startup to an empty > directory > ​Just thinking out loud - I have heard other's talk about this approach and I like the idea but wouldn't it

Re: How can I suppress the web server creating default index.html?

2017-04-14 Thread Kirk Brooks via 4D_Tech
Hi Joshua, On Fri, Apr 14, 2017 at 8:02 AM, Joshua Hunter via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I haven't tried but could you either: > > a) Use WEB SET ROOT FOLDER to change the web root on startup to an empty > directory ​I might try this - it's not the way I designed it though...​ >

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

2017-04-18 Thread Kirk Brooks via 4D_Tech
Hi Jeffrey, Yes I do have a few composite indexes. My error log was blowing up with issues around queries on c-obj fields, which are also indexed. Do you know if that was resolved as well? On Tue, Apr 18, 2017 at 7:39 AM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > There's an

Re: Top Menu Vs Sidebar (Web Applications)

2017-04-19 Thread Kirk Brooks via 4D_Tech
Sujit, I would actually suggest just starting from scratch with the most minimal templates - one of the example templates on the Bootstrap site would do. The reason is something like Metronic has so much advanced stuff it could be hard to get a grasp on exactly what's required for the programming

Re: Components: How do you reuse utility code?

2017-04-20 Thread Kirk Brooks via 4D_Tech
Hi David, Reading your comments on components has given me a lot to think about. So examining how ​I tend to look at components​ I find I break them down into two general areas: 1) as a repository for a core set of functions 2) as more or less independent sub-programs ​#1 - core functions I'd

v13: what causes boolean fields to display radios instead of check boxes

2017-04-19 Thread Kirk Brooks via 4D_Tech
I have a form that displays a record with some boolean fields. I set the fields to be checkboxes (included a title) but when the form is loaded it turns into radio buttons. I'm not intentionally changing them - so what would cause this? -- Kirk Brooks San Francisco, CA ===

Re: v13: what causes boolean fields to display radios instead of check boxes

2017-04-19 Thread Kirk Brooks via 4D_Tech
Hi Walt, No, not grouped. I worked around it by using OBJECT SET FORMAT in the on load event. Which works but begs the question of why I have to. On Wed, Apr 19, 2017 at 6:50 PM, Walt Nelson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > On Apr 19, 2017, at 6:42 PM, Kirk Bro

Re: Why does 4D have uppercase UUIDs?

2017-04-23 Thread Kirk Brooks via 4D_Tech
Arnaud, On Sun, Apr 23, 2017 at 12:31 PM, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Kirk, > > (feel free to ask for translation if needed) > ​Yeah - please. The google translate makes no sense. ​ -- Kirk Brooks

Question about synching Resources folder from 4D Server

2017-04-23 Thread Kirk Brooks via 4D_Tech
I'm having a hard time getting this to work. I have the server setting "Update Resources folder during a session" set to Always. I set the database parameter of the Clients to automatically sync. I do this on startup so I know it's set. And I know there's a 2 minute lag between when a change is

Why does 4D have uppercase UUIDs?

2017-04-23 Thread Kirk Brooks via 4D_Tech
I was looking up something else yesterday and came across some comments and directions regarding UUIDs and saying that they should always be lowercase. But this isn't a hard rule, apparently. And 4D prefers to uppercase them - which I find harder to read. Just curious what that's about and if

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

2017-03-09 Thread Kirk Brooks via 4D_Tech
Rudy, I still use longint IDs as PKs on a lot of tables in v15 with no problems. All of them autoincrement however. Like I said before if I need to ensure a sequence I don't use the PK. On Thu, Mar 9, 2017 at 8:18 AM, Two Way Communications via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I wonder …

Re: Bug or feature?

2017-03-03 Thread Kirk Brooks via 4D_Tech
Jeff, I vote for bug. Though it could be it's 2 different errors as far as 4D is concerned with a compiler error tripping first which doesn't show up interpreted. I've noticed -1 being returned as an error code for a really wide range of errors. Or, it's a case like this where the compiler trips

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

2017-03-08 Thread Kirk Brooks via 4D_Tech
Rudy, I suggest you use both Nigel and Arnaud's suggestions: ID (key field) field is UUID and autoincrement Add a separate field for the sequence number I ​f you aren't using autoincrement already I suspect it's because you need control over the number sequence and want to avoid gaps. That's

Using METHOD SET CODE on from objects

2017-03-11 Thread Kirk Brooks via 4D_Tech
This is the first time I'm attempting to use METHOD SET CODE on form objects in a v13.6 db. There's nothing tricky about what I'm doing: export methods from one database and import into another. Project methods all work flawlessly but object methods just don't. I verified the method paths are

Re: Using METHOD SET CODE on from objects

2017-03-11 Thread Kirk Brooks via 4D_Tech
a newer version. I haven't seen a > mention of an issue like this in a "fixed bugs" document but, again, it > might be worth trying to get a better understanding of what is(n't) > happening. > > > > -- > Douglas von Roeder > 949-336-2902 > > On

Re: Anyone successfully running Sierra on their development machine

2017-03-12 Thread Kirk Brooks via 4D_Tech
Robert, I think it's still hardware dependent. I can say for certain you can't run v13 on a new (OLED bar) MacbookPro period. But some folks upgrading older machines had better luck. And don't encourage Tom with respect to any kind of comment involving the word 'lube'. Just don't. On Sun, Mar

Re: Unique Files Verification Software (Mac)

2017-03-14 Thread Kirk Brooks via 4D_Tech
Robert, It sounds like you are doing some really interesting stuff. It also sounds like you might want to be looking for forensic tools already been built for this sort of work. Alex is right about hashing the file blob to develop a unique identifier for exact matches regardless of name but that

Re: Backup files - restoring backup

2017-03-14 Thread Kirk Brooks via 4D_Tech
Pat, I also see this happen when I'm developing and the log file or the datafile gets replaced. Before everyone starts thinking I'm being incredibly sloppy it happens when I pull a copy of the datafile off the server to open on my developer machine. If I forget to trash the existing log file

Re: Users & Groups (What is "proper access privileges"?)

2017-03-14 Thread Kirk Brooks via 4D_Tech
Hi Jeremy, A little over a year ago I transitioned one of my primary project from my 'roll my own' user system to using the 4D system. Primarily I wanted to get out of the password security business as well as take advantage of some of the native 4D security features. All of that gave me reason to

Re: Question about SET and GET WEB OPTIONS

2017-03-06 Thread Kirk Brooks via 4D_Tech
John, On Mon, Mar 6, 2017 at 7:31 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com > wrote: > > And on a related note - if I set the session timeout to something long, > say > > 3 days, and the process timeout to something like an hour (so I don't > have > > a bunch of idle web processes hanging

Question about SET and GET WEB OPTIONS

2017-03-05 Thread Kirk Brooks via 4D_Tech
I've been working with the web server in v15.4 and playing with WEB SET OPTION and WEB GET OPTION. I wrote a method to retrieve a list of settings from the server. The method executes on the server and stores the options in a c-obj. I changed some things on the server and the changes were

Re: Question about SET and GET WEB OPTIONS

2017-03-05 Thread Kirk Brooks via 4D_Tech
OK, I think I have a better handle on this now. Someone please correct me if I'm wrong. If you read the docs carefully you notice it says: The WEB SET OPTION command modifies the current value of various options concerning the functioning of the 4D Web server. link

Has anyone done anything with DocuSign?

2017-04-03 Thread Kirk Brooks via 4D_Tech
I'm interested to hear how easy/tricky it is interfacing with them. -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* **

Re: [offish]WIndows 10 - phone home info

2017-04-07 Thread Kirk Brooks via 4D_Tech
I'll add my voice to Little Snitch. I've been using it for the last three years or so and can't imagine going without it on my personal system. It's robust but easy to configure and gets regularly updated. On Fri, Apr 7, 2017 at 12:28 PM, Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: >

Re: Google Address Lookup/ Autocomplete

2017-04-05 Thread Kirk Brooks via 4D_Tech
Sujit, A couple of things about addresses to be aware of when using google. First is google doesn't validate an address. Think navigation. If my primary interest is getting TO a place I'm not worried about delivering the mail or whether the address is correct. I only care about figuring out where

Re: 4D Compiler

2017-04-06 Thread Kirk Brooks via 4D_Tech
Tim, That's probably an inflation-adjusted number. Which makes the first 128k Mac I bought in April of '84 the equivalent of about $6,700 now. Still not the most expensive computer I've personally bought - that was a Mac II with an 80mb drive and I don't remember how much RAM. 4MB of RAM back then

Re: 4D Server Crashes When Tracing Buggy Web Connection Code

2017-04-07 Thread Kirk Brooks via 4D_Tech
Sannyasin, Two things: I make it a habit to check for -1 anywhere I'm using Find in array... it just bites me if I don't. For methods that run on the server, or even better for processes that run on the server, wrap them in an On err call method that lets you manage the errors yourself. Like not

Re: 4D Compiler

2017-04-07 Thread Kirk Brooks via 4D_Tech
Nigel, I went through a similar process several years ago when I changed the compile settings on a rather extensive database to 'all variables are typed.' I forget the number but it was a lot. Daunting. I forget how much time I spent on it but it turned out to be much less than I thought it

Re: Unexpected External Call Back...

2017-04-08 Thread Kirk Brooks via 4D_Tech
Robert, I agree with Miyako - it's the execute on server attribute. The problem is IP vars are specific to the machine so you really don't want to use them in EOS methods unless you know what you're doing. (by that I mean you intentionally want to use the contents of the IP var on the server - not

v15.2 clients logging into v15.4 server

2017-04-17 Thread Kirk Brooks via 4D_Tech
Hi folks, I am suddenly having all sorts of problems with a v15.4 server (windows, 64 bit). The server has been upgraded to v15.4 for a few weeks and suddenly I'm getting all sorts of random errors, data corruption and such. I haven't been able to pinpoint the exact cause yet but I notice there

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

2017-04-18 Thread Kirk Brooks via 4D_Tech
To close this out I'm going to finger server 15.4 as the problem here. Looking back at my notes I see I didn't put in the upgrade previously but did it this weekend. I updated my development machine to 15.4 a while ago but not this server. When I rolled back to v15.3 everything went back to

Re: Recommendations?

2017-07-31 Thread Kirk Brooks via 4D_Tech
) 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 > > > >>

Re: "Inspect Element" in 4D web area

2017-07-28 Thread Kirk Brooks via 4D_Tech
Jeff, Web area set preference is what you want - http://doc.4d.com/4Dv16R4/4D/16-R4/WA-SET-PREFERENCE.301-3317027.en.html On Fri, Jul 28, 2017 at 8:12 AM, Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Is there a way to turn off the "Inspect Element" contextual menu item in a > 4D

Re: Restricting a query

2017-07-31 Thread Kirk Brooks via 4D_Tech
Jarosz, For that you'll want to build your own query editor. To achieve that sort of separation of data you'll need to be careful that all queries and selections created by relations are segregated by client. On Mon, Jul 31, 2017 at 11:34 AM, jarosz via 4D_Tech <4d_tech@lists.4d.com> wrote: > I

Re: Is there a way to put a separator line in a macro list?

2017-08-02 Thread Kirk Brooks via 4D_Tech
On Wed, Aug 2, 2017 at 3:02 PM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Just learned by example about how cool it is to call a custom method from a > macro. So cool. > > Anyway, now that I've got religion about macros, I'd also like to get > organized. With that in mind, I'd

Re: Is there a way to put a separator line in a macro list?

2017-08-02 Thread Kirk Brooks via 4D_Tech
I've never tested it but has never failed to reload for me - or throw an error. On Wed, Aug 2, 2017 at 3:04 PM, David Adams via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On more macro question, it seems that the file reloads after editing as > soon as you switch back to 4D. Is this a reliable

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

2017-08-16 Thread Kirk Brooks via 4D_Tech
works for me with V16R3 on my MacBook Pro on macOS Sierra. > > > > > Le 11 août 2017 à 00:34, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com > > > > a écrit : > > > > > > In prior versions when working with a form and the Property List is >

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

2017-08-14 Thread Kirk Brooks via 4D_Tech
- or now. > > > On Aug 14, 2017, at 3:06 PM, Jeffrey Kain via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Never knew about this shortcut... > > > > -- > > Jeffrey Kain > > jeffrey.k...@gmail.com > > > > On Aug 14

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

2017-08-14 Thread Kirk Brooks via 4D_Tech
Um - does this mean no one else is seeing this behavior? Any thoughts about why it is happening on my machines? On Thu, Aug 10, 2017 at 3:34 PM, Kirk Brooks wrote: > In prior versions when working with a form and the Property List is > displayed I could show/hide all

SEND / RECEIVE RECORD questions

2017-08-10 Thread Kirk Brooks via 4D_Tech
Hi folks, I have never really used SEND RECORD and RECEIVE RECORD. I get the theory of it and the docs explain the mechanism. I'm wondering what happens when you attempt to use them and the structures have changed? Or tables or fields were re-named? And what about changes across 4D versions? Like

Re: SEND / RECEIVE RECORD questions

2017-08-10 Thread Kirk Brooks via 4D_Tech
, > it looks at the header and converts ANSI to Unicode text as necessary. > > > 2017/08/11 5:51、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール: > > And what about changes across 4D versions? Like attempting to RECEIVE > > RECORD i

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

2017-08-10 Thread Kirk Brooks via 4D_Tech
In prior versions when working with a form and the Property List is displayed I could show/hide all panes on the list by holding the Control (not the Command) key and clicking on one of the pane triangles. This doesn't work for me in v16. I've tried on two different Macs, one running Sierra and

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

2017-08-14 Thread Kirk Brooks via 4D_Tech
Randy, You could have a background process on 4D server that periodically pings the web server. Or makes an http call to it. I use a service to monitor server status that relies on this approach. This will also raise a flag if the server is un-available for some reason even if it is running. ​But

Re: ​Someone help me out, how do you get good information out of 4D

2017-07-11 Thread Kirk Brooks via 4D_Tech
David, Interesting initial post - like marmalade on a flakey croissant, a little sweet and a little bitter. I've hammered a similar nail before: what is 4D's vision of itself? What is the target market? Why does such a fabulous product remain so unknown? Why isn't there better documentation? Let's

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

2017-07-17 Thread Kirk Brooks via 4D_Tech
Hi John, I haven't done very much communicating from 4D to a SQL database so this is a very naive question - but could you talk about how a tool like Navicat helps you with 4D? On Mon, Jul 17, 2017 at 8:39 AM, John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I bought Navicat 11 a few

Any issues with running v13.6 server and 13.5 clients?

2017-07-07 Thread Kirk Brooks via 4D_Tech
Just wondering. Thanks -- Kirk Brooks San Francisco, CA === *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ** 4D Internet Users Group (4D iNUG) FAQ:

What exactly is the scope of the On err call between 4D server & Client?

2017-07-07 Thread Kirk Brooks via 4D_Tech
I think I know the answer to this but think I'll ask anyway. When my server starts up in installs an error handler, ON ERR CALL("err_log_only"). As the name implies it simply logs errors and keeps churning. It doesn't seem to be called when a method called by Execute on server is running. At

Re: What exactly is the scope of the On err call between 4D server & Client?

2017-07-07 Thread Kirk Brooks via 4D_Tech
David, I was hoping you might weigh in here. Yeah, so I'm talking about a method with the Execute on server attribute (or property - whatever) checked. So the situation is a client process is churning away and passes some arrays off to the EOS method for processing on the server (looking things

Re: What exactly is the scope of the On err call between 4D server & Client?

2017-07-07 Thread Kirk Brooks via 4D_Tech
Jody, Right, but what I'm seeing is a client side process which has an error handler installed. Running a method with EOS an error is blocking the server with the 4D native error handler. Even though the server has an error handler installed. This is following the what's in the docs: "ON ERR

Re: What exactly is the scope of the On err call between 4D server & Client?

2017-07-07 Thread Kirk Brooks via 4D_Tech
Hi Ben, On Fri, Jul 7, 2017 at 5:15 PM, Ben Kershaw via 4D_Tech < 4d_tech@lists.4d.com> wrote: > When a method with this property checked is executed, it runs in the > context of the servers “twin” process (which isn’t really a twin, since it > doesn’t really share anything with the client

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

2017-07-14 Thread Kirk Brooks via 4D_Tech
Julio, I don't think 'variable structure' is necessarily the defining element. It's certainly good for that but now that we can search on these fields they're also good for situations where you want to allow each record to have some large number of fields most of which won't ever be used but need

Re: Collections in v16R4

2017-07-19 Thread Kirk Brooks via 4D_Tech
Yea! Does SDI provide the same flexibility we have on Macs when working with multiple monitors? It's a real pain getting multiple monitors configured to "see" the MDI on more than one at a time. On Wed, Jul 19, 2017 at 2:03 AM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > you can

  1   2   3   4   5   6   >