Re: Microsoft Azure & 4D

2019-07-22 Thread Kirk Brooks via 4D_Tech
Paul, Are using CLI on the server or client machines? On Mon, Jul 22, 2019 at 1:12 AM Paul Dennis via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I use the AWSCLI tools to sync and move my locally generated pdf's to S3 > using launch external process. When pdf's are generated I call AWSCLI and > it

Re: Microsoft Azure & 4D

2019-07-19 Thread Kirk Brooks via 4D_Tech
John, I have been using Bruno's AWS component for a few years myself. I'm going to be moving away from using the component soon. Not because of a problem with it but because I'm changing the way files are put into AWS. I'm looking at a service for managing file transfers called Transloadit

Re: Stuffing a shared object

2019-07-15 Thread Kirk Brooks via 4D_Tech
n which both works and is enormously more elegant. > > Jeremy > > > On 15 Jul 2019, at 17:05, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Jeremy, > > It's easy to keep trying to do everything the same way we have for years. > > That

Re: Stuffing a shared object

2019-07-15 Thread Kirk Brooks via 4D_Tech
hat CALL WORKER is for, > isn’t it? > > Jeremy > > > On 15 Jul 2019, at 16:44, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Jeremy, > > I don't think this would be a good situation for using Shared objects. > > Every object in a shared ob

Re: Stuffing a shared object

2019-07-15 Thread Kirk Brooks via 4D_Tech
Jeremy, I don't think this would be a good situation for using Shared objects. Every object in a shared object must itself be shared. There's a lot of overhead involved in maintaining the various lockers and such. I would look at using CALL WORKER. Bundle up everything into an object and pack it

Re: Stylesheet Search?

2019-07-13 Thread Kirk Brooks via 4D_Tech
Tim, At the moment style sheets only go away in Projects. I've been working with Projects and quite a bit with dynamic forms. You can implement an equivalent of style sheets pretty easily when you're working with the form JSON directly. In fact you have far better style capabilities. A style sheet

Re: Splitter behaviour

2019-07-12 Thread Kirk Brooks via 4D_Tech
Hi Pat, Try adding a vertical splitter on the left and right of the area with the horizontal splitter set to grow vertically. I have almost always see problems with a splitter placed as you described. Using other splitters to define the area seems to help. On Fri, Jul 12, 2019 at 7:35 AM Pat

Re: Listbox Subform Modern UI

2019-06-27 Thread Kirk Brooks via 4D_Tech
this database will continue to use the old > subform approach in these Admin only areas… but I’m still curious how you > might choose to implement this with Listboxes. > > Thanks, > > Robert > > > On Jun 27, 2019, at 4:59 PM, Kirk Brooks via 4D_Tech < > 4d_

Re: Listbox Subform Modern UI

2019-06-27 Thread Kirk Brooks via 4D_Tech
What version are you using? On Thu, Jun 27, 2019 at 1:55 PM Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Although, I’ve implemented this in various ways, I’d like to know the > modern UI approach that you’ve found to be beneficial to your users and > with an efficient programming

Re: Complex graph

2019-06-26 Thread Kirk Brooks via 4D_Tech
Ferdinando, For truly complex graphing you can't beat D3 . On the other hand for the sort of in-line graphs you referenced I heard a great hack from David Adams: Unicode U+2588 is a small, black, borderless square. So you create single line histograms in a text var using this

Re: Managing multiple windows in the same process (v17r5)

2019-06-26 Thread Kirk Brooks via 4D_Tech
Hi Chris, Good questions. Here are my thoughts on them based on what I've picked up from the World Tour and Summits. On Wed, Jun 26, 2019 at 12:31 AM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > 1) What is the reasonable limit as to how many windows/dialogs should get > opened in

Re: Dialog (;*) question

2019-06-25 Thread Kirk Brooks via 4D_Tech
Hi Peter, When you call DIALOG(*) the dialog opens in the current process. But as you saw execution continues on. The solution is to make a DIALOG call by itself first and open the subsequent windows from there. The suggestions I've heard are to think about having a single UI process. This

Re: Select document command and .4lbp files

2019-06-24 Thread Kirk Brooks via 4D_Tech
Jeff, Sorry, I didn't read your original email closely enough. I just updated the code I posted to: $DocType:="com.adobe.pdf;com.4d.4d.labelFile;.jpeg;.txt;.text;.csv;.json" I was able to select both a PDF and a label file I just created. Perhaps there is some sort of permission block? Or, how

