(Offish) RE: NB: Pre-emptive mode hassle

> Nobody likes when someone says “what’s wrong with you? You are a weirdo for > not > thinking of this.” > > you are going to catch a lot more flies with honey than with vinegar. Give it > a > try you are going to find it really does work. > Who do you want to talk to or listen to? A “nice

Re: Min/Max for Date Fields in 4D

> Le 12 oct. 2017 à 00:39, Alan Tilson a écrit : > > Arnaud, > Max & Min don't work for date fields or date arrays it seems. I get values > like 5.67746e+17? Is there a way to translate this to a date? Date field is 8 bytes since v11 (most probably date+time), I suppose there is a way to conv

Re: Min/Max for Date Fields in 4D

for what it's worth, it works on Japanese version too. but the selection must not be empty, because in that case you would be attempting to assign undefined to date. 2017/10/12 18:12、Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> のメール： That screen copy is a sel

Re: Min/Max for Date Fields in 4D

> Le 12 oct. 2017 à 13:07, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > for what it's worth, it works on Japanese version too. I added a comment in livedoc for doc team, time will tell… -- Arnaud de Montard

ALP Change Crashing 4D

Hello, I seem to be having a brain-fart this morning regarding ALP. I've designed a screen with two ALP objects. I need to make a change to the one ALP object in that I'm currently using a LONGINT array, which needs to be changed to a REAL array. I made all the necessary changes, and when I run

Re: ALP Change Crashing 4D

Hello Steve, We can probably help you in the professional tools forum. It may help if we know the exact versions of ALP and 4D that you are using :-) Best regards, -- Phil forums.e-node.net > On 12 Oct 2017, at 15:48, Stephen J. Orth via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hello, >

Re: Print From Web Area

Hi Kirk, What command would I use to invoke the printing in the first place? -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Oct 11, 2017, at 5:11 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If the web area isn't using the WebKit it's

Re: ALP Change Crashing 4D

Hi Steve, The only time I've seen something like that is when an array isn't filled as expected. Maybe the array type is changed by a selection to array (interepreted), or there is something inconsistent about the declaration and the filling. It's been a long time, but we've seen cases where a sel

Re: Min/Max for Date Fields in 4D

Distinct values ? sort (resulting) array get first and last element On Wed, 11 Oct 2017 17:30:01 -0400, Alan Tilson via 4D_Tech wrote: > Greetings everyone, > > Is there a way to get the earliest and latest dates from a selection of > records similar to using Min/Max for numerical data? > > I ha

Re: Min/Max for Date Fields in 4D

Alan, I haven't followed this thread closely, so apologies if I say something silly. * Is it important to optimize this operation past the sensible solution you've already tried? * Since you already have a sorted selection, why no use that and SELECTION RANGE TO ARRAY? So, use SELECTION RANGE TO

Re: Min/Max for Date Fields in 4D

> Le 12 oct. 2017 à 18:10, David Adams via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Alan, > > [...] > > * Since you already have a sorted selection, why no use that and SELECTION > RANGE TO ARRAY? So, use SELECTION RANGE TO ARRAY to get a single value from > the first record, that's your

Re: Print From Web Area

> What command would I use to invoke the printing in the first place? have you tried this? Regards O r t w i n Z i l l g e n -

v13 - odd compiler error

I have a method, which takes 3 parameters When I try to compile... - Generate typing -- OK - Check Syntax -- OK - Compile 0: The parameter $4 could not be typed ... 0: The parameter $42 could not be typed as this is a component, there are no calls to this method in the database. Any Ide

Re: Min/Max for Date Fields in 4D

