Re: Field Validation in Listboxes

2018-03-20 Thread Kirk Brooks via 4D_Tech
Jeff, I think you want to use EDIT ITEM. $objName:=OBJECT Get name(Object current) // will be the name of the listbox object even if called from a column/array $row:=listbox_get_rowcolumn ($objName;->$column;->$objPtr) // method gets the row and ptr to the column & column object If(Not( code

Re: Multi-Table Query Into JSON?

2018-03-23 Thread Kirk Brooks via 4D_Tech
On Thu, Mar 22, 2018 at 10:48 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > it’s not that the command has negative attributes, it’s more to do with > the fact that the command is too basic. a similar example is ALERT. I know > many applications use it in production, and there is

For any of you Phantom JS users out there

2018-03-03 Thread Kirk Brooks via 4D_Tech
https://github.com/ariya/phantomjs/issues/15344 -- Kirk Brooks San Francisco, CA === *We go vote - they go home* ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: How do I get the type of a Collection element? (v16r6)

2018-04-26 Thread Kirk Brooks via 4D_Tech
fail Time for example. > And I believe v16r6 fails Date too (fixed in v17.0Beta). > > I reported that same issue to the beta forum. I hope that gets sorted out > in the beta cycle. > > On Thu, Apr 26, 2018 at 12:36 PM Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> w

Object get type no longer returns the Object Array type in v16r6

