RE: Connection is broken, cannot receive request reply

Hi David, Do you have a managed switch on this network?, it is possible for a switch to close a connection with no traffic, which could also result in this message. The usual wisdom dictate having the timeout set to less than the switch/router timeout to prevent the port closing without the ap

RE: Slow characters visualization

Ferdinando, There was an issue with memory leak in some versions that exhibit similar behaviour. I know the issue existed in v16 (fixed in one of the NB), returned in 16r3 and 16r4, and it's been since fixed in 16r4 build 215501, but I don't know if it effected any v15 releases too. To verif

4D dev/manager position available in Nepal

Hi everyone, Ever felt your life was lacking a bit of purpose, or needed a bit of a challenge? Well… we have an opening for someone experienced with 4D to work in our Nepal office for a one year (or possibly longer) contract. We have 7 full time developers in our Kathmandu office who would love t

Code signing Mac (again)

Hi, we can sign our Mac single user app by building with code signing off, and then removing extended attritbutes with xattr -cr mSupply385.app Then we run the 4D supplied codesign.sh script and it reports success. However, after that if we do codesign --verify --verbose=4 mSupply385.app We get:

[solved] Code signing Mac (again)

Hi everyone, Just a quick note to save others years of aging… if you’re having trouble codesigning your mac app, make sure that the Developer Certificate in your Keychain is not set to “Always trust” - it must be set to “System default” Thanks to Christian Kaesbach for some off-list help. Cheers,

4D 15r5 won't run on Windows 10 pro (2018)

Hi, we’ve just configured 3 Windows 10 computers and they won’t run 4D 15r5 (both client and 4D single user) Windows 10 install disk from 2016 works. Has anyone seen this with new Windows 10 installs? (We’ve tried all the usual DEP and UAC suspects) With thanks, Craig - Susta

RE: Confused about ORDA

Rudy, I think part of the reason might be that with ORDA you actually have the data loaded and ready to use in the resulting collection, where as with QUERY you have a selection of records, but to use any of the data you still need to load it somehow. Also, using QUERY, regardless of speed, al

RE: ORDA question: how do I add related fields to an entity selection?

Hi Julio, You need to name your relations, which then shows up as an entity in your collection, containing the related data. Assuming a table named A and a relation to table B named My_B_Link, after loading a selection of table A into collection My_Col, you can get your related data from table

RE: Export text columns containing carriage returns to Excel?

What are you using to do the export?, 4D export functionality, quick report or something else? If you are using 4D export, just change the EOL char to something else, the use that char as the line delimiter when you open it in Excel. Another option is to export it in DBF format, then import it

RE: Help please - Compiling

Hi Chip, You declare the longint var as "$sze", then use "$Size" which is undeclared. As far as the error on the sort array, the ascending operator is optional and is the default value anyway, omitting it does compile without an issue. However, if you need the sort to be Descending, this workar

RE: How to show subtotals in a list box

Hi Dani, Take a look at hierarchical list box. The idea is to insert a line at the end of each break and present the subtotal there. You could also present the subtotal in the top line, allowing the user to suppress or show the details under that group. Cheers, Lahav -Original Mess

RE: Line count - compiled component vs interpreted

Hi, From what I was able to decipher in similar instances, it seems to be the line number in the method that calls the component method. It's very (un)helpful and it's even worse if you do have more lines in the component method, as you can spend a lot of time trying to debug something like $i

RE: Storage + New shared object

