ON ERR CALL: Comments & Seeking Comments

Use it. All of the time. If you're a long-time 4D devleloper like me, you may have started out not using ON ERR CALL much, if at all. I can't remember why I was scared of it, but I tended to avoid it. That all changed forever some versions back for me (6? 6.5?) I think that it's 4D's job to give

Re: Preemptive mode flaw

For anyone following along or reading this on the archives, I wanted to add an update here from the 4D Forums: http://forums.4d.fr/Post/EN/19391591/1/19391592 Thomas MAULRe: Provide developer control when a preemptive worker receives non-preemptive code > For me this is ON ERR CALL, which

Re: Website development path

Alex, please tell us more about that—thanks! Robert > On Jan 19, 2017, at 2:43 AM, Herr Alexander Heintz > wrote: > > Recently did a shop for car spare parts with it, a fast and reliable > combination.

Re: Schemes for record level access control

Just as a simple point, it's nice to have access values as a number: 1 2 3 4 5 Imagine that access increases at each step. // On after query C_LONGINT($1;$user_access_level) $user_access_level:=$1 QUERY SELECTION([Foo];[Foo]Minimum_access_score <= $user_access_level) So, if the user has a

Re: Schemes for record level access control

G’day Kirk, > On 13 May 2017, at 05:42 AEST, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'd like to hear from some of you who have implemented systems that allow > for record-level access control in a 4D database. Pick me! ;-) You’re sure you want to discuss this on the list

Re: Schemes for record level access control

It would be a lot easier if 4D password system is activated. Just a new group "TeamAccess_Bypass". LIke I said before, 4D password system does great help on achieving this. While we find 4D password system is invaluable, I know many developers don't like it. Alan Chan 4D iNug Technical

Re: Schemes for record level access control

Right - so the ultimate permission is the most permissive of all available. On Fri, May 12, 2017 at 4:56 PM, Alan Chan via 4D_Tech <4d_tech@lists.4d.com > wrote: > I assume a member might belongs to multiple teams but will a member > belongs to multiple clubs? > > Alan Chan > > 4D iNug Technical

Re: Schemes for record level access control