2018-04-26 Thread Kirk Brooks via 4D_Tech
Object get type has been changed in 16r something. Probably when collections were introduced in r4 but I wasn’t paying attention. The change is it no longer returns the ‘Object Array’ type (39). Any value that begins with a [ is interpreted as ‘Is collection’ (42). Object arrays still work just

Re: Best way to share large files with web users

2018-06-28 Thread Kirk Brooks via 4D_Tech
John, I'll second Bruno's suggestion and suggest you go get his component to do it. I've been using it for at least a year managing about 50k docs in AWS. It works well and AWS is very cost effective for light duty like this. I think we are paying ~$10 a month for all the stuff we use. It is

Re: Best way to share large files with web users

2018-06-28 Thread Kirk Brooks via 4D_Tech
d be empty. > > Correct me if I am wrong, but If I understand their web site I > should be able to use the Free Tier for development and when I deploy my > client can do the same for their first year. > > Thanks, > > John > > > > > > On Jun 28, 2018, a

Re: object names conundrum

2018-06-28 Thread Kirk Brooks via 4D_Tech
Chuck, I don't use templates so but I do use inherited forms a lot and same situation exists there. I think it's an artifact of the shift in 4D architecture - these are fairly ancient parts of 4D that just worked and probably haven't been tweaked. It won't crash but for the inherited forms if you

Re: Does anyone have experience syncing with external contacts?

2018-06-28 Thread Kirk Brooks via 4D_Tech
t; Snow Leopard. I don’t know if Apple changed API in more recent releases of > operating system and if Keisuke updated plugin. If not, maybe AppleScript > is way to do it. > > Milan > > > On Jun 27, 2018, at 19:49, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrot

Re: 4Dv16R6: Object on form still active when another object is on top

2018-06-28 Thread Kirk Brooks via 4D_Tech
Rudy, If the 'covered' object is tabable simply placing another object on top of it won't stop entry, it just makes it less apparent what's going on. Instead of changing the visibility of the cover object why not just make the enterable object itself invisible? This does make it non-enterable but

Re: Best way to share large files with web users

2018-06-29 Thread Kirk Brooks via 4D_Tech
John, On Thu, Jun 28, 2018 at 9:37 PM JOHN BAUGHMAN via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > One tip - and I think Bruno says this to in his docs - setup a > > 'development' bucket to use for testing. > > I am not following you. Watching Bruno’s demo it looked like one > could have

Re: 4Dv16R6: Object on form still active when another object is on top

2018-06-28 Thread Kirk Brooks via 4D_Tech
to ‘dim’ the > underlying objects, and that seems to do the trick. > > > Regards, > > Rudy Mortier > Two Way Communications bvba > > > > > On 28 Jun 2018, at 13:04, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Rudy, > >

Notes on converting pictures to v17

2018-10-08 Thread Kirk Brooks via 4D_Tech
I'm preparing to move a large, established project from v15 to v17 and finally had to deal with the pictures. I've been putting this off at least partly because of just not wanting to deal with this. Turns out it's not that big a deal, at least for me. When I've just done the conversion to see

Re: Defining and documenting Objects

2018-10-11 Thread Kirk Brooks via 4D_Tech
Neil, You are correct. I think this is an example of how deep the changes are to accomplish ORDA. But there are a lot of changes in the works on forms (viz dynamic forms) so it will probably change too. On Thu, Oct 11, 2018 at 7:33 AM Dennis, Neil via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > I

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Kirk Brooks via 4D_Tech
hat happens > in your car if you select a different record. Do both show as locked only > first or only the second > > Regards > Chuck > > Sent from my iPhone > > > On Oct 11, 2018, at 1:48 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wro

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Kirk Brooks via 4D_Tech
; > > > > > On Oct 11, 2018, at 1:48 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > I have a method that tests if a record is locked and if it is attempts to > > figure out by whom: > > > > $text:="["+Table name

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Kirk Brooks via 4D_Tech
s. Given the following code > You will see that > $proc=0 > and > $user,$session,$name are all blank > > *READ ONLY*([Table]) > > *Get a record* > > *FIRST RECORD*([Part]) > > *LOAD RECORD*([Part]) > > *If *(*Locked*([Part]) > > *C_LONGINT*($proc) > &

Re: Defining and documenting Objects

2018-10-11 Thread Kirk Brooks via 4D_Tech
Olivier, First - nifty hack. Second - can you do that with a collection or object based listbox? On Thu, Oct 11, 2018 at 11:15 AM Olivier Flury via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Well, not sure if this is what you need, but you can insert a dynamic > column into a list box, get a

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Kirk Brooks via 4D_Tech
t; Lane ∙ Palisades, NY 10964 > > Please send all email contacts to supp...@printpoint.com > > <mailto:supp...@printpoint.com> > > > > > > > > > >> On Oct 11, 2018, at 1:48 PM, Kirk Brooks via 4D_Tech > >> <4d_tech@lists.4d.com&

Re: Mac OS 10.14 Mojave and 4D 15

2018-10-15 Thread Kirk Brooks via 4D_Tech
James, It works mostly. WebKit is completely horked so things like the Welcome Wizard and any other web areas that use the WebKit are screwed. They are still active, though. For example, if you click on the blank Welcome Wizard in a space where an active link is it still works. Not necessarily a

Sets and the twinned process (Execute on server)

2018-10-17 Thread Kirk Brooks via 4D_Tech
I haven't looked at this in a long time but I'm revisiting some code that uses sets. This happens to be v15 and we are talking about client/server. The docs are pretty clear about the scope of sets with the only unusual thing being a

Re: Sets and the twinned process (Execute on server)

2018-10-17 Thread Kirk Brooks via 4D_Tech
Thanks Arnaud, That's what I suspected. On Wed, Oct 17, 2018 at 9:21 AM Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Le 17 oct. 2018 à 17:58, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > > > [...] a process set created

Re: Built Server—Best Practices...

2018-10-16 Thread Kirk Brooks via 4D_Tech
Robert, I wouldn't presume to argue with Tim on best practices but will say I've been doing those sorts of updates to my built server app for - years. I've never has an issue that tracked back to it. Yet. The main benefit is users don't have to wait through downloading a new set of

Re: Help->v11 to v17 Upgrade or New?

2018-10-19 Thread Kirk Brooks via 4D_Tech
Dani, On Fri, Oct 19, 2018 at 8:22 AM Dani Beaubien via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have been using GitHub to track changes on the exported code. I have > projects that go back years that are in GitHub. Did I just hear you say something about uploading direct from 4D into

Re: Mac OS 10.14 Mojave and 4D 15

2018-10-19 Thread Kirk Brooks via 4D_Tech
I'm using v15.6,.5,.4 every day without those sorts of issues. Including 4D server. It's probably not 4D itself, some other interaction. On the other hand I spent a couple of hours setting up an external drive as a boot drive (with Mavericks!) so I can boot an old laptop into that for working with

Re: Shared Object - NOT!

2018-10-21 Thread Kirk Brooks via 4D_Tech
Peter, On Sun, Oct 21, 2018 at 5:04 AM Peter Bozek via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Sun, Oct 21, 2018 at 12:41 PM Keisuke Miyako via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > the request is more like, > > "I want to make a query in process B change the current selection of > >

Re: Shared Object - NOT!

2018-10-21 Thread Kirk Brooks via 4D_Tech
Miyako, On Sat, Oct 20, 2018 at 9:29 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > if you do the same across processes, > i.e. pass a New object or New collection to New process, CALL WORKER or > CALL FORM, > the object or collection is not shared between the 2 methods, caller

Re: Help->v11 to v17 Upgrade or New?

2018-10-18 Thread Kirk Brooks via 4D_Tech
Robert, I am just taking on a project for a similar situation: v11 to v17. I haven't had a chance to really dive into the code yet so I'm not really sure what's there but at this point the client's intention is to essentially keep the database on 'palliative care' for the next 1 to 2 years when

Re: Scope of entity selection

2018-10-13 Thread Kirk Brooks via 4D_Tech
Peter, Collections are ordered. So just sort the entity selection first. On Sat, Oct 13, 2018 at 2:40 PM Peter Bozek via 4D_Tech < 4d_tech@lists.4d.com> wrote: > On Sat, Oct 13, 2018 at 10:29 PM Christian Sakowski via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > >

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Kirk Brooks via 4D_Tech
Rudy, I did something similar once, partly to see how hard it would be. I would not race into doing it again unless there was some really compelling reason. Assuming there is that compelling reason the process worked something like this: a) go through every table affected and add the UUID field

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Kirk Brooks via 4D_Tech
Hi Chip, Another way to look at this is in terms of separating the logical structure from the data. Using UUIDs compels you to think about the logical structure separately from the contents. That's a good thing. I agree it can be useful to have a unique serial number on some tables. But that

Re: Using listbox as output form replacement

2018-10-24 Thread Kirk Brooks via 4D_Tech
Hi Jim, I have a couple of thoughts about this. First, for user mode output forms I stick with plain, old 4D output forms. It's really the best. Second, I totally support the direction you're going with using a Dialog and a listbox instead of MODIFY/DISPLAY SELECTION. I would encourage you to try

Re: Setting up an entity / collection listbox in code

2018-10-29 Thread Kirk Brooks via 4D_Tech
Jeremy, Jeremy French outlines the steps you need to follow. I would add a couple of ideas expanding on his post if you have multiple listboxes in a form. The first is simply adopt a custom of putting all the listboxes in a single object of the parent form. So I might have: Form.LB.A... Which

Re: Cross-platform Migration v15 App

2018-10-31 Thread Kirk Brooks via 4D_Tech
Ronnie, The users will grumble about how much faster everything suddenly is. But aside from that I, a hard core Mac user since day 1 of using 4D, have always put the production server on a windows machine. The issues with the path names are fairly easy to deal with when you're aware of them. Aside

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Kirk Brooks via 4D_Tech
Miyako, So Timestamp uses a completely different -source- for determining time than Current time and Current date? On Mon, Nov 5, 2018 at 12:45 AM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > 16R4 and later offers Timestamp > >

Re: Video viewer on Webarea on Windows 7

2018-11-05 Thread Kirk Brooks via 4D_Tech
Jim, On Sun, Nov 4, 2018 at 5:42 PM Jim Labos - infobase via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am using URL's and they work on Win7 on Chrome but not Explorer. So > certain it's not a URL problem. > It may be the Webkit use so I'll check that. > Without knowing which version of 4D and

Re: Backing up a VM - is it dangerous ?

2018-11-05 Thread Kirk Brooks via 4D_Tech
Peter, In a low transaction environment it's probably not an issue. But if the copy happens to take place during a cache flush you can wind up with a corrupted datafile. It's easily fixed by MSC but a record or two may be lost. I've experienced this myself by making a copy of a live datafile on a

Re: Structure Location--Best Practices...?

2018-11-01 Thread Kirk Brooks via 4D_Tech
Robert, I tend to go with: /database name/ structure.4db datafile/database name.4dd On Thu, Nov 1, 2018 at 6:29 PM Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Thanks guys, that covers Windows... what about macOS? > > R > > Sent from my iPhone > > > On Nov 1, 2018,

Re: CREATE USER Programmatically?

2018-11-01 Thread Kirk Brooks via 4D_Tech
Hey Randy, You're not a dope - it's a non-intuitive. I integrated my user system with the 4D system a couple of years ago. Allows me to keep the really fine-grained permissions they know and love while letting 4D sweat the login stuff. Plus gives me a *much* easier way to know who the user is

Re: [OFF] Credit card payments...

2018-10-23 Thread Kirk Brooks via 4D_Tech
Stripe has got to best API I have dealt with if you want to do a 4D integration. On the other hand if you don't do many transactions Square is hard to beat. On Tue, Oct 23, 2018 at 4:11 PM Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have a client with an overdue invoice….

Re: Mac OS 10.14 Mojave and 4D 15

2018-10-20 Thread Kirk Brooks via 4D_Tech
. On Fri, Oct 19, 2018 at 11:25 PM Milan Adamov via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > > On Oct 20, 2018, at 01:16, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > On the other hand I spent a couple of hours setting up

Re: Help->v11 to v17 Upgrade or New?

2018-10-20 Thread Kirk Brooks via 4D_Tech
IW, > > Robert > > > On Oct 19, 2018, at 6:28 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Did I just hear you say something about uploading direct from 4D into > > GitHub...  > > ***

Re: v13 - Why can a record NOT be Pushed?

2018-11-05 Thread Kirk Brooks via 4D_Tech
Stack is full? The record is not selected? I was trying to use PUSH & POP the other day for something. It caused me to re-read the docs about it and I found that over the years I'd forgotten the whole idea for these two commands is to allow you to PUSH the record you are currently using to allow

Re: Miyako zip plugin

2018-11-13 Thread Kirk Brooks via 4D_Tech
Piotr, If you haven't already check github to see if you are using the most recent version of this plugin. It's one that Miyako maintains and updates regularly. This may be an issue he's fixed already. https://github.com/miyako?page=3=repositories On Tue, Nov 13, 2018 at 2:33 AM Piotr Chabot

Re: activating default user

2018-11-14 Thread Kirk Brooks via 4D_Tech
Robert, I include a field in the [Users] table for the database id and database name. The significance of that value depends on the rules you set up for yourself. 1) You could say the 4D structure is the authority in which case if the structure doesn't, or no longer, has that user's db id in it

