RE: poor performance LISTBOX INSERT COLUMN

Hi Tim, Yes, I have opened a tech support case. Gr, Piotr > -Oorspronkelijk bericht- > Van: Timothy Penner [mailto:tpen...@4d.com] > Verzonden: woensdag 6 december 2017 2:24 > Aan: 4D iNug Technical <4d_tech@lists.4d.com> > Onderwerp: RE: poor performance LISTBOX INSERT COLUMN > > > My

Re: Execute on server gotcha

it's probably easier to create and run a proof-of-concept. if you create a set named "test" on the client side, and switch contexts with an EOS method, you would see in the debugger that "test" exists there too. so you can use that set on the server. you really shouldn't care whether the set "exi

Re: Execute on server gotcha

Hi Miyako, Nice post. On Tue, Dec 5, 2017 at 5:01 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > the place to look in documentation is in "Triggers" > http://doc.4d.com/4Dv16R4/4D/16-R4/Triggers.300-3317281.en.html ​OK. Not intuitive but I get the correlation. This is the first

List Box gotcha - Automatic Row Height

This bit me yesterday installing a new DB at a client site. The Automatic Row Height checkbox in a List Box’s Property list requires a 4D View Pro license to work Client/Server. It doesn’t just not work. It disables the list box entirely if you do not have a license. If you have this box check

Re: Execute on server gotcha

READ ONLY is a declaration that applies to subsequent operations. I think that is pretty clear from the documentation. http://doc.4d.com/4Dv15/4D/15.5/READ-ONLY.301-3577015.en.html quote: READ ONLY changes the state of aTable to read-only for the process in which it is called. All subsequent r

Re: Execute on server gotcha

At least with versions of 4D prior to 16, even a READ ONLY will not necessarily release an individual record, local or server. I have ended up making a habit of using LOAD RECORD or UNLOAD RECORD after ending whatever code I am running that edits and saves record(s). The READ ONLY command doesn’

Re: Import error - never mind

Almost immediately after posting my message I noted the option to replace the data instead of append. Voila! Problem solved. John > On Dec 5, 2017, at 5:07 PM, John Baughman wrote: > > I am trying to make a simple example 16 R5 database for tech support and need > to import data from the pr

Import error

I am trying to make a simple example 16 R5 database for tech support and need to import data from the problem database. I moved the table from the problem db to the example DB then exported the data from the problem DB in 4D format. I created a detail form with the form wizard that includes al

Re: Ref: Resize SVG_Use

it depends on the document, but I would create a group in "defs" and apply the scaling and/or translation factor at the "defs" level. you can "use" a "g" in SVG. 2017/12/06 10:56、truegold via 4D_Tech <4d_tech@lists.4d.com> のメール： Are you say that I need to wrap each

Ref: Resize SVG_Use

Hey Miyako, > hurts your brain, doesn't it? Ah a joke! And yes it’s never quite as simple as it seems. Change one thing and effects things downstream. But it does appear hat the svg is working as it’s designed to. I’m just not quite skilled enough yet. > by the way, > your SVG is not wrong, >

Re: Assign multidimensional array

I would not do this "as is", but in theory, it should be possible to append an array like this: ARRAY TEXT($a;2) ARRAY TEXT($b;2) $a{0}:="a" $a{1}:="b" $a{2}:="c" $b{0}:="A" $b{1}:="B" $b{2}:="C" $a:=1 $b:=1 VARIABLE TO BLOB($a;$ax) VARIABLE TO BLOB($b;$bx) CLEAR VARIABLE($a) CLEAR VARIABLE($

RE: poor performance LISTBOX INSERT COLUMN

> My only hope is that 4D will investigate the command. If you haven't already done so, please open a tech support case on taow.4d.com or file a bug report on forums.4d.fr so that someone investigates this for you. -Tim ** 4D

Re: Ref: Resize SVG_Use

this is an SVG question, not a 4D question, but the answer is "yes". if you change the scale in transform then it applies to the coordinates you pass to translate and rotate. it also inherits the scaling resulting from scaling on parent elements as well as the viewBox/viewPort ratio at the top l

Re: Execute on server gotcha

the place to look in documentation is in "Triggers" http://doc.4d.com/4Dv16R4/4D/16-R4/Triggers.300-3317281.en.html quote: • With 4D in local mode, the trigger works with the current selections, current records, table read/write states, record locking operations, etc., of the invoking process.

Re: localisation

Hello, the compatibility page (tab) only lists settings that contradicts the defaults in your structure file. what you see depends on the last version before an upgrade. once you activate the current (or recommended) settings, and then upgrade, that setting no longer appears in the list as you h

Re: localisation

Hi I upgraded from 13.3 to 13.6 and I now have a compatibility tab, but all it has under it is "web" under which is "automatic variable assignment", which is checked. Nothing Else thanks -pm On Tue, Dec 5, 2017 at 8:57 PM, Peter Bozek wrote: > > > On Tue, Dec 5, 2017 at 9:47 PM, Peter Mew wrote

Re: localisation

On Tue, Dec 5, 2017 at 9:47 PM, Peter Mew wrote: > Hi > I dont have a Compatibilty tab, under database sttings. > v13,3 > > you should have it: http://doc.4d.com/4Dv13/4D/13.4/Compatibility-page.300-1226529.en.html -- Peter Bozek

Re: localisation

Hi I dont have a Compatibilty tab, under database sttings. v13,3 thanks -pm On Tue, Dec 5, 2017 at 8:41 PM, Peter Bozek wrote: > > > On Tue, Dec 5, 2017 at 9:22 PM, Peter Mew via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Hi >> I have an app that works fine, when used on a machine running Eng

Re: Execute on server gotcha

> Le 5 déc. 2017 à 21:17, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] it was the result of some EOS methods [...] I think ~90% of my processes start like that since v11: read only on client side, request server to set twin too. If we had a compatibility option to say