If implemented correctly, performance hit could be minimum. Do what query if(records in selection([WhateverTable]>0) if(<>TeamAccessRequired)\\some customers do not need this feature Query selection with array([WhateverTable]Team;<>CurTeam) end if end if <>CurTeam is loaded from team member

Re: Schemes for record level access control

I assume a member might belongs to multiple teams but will a member belongs to multiple clubs? Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >Hi Alan, >Those are the go-to solutions. In my case we aren't using the 4D password >system so I can't rely on that. Plus I need actual

Re: Schemes for record level access control

Hi Alan, Those are the go-to solutions. In my case we aren't using the 4D password system so I can't rely on that. Plus I need actual record level restriction. So to follow your example, I may want a Team to be able to see themselves and other teams in their Club (just making this up) but not

Re: Schemes for record level access control

Kirk: Of course there are all sorts of ways this could be done. It all depends on the complexity. We had to record by each user which records they were restricted from seeing. We also needed to permit / restrict by a group as well. Therefore we could not put a ‘flag’ within the record. When a

unrendered spaces

My numeric display format issue is not confined to numbers. If I put “abc” and “abc “ into an array (or into a table) and display it on a form, I get abc| abc| ( | represents edge of object) instead of abc| abc | The space is in the array value (or table), 4D doesn’t display it. If you want to

Schemes for record level access control

Hi folks, I'd like to hear from some of you who have implemented systems that allow for record-level access control in a 4D database. This is the sort of thing where we want to prevent unauthorized users from seeing or inferring the 'restricted' records. Theoretically it's pretty easy - include a

Re: Limit input into alpha characters into variable

Hi Keith, Heres a code snippet if it helps $iFormEvent:=Form event Case of : ($i=On Load) C_TEXT(Test) : ($i=On After Keystroke) $t:=Get edited text If (Length($t)>10) Test:=Substring($t;1;10) End if End case From: Garri Ogata

Re: Limit input into alpha characters into variable

Hi Keith, You can use a field with a set size. Or you can trap for after Keystroke and use get edited Text and do substring. Garri From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of Keith White via 4D_Tech <4d_tech@lists.4d.com> Sent: Friday, May

Re: Limit input into alpha characters into variable

Use an alpha field with the character limit you want from a temporary table. Copy the alpha field to the variable. Dave Porter Tailored Solutions, Inc. Business Management Software for Label Converters > On May 12, 2017, at 12:12 PM, Keith White via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >

Limit input into alpha characters into variable

Hi Is there a way to limit the number of characters you can impose on the user for alpha _variables_ (in a 4D form)? I tried using an entry filter, but that changes how the data is entered (you can only highlight one character at a time). Setting an entry format didn't seem to do it. I'm

Re: Disable close button on Splash screen windows v12

John: The code shown above is from V12.5 and an old version of Win32. Per the docs for Win32 8.1.2, the three commands listed above have been deprecated. The new versions of the command use the same command name with an "Ex" appended. -- Douglas von Roeder 949-336-2902 On Thu, May 11, 2017 at

INTO LISTBOX

I accidentally discovered something yesterday using SELECT ... INTO LISTBOX. I had 2 listboxes filled with SELECT ... INTO LISTBOX and 4D gave both identical names to columns and headers (sql_column1..sql_columnN, sql_header1..sql_headerN), resulting in duplicated object names in the same

Re: Finding where a filter or format is used in a structure

Randy, The log from the verify does in any case. Paul > Le 12 mai 2017 à 15:04, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I haven’t tried this - does the log let you know where these deletions > occurred so you can go set them to more appropriate filters? > > That was

Re: Finding where a filter or format is used in a structure

I haven’t tried this - does the log let you know where these deletions occurred so you can go set them to more appropriate filters? That was the reason I had written my method - I needed to track down inconsistencies. Randy

Re: Finding where a filter or format is used in a structure

Yes, great idea. Deleting the filter and the repairing with MSC removes all the filters in variables and fields. Thanks for the tip. Paul > Le 12 mai 2017 à 13:15, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > you could FORM GET NAMES , > iterate with FORM LOAD, FORM GET

Re: Finding where a filter or format is used in a structure

I have a utility method and a calling method for looping through the forms that dumps the following information into a text file on desktop for all table forms and project forms. The columns it writes are Table Form Name Page # Object Name Variable / Field Name Format Help Tip Filter I

Re: Finding where a filter or format is used in a structure

you could FORM GET NAMES , iterate with FORM LOAD, FORM GET OBJECTS, OBJECT Get filter and process the results. alternatively, you could create a copy of the structure, delete the filter in toolbox and run MSC verify. 2017/05/12 20:08、Paul Lovejoy via 4D_Tech

Finding where a filter or format is used in a structure

Hi everyone, With the good old 4D Insider it was easy to find where filters and formats created in the Toolbox were used in a structure. This feature disappeared with v11 and I certainly miss it, as I have to remove filters from fields and variables in v15 which are causing problems with

Re: Circumflex strangeness with v15 on OS X 10.10.5

> On 12May, 2017, at 08:44, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The users are based in Europe and have keyboards which make entering these > accented characters quite easy. There is one key for the “^” and the system > waits for a vowel over which it will be placed.

Re: Circumflex strangeness with v15 on OS X 10.10.5

Hi Miyako, The users are based in Europe and have keyboards which make entering these accented characters quite easy. There is one key for the “^” and the system waits for a vowel over which it will be placed. With this bug, the user winds up with the “^” on the vowel as well as stand-alone.

Re: Problems with LISTBOX SET FOOTER CALCULATION and dynamic columns (v15)

Hey Lahav, You are correct - thanks for saying something. It prompted me to go look at my actual code which is pretty similar: get the current doc values obj $obj:=JSON Parse("{}") $obj:=IG_get_curDocValues ($igPtr) For ($i;1;Size of array(aIG_ftrVars)) OBJECT SET RGB