Re: Making a Selection

2018-11-09 Thread Kirk Brooks via 4D_Tech
Peter, No. For something like that I'd think about adding some sort of indicator button next to object of interest. The user could click the ones selected and some other action, perhaps another button but could be something else, would trigger the code to loop through these objects and build the

Re: Making a selection

2018-11-09 Thread Kirk Brooks via 4D_Tech
Peter, That's doable. I haven't played with form objects at that level for some time. I'd use a picture for the background or boundary object. The On Mouse Down event let's you trap a click on the picture. You could also trap the On Mouse Up event to get the delta between where the click started

Re: Semaphores and Server-Side Data Updates in Multi-User Environment

2018-11-12 Thread Kirk Brooks via 4D_Tech
Hi Ben, I do a lot of processing like this. I like to use the Execute on server property for the method doing the processing. The structure is pretty straightforward: // EOSmethod ( parameters ) -> text // first off, check the semaphore If (Not(Semaphore("specialMethod"))) READ ONLY(*) //

Re: Mojave, dark mode and v17

2018-11-06 Thread Kirk Brooks via 4D_Tech
Read more Nietzsche? On Tue, Nov 6, 2018 at 12:31 AM Jeremy Roussak via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Is there a way of getting applications built in v17 - and indeed v17 > itself - to honour dark mode? > > Jeremy >

