Re: 4D 18.5 Server on M1

I would suspect that it should run. You will be running under Rosetta 2. Until you get to V19 and native compilation you have to run under Rosetta 2. You can still get minis that run under intl. But they are higher end minis.

Re: Living past "End of support"

This is actually the model used by many software producers. Usually its the current and 1 prior major releases. Then off the the dustbin with it. In the internet age many have taken too the Facebook development model. Move fast and break things. Then fix them as you go. But it depends on how

Re: Curious about Workers

Good morning, I have not seen a way to target a specific core or type of core. The worker is just another thread running on the computer. Are you looking to try to target a high performance core on a M1 Mac vs a low performance core. If so then 4D does not offer a way to do this yet.

Compiled Client server application updates.

I have an interesting question that doe snot seem to be clear from the documentation. If I build a Client server application in 4D using v18.1 and then after deploying I make a client /server version using V18r2 will the clients built under the v18.1 upgrade from the 18.1 base code to the

Re: Users and group not converting when moving from v17r5 to v18

020, at 2:29 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com >> <mailto:4d_tech@lists.4d.com>> wrote: >> >> I have found that if you take a 4D v17r5 program and convert it to v18. Then >> change the database to a project database it will lose the membership

Users and group not converting when moving from v17r5 to v18

I have found that if you take a 4D v17r5 program and convert it to v18. Then change the database to a project database it will lose the memberships in the users and groups. When exported you will see all your groups and users. But the memberships between the two will disappear. With the

Re: Using the length parameter in a ORDA query.

ery that is generated by concatenating strings to build the query part and Objects creating the parameters passed to the query. I have used code like you example in my parking lot function. > On Apr 27, 2020, at 2:08 PM, Peter Bozek wrote: > > > > On Mon, Apr 27, 2020 at 6:54 P

Re: Using the length parameter in a ORDA query.

riginal Message- > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Eric Naujock via > 4D_Tech > Sent: Monday, April 27, 2020 10:54 AM > To: Technical iNug 4D <4d_tech@lists.4D.com> > Cc: Eric Naujock > Subject: Using the length parameter in a ORDA

Using the length parameter in a ORDA query.

I am trying to preform an unusual query. I em effectively thing to find all the records in a parent where the parent has children. Any suggestions other than build a collection of records primary keys and use an “in” conditional. Which feels dirty. This this case I have a table “cases” with

Re: 4D Summit Videos

Hood morning, I have been watching the keynote presentations. Keisuke Miyakos presentation on Document Production managed to get me excited. But I cannot find in the V18 or v18R2 documentation more about what he discussed. Nor doe the command seem to exist in V18.1. Unless I’m missing

Re: Word count in 4D write pro

Good morning, Apparently in 4D V17 a new command WP Get Text was added. I missed that one since the last time I was messing with this code I was using 4D v16r5. This command allows you to get a plaintext version of any 4D Writ pro object. I mention this just for reference to prevent

Re: Word count in 4D write pro

15, 2020, at 5:50 PM, Randy Kaempen wrote: > > Eric, > >> On Apr 15, 2020, at 4:48 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Is there a simple way to get a accurate word count for a 4d Write pro >> object? I am trying

Word count in 4D write pro

Is there a simple way to get a accurate word count for a 4d Write pro object? I am trying to be Abe to check if a document is long enough to be plausibly done. In the past with 4D write I could convert the document to raw text and use STR_Count_Words to be able to get a word count. But with

Re: Convert Object to shared object.

Thanks, That helped a lot. > On Mar 5, 2020, at 3:49 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > https://kb.4d.com/assetid=78197 ** 4D Internet Users Group (4D iNUG) Archive:

Convert Object to shared object.

Does anyone know of a way to simply convert an object to a shred object. I have tried numerous methods to get this done but I have found that nothing seems to want to allow an easy conversion from a c_object type to a shared object. Though in reality what I really want to do is convert a

Re: V18 and wakanda.

24, 2020, at 9:55 AM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Is anyone else using Wakanda with 4D server? If so what are you doing to > handle the change to 4d V18? I am seeing that it looks like the Wakanda > support for V18 is no longer listed bu

Re: v18 documentation

I understand. Usually I see the PDF versions show up a few months later. Fortunately I almost always have internet access when developing. But I can also sometimes see the need for a searchable PDF. Especially when the docs site is down. > On Jan 24, 2020, at 11:03 AM, Jeremy Roussak wrote: >

Re: v18 documentation

I live on the docs.4d.com website. The v18 tab has been there for a while. I was missing the v17r5 tab that went away shortly after the v18 tab appeared. https://docs.4d.com/4Dv18/index.en.html > On Jan 23, 2020, at 6:25 AM,

