The other thing that would need some clarification is the alternativ methode to prevent a single cell from editing: The event On Before Data Entry.
There are several ways to reach a cell, either by tabbing or by clicking. What I'm struggling with is how to determine which cell needs to be edited instead of the blocked cell. Clicking more or less should lead to nothing, of course any indication that the individual cell is locked would be nice. But then when tabbing we can reach the cell from two directions which makes things more complicated. This is manageable through keeping tabs on which cell the user edited last but still imagining doing that work manually seems a bit off since it is rather easy for 4D to provide something like a "next cell" information given the tab order the cells are in and whether the user tabbed or shift-tabbed into a locked cell. Tilman Am 23.01.2018 um 04:30 schrieb Lloyd SIgler via 4D_Tech <[email protected]<mailto:[email protected]>>: Okay, it works as expected when you make area ‘Enterable’ in Property List. No requirement to to put it in the “On Before Data Entry”. Evidently, v14 allowed overriding that setting in code, which I personally prefer since it eliminates the need to add code to make it unenterable. Lloyd On Jan 22, 2018, at 1:19 PM, Lloyd Sigler via 4D_Tech <[email protected]<mailto:[email protected]>> wrote: I will try that approach, but seems that the code 'should' work since the row and column are specified. Makes cleaner code to deal with it all in one place, in this case I have a boolean that gets ‘checked’ if we are paying an invoice, and it then ‘unlocks’ the ‘amount’ in that row and puts cursor there to edit the amount being paid on the open invoice. Lloyd Sigler [email protected]<mailto:[email protected]> On Jan 22, 2018, at 8:30 AM, Kirk Brooks via 4D_Tech <[email protected]> wrote: The link Miyako included to the section on Managing Entry does actually talk about this. (I confess I hadn't read it very carefully before now myself.) You use OBJECT SET ENTERABLE to manage the enterability of the 'object' which is the listbox column. To control the enterability of an individual cell you use the On Before Data Entry form event. It may seem a bit odd to have an object method return a value but that's how it works. Kirk Brooks San Francisco, CA ======================= *We go vote - they go home* On Mon, Jan 22, 2018 at 8:07 AM, Jim Crate via 4D_Tech <[email protected] wrote: On Jan 21, 2018, at 10:41 PM, 4d--- via 4D_Tech <[email protected]> wrote: The following works fine in v14, but in v16 doesn’t work. Is this a known issue?? OBJECT SET ENTERABLE(ar_invBalance{$row};True) EDIT ITEM(ar_invBalance;$row) I tried EDIT ITEM in v16 last week and it didn’t work for me either. Jim Crate ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