Re: Sorting an array of email addresses

2018-11-06 Thread Kirk Brooks via 4D_Tech
David, Use a collection instead of an array. On Tue, Nov 6, 2018 at 2:17 AM David Samson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Would this be reliable since they all contain the "@" sign? You might have > " > i...@abc.com" and "i...@def.com". > > (Windows v17 if it matters) > > D Samson >

Re: Defining and documenting Objects

2018-10-04 Thread Kirk Brooks via 4D_Tech
If anyone is a little intimidated about writing JSON validation schema from scratch (I am) there are some online resources to assist. One that's particularly easy to use is https://www.jsonschema.net/ On this site you can paste in a properly formatted JSON and the site will infer the schema. The

Re: Defining and documenting Objects

2018-10-03 Thread Kirk Brooks via 4D_Tech
Paul, You touch on an excellent point about using objects. At the heart of it is your naming convention. We haven't had to worry about naming too much in the past. Variable names aren't case sensitive and you could always use the COMPILER_ methods to document the IP and process variables. And the

Re: Defining and documenting Objects

2018-10-05 Thread Kirk Brooks via 4D_Tech
Paul, You know it's perfectly acceptable to just not even worry about it. Personally I never wrote a SOAP API or client and it looks like I never will. :-) If you don't need dot notation and don't see anything on the horizon that will require it spend that time doing other things. I've seen some