Re: Email Attachments Missing after New process ?

I have seen this kind of behavior when I deal with workers. It seem to just be the way things are done. What you way want to do is instead of generating the email in the the client and then sending it to a process. Gather an object that tells the new process how to build the email and send it.

Re: Change menu title

In my code I generate my menus programmatically. It makes for a much easier way of handling things Plug I can use the Internationalization in theme items. It makes it easier to allow or deny menu items based on user and roles. My system is to have a main MB function and then for each Manu if

V18 and wakanda.

Is anyone else using Wakanda with 4D server? If so what are you doing to handle the change to 4d V18? I am seeing that it looks like the Wakanda support for V18 is no longer listed but Im also not finding any docs in the V18 section that discusses the REST interface for v18 server. Or how

Re: For those using JavaScript

What is ALP? > On Jan 18, 2020, at 12:39 PM, Stephen J. Orth > wrote: > > Eric, > > From our perspective we are looking for a grid tool that mimic's ALP, so > simply CSS grids won't cut it. > > Best, > > Steve > > > -Original Message- > From: Eric Naujock > Sent: Saturday,

Re: For those using JavaScript

I have a quick question, When refereeing to a grid are you referring to a speardsheet like tool or are you looking for a simple grid similar to what you would have used tables for in the 90’s If all you want is a HTML grid that can be defines any not just use CSS Grids. Its much simpler than

Re: Dates and 4 digit years.

zek wrote: > > > > On Fri, Jan 17, 2020 at 10:33 PM Eric Naujock via 4D_Tech > <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote: > I am running with 4d V17R5 and am seeing some odd date behaviors. When I > search for a record with a date prior to 1921

Re: Dates and 4 digit years.

hing with date constants or using a string? > > John DeSoi, Ph.D. > > >> On Jan 17, 2020, at 3:33 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> I am running with 4d V17R5 and am seeing some odd date behaviors. When I >> se

Dates and 4 digit years.

I am running with 4d V17R5 and am seeing some odd date behaviors. When I search for a record with a date prior to 1921 I get all records in the database. Though most of the records are have dates newer than 1985. This is rather odd. I am not sure if this is due to 4D playing games with the

ORDA previous and next win a form.

I have a form that is using a dialog method and is using first, last, previous, and last to walk though a record in a form. When I use the previous, next etc method from the form it properly moves between the records in the EntitySelection as far the the Form. Variables go. But I have several

Re: catalina and 4D

We ended up having to go to the R5 release to get some of the issues fixed. There were a number of bugs with 4D write pro and object data types in ORDA that are fixed in R5. I also encountered some horrid speed issues in 17.3. If you are not on Gig ethernet it was taking upwards on 1 minute to

Re: 4D Authentication not working as expected

Good day, I have seen that issue as well. I have a function that prior to running a backup is saves the users and groups to a blob using user to blob and puts them in the database. I have seen this issue where when a restore the users and groups the memberships in the groups get

Re: 4D write pro add a new section.

Thanks, I never though about using an insert break to add a new section, or a section break. But I could see it now that it's brought to my attention. The issue with page numbers may prevent me from using this to get two columns. Though it seemed like to most elegant way to accomplish

4D write pro add a new section.

I see I can add a new subsection. But I am still trying to figure out how I would create new sew section object to append to a document. I see I need to have a second section to change from a one column layout to a 2 column layout. But there does not seem to be ab way to create a section object

Re: Write Pro multi column layout.

I think I may have found it in the blogs. https://blog.4d.com/create-multi-column-documents-in-4d-write-pro/ <https://blog.4d.com/create-multi-column-documents-in-4d-write-pro/> > On Jan 10, 2020, at 4:21 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Write Pro multi column layout.

Good morning, I have been digging in the docs to try and figure out how to add a two column block to a Write Pro document. I have a single column document. But wanted to add a block to the end that had two columns for a set of two signature blocks. Effectively I would like to create a

Re: Structure and Verification issue

dx can take a lot longer, especially on large >> data files. I only do it as part of routine maintenance. >> >> In this case I think you should consider deleting both, Mitch, and letting >> 4D rebuild them. >> >> Tom Benedict >> >>> On Dec 10, 2019, at

Re: Structure and Verification issue

I have seen cases where the index files get messed up. For my small databases I just delete the index files and let 4D regenerate them. But for big databases it may take a while to rebuild them. > On Dec 9, 2019, at 5:50 PM, Mitchell Shiller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi,

Re: Constants in code.

ing able to add comments to what the constants are for in the > code. You just can't do that with the 4DPOP component. > > On Mon, Dec 9, 2019 at 9:55 AM Eric Naujock via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Thanks I downloaded the document. Reading into it. Hopeful

