4D Write Pro license question

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?

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)

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

I've updated sideORDA

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?

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

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

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

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

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: activating default user

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: Miyako zip plugin

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: Semaphores and Server-Side Data Updates in Multi-User Environment

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: Making a selection

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: Making a Selection

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: Sorting an array of email addresses

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: Mojave, dark mode and v17

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: v13 - Why can a record NOT be Pushed?

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: Backing up a VM - is it dangerous ?

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: Video viewer on Webarea on Windows 7

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: Current time (*) incorrect today on v17?

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: Structure Location--Best Practices...?

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?

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: Cross-platform Migration v15 App

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: Setting up an entity / collection listbox in code

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: Longing IDs or UUIDs as primary key?

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: Longing IDs or UUIDs as primary key?

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: Using listbox as output form replacement

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: [OFF] Credit card payments...

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: Shared Object - NOT!

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!

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?

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: Mac OS 10.14 Mojave and 4D 15

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

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

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: Help->v11 to v17 Upgrade or New?

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: Sets and the twinned process (Execute on server)

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

Sets and the twinned process (Execute on server)

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: Built Server—Best Practices...

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: Mac OS 10.14 Mojave and 4D 15

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

Re: Scope of entity selection

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: Defining and documenting Objects

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?

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: What causes a record to be Locked but Locked By has no info?

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: What causes a record to be Locked but Locked By has no info?

; > > > > > 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?

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: Defining and documenting Objects

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: Defining and documenting Objects

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

Notes on converting pictures to v17

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

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: Defining and documenting Objects

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

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: can an array be added to a Form's object list i.e. Form.Array?

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: can an array be added to a Form's object list i.e. Form.Array?

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?

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: Thoughts and Suggestions?

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

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

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: Document in use

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: Creating a form object to use as dynamic form

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

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: 4D v17 pause when printing to Canon ImageRunner printer

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: v17 Orda, Transactions, and ListBoxes with related many

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: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

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: PDF generation on Windows - Latest Thinking

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: PDF generation on Windows - Latest Thinking

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: Storage — Server vs Client

Chris, To expand on this a little bit, Storage consists of shared objects only. It's not possible to share objects between clients or a client and the server. Nor would you really want to. Nor would you want to attempt using something like Variable to Variable. As Lutz points out you can read

Re: Address Standardization

emed very reasonably priced. > > What's their reliability//uptime like? > -- > Douglas von Roeder > 949-336-2902 > > > On Tue, Sep 4, 2018 at 3:28 PM Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> > wrote: > > > Doug, > > I've been using SmartyStre

Re: Storage + New shared object

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: CALL WORKER questions

Jim, Miyako's post is a concise primer for modern 4D forms. Being able to pass a pointer to a dynamic form variable to another process, even one running on the server, is a great feature and one I've been using for several years. Let me share a couple of things I've learned doing this: - avoid

Re: How to tie 4D to barcode readers?

Tony, How are you handling programming the barcode reader to include information about what the barcode belongs to? Or are you using it as an extended keyboard input? On Tue, Aug 28, 2018 at 4:19 PM Tony Pollard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If you want the bar code scanning to be

Re: New record numbering system and CALL WORKER

I am surprised this thread has drawn so much discussion. It's good discussion but scanning back over it a key point is that all of these contortions and workarounds to preserve a number sequence are based on the single design decision to use an invoice (in this case) number as a key field. I'm not

Re: New record numbering system and CALL WORKER

Hey guys - the very issue with the record counter is sketched out in the discussion about Suspending Transactions: http://doc.4d.com/4Dv16/4D/16.3/Suspending-transactions.300-3652126.en.html I had missed this - it's quite a feature. On Mon, Aug 27, 2018 at 7:54 AM Keisuke Miyako via 4D_Tech <

Re: New record numbering system and CALL WORKER

Pat, On Sat, Aug 25, 2018 at 8:25 AM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > What you say makes sense, but the record number as key field is so integral > to the way the program works, it would be a nightmare to try and change it > Understood. But this approach still works, you

Re: New record numbering system and CALL WORKER