Re: Select document command and .4lbp files

2019-06-24 Thread Kirk Brooks via 4D_Tech
Jeff, I have only had luck using Select document when the file types are separate by semi colons. Here's an example from working code: *C_TEXT*($doc;$DocType) *ARRAY TEXT*($aDocs;0) $DocType:=".pdf;.jpg;.jpeg;.txt;.text;.csv;.json" $Doc:=*Select document*(*System

Re: Developing Using Selector Methods

2019-06-20 Thread Kirk Brooks via 4D_Tech
Hi Narinder, I have some thoughts. To start, with v17 the whole concept of what a form is in 4D is fundamentally different. I'm talking about building new forms, here, not tweaking existing ones. One important change is ditching process variables as form elements. Just stop. Buttons, fields,

Re: Arrays in objects

2019-06-10 Thread Kirk Brooks via 4D_Tech
e issues if you use them as object property names. Hope this helps > > Jeremy > > > On 10 Jun 2019, at 19:47, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Jeremy, > > Depends on which version you are using. If you are in v17 then 'arrays

Re: Arrays in objects

2019-06-10 Thread Kirk Brooks via 4D_Tech
Jeremy, Depends on which version you are using. If you are in v17 then 'arrays in objects' are essentially gone. They are collections now and you can use dot notation with collections. Otherwise, yes 'arrays' are still arrays within the object. It's possible to mix the nomenclatures in v17. You

Re: Open a v17 data file when Structure is unknown

2019-06-08 Thread Kirk Brooks via 4D_Tech
pplication, > meaning no application/data no business. > It is possible to go to the user environment and export all that stuff > manually. > But this is not my problem any more at least for a long time I hope. > > > > On 9 Jun 2019, at 01:36 AEST, Kirk Brooks via 4D_Tech < >

Re: Open a v17 data file when Structure is unknown

2019-06-08 Thread Kirk Brooks via 4D_Tech
Jorg, Well, one man's 'data rescue' is another man's 'data breach'. Frankly it sounds a little hinky that a client would have a lone datafile and no clue about where the structure file is or who created it. But I have run bars and restaurants in my past and am suspicious of stories like that. In

Re: Open a v17 data file when Structure is unknown

2019-06-08 Thread Kirk Brooks via 4D_Tech
Jorg, As I recall the WEDD was a simple string supplied by the developer. I never looked into how, or if, 4D used that string to create anything more complex like a hash. On Sat, Jun 8, 2019 at 12:37 AM Jörg Knebel via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Since this project turned into a

Re: v15 to v17 Conversion of Obsolete _o_C_STRING/_o_ARRAY STRING Commands

2019-06-07 Thread Kirk Brooks via 4D_Tech
Hi Narender, Welcome back. Changing the variable declarations is a simple regex exercise. In fact I think 4DPOP may have a command in it already for doing so. If not it's not too difficult to write a method to loop through all the code, find the old strings and replace them. I don't have any

Tips on reading email from gmail?

2019-06-04 Thread Kirk Brooks via 4D_Tech
Hi folks, I know I've seen this subject passing by but can't seem to find it when I need it. So, is anyone willing to share some tips about reading email in a gmail account? Specifically I want to use IMAP. Thanks -- Kirk Brooks San Francisco, CA === What can be said, can

Re: Anyone using zipcodeapi

2019-06-01 Thread Kirk Brooks via 4D_Tech
John, I've been using SmartyStreets for several years. It's very easy to connect with and the folks who run it are extremely helpful and friendly. I looked at the website for zicodeapi.com and notice the service is less expensive and offers a number of APIs for working with zip codes. It's a

Re: I've not seen this before

2019-05-29 Thread Kirk Brooks via 4D_Tech
Bob, A project I'm working on has recently found that there can be issues editing files, especially large files, directly on the server. Microsoft and Adobe in particular but it seems true of any complex or large file. The best practice, specifically mentioned by Adobe for one, is to copy the file

Re: creating a plain text document from within 4D

2019-05-27 Thread Kirk Brooks via 4D_Tech
Hi ernie, Reading this it seems like you are trying to do two different things at the same time. The snippet you pasted looks like Styled Text. But you say you want a "plain text" document. But you also say you want to text to look the same way it does on the screen. You can't have it both ways,