Hi David, First Both, $DeleteRecord_ob and $DeleteRecord_PN_ob must be a shared objects. Also, it seems that shared objects do not accept arrays. Convert the arrays to shared collections instead. This should work: ARRAY TEXT($DeleteRecord;Get last table number) ARRAY LONGINT(

RE: Shared Object - NOT!

Hi Pat, In order to share an object between processes without using an interprocess variable, you must use the "Storage" container/catalog. In your startup: Use(Storage) Storage.TriggerState:= New shared object End use Later in your subsequent code, you assign the contents: $MyTrigger:= Stor

RE: v16R6 Crashing on Compile

I have the same issue. I have found that I have to close all open windows in the structure to avoid the crash. The same structure compiles without an issue in v17 without closing anything. HTH, Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jim Hays

RE: 4D Server - Not letting go of users

Hi Randy, I see this quite a bit, and it has something to do with the new network layer. I have reported it to tech support, but never really saw the issues resolved. The problem goes away if I use the legacy network layer. Cheers, Lahav -Original Message- From: 4D_Tech [mailto:4d_te

RE: Anyone using v16 in WAN

Of the sites we are running at, all but the smallest ones exhibit the same slowness, non-responsiveness after several days (number of days depended on usage load), logged off clients not clearing from the server and occupying licenses. We can actually see the system response time increase as mo

RE: Anyone using v16 in WAN

Of the sites we are running at, all but the smallest ones exhibit the same slowness, non-responsiveness after several days (number of days depended on usage load), logged off clients not clearing from the server and occupying licenses. We can actually see the system response time increase as mo

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

Hi Kirk, The issue is the inability to use any of the automatic footer calculations such as SUM or AVG in a footer of a numeric column, since regardless of what type the column is, the dynamic footer variables are always of type Text. This is how I have it working (Yes, it's ugly and there migh

RE: Schemes for record level access control

Hi Kirk, I'll get back to my usual NUG posting -- Private 😊 I think it depends on what you need to do, and how "general" it needs to be. I have a system that is accessed by multiple business entities, where most are limited to their own records, while one can "see" all records. In this case,

HTTP Get when a domain name returns multiple IP addresses

Hi, we’re running a serverless API using Amazon Lambda, and 4D seems to fail on the DNS lookup as it returns multiple IP addesses A dig gives you api.universalcodes.msupply.org.nz. 25 IN A 52.84.207.226 api.universalcodes.msupply.org.nz. 25 IN A 52.84.207.186 api.universalcodes.msupply.o

Re: HTTP Get when a domain name returns multiple IP addresses

Hi Miyako, > On 10 Jun 2017, at 7:00 AM, 4d_tech-requ...@lists.4d.com wrote: > I would invite you to test the latest nightly build which fixes ACI0096586 > http://bugs.4d.fr/fixedbugslist?Branch=16 > "HTTP Get" request fails with certain https web sites That didn’t work, but we found (we think) i

RE: Pasting Spreadsheet Data into 4D Records

Alan, Take a look at XL Plugin from Pluggers (https://www.pluggers.nl/product/xl-plugin/). It is an excellent tool for working with Excel, writing or reading directly. HTH and happy holidays, Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Alan Tils

RE: Denver Area Developers

Hi Tom, I am there practically every other week, but only at the airport while waiting for a connecting flight, does that helps? 😊 Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Tom Dillon via 4D_Tech Sent: Friday, February 22, 2019 1:46 PM To: 4d_tec

RE: issue with invisible button

Chuck, The button with the assigned 'Enter' key will take precedence over the default settings of 4D global shortcut keys (see Setting/interface/shortcuts). When you disable your button, or make it invisible, the default shortcut is no longer trapped and is validating the entry. Lahav -Or

RE: Arrays in objects

Jeremy, $o.array[1] will do it. Take note of the square brackets, and be aware that the index starts from 0, not 1 However, what you are trying to do can be accomplished much easier using a key pair object without a matched arrays. Before: Array_Names{1} = "Tag_Name" Array Values{1} = text

RE: Complex graph

Ferdinando, Send me a private email for a code demo on how to do it. Lw at xsitra period com -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of stardata.info via 4D_Tech Sent: Thursday, June 27, 2019 1:30 AM To: 4d_tech@lists.4d.com Cc: stardata.info Subject:

RE: 4D over different platforms

Set up a terminal server running Parallels software, then run a client on that machine, with settings to allow for the different screen size/resolutions you need to support. Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of stardata.info via 4D_Tech Sen

RE: Active Listbox/Form while listbox dynamically built

John, An easier way to think of CALL FORM is to look at it as the old ON OUTSIDE CALL event in a form, but with the added bonus of being able pass data to the form as parameters from the calling process, without using global variables. Cheers, Lahav -Original Message- From: 4D_Tech <4

RE: Active Listbox/Form while listbox dynamically built

Hey John, You are actually calling a method that runs in the context of the form window. You don't need to trap for an event, the method just runs and does whatever it needs to do in the context of the form. For example, if you only need to add a row to an array on the form, write a method "I

RE: How can one REDRAW a SUBFORM that uses a OBJECT as its 'variable or expression'?

All you need to do is to assign the entity selection object to itself to trigger an update, as in Form.my_Entity_List:= Form.my_Entity_List Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chris Belanger via 4D_Tech Sent: Tuesday, March 10, 2020 7:03 P

RE: one server window on client

Chuck, Just to make sure, you are executing that command on a client, not on the server with a stored proc or Execute on server right? Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via 4D_Tech Sent: Tuesday, April 14, 2020 1:17 PM To:

RE: one server window on client

Did you try clearing the local resources and start over?, we have had unexplained issues on specific machines that went away when we started fresh. Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via 4D_Tech Sent: Tuesday, April 14, 20

RE: 4D v18 — Need methodology to

Chris, Just create a regular method, mark it as "Execute on Server" in the method properties, then call it just like any other method. You can return anything you want in $0 $myData:=ThisMethodRunOnServer(whatever) Just make sure to check that little box in the ThisMethodRunOnServer Method p

RE: Using the length parameter in a ORDA query.

Take a look at FORMULA and eval() syntax in queries... Lahav -Original 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 lengt

RE: Object notation replacement for use of Self in a script — v18

OK, so can we get a real example of how to replace the *old* way with the new? In a case where there are several entry objects: Form.Name Form.Address Form.Note I want to enforce a proper uppercase/lowercase on all three, so in the old days I created an object, set the method to "UpperLower(se

RE: Object notation replacement for use of Self in a script — v18

Did you actually test this?, any kind of a get pointer on a form object having a dot notation source will return a Nil pointer, regardless of the name matching or not. If you are using matched names, you could use the following: Form[Object get name(object current)]:=DoWhatever(Form[Object get

RE: Object notation replacement for use of Self in a script — v18

CDI > On Apr 30, 2020, at 3:45 PM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Did you actually test this?, any kind of a get pointer on a form object > having a dot notation source will return a Nil pointer, regardless of the > name matching or not. >

RE: Object notation replacement for use of Self in a script — v18

com> > wrote: > > 18.1 > > The pointer OBJECT Get name(Object current) is to the entity instead of the > to the entity attribute. > > The field is eg, MyEntity.MyName, but the pointer to the form object > ends up being ->MyEntity > >> On Apr 30, 2020, at 3:5

RE: Object notation replacement for use of Self in a script — v18

OK, based on this design, we are back to using variables (or dynamic variables) for data entry of anything that needs any kind of processing done to it after an entry, having to load the values to these data entry objects when loading the form, and copying the values back when we want to save an

RE: Object notation replacement for use of Self in a script — v18

ic code." -- Douglas von Roeder 949-910-4084 On Thu, Apr 30, 2020 at 3:03 PM Randy Kaempen via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > On Apr 30, 2020, at 4:43 PM, lists via 4D_Tech > > <4d_tech@lists.4d.com> > wrote: > > > > OK, based on this

RE: Object notation replacement for use of Self in a script — v18

Kirk, I have one word that will do all of what we are after : "This" It works in listbox, which is a form object, any reason it can't be extended to other form objects? Again, I don't think anyone on this thread is complaining, we are just trying to understand how to use the new functionalit

RE: Object notation replacement for use of Self in a script — v18

ooks Subject: Re: Object notation replacement for use of Self in a script — v18 Lahav, On Fri, May 1, 2020 at 1:51 PM lists via 4D_Tech <4d_tech@lists.4d.com> wrote: > I have one word that will do all of what we are after : "This" > Damn - I wish I'd said that. >

RE: Object notation replacement for use of Self in a script — v18

method : Execute method(Current method name;…. Cordialement, Bernard Escaich > Le 29 avr. 2020 à 19:15, lists via 4D_Tech <4d_tech@lists.4d.com> a écrit : > > OK, so can we get a real example of how to replace the *old* way with the > new? In a case where there are severa

RE: Generic code for entity selection projection

Steve, One way to do it is a bit convoluted, but will do what you want: $Params:=split string($YourText;".") Case of :($Params.length=1) $collection:=$employees[$Params[0]] :($Params.length=2) $collection:=$employees[$Params[0]] [$Params[1]] :($Params.length=3) $collection:=$employees[$Params[0]

RE: Pluggers XL_Plugin Format Question

Ken, You build the format and assign the different attributes to it (one of which can be the locked flag, a font etc). $ YourDefinedFormat:=xlBookAddFormat ($xlBook) $font:=xlBookAddFont ($xlBook) xlFormatSetFont ($YourDefinedFormat;$font) xlFontSetName ($font;"Arial") xlFontSetSize ($font;10) x

RE: Pluggers XL_Plugin Format Question

s like a spectacular plugin." I agree. The XL Plugin is an excellent product. -- Douglas von Roeder 949-910-4084 On Thu, May 28, 2020 at 3:57 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote: > Awesome, thank you! > > > > On 05/28/20 1:46 AM, lists via 4D_Tech wr

RE: PING of life...

I'm not on here, so I wouldn't know 😊, and Jörg, carful with labeling us dinosaur/old timers, we are just well seasoned. Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of THOMAS BENEDICT via 4D_Tech Sent: Wednesday, January 13, 2021 3:13 PM To:

RE: PING of life...

" back in 21016"??? Is that back to the future? 😊 -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of SPC via 4D_Tech Sent: Saturday, January 16, 2021 2:53 PM To: 4d_tech@lists.4d.com Cc: SPC Subject: Re: PING of life... Thanks all for your prompt and thorou

RE: v18 Background Image / Win32API

Win32api is alive and well. Download the latest version https://github.com/OrchardSoftware/4D-Win32API and read the docs... Lahav -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keisuke Miyako via 4D_Tech Sent: Wednesday, June 23, 2021 6:44 PM To: 4D

RE: ON ERR CALL

Look at the GET LAST ERROR STACK command. Also, these variables will give you that information also: Error (#) Error method Error Line Cheers, -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of stardata.info via 4D_Tech Sent: Wednesday, August 16, 2023 10:07

Apple Push Notification Servers (APNS)

Hello, Anyone having any luck sending notifications to Apple's Push Notification Servers? I'm getting mixed results when I try to POST the HTTP REQUEST: in v16.4: Error code: 49 SSL internal error : error:14094418:SSL routines:ssl3_read_bytes:tlsv1 alert unknown ca component: 'srvr' in v17.0:

Re: Apple Push Notification Servers (APNS)

elated to a keep-alive error (* > as the last parameter) in the HTTP client implementation, but it appears you > are not using that option. My work-around was to just retry the request which > seemed to work. Might be worth a try. > > John DeSoi, Ph.D. > > > > >>

ORDA - NOT(IN)

Hi All, I'm generally in love with ORDA, but: Now assuming that the field "entityUUID" is populated (no null values), How come I get different results with: $vC_uuidsToIgnore:=New collection() $deletes:=ds.SyncDeletes.query("NOT(entityUUID IN :1)";$vC_uuidsToIgnore) $deletes -->

Re: An API for my 4D app

We provide API resources just by using the web extension and returning JSON to validated queries. For example a customer device might make a request like: https://online.myDomain.ca/4DACTION/API/API_GetAssets?key=8B99FB68&criteria=new&pretty=yes

Re: ORDA - NOT(IN)

) > > Remove the parenthesis so you have: > $vC_uuidsToIgnore:=New collection > > See: https://doc.4d.com/4Dv18/4D/18/New-collection.301-4505843.en.html > <https://doc.4d.com/4Dv18/4D/18/New-collection.301-4505843.en.html> > > Best regards, > Jeremy French > > > >

Re: ORDA - NOT(IN)

Yup, add any dummy element of any kind (since a collection can be mixed) and you have a work-around. You could instead bypass the query if the search collection is empty, that would be logical, might even be (insignificantly) more efficient . Keisuke mentions a potential issue about "runtime"…

Re: ORDA - NOT(IN)

Yup, that's my bug! [ ] # Null Cheers, Tom > On Mar 26, 2020, at 5:52 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > remember this discussion? > > good news! common sense prevails! > > https://urldefense.proofpoint.com/v2/url?u=https-3A__bugs.4d.fr_fixedbugslist-3Fbra

Re: Active4D/ObjectTools with 4D 32-bit

We plan to have 32-bit clients for the next 6-12 months, running v16. I am actually encountering an error trying to launch v16.5 Server, 64-bit, on 64-bit Windows 2012r2. Any call to an OT method, including the register method, generates an error: Incompatible version. You need to upgrade your pl

Re: Active4D/ObjectTools with 4D 32-bit

Aparajita, You're right on the QLM - my mistake, I had too many notes with all my issues -- apparently I have TONS of issues right now. I will give a try with the Windows update and report back. Was interesting that the 16.4/5 releases have the issue, while the 16R5/6 do not. On Fri, May 24, 201

Re: Active4D/ObjectTools with 4D 32-bit

Aparajita - no joy on that try. Server had 2017 (14.1) installed, so uninstalled those, installed the 2015, restarted, and seeing the same issues. Error in v16.5, OK in v16R6 (both 64-bit). Assistance always much appreciated! On Fri, May 24, 2019 at 2:22 PM Aparajita Fishman via 4D_Tech < 4d_tech