Re: Constants in code.

so a way to create constants in your code if you want. There is a > tech note about it here: > > <https://kb.4d.com/assetid=77806> > > HTH. > > — > Cannon.Smith > Synergy Farm Solutions Inc. > Aetna, AB Canada > > > > >> On

Re: Constants in code.

ID duplication. > > there might be more that I do not remember off the top of my head. > > Chip > On Mon, 9 Dec 2019 15:20:05 +, Epperlein, Lutz (agendo) via 4D_Tech > wrote: >> You have to use xliff and you can find an example here: >> https://kb.4d.com/assetid=76

Constants in code.

Good morning, This seem pretty rudimentary, but I don’t seem find anything in the docs for this. Can you define your own Constants? I would like to define constants in my database to cover various groups for permissions. But what I am finding in the docs for v17r6 says they are listed

Re: Determining if a 4D Write Object has been changed since load.

gt; $isModified:=$1 >>> Else >>> $isModified:=True // default >>> End if >>> >>> WP_Information.DocumentInfo.Modification:=$isModified >>> >>> — Test the state wherever/whenever you wish with: >>> >>> // Method:

Re: Determining if a 4D Write Object has been changed since load.

e: 9/5/2019, 11:07:29 > // > // Description > // Get the Modification Property of WP_Information object > // See WP_Information_Init > // bld277005 > // > > C_OBJECT(WP_Information) > C_BOOLEAN($0) > > $0:=(WP_Information.DocumentInfo

Re: Determining if a 4D Write Object has been changed since load.

e: 9/5/2019, 11:07:29 > // > // Description > // Get the Modification Property of WP_Information object > // See WP_Information_Init > // bld277005 > // > > C_OBJECT(WP_Information) > C_BOOLEAN($0) > > $0:=(WP_Information.Do

Determining if a 4D Write Object has been changed since load.

I have a series of records and want to detect whether the 4D Write Pro object has been changed since it was loaded. This way I can keep a version archive of older versions of a document available. Is there an easy way I’m not seeing to know if the Write pro object has been changed since it was

Re: SSL Certificate parsing in 4D

Thanks for the feedback. I will take a Look. kb.4d.com is no longer running or usable. I will see if the article name is available in the us.4d.com website. > On Oct 22, 2019, at 11:09 AM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >

Re: SSL Certificate parsing in 4D

PM, Spencer Hinsdale wrote: > > openssl? > > On 10/21/19, 2:04 PM, "4D_Tech on behalf of Eric Naujock via 4D_Tech" > <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote: > >Is there a plugin or tool out there that can parse and breakd

SSL Certificate parsing in 4D

Is there a plugin or tool out there that can parse and breakdown a X509 style certificate into its components to be able to display the fields within. I did the typical Google Foo, and the 4D Docs. Along with Miyako. I just am not using any such code. Any suggestions?

Re: 4D authentication system that allow for stronger security.

d_o...@pghrepository.org> wrote: >>> >>> On Fri, 6 Sep 2019 09:25:39 -0400, Eric Naujock via 4D_Tech wrote: >>>> as I look closer at it with questions from a state government >>>> security person I can see a number of glaring holes that should be

Re: 4D authentication system that allow for stronger

My current system does extend the directory system. Though managing that extension can be a headache. Right now we just use the built in basic username/password authentication. But I have found parts of the old code that did implement their own authentication solution. But that was likely used

Re: 4D authentication system that allow for stronger security.

> On Sep 6, 2019, at 10:19 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > On Fri, 6 Sep 2019 09:25:39 -0400, Eric Naujock via 4D_Tech wrote: >> as I look closer at it with questions from a state government >> security person I can see a number o

Re: 4D authentication system that allow for stronger security.

. Bcrypt or PBK-DF2 would be even stronger. Plus the Bcrypt or PBK can have salt in the password hashes. > On Sep 6, 2019, at 2:47 AM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Eric, > >> On 6 Sep 2019, at 24:22 AEST, Eric Naujock via 4D_Tech >

Re: 4D authentication system that allow for stronger security.

dea of what 4D offers > > https://blog.4d.com/4d-security-guide/ > <https://blog.4d.com/4d-security-guide/> > > > Best regards, > > Maurice Inzirillo > -- > AJAR S.A. > > https://ch-fr.4d.com <https://ch-fr.4d.com/> > twitter: ajar_info >

4D authentication system that allow for stronger security.

Does anyone have a replacement login system for 4D that offers stronger authentication security than the current system. Since the current system does not enforce password changes, or password complexity it is a pretty poor system in the current age. While the encryption is crypt is is still

Re: Combo Box & Return Key