Re: Injecting Forms from a component

2019-05-23 Thread Kirk Brooks via 4D_Tech
John, On Thu, May 23, 2019 at 10:28 AM John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > Can you inject a form from a component into a host system? > > if so - how? > > Not possible as far as I know. In theory it will be possible with version > 18. With version 17 you can use dynamic

Re: Benefits of 64-bit 4D Remote

2019-05-23 Thread Kirk Brooks via 4D_Tech
Tom, I think this is a germane and timely question. It correlates with the 'if it isn't broke don't fix it' rule of thumb and is particularly relevant to the 4D community because of the longevity of many of our projects. In your case you have probably done all you can. There doesn't appear to be

Re: Webarea Embedded rendering engine show blank pages in 64-bit

2019-05-08 Thread Kirk Brooks via 4D_Tech
Piotr, I also generate the webarea content on the fly and never found generating the temp html files an issue speed wise. The processing is exactly the same leaving on the time to write the file to disk. I added a routine to startup to clear out the temp folder. It also gets cleared whenever you

Re: Webarea Embedded rendering engine show blank pages in 64-bit

2019-05-08 Thread Kirk Brooks via 4D_Tech
Piotr, I use web areas quite a lot. WA SET PAGE CONTENT is tricky to make work if it's not initialized and generally not on the first page. I create pages on disk instead in a WA folder I setup in Resources. This also gives me a place to store Assets (CSS, JS, etc.) I use in the pages. Writing the

Re: Custom Form Events

2019-05-06 Thread Kirk Brooks via 4D_Tech
Hi Chris, I apologize for such a late response. I left on a road trip about the time you sent this and frankly forgot to get back to you. Your enthusiasm is infectious. And you describe some excellent applications. I haven't played with OBJECT SET LIST BY REFERENCE yet... Thank you for the tips.

Re: 4D V15 crash

2019-05-04 Thread Kirk Brooks via 4D_Tech
Bob, Tech support 101: Is it plugged in? When was the last time you restated it? It's easy to forget why that has become cliched. I may well be using that myself today, as I think about it... On Sat, May 4, 2019 at 9:59 AM Robert McKeever via 4D_Tech < 4d_tech@lists.4d.com> wrote: > And, the

Re: Data Merge from v13 to v15

2019-05-01 Thread Kirk Brooks via 4D_Tech
Ronnie, I was just reading through the thread here. I did a similar migration when I moved a database from v2004 to v13. In that case the v13 database was a major re-write of the original. There were significant differences in the new structure including removing a couple of subtables. And there

Re: Form and DIALOG

