AW: Memory leak with dynamic variables in list boxes?

Works interpreted, but not compiled. https://flury-software.ch/ -Ursprüngliche Nachricht- Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von Keisuke Miyako via 4D_Tech Gesendet: Freitag, 27. Juli 2018 01:32 An: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Keisuke

AW: Memory leak with dynamic variables in list boxes?

Hi Michael, Absolutely, dynamic footer variables are typed as text, but footer sum requires a numeric variable. Changing the type of a dynamic variable does not work in compiled mode. Only changing the type of dynamic arrays. Would be great if 4D would extend LISTBOX INSERT COLUMN with an

Re: 4D v11 on Windows Server 2016 (Win 10 Clients)

On Jul 26, 2018, at 8:15 PM, Robert ListMail wrote: > Apparently, the client did some testing in that regard, everything seemed to > work except the printing from 4D failed. I’ll just keep them going on the old > hardware until I’m ready to make the change to the new v17 version. This is a

v17 PDF-Manuals

Hi, When can we expect the PDF-version of the manuals for v17? HTML-only is not exactable! Thanks Regards Jörg Knebel, M.Eng. - 4D Developer since 1991 TTT Data Systems Pty Ltd Phone: +61 (0)2 6601 7453 www.tttdatasystems.com.au

Re: collection.min() Returns Null

Hi Miyako, Perfect! Thanks, that makes sense and works well. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Jul 26, 2018, at 3:27 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > in your case, you could do something like > >

Re: standard action for design mode not working in 17.0

Hi Jody, The button had the action assigned to it, not done with code in any way. As you said, I think the name changed and that was reflected in the button action in the form editor. I never use the "user mode" features to access the database and find it rather annoying when that window shows

Re: 4D v11 on Windows Server 2016 (Win 10 Clients)

Apparently, the client did some testing in that regard, everything seemed to work except the printing from 4D failed. I’ll just keep them going on the old hardware until I’m ready to make the change to the new v17 version. Thanks, Robert > On Jul 26, 2018, at 2:19 PM, Charles Miller via

Re: Memory leak with dynamic variables in list boxes?

correction: since it is a form local variable, you should be able to retype it simply by calling C_REAL ($footerPtr->) 2018/07/27 8:30、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>のメール: dynamic variables create for footers are typed as text by default. you need

Re: Memory leak with dynamic variables in list boxes?

dynamic variables create for footers are typed as text by default. you need to change it to numeric by replacing it using VARIABLE TO VARIABLE. 2018/07/27 7:34、mferguson--- via 4D_Tech <4d_tech@lists.4d.com>のメール: Seems like it should be simple, but I’m missing

Re: Memory leak with dynamic variables in list boxes?

Hi, I converted it to use dynamic variables for the listbox columns insert, passing in nil pointers for the header and footer variables. It works great for regular columns but I can’t get it to work for footers. Specifically: LISTBOX SET FOOTER CALCULATION(*;Object name;listbox footer sum)

Re: standard action for design mode not working in 17.0

John: I encountered this too. I believe the command changed from the v16R series to a slight difference in v17. The constant had changed. I looked it up in v17 and just used the new command. Jody > On Jul 14, 2018, at 8:18 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I

Re: Objects without Stylesheets suddenly displayed as Wingdings!

Chuck: That sounds like great code module to have in a developer tool kit. If you are willing to share, I would appreciate a copy. Thanks jody > On Jul 12, 2018, at 8:12 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have code that will report on any object on forms

Re: Memory leak with dynamic variables in list boxes?

that just sound like a recipe for headaches, never a good idea to use EXECUTE FORMULA to create process variables. you should be able to confirm with a simple form and listbox that nil pointer does indeed create a new form local variable and that it can reliably be referenced using its object

Re: collection.min() Returns Null

one thing to keep in mind is that this (rules on sorting) does not apply to count() or average() - count does NOT count null, object, collection the doc. says that the method only counts "non-null" values. non-null does not include object or collection - average() does not include null,

Re: collection.min() Returns Null

it is documented. min() http://doc.4d.com/4Dv17/4D/17/collectionmin.301-3730928.en.html says If the collection contains different types of values, the collection.min( ) method will return the minimum value within the first element type in the type list order (see collection.sort( )

Re: collection.min() Returns Null