Re: localisation

On Tue, Dec 5, 2017 at 9:22 PM, Peter Mew via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi > I have an app that works fine, when used on a machine running English > language. > When run on a machine running German, real numbers get messed up because > the decimal point is a dot and a comma is expect

localisation

Hi I have an app that works fine, when used on a machine running English language. When run on a machine running German, real numbers get messed up because the decimal point is a dot and a comma is expected. what do I need to change, so that the decimal point is a comma and the German language is s

Execute on server gotcha

I use EOS methods a lot. They can make a huge difference since we run over IP connections. As part of my init for new processes I put all tables into Read Only and unlock the ones I need as I go along. You all probably do that too. Every now and then I'd be vexed by occasional locked records. 4D r

RE: Saving an object array to disk

The SAVE VARIABLE and LOAD VARIABLE commands do not support Array variables. The docs say: "WARNING: This command does not support array variables. Use the new BLOB commands instead." > (I’m trying to migrate an entire table for processing selectively in another > structure. I packed each record

[ANN] Innovative Summit Sessions from the 4D Community

Innovative Sessions from the 4D Community 4D Summit 2018 - Washington D.C. Playing Doctor: Using Vital Statistics to Assess your Application’s Health - Dani Beaubien In order to diagnose their patients, doctors have developed diagnostic tools and inventive ways of gathering information. Fo

Re: Server 15.4 crashing on Mac OS X xServe - interpreting spindump?

Thanks for your comments. 4D Server, the application, data and backups are on internal SSDs on an xServe. The application does access text and xml files on a mounted SMB volume. Since upgrading to v15 we’ve noticed some problems with reading and writing to the SMB volume. We suspect this may be

Re: Saving an object array to disk

> On 5 Dec 2017, at 16:18, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > (I’m trying to migrate an entire table for processing selectively in another > structure. I packed each record into respective elements of an object array > then wrot eit to disk with SAVE VARIABLES. No

RE: poor performance LISTBOX INSERT COLUMN

Hi Chip, I understand what you are saying. I did a quick test between append (position = column count + 1) and insert (position = 1) I don't have the feeling it makes a lot of difference. And remember, we are not talking about millions of elements. Maybe then it would make a difference. We are t

RE: Server 15.4 crashing on Mac OS X xServe - interpreting spindump?

It looks like you are running a 32 bit version of 4D Server, and from a mounted volume instead of an actual location: Quote: " Path:/Volumes/VOLUME/*/4D Server 32-bit 15.4.app/Contents/MacOS/4D Server" ^ I would suggest checking and making sure this is installed properly because the

Saving an object array to disk

Hi Has anyone used the SAVE VARIABLES command with an object array ? I am getting crashing when I try to read it back in with LOAD VARIABLES. The test data is tiny so it isn’t size that’s the problem. Just wondering if anyone’s tried it. (I’m trying to migrate an entire table for processing se

RE: poor performance LISTBOX INSERT COLUMN

if I am correct... list boxes should/do behave as arrays. So... you should - no I have not done the testing - that inserting (add to location { 11, 11-> 12 etc). This will/does/should add overhead. If you are inserting - especially blank/empty columns - rather then appending the columns to your

RE: poor performance LISTBOX INSERT COLUMN

Hi Arnaud, Thanks for your thorough test. >That's not surprising, IMHO, it's like concatenation: as the room is filled, >each piece added is harder to arrange than the previous. I understand this, but still I believe maybe there can be some performance improvement in the command. I cannot be

Re: Server 15.4 crashing on Mac OS X xServe - interpreting spindump?

Hi Ron, Thanks for your advice. Nothing has changed for several weeks in the code base and nothing recently regarding arrays. We regularly check and repair with MSC if necessarily and always rebuild indexes when we do. I’m suspecting some i/o problems, perhaps with a volume mounted in SMB. Al

Re: poor performance LISTBOX INSERT COLUMN

> Le 5 déc. 2017 à 12:08, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > --> 4D appreciates much better duplicate at runtime. PS and the .4DB file [size + complexity] too, I guess. -- Arnaud de Montard **

Re: poor performance LISTBOX INSERT COLUMN

> Le 5 déc. 2017 à 10:11, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com > a écrit : > > LISTBOX INSERT COLUMN becomes slower when more columns have been inserted That's not surprising, IMHO, it's like concatenation: as the room is filled, each piece

Re: Server 15.4 crashing on Mac OS X xServe - interpreting spindump?

Paul: Could be something as simple as an out-of-range error on an array; I’ve seen that cause 4D to consume 100% of CPU and then freeze. If any code was recently modified (especially involving arrays), I’d check on that. Also, run Maintenance & Security Center diagnostics and repair any dama

Server 15.4 crashing on Mac OS X xServe - interpreting spindump?

Hi, We’ve have two big freezes in 16 hours on 110 gb database with about 150 users. 4D v15.4 is running on Mac OS X 10.10.5 on an xServe with 16gb RAM and 1tb SSD. There don’t appear to be any issues with the hardware. The Console doesn’t show anything in particular, other than a 4D Server spin

RE: poor performance LISTBOX INSERT COLUMN

hi Alan, Maybe calling the average was a bit misleading after all : So I created a demo database with 1 form On this form I have 12 listboxes with 1 column On load of each listbox I insert 20 columns with LISTBOX INSERT COLUMN Inspecting the 4D debug log I am seeing something I did mention below