2019-04-29 Thread Kirk Brooks via 4D_Tech
Jeremy, In the situation you describe I initialize the object that will be passed to the Dialog first. Like so: $formObj:= New object("listbox_1";New Collection(100;200;300);"someObject";New Object("foo";"Hello world") DIALOG("MyDialogForm";$formObj) // Dialog is closed and $formObj contains

How to use collection.query for specific element of embedded collection

2019-04-26 Thread Kirk Brooks via 4D_Tech
Imagine a collection or entity selection populated with objects like: { id: "some string", fields: [ {i:0, name:value1}, {i:1, name:value2}, {i:2, name:value3}, ... ] } I want to find collection elements by searching for 'fields[1].name' = someValue. That is, only matches on the second

Re: Custom Form Events

2019-04-25 Thread Kirk Brooks via 4D_Tech
Chris, Thanks for the insight. It sounds like you are working with classic 4D code (even if you're using v17). Let me encourage you to think about re-writing your form using v17. I think most of the issues requiring elaborate workarounds won't be necessary. Positioning objects on the form. You

Re: -1 undefined database event

2019-04-24 Thread Kirk Brooks via 4D_Tech
David, On Wed, Apr 24, 2019 at 2:23 PM David Ringsmuth via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The message says the record is locked, but 4D’s Locked($pTable->) returns > false, and so does 4D’s Read only state($pTable->). > > Under what circumstances would this happen? > If you are using

Re: Custom Form Events

2019-04-23 Thread Kirk Brooks via 4D_Tech
Chris, Reading through your post and the replies I'm trying to think of what a 'custom event' would be. Can you give an example or two? On Tue, Apr 23, 2019 at 7:33 AM Chris Belanger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am wondering if there is a way to configure Custom Form Events. I

Salesforce anyone?

2019-04-18 Thread Kirk Brooks via 4D_Tech
I would like to talk with anyone who had done any work with Salesforce. Specifically I'd like to hear about integrating with 4D. Please ping me offline to talk. Thanks! -- Kirk Brooks San Francisco, CA === What can be said, can be said clearly, and what you can’t say, you

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Kirk Brooks via 4D_Tech
Bingo. On Tue, Apr 16, 2019 at 11:53 AM Keith Culotta via 4D_Tech < 4d_tech@lists.4d.com> wrote: > It's looking like it can all be done with entity selections, and be more > efficient. > -- Kirk Brooks San Francisco, CA === What can be said, can be said clearly, and what

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Kirk Brooks via 4D_Tech
Keith, You know you can go about this from another point of view. I actually posted about this a bit ago. This won't accomplish exactly what you are asking for but it may be something you can use. First, remember that even when you have a very large collection or entity selection, as you seem to,

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Kirk Brooks via 4D_Tech
All, I just started a Feature Request for this: http://forums.4d.com/Post//29409213/1/ Take a look and see what you think. Collection/entity based listboxes are a very different animal from array or selection based ones. And the way to work with them is different too. Frankly the easiest thing

Re: From where is my form method called?

2019-04-15 Thread Kirk Brooks via 4D_Tech
Sandor, You can open the form in the editor. At the top of the property list is a popup menu. It lists all the objects on the current page of the form. You can choose the object name from the popup and it will be selected. If there are a lot of pages you will have to go through them one at a time.

Re: Type Ahead in Array Listbox Cell

2019-04-11 Thread Kirk Brooks via 4D_Tech
Doug, I believe you want to use the On after keystroke form event on the listbox (or the column) and the Get edited text function. Get edited text returns the text that's being edited before it's saved to the object it's edited in. On Thu, Apr 11, 2019 at 8:35 AM Doug Cottrill via 4D_Tech <

Re: I really recommend the 4D World Tour

2019-04-10 Thread Kirk Brooks via 4D_Tech
event. > Pat > > On Wed, 10 Apr 2019 at 15:00, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: > > > Heading home from the WT in Atlanta. For me this was the best WT so far > and > > I've been to them all. I think anyone using 4D benefits from attending. &

Re: I really recommend the 4D World Tour

2019-04-10 Thread Kirk Brooks via 4D_Tech
troduction, and my expectation is that the WT > this year will be some serious work to be thought through. Plan on coming > rested this time. > > Thanks again > > Jody > > > On Apr 10, 2019, at 8:00 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrot

I really recommend the 4D World Tour

2019-04-10 Thread Kirk Brooks via 4D_Tech
Heading home from the WT in Atlanta. For me this was the best WT so far and I've been to them all. I think anyone using 4D benefits from attending. The first day is free. In previous WTs day one was more of a sales pitch and feature overview. Not so this time. There are 17 demo databases in day

Re: MAXIMUM NUMBER REACHED

2019-04-10 Thread Kirk Brooks via 4D_Tech
Ferdinando, How do you know it's the 8th connection? If you log into the server and observe the console window you can verify: 1) how many licenses (seats) you have available 2) how many are currently logged in I would check that you have all your expansion licenses installed. 7 users is the 2

Re: ORDA and 4D selections

2019-04-09 Thread Kirk Brooks via 4D_Tech
Chuck, There is no reason to use ORDA if you need a regular selection. Just use the classic 4D query commands. On Tue, Apr 9, 2019 at 2:27 PM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi all, > > is there any way to perform a query using ORDA and create a current > selection or

Re: Hierarchical Listbox Row with leading Icon (like hierarchical list)

2019-04-09 Thread Kirk Brooks via 4D_Tech
Hey John, If you can make it to the World Tour JPR has a v17 listbox demo that does this. On Mon, Apr 8, 2019 at 8:55 PM John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > I’m trying to duplicate the look and feel (in as much as it’s possible) of > a hierarchical list but

[TIP] Moving elements of a collection

2019-04-03 Thread Kirk Brooks via 4D_Tech
Collections are not arrays. So is I have a collection based listbox and want to have a control to allow the user to move a selected element within the collection how do I do that? One way would be to allow her to drag and drop the element to the new position. The other way is a spinner of some

Re: Securing sensitive data in a 4D data file (Chip Scheide)

2019-03-31 Thread Kirk Brooks via 4D_Tech
I've taken the approach of creating a separate table for storing secure data. Each record has a blob to hold the data. The idea is the sensitive data is encrypted into a blob and the blob is saved in one of these records. The record the data belongs to records the secure record id. When the data

Re: Printing Structure Diagram

2019-03-30 Thread Kirk Brooks via 4D_Tech
Hi Kirk, Check this out https://github.com/miyako/4d-utility-structure-to-svg-converter On Sat, Mar 30, 2019 at 1:06 PM rooftop99--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > Thank you Chip, > > I am aware of the xml and html exports. I have used the xml export for > several purposes. My

Re: Encrypt Blob issue

2019-03-28 Thread Kirk Brooks via 4D_Tech
Chip, Try encrypting the blob before writing it to the field. I have always applied encrypting and compressing to a blob variable and then written the variable to/from the field without issues. On Thu, Mar 28, 2019 at 8:20 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > When I

Re: Dropbox Upload and Dropbox Download Methods

2019-03-08 Thread Kirk Brooks via 4D_Tech
Tim, Thanks for sharing this. On Fri, Mar 8, 2019 at 3:55 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > A few weeks ago I posted a message asking if anyone had written code to > upload and download files to Dropbox. Got no responses other than “the API > looks like it is easy to do”.

Re: v17 web area

2019-03-05 Thread Kirk Brooks via 4D_Tech
David, I downloaded the tech note and see the same thing. Looking under the hood a little bit I'm thinking the issue is with the fairly old versions of Leaflet, jQuery and some other libraries it uses. At this point they are all 5 or 6 years old (based on the file headers) which is pretty long in

Re: "Attempting to retype using a pointer"

2019-02-28 Thread Kirk Brooks via 4D_Tech
I just noticed something when I stepped through one of my examples - in this case: $to:=New object $from:=New object $i:=100 $from.ptr:=->$i $to.ptr:=->$k $to.ptr->:=$from.ptr-> // $k = 100 at this line The value of $k changed as soon as this line runs. I also wondered what would happen if I

Re: "Attempting to retype using a pointer"

2019-02-28 Thread Kirk Brooks via 4D_Tech
Jeremy, On Wed, Feb 27, 2019 at 11:53 PM Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Objects pre-date ORDA, as you know. True. In this case what we are really talking about is 4D's object notation. I tend to use 'ORDA' for all the new capabilities and should be more specific.

Re: "Attempting to retype using a pointer"

2019-02-26 Thread Kirk Brooks via 4D_Tech
n’t understand the actual error message, since > I’m not doing what it’s accusing me of doing. > > Jeremy > > > > > On 25 Feb 2019, at 16:47, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Jeremy, > > Since you are writing the data to an

Re: "Attempting to retype using a pointer"

2019-02-25 Thread Kirk Brooks via 4D_Tech
Jeremy, Since you are writing the data to an object what's the value of using the pointer? Why not just write the data? In fact, since TCMGetRow looks like it is simply holding the data for the transfer you could make it a loop: For($i;1;number of objects) $o["_"+string($i)]:=Object get

Re: Object notation bug?

2019-02-21 Thread Kirk Brooks via 4D_Tech
Drew, On Thu, Feb 21, 2019 at 10:27 AM Drew Waddell via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am unable to do $oChildObject:=null in my actual situation because I am > passing that object into a Dialog You run into this when passing the object to a new form using DIALOG. I use two

Re: interesting find

2019-02-20 Thread Kirk Brooks via 4D_Tech
I have noticed the compiler in v17 is significantly better at flagging little errors like that. And a lot of others. There were some wonky things in a database I converted which is in active use, compiled, all vars typed. I thought v17 must have corrupted the code somehow because I just didn't

Easy dynamic field highlighting

2019-02-16 Thread Kirk Brooks via 4D_Tech
Hi folks, Here is a link to a few methods you may find useful. https://github.com/KirkBrooks/Form-object-hilite Sometimes the focus rectangle is just not the look I want on a form. What I demo here are a couple of techniques for adding dynamic field highlighting on the fly. Both of them are a

Re: V17 R - Mojave compatibility

2019-02-15 Thread Kirk Brooks via 4D_Tech
Mitch, I've been using 17R3 and recently R4 with Mojave with no issues. I'm not doing production or using any fancy plugins with it but for general development it's been fine. On Fri, Feb 15, 2019 at 10:58 AM Mitchell Shiller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi, > > I know that 17.1

Re: v17 conundrum in design

2019-02-10 Thread Kirk Brooks via 4D_Tech
I worked on a project that did this too. In that case it turned out to be an error in some old ALP code. Something subtle like a mistyped variable. You may have a component or plugin that's generating the error silently. On Thu, Feb 7, 2019 at 12:52 PM Chuck Miller via 4D_Tech <

Re: Set Time question

2019-02-10 Thread Kirk Brooks via 4D_Tech
Just to add a little more to this. I suspect a number of readers already realized a really simple solution to this specific case is to simply test the read/write state in the On timer form event and NOT update if it's read write. This turns out to be a better solution in my case because it's a

Re: Set Time question

2019-02-08 Thread Kirk Brooks via 4D_Tech
sts.4d.com> wrote: > > > Le 8 févr. 2019 à 17:48, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > > > [...] Is there a way to trap use actions like that so I can block the > > On timer code from running? > > Each new SET TIMER "kill

Set Time question

2019-02-08 Thread Kirk Brooks via 4D_Tech
Hi List, I have never used Set timer very much so I've got a noobie question. I'm adding some real-time updating code to financial forms: think Invoices, Billing Account summaries. that sort of thing. An invoice is the most obvious - User A has a form open that displays the invoice details (total

Re: How to display read-only input form

2019-02-06 Thread Kirk Brooks via 4D_Tech
Jim, If the table is in read only mode you can use any form you want and the user can't edit the data. I'd just put the table in read only and use DIALOG with the input form. On Wed, Feb 6, 2019 at 1:32 PM Jim Crate via 4D_Tech <4d_tech@lists.4d.com> wrote: > Is there a convenient way to mimic

Re: Three-dimensional arrays?

2019-02-04 Thread Kirk Brooks via 4D_Tech
entive to do so. > > Pat > > On Mon, 4 Feb 2019 at 15:35, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com > > > wrote: > > > Pat, > > This would be a lot easier to do with collections instead of arrays. > > > > Each 'sheet' can be represented by a collection

Re: Three-dimensional arrays?

2019-02-04 Thread Kirk Brooks via 4D_Tech
Pat, This would be a lot easier to do with collections instead of arrays. Each 'sheet' can be represented by a collection. The 'workbook' is itself another collection with each 'sheet' pushed onto it. You will put some graphic element on the form to manage choosing the sheet you want but then

Re: call subform

2019-01-30 Thread Kirk Brooks via 4D_Tech
Chuck, If AddButton is on the subform you don't need CALL SUBFORM CONTAINER at all. Just handle it there in your subform code: OBJECT SET VISIBLE(*;"AddButton";Not(Read only state([table]))) I would put that in the form method code (i'm talking about the actual form you use as the subform) so

Re: call subform

2019-01-29 Thread Kirk Brooks via 4D_Tech
Hi Chuck, On Tue, Jan 29, 2019 at 5:11 PM Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have created a subform with an add button on it. In the form method I > call subform (-999) > What kind of subform? input or output What is the button adding? And is it doing so with an

Re: listbox commands and collection variables

2019-01-23 Thread Kirk Brooks via 4D_Tech
John, On Wed, Jan 23, 2019 at 6:31 PM John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > $1 is a pointer to the collection listbox variable and the debugger shows > it has 10 elements. The object name on the form is the same as the variable > name. If I execute it with the name, $hdrVars has

Re: listbox commands and collection variables

2019-01-23 Thread Kirk Brooks via 4D_Tech
Hey John, I'm not able to replicate all of the issues you mention with a collection based listbox. To test I made a form and added a collection based listbox with two columns. To open it I made a method, created a collection with 10 elements comprised of objects and had the listbox displace the

Re: Postal Addresses by City

2019-01-16 Thread Kirk Brooks via 4D_Tech
Walt, Are looking for the actual addresses? There are companies that sell those sort of lists. I haven't looked in years... This one is top of the list: https://www.infousa.com/lists/zip-code-mailing-lists/ Or do they have addresses and want to verify them? For that I have been using Smarty

Re: Socket Communication

2019-01-15 Thread Kirk Brooks via 4D_Tech
That looks pretty cool. I've built a chat app on PubNub a while ago. ( www.pubnub.com) I haven't looked back at PubNub recently - Pusher looks like they may have built out a few more tools. In both cases they have very generous free programs. On Tue, Jan 15, 2019 at 1:57 PM Welsh Harris via

Re: 4D Write Pro license question

2019-01-14 Thread Kirk Brooks via 4D_Tech
On Mon, Jan 14, 2019 at 10:55 AM Guy Algot via 4D_Tech <4d_tech@lists.4d.com> wrote: > I was using groups and BLOB TO USERS and although groups would be > restored, any changes to groups would not. So perhaps a bug in USERS TO > BLOB? > That's really not a good thing. -- Kirk Brooks San

Re: 4D Write Pro license question

2019-01-13 Thread Kirk Brooks via 4D_Tech
ser licences and everybody needs access to WP and you > also have stored procedures running that require a licence, I reckon you > will need 5 WP licences. > > Pat > > On Sun, 13 Jan 2019 at 18:10, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: > >

Re: 4D Write Pro license question

2019-01-13 Thread Kirk Brooks via 4D_Tech
te plugin, the 4D Write PRO code will work in the > stored > > method. > > > > It will temporarily use up 1 of the licenses available, but only for a > > short time. > > > > As such, you do not really need to ‘reserve’ a license. > > > > > > Reg

4D Write Pro license question

2019-01-12 Thread Kirk Brooks via 4D_Tech
Does 4D Server require a 4D Write Pro license for non-UI methods? Let's say I have a database with 10 4D Write Pro licenses. I may have more than 10 users and understand how to check and manage licenses available for users. My question is if I have to 'reserve' a license for the server to be

MSC: why "Checking list of deleted records ..." persists?

2019-01-12 Thread Kirk Brooks via 4D_Tech
A few months ago a bug resulted in a large number of records being created in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus records were deleted. Since then the data file has been verified and compacted at least once. Just now I was running a verify on the data file

[TIP] Hiding rows of a collection based listbox (you can't and that's OK)

2019-01-10 Thread Kirk Brooks via 4D_Tech
In prior versions of 4D one of my favorite uses of array based listboxes is for displaying lists of things and including a variable the user could type into to filter the list as they typed. The technique involved two things: the listbox had a 'hidden' array specified the code for the search

Re: ListBox - assign pulldown array ?? a la ALPro for Data Entry

2018-12-31 Thread Kirk Brooks via 4D_Tech
Randy, Here are a couple of methods that are handy working with almost any type of listbox pre collection based ones. First is my method for getting the column variable pointers. Greatly simplifies working with a listbox constructed of dynamic columns. You pass the name of the listbox and a

Re: Storing Dates and Times From Different Time Zones

2018-12-21 Thread Kirk Brooks via 4D_Tech
https://www.youtube.com/watch?v=jgF_ycCmF18 It just had to be said. On Thu, Dec 20, 2018 at 6:04 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > is this a competition? > -- Kirk Brooks San Francisco, CA === *We go vote - they go home*

Re: Where the f*** is the knowledge base hidden???

2018-12-19 Thread Kirk Brooks via 4D_Tech
Maybe you have a security setting that doesn't allow non https sites? Which also brings up the question of why it isn't https... On Wed, Dec 19, 2018 at 3:02 AM Jörg Knebel via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Everyone / Anyone, > > I tried to look something up but, the subject line

Re: v13+ - plugins

2018-12-18 Thread Kirk Brooks via 4D_Tech
http://livedoc.4d.com/4D-Language-Reference-17/4D-Environment/PLUGIN-LIST.301-3730399.en.html On Tue, Dec 18, 2018 at 7:26 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Is there a way to determine what plugins are currently installed? > > Thanks > Chip > > --- > Gas is

How can I identify a process with an active transaction from outside the process

2018-12-17 Thread Kirk Brooks via 4D_Tech
Here's the deal - I only want a user logged in once. So if I am logged in and walk into another room and attempt to login using a different computer I get a message informing me I'm already logged in and asking if I want to cancel that session. The mechanism for managing this involves registering

Re: Coding/Development Style Guide?

2018-12-16 Thread Kirk Brooks via 4D_Tech
I agree with Peter. Object names need to convey what their purpose is, at best, and be as unambiguous as possible at least. The size of the method has a lot to do with how ambiguous a name might be. I have no qualms about using $i as an index counter in a method where there is only one loop or

Re: 4D Structure Export...

2018-12-07 Thread Kirk Brooks via 4D_Tech
Tom, On Fri, Dec 7, 2018 at 10:14 AM Tom Benedict via 4D_Tech < 4d_tech@lists.4d.com> wrote: > if this feature does more than the export we’ve been able to do since > v12/14 via various versions of VC_Framework. Is this simply a higher level > of integration with the app or does it actually

[TIP]: Esoteric method for calculating Excel column references

2018-12-01 Thread Kirk Brooks via 4D_Tech
I had need to calculate column references for an Excel spreadsheet for columns greater than 26. You know, so you can come up with the reference like: A1:AG1. Fun stuff. Anyway, the scheme for this is deceptive. A -> Z is easy. But A # 0 or 1 strictly. It's tricky. I suspect this is one reason

Re: Mojave

2018-11-30 Thread Kirk Brooks via 4D_Tech
Canon, I haven't had any issues running v17 on Mojave. I'm not really doing anything with v16 anymore so can't speak to that. v15 is mostly OK except for issues with the web area. On Fri, Nov 30, 2018 at 6:18 AM Cannon Smith via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I don’t believe 4D has

Re: PDF - TEXT CONVERSION

2018-11-28 Thread Kirk Brooks via 4D_Tech
Ferdinando, Look in Miyako's github repos - he posted a plugin or component there some time ago that does this. https://github.com/miyako On Wed, Nov 28, 2018 at 10:12 AM stardata.info via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi all, > > In one 4D application, I need to convert one pdf

Re: [off-ish] Regex help

2018-11-28 Thread Kirk Brooks via 4D_Tech
Chip, I think what you want is to parse the path into its component parts. This this pattern for matching: ([ \w\d-_]+): This will match letters, numbers, spaces, underscores and dashes up to the semi colon. You will want to use it in a loop like so: $pattern:="([ \\w\\d-_]+):" $start:=1

Be willing to be a beginner with ORDA

2018-11-24 Thread Kirk Brooks via 4D_Tech
Miyako wrote this in another post recently: "Form" based design is a total rethink of how to use variables in forms. Form is an object, and an object is a reference, which drastically reduces the need for pointers. historically a pointer can only point to tables, fields, variables and arrays.

Re: Audit File Updates via Triggers...

2018-11-21 Thread Kirk Brooks via 4D_Tech
On Wed, Nov 21, 2018 at 12:35 PM Benedict, Tom via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If you live on an island where the only language is 4D, objects offer > some advantages. But if there's ever the chance that you'd like to > communicate with the outside world the lingua franca of rows

Re: Audit File Updates via Triggers...

2018-11-20 Thread Kirk Brooks via 4D_Tech
John, Sure you can - you make a method to extract the data you want. In selection based listboxes you can put the method in a column formula. It's definitely easier in v17 but I've been using this in v15 for a long time. On Tue, Nov 20, 2018 at 1:14 PM John DeSoi via 4D_Tech

Re: Audit File Updates via Triggers...

2018-11-20 Thread Kirk Brooks via 4D_Tech
Robert, My thoughts on the created by/modified by stuff: 1) I moved all this to a single object field. I call it '_meta' and it's on every table I want to manage. 2) At a minimum the field has: {"created"; {"name: "", "date": ""}, "modified"; {"name": "", "date": ""}} 3) I wrote a few (I

Re: dragging an object

2018-11-20 Thread Kirk Brooks via 4D_Tech
Peter, This works in two parts. 1) On begin dragover: You need to capture the mouse xy of the click and store it in the pasteboard. Something like: GET MOUSE($x;$y;$mods) SET TEXT TO PASTEBOARD(Json stringify(New object("x";$x;"y";$y))) 2) On drop: get the data in the pasteboard, calculate

I've updated sideORDA

2018-11-17 Thread Kirk Brooks via 4D_Tech
A few folks have asked me to update sideORDA to include the examples I showed in my 4D Method presentation . I've done that

Re: What's the thinking on setting/clearing semaphores rapidly?

2018-11-17 Thread Kirk Brooks via 4D_Tech
> On Nov 17, 2018, at 10:38 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > The overall performance is pretty sluggish and > > I'm looking at things that may contribute to that. > > ***

  1   2   3   4   5   6   >