Pat, A couple of thoughts since it sounds like you're refactoring your code (all pseudo code, v17): 1) don't use this number as a key field. 2) The counter record: [COUNTER] ID name - optional but a good idea _data - object field: { nextNumber: 0, returned: []} 3) Counter_get_next(text) ->

Re: How to show subtotals in a list box

Dani, I am interested to know how you resolve this one. On Mon, Aug 20, 2018 at 2:05 PM Dani Beaubien via 4D_Tech < 4d_tech@lists.4d.com> wrote: > My situation is that I have a list box that has 1 level of break rows and > I have been asked to add a subtotal of the rows within each break level.

Re: Sales Tax Solutions for 4D

8 07:25:58 -0400, Jeffrey Kain via 4D_Tech wrote: > > Not compared to filing sales tax in every tax jurisdiction in every > > state (eventually) every month ourselves... > > > >> On Aug 17, 2018, at 1:00 AM, Kirk Brooks via 4D_Tech > >> <4d_tech@lists.4d.com&

Re: Sales Tax Solutions for 4D

So kinda pricey? On Thu, Aug 16, 2018 at 8:07 PM Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Probably all negotiated individually... > > > On Aug 16, 2018, at 5:40 PM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote

Re: Sales Tax Solutions for 4D

Jeff, What do they cost? On Thu, Aug 16, 2018 at 2:26 PM Jeffrey Kain via 4D_Tech < 4d_tech@lists.4d.com> wrote: > We integrated with Avalara. > > Should have bought their stock before the Supreme Court ruling on sales > tax... lol > > > On Aug 16, 2018, at 4:16

Re: Sales Tax Solutions for 4D

That's a great tip. On Thu, Aug 16, 2018 at 10:20 AM Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> wrote: > I talked to this service via 4D. Best API I’ve dealt with aside from maybe > Stripe. > > https://www.taxjar.com/ > > > > On Aug 16, 2018, at 9:28 AM, Dan Ivy via

Re: ORDA - updating data in listboxes

John, Agreed. It would be nice if REDRAW simply recognized what the object/parameter is and took appropriate action. On Sun, Aug 12, 2018 at 3:14 PM John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > This makes me wonder why REDRAW can't do this internally instead of adding > yet another

Re: ORDA - updating data in listboxes

b663e7 < > http://kb.4d.com/resources/inug?msgid=GmailId164f73d107b663e7> > > > > On Aug 12, 2018, at 11:55 AM, Kirk Brooks via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > The t

ORDA - updating data in listboxes

I'm playing around with listboxes and subforms. The scenario is reasonably simple: I have a table of [PEOPLE] which I display in a dialog. The parent form On Load loads them into Form: Form.people:=ds.PEOPLE.all().orderBy("Name asc") Parent form contains: 1) a listbox with

Re: Query from C#?

Hi Pat, I know almost nothing about C# but as we say in 4D land, "why would you want to do that?" I can see why a customer would want it but why would you want them to be able to? And how would you control what they can access? I think if they want some sort of ad hoc query capability you'd be

How to access formsSchema.json in the 4D app?

Working with dynamic forms and want to validate a form object. Laurent Esnault showed how to do this is his presentation in DC. He mentioned that formsSchema.json in the 4D app is the thing to use. How can I reference this document from within 4D? I tried various iterations starting with

Re: Memory leak with dynamic variables in list boxes?

Michael, No idea what that's about. Here's what I did when I downloaded and ran it. 1) opens to the demo dialog 2) closed the dialog and I'm in design. If you hit the Mode/Design menu command first just close the dialog. On Thu, Aug 2, 2018 at 7:52 AM mferguson--- via 4D_Tech <

Re: Memory leak with dynamic variables in list boxes?

Hey Michael, You don't need the source code. Just download the database zip. You have to close the demo dialog to get into design mode (because the dialog is opened with the On startup database method). On Thu, Aug 2, 2018 at 6:25 AM mferguson--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi

Re: selected rows for a collection listbox

Hey John, On Mon, Jul 30, 2018 at 7:05 PM John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > The selected row numbers matter if you are not using ORDA or a fully > materialized collection of objects. I hesitant to comment directly on what you're doing because frankly you are frequently

<    1   2   3   4   5   6   7   >