On Thu, Oct 12, 2017 at 6:57 AM, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > It's a solution if the selection is huge (is it?). But sort selection > (I've always found 4d sort is slow), then 2 selection to array, that's 3 > server calls, at end. I'd prefer selection to array (

Re: NB: Pre-emptive mode hassle

> Also trying to justify reducing the size of the process variable table. > Supposedly having 1 - 10 object variables was far superior to 100 process > variables. Who the hell cares if your process variable table is 1MB in size > when everyone has over 4,000MB to work with? And don’t try to say “it

Re: Min/Max for Date Fields in 4D

​Thank you everyone for your continued input on my question! I was pretty satisfied with the sorting approach but distinct values might be an interesting approach! I just ran another test on 240k records first using the approach that sorts the records and then using the selection to array approach

Re: NB: Pre-emptive mode hassle

Right, about the custom code scanner/pre-processor/compiler macro idea, I forgot to mention that you could use such a tool to remedy problems in 4D. For background, some of this takes a syntax in your code that enables you to identify the following: -- Required parameters -- Optional parameters --

Re: v13 - odd compiler error

Check if there is a typo and you've declared $43 instead of $3. The errors you describe are almost exactly what I would expect in this case. Not that I've ever done anything like that...but it happened to a friend once or twice. **

Re: Min/Max for Date Fields in 4D

​Another interesting point is that with a larger selection of 446.5k records and a warm database I got: 3 ticks for DV approach 6 ticks for the record sorting approach and on a warmed up indexed longint field​ 23 ticks for Min then Max, the 4D functions So our DV approach is faster than the 4D func

Re: v13 - odd compiler error

well your "friend" ;) was right... DUH! c_pointer($43; of course, I have copy pasted, into a new method window, deleting the original, compacted, and had *just* finished manually retyping the method (not long fortunately)... On Thu, 12 Oct 2017 10:26:01 -1000, David Adams via 4D_Tech wrote:

Problem with ZINT Plugin

I’m having problems with Miyako’s ZINT plugin that creates barcodes. It works great on macOS 10.10 with 4D v16 R3. But it fails to work on Windows 10. It does not return an image. Does anyone see anything wrong with this code: C_TEXT($textData_t;$barcode_t) ARRAY LONGINT($optionNames_al;0) ARRA

Re: Print From Web Area

Hey Cannon, I would enable the context menu and let the user invoke printing with a right click on the web area. You can control access to the inspector with the web area parameter. On Thu, Oct 12, 2017 at 7:04 AM, Cannon Smith via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Kirk, > > What comma

Re: Min/Max for Date Fields in 4D

> Le 12 oct. 2017 à 22:00, David Adams via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > you would want to balance the cost of pulling more data over the network in > once call with pulling tiny bits of data over the network with multiple > calls. I'd say it doesn't matter in LAN. But in WAN,

Re: Min/Max for Date Fields in 4D

> Le 12 oct. 2017 à 16:44, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Distinct values ? > sort (resulting) array > get first and last element Hi Chip, best idea, DV is a must. But the sort is useless, the resulting array is sorted. -- Arnaud de Montard ***

Re: Min/Max for Date Fields in 4D

> Le 12 oct. 2017 à 22:37, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > ​Another interesting point is that with a larger selection of 446.5k > records and a warm database I got: > 3 ticks for DV approach > 6 ticks for the record sorting approach Guessing… Only twice more for t

Re: Min/Max for Date Fields in 4D

It is CS actually! All my testing was CS. Alan sent from my Note 4 On Oct 12, 2017 6:40 PM, "Arnaud de Montard via 4D_Tech" < 4d_tech@lists.4d.com> wrote: > > > Le 12 oct. 2017 à 22:37, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > > > ​Another interesting point is that with a l

Re: Min/Max for Date Fields in 4D

There are plenty more variables to consider that could make a huge difference in performance. If the table is large (say 20 million records) and the selection size is above a certain size (roughly 15,000 records), DISTINCT VALUES is very slow for b-tree indexed fields. I'm seeing times over 10 s

Subrecords with subrecords

New client with a database to update to v16. It's currently running in 2004. But it has subtables with subtables, which, as I'm discovering, isn't really supported in 2004. So, how did they do that? That is, run a compiled database in 2004 that has a two level deep subtable? And, is there a way t

Re: Subrecords with subrecords

I recall Josh Fletcher presented that exact scenario just after v11 came out. Nested subtables were possible in 4D v2 (or something like that). > 2017/10/13 10:07、Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> のメール： > > New client with a database to update to v16. It's currently running in > 2004. B

Re: Subrecords with subrecords

It was in 4D v1. > On Oct 12, 2017, at 6:59 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I recall Josh Fletcher presented that exact scenario just after v11 came out. > Nested subtables were possible in 4D v2 (or something like that). > >> 2017/10/13 10:07、Lee Hinde via 4D

Re: Subrecords with subrecords

Lee, I assume you mean migrate the data out of that structure and into a brand new one? I'd say the thing to do is look at the result of opening it in v16 - which you already did and said the nested subtable isn't even there. So now add that table yourself linking as appropriate to the new table 4

Re: v13 - odd compiler error

Chip Ah..The joy of auto declared variables removes this problem for me..so much that when i work on databases that don’t do the declarations for me it is a pain. Nigel Greenlee > On 12 Oct 2017, at 22:36, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > well your "friend" ;) wa