If you really want to capture that keystroke you can use the On Before Keystroke event. But be careful with it, that function can get pretty active with a fast typist. I use the On after Keystroke to allow the dropdown to populate as the user types. > On Aug 30, 2019, at 10:37 AM, Stephen J.

Re: ORDA Limiting number of records returned.

om> wrote: > > Am 10.04.2019 um 16:09 schrieb Eric Naujock via 4D_Tech > <4d_tech@lists.4d.com>: >> >> Related to the note about 4D Write Pro documents slowing things u. Would it >> help to move all the 4D Write documents to a 4D Write table containing the &

Re: ORDA Limiting number of records returned.

:15 schrieb Keisuke Miyako via 4D_Tech >> <4d_tech@lists.4d.com>: >> >> ORDA queries only return a reference to the selection and not the entire >> data set, >> so it's not as if the payload should be a problem (especially at 35K which >> is small) >

ORDA Limiting number of records returned.

Is there a way to limit the number of records returned in a ds..query result. I know about the set query limit in the system, but I am trying to do this new trick with order and want to be able to limit the results to only 1000 records max out of a table with over 35,000 rows. Any suggestions

Re: 4d will not start ssl on 443

Are you also running any part of osx server? I have also found that sometimes the built in apace server gets started on the machine. In both cases the ports are in use and you will not be able to start your 4D with 80 or 443. Use `sudo lsof -i :8` and look for listeners. Then you may have to

Re: Call workers allowing multiple threads to run at once.

It would seem I have my answer for the question of require the use command for for the signal variable. You do have to use the use command to change the values of the signal since it is a shared object. > On Mar 25, 2019, at 4:53 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com>

Re: Call workers allowing multiple threads to run at once.

> That's the point of workers. > > You queue up messages for the worker to handle, in order, so your calling > method doesn't block. > >> On Mar 25, 2019, at 4:33 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> But I have fou

Call workers allowing multiple threads to run at once.

I have a stored procedure that watches a table in the database. This Store procedure then executes call rocker depending on the tasks placed in the table. Depending on what is put into the record of the table it will cell multiple workers. Each worker could run for un undetermined amount of

Getting a collection created from 4D function to work in Storage.

I am having a curious time with this one. I am trying to get a collection retrieved from Get System Info to be saved into the Storage Collection. Right now I am using the following to get the information. $systemInfo:=Get system info $volumeCollections:= $systemInfo.volumes This

Re: Programmatically change the background image in the Application Window

17, at 11:00 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thanks for that tip. I played a bit with that and I now have a basic form > running in the Application window. Since I have started refactoring my code > to start using CALL FORM and CALL WORKE

Re: Programmatically change the background image in the Application Window

Thanks for that tip. I played a bit with that and I now have a basic form running in the Application window. Since I have started refactoring my code to start using CALL FORM and CALL WORKER. This gives a very interesting option. I will continue to play with this to see if I can get some more

Re: Programmatically change the background image in the Application Window

Good evening, Yes I read the page you mentioned before I posted, But that page assumes that we are using the menu bars in the menu items. I am using the menu commands to build and present my menu bars. There does not seem to be a command line option to accomplish that. There is no

Programmatically change the background image in the Application Window

Good afternoon, Is there a way to from within code of a database change the background graphic for the 4D application window? Or is there something else that can be done with it other than show a static picture or the 4D logo? If there was a way to change the image it would be

Re: Optimizing and improving 4D queries.

I used to have this set as automatic and that did not help. According to KB 49932 you use Btree if the selectivity is near 1, and use cluster Btree if the selectivity is near 0. Where selectivity is calculated as selectivity = (number of distinct values in field) / (Total number of records in

Re: Optimizing and improving 4D queries.

The field is indexed with btree since its designed for lots of unique values and its a UUID. This was based on the technote regarding the optimal index to use. --- MacCafe 4405 Talmadge St. Toledo, OH 43623 Eric Naujock -

Re: Optimizing and improving 4D queries.

; > I don't use RELATE MANY, but recently verified the same problem with DISTINCT > VALUES impacts RELATE ONE SELECTION. 4D's built in progress dialog pops up > with a message such as "computing distinct values". > > > John DeSoi, Ph.D. > > >> On Jun 28, 20

Optimizing and improving 4D queries.

I have been trying to do some performance tuning an optimizing on one of my 4D databases and am finding that one function RELATE MANY is taking over 1790 ms. At lease are there any 4d Tools that are available to help analyze the case of tis timeout and resolve the issue. I have tried adjusting

Tags in record on 4d.

Has anybody come up with a good way add tags records in a table? For instance I have a table of contacts, but I would like to be able to tags them with labels and then be able to filter on those labels. Kind of like the usage of tags in osx. In this case I would like to be able to add tags