query() is not the only member function to filter a collection. in your case, you could do something like $cTest:=$cTest..filter("remove_null") where the project method remove_null is C_OBJECT($1) $1.result:=($1.value#Null) 2018/07/27 5:09、Cannon Smith via 4D_Tech

Re: collection.min() Returns Null

Hi Christian, Thanks. The values are a series that need to be graphed. Some values in a series may be null, indicating that the graph line should be skipped at that point since we don’t know what the value is. That’s why I decided to use C_COLLECTION instead of ARRAY REAL to hold the values.

RE: picture of a form

Randy, I think its FORM SCREENSHOT Steve -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy Jaynes via 4D_Tech Sent: Thursday, July 26, 2018 3:38 PM To: 4D iNug List <4d_tech@lists.4D.com> Cc: Randy Jaynes Subject: picture of a form My feeble

Re: picture of a form

Form screenshot -- Douglas von Roeder 949-336-2902 On Thu, Jul 26, 2018 at 1:38 PM Randy Jaynes via 4D_Tech < 4d_tech@lists.4d.com> wrote: > My feeble mind says there is some fairly new command that lets us get a > ‘screenshot’ of the current window or form. > > Can’t think of right words to

picture of a form

My feeble mind says there is some fairly new command that lets us get a ‘screenshot’ of the current window or form. Can’t think of right words to search because I’m not finding anything on KB or searching documentation. Am I off my rocker? Randy

Re: collection.min() Returns Null

Yes, this is expected. You can only do a query() on a Collection with objects. Where do you get these values? You should select before to get only non-null values or remove them from the collection with a For/Each-Loop. -- Grüße/Regards, [heubach-media] | Christian Sakowski

Re: collection.min() Returns Null

As a follow up, I thought I would try to remove the null’s from the collection use collection.query(), but I don’t know what to use for the query string since there are no named object properties in the collection. $cTest:=New collection(100;200;Null;80)

collection.min() Returns Null

I was surprised that the following code tries to return null instead of 80: $cTest:=New collection(100;200;Null;80) $lMin:=$cTest.min() I would have expected that a Null value in the collection would be ignored when looking for the minimum value. Is this what others are expecting or is this a

RE: Feature request thoughts

Command+Tab cannot be used for switching tabs because it is used by the OS for switching applications. The shortcut for switching tabs is Control+Tab to go to the next tab and Control+Shift+Tab to go to the previous tab. -Tim

Re: 4D v11 on Windows Server 2016 (Win 10 Clients)

Anythings possible, but i would bet on some type of problems. If possible I would run with the latest version of v11 I could Regards Chuck On Thu, Jul 26, 2018 at 3:13 PM, Robert ListMail via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have a new project that involves a v11-based system. A new

4D v11 on Windows Server 2016 (Win 10 Clients)

I have a new project that involves a v11-based system. A new system is in development but not ready for production, any possibility of running a v11 system on a new Server OS (Windows Server 2016) with Windows 10 clients? Thanks, Robert

Re: Feature request thoughts

Thanks Jeff. For some reason I was ignoring General and going straight to Methods. Duh! John John Baughman 1331 Auwaiku Street Kailua, Hawaii 96734 (808) 262-0328 john...@hawaii.rr.com > On Jul 26, 2018, at 8:59 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It's

Re: Feature request thoughts

It's in Preferences. > On Jul 26, 2018, at 2:59 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > First off thought there was a way to turn tabbing off, but cannot find it. ** 4D Internet Users Group (4D iNUG)

Feature request thoughts

Working in 64bit on the Mac I am a bit frustrated with tabbed windows. Maybe it’s just me but I keep closing the window instead of the tab I am in. Also moving between multiple tabs is less than convenient when you do not remember where a tab you want is located in the window with a lot of

RE: Does MSC database compact work for large data files?

Are you opening the database first, or going directly into the MSC without opening the database first? I don’t think the cache settings are taken into account unless the database is opened first :-/ I just did a quick test (I tested Windows first; still need to test Mac) and my used memory

Re: Does MSC database compact work for large data files?

By "no longer needed" I was referring to Chip's suggestion of reindexing with SQL. Prior to v15R-release indexes were built in creation order, which made horrible use of the cache. Now it goes in table order which makes it MUCH faster on a large data file. I think I understand the problem

Re: Does MSC database compact work for large data files?

Chuck, > On Jul 26, 2018, at 11:50 AM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I did not. I meanty sql calls, but you are correct, object fields need to > be handled in a different way. That is why I never use object fields. I do > not think 4D should ever create field

Re: Does MSC database compact work for large data files?

I did not. I meanty sql calls, but you are correct, object fields need to be handled in a different way. That is why I never use object fields. I do not think 4D should ever create field types that work in 4D but not in SQL or vice versa. I will not use them no matter how cool they may be. There

Re: Does MSC database compact work for large data files?

> On Jul 26, 2018, at 11:21 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Sometimes it is better to use sql to recreate data file. Now that v16 handles > blob arrays it is very fast. If you mean SQL EXPORT DATABASE, it will not work if the database has object fields.

Re: Does MSC database compact work for large data files?

Hi Jeff, > On Jul 26, 2018, at 11:05 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > No longer needed in v16. A compact will reorganize the data file, and then > do a complete reindex. This is what I'm trying to do that is not working without forcing 4D to quit and reindex

Re: Does MSC database compact work for large data files?

I do not think this will work any longer because A. Indices that point to related records and on related records can not be turned off B. A primary key or in fact any key that is set as unique must have indexing turned on Sometimes it is better to use sql to recreate data file. Now that v16

Re: Does MSC database compact work for large data files?

the issue John brought up was the reindexing process. the cache appeared NOT to be used, and not to be set to large values. >From John 2. Wait for hours and the progress bar finally reaches the last table and is pixels away from the end. Wait for many more hours, nothing seems to be happening

Re: Does MSC database compact work for large data files?

No longer needed in v16. A compact will reorganize the data file, and then do a complete reindex. We do our compacts on 4D Server 64-bit on Windows. We do it on a machine that has enough RAM so that the cache never gets used up. Since version 16 and the latest new-and-improved cache manager

Re: Localization: Simulating another Language

Hi Miyako, I’me sure I read that blog yars ago but had forgotten about it. Thanks for that!!! I have a list of the other itesm from past conversations. Again thanks... John… > On Jul 26, 2018, at 7:22 AM, 4d_tech-requ...@lists.4d.com wrote: > > the very first 4D blog post featured a 3rd

Re: Does MSC database compact work for large data files?

I have not had to do this, but I remember seeing others mention this process. it went something like this: - TURN OFF the indexes through out the database. - let compact do its job - TURN ON indexes through out the database - let database index -- not sure if this is needed/helps but you might

Re: Memory leak with dynamic variables in list boxes?

Hi Michael, As pointed out by Oliver and Kirk, use LISTBOX GET ARRAYS to confirm the object names you think are present in the list box are in fact assigned as the object name to a header or footer. If not, you will get a nil pointer. So, see if the value for "FTR_Names_aT{$Ndx}" is present in

Re: Memory leak with dynamic variables in list boxes?

Michael, On Thu, Jul 26, 2018 at 6:32 AM mferguson--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > We have a memory leak in our v15.6 Windows database and have narrowed it > down to a listbox where the columns are dynamically added using LISTBOX > INSERT COLUMN. > The header and footer variables

Does MSC database compact work for large data files?

I had a very stable 16 user database with 4D 15 32-bit Mac. After upgrading to 4D 16 64-bit Mac (on 16.3HF4), 4D server has been crashing about twice a month. There is no consistency on the process or records involved in the crash. The only consistency is the backtrace of the internal 4D

AW: Memory leak with dynamic variables in list boxes?

Hi Michael, There should not be a need to use Execute, also it is not recommended to do so for declaring/creating new variables during runtime (however, I admit, it can be handy...) When you tested with nil pointers for header and footer variables: could it be that your object names (for

Memory leak with dynamic variables in list boxes?

Hi, We have a memory leak in our v15.6 Windows database and have narrowed it down to a listbox where the columns are dynamically added using LISTBOX INSERT COLUMN. The header and footer variables are nil pointers, in accordance with the documentation. And to reference these variables for the

UTF-8 and SEND HTML FILE with Tags

Hello, I am trying to get the correct output using SEND HTML FILE on a 4D Web Server when the content is Thai characters and it stored in 4D v16.3 correctly. 1) In Design… Database Settings… Compatibility, I have Unicode Mode on. 2) In Design… Database Settings… Web… Options (II), I have Send