Re: can an array be added to a Form's object list i.e. Form.Array?

2018-10-02 Thread Kirk Brooks via 4D_Tech
Chris, As you found arrays are not supported for use with Form. Objects like a combo box are aren't that hard to do but until they support a collection as the data source you have to manage them in classic 4D fashion. Which means you can shuffle an array around using OB SET/GET ARRAY and some

Re: can an array be added to a Form's object list i.e. Form.Array?

2018-10-02 Thread Kirk Brooks via 4D_Tech
Keith, Sure, if having the choice list in the data object is relevant. Depends on how the form is set up I think. Typically I would pass a data object to a form or subform to be populated with data or allow the user to edit it. I make the form for a particular kind of operation. Right now I'm

Re: can an array be added to a Form's object list i.e. Form.Array?

2018-10-02 Thread Kirk Brooks via 4D_Tech
4d.com/4Dv17/4D/17/OB-SET.301-3730704.en.html makes me want to > try using Form.CollectionName[n] too. > > Keith > > > On Oct 2, 2018, at 4:03 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Keith, > > Sure, if having the choice lis

Re: Defining and documenting Objects

2018-10-11 Thread Kirk Brooks via 4D_Tech
Bernd, On Wed, Oct 10, 2018 at 11:49 PM Bernd Fröhlich via 4D_Tech < 4d_tech@lists.4d.com> wrote: > there are no globals required for menus (I assume here that you are > talking about popup menus in the form). > So true. This deserves its own thread. In fact unless you have some extended

Re: Thoughts and Suggestions?

2018-10-01 Thread Kirk Brooks via 4D_Tech
Ken, The tricky part is: On Mon, Oct 1, 2018 at 5:00 PM Kenneth Geiger via 4D_Tech < 4d_tech@lists.4d.com> wrote: > These people need to take notes and record data during their field-work > using iPads. Then, once they get back to “civilization”, this data needs to > be uploaded to the Database.

Re: C_OBJECT Performance problem with arrays

2018-10-01 Thread Kirk Brooks via 4D_Tech
Miyako, On Mon, Oct 1, 2018 at 1:29 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > This makes it easy to, say, iterate through each element. Beyond > > convenience are you saying this is more efficient than using the full dot > > notation? > > it depends on how frequently you

Re: C_OBJECT Performance problem with arrays

2018-10-01 Thread Kirk Brooks via 4D_Tech
Miyako, On Sun, Sep 30, 2018 at 8:24 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > in fact, you should use object notation just once, to get a handle on the > property which is a collection of objects, > and work with that reference directly rather than dotting your way through

Re: Storage + New shared object

2018-09-02 Thread Kirk Brooks via 4D_Tech
David, You need to define the objects as shared objects. You will also want to use collections instead of arrays because I don't think you can have a shared array. This works without error : *C_COLLECTION*($DeleteRecord_ob) $DeleteRecord_ob:=*New shared collection*

Re: 4D v17 pause when printing to Canon ImageRunner printer

2018-09-19 Thread Kirk Brooks via 4D_Tech
James, On Wed, Sep 19, 2018 at 5:26 PM James Brown via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The reason we have the server do the printing is because we have people > pick orders using iPads with barcode scanners. When they have finished > picking, the server processes the order and prints

Re: Creating a form object to use as dynamic form

2018-09-24 Thread Kirk Brooks via 4D_Tech
Jody, You are correct about the form editor. I've been dabbling with building even a simplified form editor and it's not a trivial task. On the other hand my work with dynamic forms has shown me the mechanics of the current form editor and the approach employed by the dynamic forms part is very

Re: button picture problems in v16 and v17

2018-09-21 Thread Kirk Brooks via 4D_Tech
On Fri, Sep 21, 2018 at 8:36 AM Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Actually source was available. I have it. Fixed the issues I was having. I > did look at the tech note and the link for Miyako’s component was broken so > any ideas where I might find it >

Re: Document in use

2018-09-25 Thread Kirk Brooks via 4D_Tech
Ferdinando, I think you are on the right track. I'd write an error handler to recognize the file open error (I forget the number) and install it prior to calling Open document. That way you can gracefully handle the situation. On Tue, Sep 25, 2018 at 6:17 AM stardata.info via 4D_Tech <

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: 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: 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: 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

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: 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

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: 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: 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

[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: 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

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-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: 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-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: 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

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

2018-11-17 Thread Kirk Brooks via 4D_Tech
I'm looking at some code (v15) that writes logs on the server. It's a delay loop with a short period - 15 ticks. Within that loop a semaphore gets set, the code runs and then the semaphore gets cleared. I seem to recall hearing talk about not using semaphores in cases like this - inside really

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

2018-11-17 Thread Kirk Brooks via 4D_Tech
at 8:13 AM Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Kirk, what’s the problem with the current setup? > > Sent from my iPhone > > > On Nov 17, 2018, at 9:54 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > This is a

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. > > ***

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

[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: 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: > >

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

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

Re: PDF generation on Windows - Latest Thinking

2018-09-13 Thread Kirk Brooks via 4D_Tech
I agree that PDF Creator is terrible on the server. I tried it briefly and it was a headache. In addition to the points Lutz made doing any printing Server side restricts you to a single print job at a time. That can become a problem - you have to write your own print job que. Plus PDFC can throw

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

2018-09-15 Thread Kirk Brooks via 4D_Tech
Hey David, You know, you say that RAM is the primary limiting factor but then also say you're only interested in actual timing tests. Umm. Seems like the coding version of the the building contractor talking to a client: You can have it fast You can have it cheap You can have it done well Pick

Re: v17 Orda, Transactions, and ListBoxes with related many

2018-09-16 Thread Kirk Brooks via 4D_Tech
Hi Chris, 1) do table forms have any relevance in ORDA anymore? Sure. Personally I am sticking with them for output forms in user mode, for example. And I'm still including a bare bones input form as well. I wouldn't use it for user-facing production forms. I don’t want to mix ‘classic’ 4D in

Re: PDF generation on Windows - Latest Thinking

2018-09-12 Thread Kirk Brooks via 4D_Tech
Peter, Win10 has a native PDF print engine like MacOS does. You can use it. I don't think PDFCreator 1.7whatever will even run on Win10 (but you probably found that out). On Wed, Sep 12, 2018 at 4:06 AM Peter Jakobsson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi > > For years I used PDF

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: 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

[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: 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: "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

<    1   2   3   4   5   6   7   >