Questions about the 'Sum' function

Hi Occasionally I’d like to use the “Sum” function on a current selection but am hesitant because of distant memories of it only being supported in certain circumstances (e.g. in reports, on single user.not client server etc). Do people use this outside of a report context and on any current

Re: Questions about the 'Sum' function

On 12 Apr 2017, at 13:29, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> wrote: > Sum has always worked on a series Thanks Sujit. But what’s the definition of a ‘series’ ? Does a field from a current selection qualify as a ‘series’ ? Peter

Re: Migrating Tables with Relations Between Structures

Hi John Thanks for that suggestion. I tried that but in a complex structure it’s quite a footery and unsystematic process. You’ve got to identify tag blocks indirectly by UUID and so on and I found it didn’t save much time over just redrawing the relations manually. It probably works better

Re: Migrating Tables with Relations Between Structures

Many thanks Miyako ! I’ll look into both of those approaches. Very promising. Peter On 6 Apr 2017, at 02:37, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> wrote: > when you copy multiple tables in the structure editor, > you get the table as well as the relation. > > pasting it back to

Re: [OFF] Hardware advice Was: 4D World Tour 2017

On 5 Apr 2017, at 19:52, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> wrote: > If it was my personal money, I'd probably find a used MacBook Pro from 2014 > or 2015, fully loaded. If the purchase is part of a budget, I'd wait for the > forthcoming "Kaby Lake" revision to the MacBook Pro

Re: Clean Slate - Modern User Experience.

On 15 Apr 2017, at 09:49, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com> wrote: > Where could I go to see samples of what folks are doing with 4D which brings > the UI into the modern era? Any thoughts? Doesn’t the O/S define ‘modern era’ ? If you stick to vanilla 4D objects (i.e. just the

Re: Components: How do you reuse utility code?

On 21 Apr 2017, at 02:44, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > I think we sometimes forget that 4D is not a 3GL programming language like C > or C++. 4D is a 4GL language. You don’t get all the feature, benefits and > capabilities of a 3GL language in a 4GL language. Remember

Copying forms between structures: No 'Use Object with Same Name' option

Hi I’ve always wondered why this option is available when copying tables between structures but not when copying formats. It would save an enormous amount of time since every time you copy a form you have to manually go through the same formats over & over again mapping them to the format

Minute of Silence for the "Altura Toolbox"

Being something of a “4D fossil” myself as one of our more celebrated peers once put it, I couldn’t help raising an eyebrow at the quietly announced retirement (see 4D Blog) of an equally entrenched but possibly far more productive contemporary and felt I couldn’t let this news pass without at

Arrays vs Object for Key/Value pair lookups

Hi I remember at last year’s summit, JPR was emphasising how objects were far more optimised than arrays for doing lookups over large numbers of key value pairs. e.g. we usually do this: $x:=find in array(myKEYS;”product_code_x”) if($x>0) $0:=myPRICES{$x} end if How do people prefer to do

Re: Arrays vs Object for Key/Value pair lookups

On 17 Jul 2017, at 17:03, Herr Alexander Heintz via 4D_Tech <4d_tech@lists.4d.com> wrote: > so I queried for the language I needed and then > apply to selection([dict];ob set(<>Dict;[dict]WordKey;[dict]Word) Ah ! So you just ‘hoover up’ into your dictionary object. Like a hoover ? Peter

Re: Use of Objects vs Global Variables (Was 'Arrays vs Objects...)

Well, I’m afraid I’ll have to take the pariah role here and politely disagree with you all :-)) - or at least present an alternative perspective in which “globals” play a very powerful and unique part. Lets think this all through for a moment. As is relevant to this topic, we can notionally

Re: Use of Objects vs Global Variables (Was 'Arrays vs Objects...)

On 21 Jul 2017, at 16:48, David Adams via 4D_Tech <4d_tech@lists.4d.com> wrote: > * No. You do not need classes. Modules do not require OOP, OO came out of > earlier work and embraced modules and extended them. I'm just talking about > module-level scope and data hiding, not OO Ok, you could be

Re: Arrays vs Object for Key/Value pair lookups

On 20 Jul 2017, at 11:39, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote: > In case of an object, the properties are 'indexed' by using an internal Hash > table, so the access to one particular Property doesn't need a sequential > parsing of the list of values, but an almost direct access. I

Re: Nested transactions - most appreciated feature

On 2 Jul 2017, at 00:12, Alan Chan via 4D_Tech <4d_tech@lists.4d.com> wrote: > It's a great feature if long transaction that holding up records isn't an > issue to your operation. Of course, make sure no one would take coffee in the > middle of a transaction:-) Hi Alan They execute in

Re: Nested transactions - most appreciated feature

On 2 Jul 2017, at 18:44, Alan Chan via 4D_Tech <4d_tech@lists.4d.com> wrote: > If there's no UI, why you need nested transaction? I’ve never considered transactions as a UI tool (mainly because it’s a bit of a nightmare matching the scope of the opening and closing points) but I acknowledge

Nested transactions - most appreciated feature

Hi Sorry to be late to the party on this. It always takes me about 5 years to start using a new feature of 4D with gusto. I tend to believe that if I’ve worked around some deficiency for years then suddenly having to *not* do so is too good to be true and that there must be some catch. In

Re: Components: How do you reuse utility code?

Jim - I read all of your post with interest. But with respect, IMHO it really does not do the least bit of justice to the real world applications that 4D’s component architecture is designed to address. Nor does it reflect the practice of a component based development paradigm. For example

Re: Getting component to update

On 24 Apr 2017, at 22:50, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> wrote: > I opened another method to publication. Hi Chip When you made the change the first time, was the host structure still open ? TRY: • open the component structure only • un-publish the method • re-publish it

Re: How to trap a form save keystroke in an object method ?

On 18 May 2017, at 05:50, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> wrote: > Get rid of the auto save action. Then you can handle what ever situations you > need to. We have not used auto action buttons for 25 years. Hi Jody I have actually done that. It isn’t the problem here though - the

How to trap a form save keystroke in an object method ?

Hi I rarely come across this problem. Lets say you have a field with an “On Data Change” object method which does field level validation that rejects an entry. Lets says the form has a default button and the user clicked the “Big Enter” key (on the numeric keypad) which invokes a ‘save’

Re: Components: Running uncompiled?

On 4 May 2017, at 12:33, David Adams via 4D_Tech <4d_tech@lists.4d.com> wrote: > I'm still working away on my components and I have another remedial > question. I'd really like to be able to trace through a component while in > the host. Sometimes this works, sometimes I get complaints Hi David

Re: oh sweet

> On 6 Oct 2017, at 17:54, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > How long have i wanted this…. +1 Nigel ! ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: [offish]Volume of mail

> On 5 Oct 2017, at 21:15, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We have a lot of 4D developers working here, but I'm on the only who > participates actively in the list. Also, 4D has a lot fewer "issues" these > days than in the old days. I’m probably in this category

Tip: Exporting to a target folder in a package

Hi I have XLIFF applications that generate stuff like custom constants and language resources. Unfortunately, if you use 4D’s desktop navigation commands like “Create Document(“”)” or Select Folder and the like, to allow the user (me !) to locate the target folder for the export, it doesn’t

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

Re: Saving an object array to disk

> On 5 Dec 2017, at 20:45, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The docs say: "WARNING: This command does not support array variables. Use > the new BLOB commands instead." Thanks Tim Didn’t see that. > > Why don't you just use SQL EXPORT SELECTION and SQL EXECUTE

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

Re: Tip: Exporting to a target folder in a package

> On 24 Oct 2017, at 12:39, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Have you tried Select document? It lets you navigate inside of packages. > On 24 Oct 2017, at 12:48, Koen Van Hooreweghe via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Select folder allows you to

Re: Time Machine error -8003 when restoring 4D structures

Ah ! Good idea. That’s the kind of thing I’d think of for my clients but never myself ;) Thanks for the tip Charles. Regards Peter > On 18 Jun 2018, at 23:01, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It does. How about using 4d backup and then backing that up.You could

Time Machine error -8003 when restoring 4D structures

Hi MacOS 13.13.5, High Sierra on a recent Macbook Pro. I’m getting this error when attempting to restore 4D structures from a Time Machine archive. It’s not just one - several of the archives have it but it only seems to apply to 4D structures. If I try to restore other things - like text

Re: Docs about "twinned" process and pre-emptive mode

> On 19 Jan 2018, at 04:10, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > are you familiar with the request log file? > > you will see a P (for preemptive) or C (for cooperative) indicated for each > network request. The log file seems to do this for everything *except* the

Re: Docs about "twinned" process and pre-emptive mode

Ok, I dug out an old laptop which had a lot of interesting discussion on this from 2011. What I’m wondering is if triggers can now run pre-emptively (if they are compliant code-ways: no IP variables etc). In 2011, David Dancy said that any regular 4D code whatsoever would force the method to

Re: Docs about "twinned" process and pre-emptive mode

Thanks Miyako. That’s useful. I basically was wanting to know if inline SQL used the “twinned” pre-emptive thread or not. Peter > On 19 Jan 2018, at 04:10, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > are you familiar with the request log file? > > you will see a P (for

Re: Roy (Suzi) McGregor Paterson R.I.P

I am very sorry and taken aback to hear of this. I can only imagine that he was subject to illness as it seems premature. I always chatted to Roy at meetups going right back to the 1992 summit in the Meridien Montparnasse at the launch of 4D server when I remember him telling me he was

Docs about "twinned" process and pre-emptive mode

Hi I’ve been raking through the online documentation trying to find where the querying modes pre-emptive / co-operative are documented but have been unsuccessful. What I’m specifically looking for is more background on what conditions SQL queries use the twinned pre-emptive process for

Re: 4D Summit 2018 Comments

> On 9 Apr 2018, at 21:25, Richard Wright via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I’ll be interested in learning how this differs from Views, not necessarily > 4D’s rather simplistic implementation, but something like Oracle’s, along > with their very powerful SQL implementation. Hi

Re: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen

Hi Alexander Thank you for passing on this news and I’d like to add my condolences and deeply felt sadness at the departure of such a creative and appreciated contributor to the 4D community. I had occasion to liaise with Ortwin on a couple of projects and his input was always spirited,

Re: Longing IDs or UUIDs as primary key?

> On 24 Oct 2018, at 16:52, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > The process seems quite cumbersome: to start, I need to remove the ‘primary > key’ flag from all the ID fields Rudy - Just to add to the many useful contributions made so far, I found a way to

Backing up a VM - is it dangerous ?

Hi One of my sites contracts out their server maintenance, procurement and general support to an IT contractor. The contractor is fairly adaptable and I have good professional relations with them, however I still have to work within certain “overall parameters”. One of these is that their

Re: Backing up a VM - is it dangerous ?

Many thanks for the useful replies. I’ve contacted the IT contractor to try to negotiate a new backup strategy. Hopefully it will be less of a sweat than the China trade talks :-) Peter > On 5 Nov 2018, at 13:36, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Definitely not

Re: Defining and documenting Objects

Hi This is a good point made by Paul... > On 5 Oct 2018, at 09:15, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> wrote: > > With tables and records and the structure it's relatively > straightforward to track through the code and work out what's going on. I > can see this being a real problem

Re: Defining and documenting Objects

> On 11 Oct 2018, at 08:49, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > there are no globals required for menus (I assume here that you are talking > about popup menus in the form). > Just give them an objectname, get a pointer in the "on load" phase with > Object Get

Re: Defining and documenting Objects

> On 11 Oct 2018, at 12:02, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > All true, but with globals you can have hard to find side effects. > E.g. i have a lot of buttons and other variables on a lot of forms use > "standard" global variables (bOK, bCancel, bSave, bPrint,

Amazon EDIFACT/X12 Gateway

Hi A very happy new year everybody. I have an ERP running at a customer site who is a big Amazon suppler (i.e. they sell products/services TO Amazon). Amazon want them to submit sales invoices via their EDIFACT (or X12) gateway. I’m a bit out of my depth here as I haven’t done any EDI stuff

Re: Subject: Re: Amazon EDIFACT/X12 Gateway

Hello Jim I just saw this message. Thanks for replying - interesting case. Regards Peter > On 7 Jan 2019, at 16:45, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> wrote: > > We have an account with OpenText an EDI VAN (Value Added Network) > We use their software to Send and receive EDI

Re: PDF generation on Windows - Latest Thinking

Many thanks for the replies. I’ll attempt to go with the native PDF engine. Regards Peter > On 12 Sep 2018, at 15:19, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I think it does run on windows 10 ** 4D

4D Write (v15) Images Slanted

Hi I looked back in the archive for an answer to this one and found some useful posts regarding DPI etc. However when I paste an image into 4D Write (legacy version), the image appears slanted at a 30 degree angle (roughly). Have tried forcing the image into both 300 dpi and 600 dpi in

Re: PDF generation on Windows - Latest Thinking

> On 12 Sep 2018, at 21:22, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > > PDF Creator 1.7 works just fine on Windows 10. No problems. And it has many > more configuration options than the built in Window 10 PDF driver. And it > does not have a nuisance bug the Windows 10 driver has

Re: 4D Write (v15) Images Slanted

Hi It appears I’ve solved this - it needed to be a JPEG. But I presume this won’t print too well. > On 12 Sep 2018, at 22:05, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > appears slanted at

PDF generation on Windows - Latest Thinking

Hi For years I used PDF creator to generate PDFs from 4D on Windows 7 - mainly because you didn’t have to type in a document title for every single page in a print run and this could be done from code. My customer has now upgraded to Windows 10 and it’s using the default PDF writer as I didn’t

Re: Formatter that only shows decimals

> On 8 Apr 2019, at 00:19, Mark Katz via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Maybe (likely) I’m missing something but couldn’t you display the actual > value x 100 instead of the actual value? Hi Mark Yes, I could do that. I was just wondering if the formatter could do it because it

Re: 4D Developer Available

That is a stellar curriculum I must say. Good luck with your new phase ! Peter > On 26 Feb 2019, at 17:52, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have recently left my long time employer and begun free-lance 4D > development work. > > I have 24+ years of experience

Re: Epoch time in milliseconds

Thanks Arnaud ! Very useful indeed. Bruno has been very productive in this area. > On 20 Feb 2019, at 22:19, Arnaud de Montard via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > You may be interested by 2 methods from Bruno Legay about epoch in the code > sharing zone: >

Re: OAuth

> On 10 Mar 2019, at 09:51, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The server I’m hoping to talk to is the Value Added Tax server at HMRC in > England (in a couple of months’ time, entering figures for VAT returns will > have to be done by software rather than

Caching URLs. Hashed or unhashed ?

Hi I am caching the responses from a commercial API services to save costs. (i.e. the code does a lookup on a 4D table on the exact URL of the API call to see if we already have that response in the cache). What is people’s opinion on best practice for storing and querying on URL’s ? Should

Re: HMAC SHA512 Signing - solved

The answer was hiding in plain sight !! $isOk:=PHP Execute("";"hash_hmac";$P_dataSignature;"sha512";$P_dataRequestRaw;$P_apiSecret) …and it works. > On 16 Feb 2019, at 20:35, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I’v

HMAC SHA512 Signing

Hi I’ve spent about half a day researching this so far so thought I’d give the NUG a try. Is anyone familiar with a way to do HMAC SHA512 signing in 4D ? v17 now supports SHA512 in the Generate Digest command but that doesn’t do signing. I also tried NTK’s "NTK HMAC Text” (with the “SHA512”

Re: Epoch time in milliseconds

> On 20 Feb 2019, at 01:29, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > $P_timeString:=String(Current date(*);ISO date GMT;Current time(*)) > > does this not invoke 2 calls to the server in C/S mode? Good point Miyako. (I stopped worrying about optimising for performance

Epoch time in milliseconds

Hi Does anyone have an idea how to get the epoch time in milliseconds in native 4D ? The problem is that if I convert Current Date and Current Time to milliseconds there’s a precision error of up to a second and the API server’s I’m using think I’m out of sync. Is it another job for PHP ?

Re: Epoch time in milliseconds

untDAYS*86400)+$P_countSECONDS) $0:=Int($P_posixTIME)*1000 > On 19 Feb 2019, at 23:25, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > The problem is that if I convert Current Date and Current Time to > milliseconds there’s a precision error of up to a second and t

Formatter that only shows decimals

Hi Does anyone know how to do a formatter that only shows (currency) decimals but that hides the decimal point ? I have used ".00;-.00;00” which works ok except that the decimal point itself displays. I’d like to only display the numerics without the point if poss. Thanks in advance for any

Web area fail on accessing secure area

Hi I’m slightly poking around in the dark here looking for a handle. In a 4D Web Area, the a login “submit" button has no effect when submitting username and password to a secure area. The site concerned is the gov.uk (UK Government services). i.e. we start here:

Miyako Excel Component

Hi I have a one-off need to create 2 very small (about 9 rows each, 2 columns) spreadsheets from 4D in native Excel format. Is Miyako’s component still available anywhere ? The sources.4d.com site seems to have gone away. (Or maybe I’m just not accessing it correctly…is it FTP ?) Thanks

Re: Miyako Excel Component

> On 24 May 2019, at 19:48, Arnaud de Montard via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > There are many xl things in Miyako's shop (I only know the freeXL one, it > reads .xls): >

Re: Capturing workstation timezone from the OS

Hi John Many thanks. Nearly a decade old ! Should be well trodden. Peter > On 6 May 2019, at 18:03, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > > This gives the number of seconds offset from GMT. > > John DeSoi, Ph.D.

Capturing workstation timezone from the OS

Hi I’ve been looking into capturing the OS timezone (i.e. GMT +01 etc) from the 4D language but have drawn a blank. I thought there might be some fancy footwork with String(?00:00:00?;ISO GMT) or something trick like that possible but I’ve been unsuccessful. Has anyone done this without

Unexpected authentication window appears in web area

Hi I have a very simple web area embedded in a 4D form for logging into an authenticated domain. I’m observing different behaviours in Mac and Windows: Mac: works fine. You enter user and password, click the web page submit button and authentication is successful. Next web page appears

Re: More on 4D Objects and 'Inheritance'

Fascinating stuff Kirk. Thanks for posting. Peter > On 16 Sep 2019, at 17:10, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Not everyone is a fan and there are some good arguments to be made ** 4D Internet

Re: More on 4D Objects and 'Inheritance'

rofl ! That was a very inspiring post. Ok I think thats pushed me over the edge. OO 4D here I come. > On 16 Sep 2019, at 22:23, Aparajita Fishman via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >> Well my recommendation is not to use New formula ever. > > Translation: “I’m not sure I can use

Re: Object property inheritance - why does this this not work ?

That was a very inspiring post. > On 15 Sep 2019, at 21:44, Aparajita Fishman via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >> ORDA looks really interesting too but I haven't played with it yet, but I'm >> looking forward to experimenting with it soon. > > It’s more than interesting, it’s

Re: Object property inheritance - why does this this not work ?

Thanks Narinder. Doesn’t this imply we need to change our entire style and approach to coding ? Language data structures, forms, the lot ? Have you found you needed to do this ? (At least in terms of new code and optimal approaches). Having attended the last couple of summits and various

Object property inheritance - why does this this not work ?

Hi Using the v17 dot notation I was unable to get one object to inherit another’s properties using the assignment operator. Also when I inspect $dog in the debugger after assigning the first property, it appears empty. Code is: C_OBJECT($animal;$dog;$cat) $dog:=New object $cat:=New object

Re: Object property inheritance - why does this this not work ?

> On 15 Sep 2019, at 14:32, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Don't try to fit a square peg into a round hole just yet Fair enough, Jeff. I won’t, and your advice is of course wise re. “the real thing is coming”. But it’s still interesting to explore the potential

Re: Object property inheritance - why does this this not work ?

Hi Narinder So it does. I created a brand new structure and it now works. I did that example in a legacy upgraded structure so maybe there’s some compatibility setting that I needed to change to fully support the new object syntax. Many thanks for taking the time to check it and respond !

Re: Object property inheritance - why does this this not work ?

Hi Narinder Thanks for posting your commentary. Very interesting. Regards Peter > On 15 Sep 2019, at 13:58, Narinder Chandi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I think our coding style will need to undergo an evolution rather than > revolution

More on 4D Objects and 'Inheritance'

Hi Just expanding on that last thread, (“Why does this not work") there do appear to be some real object orientation aspects to the new 4D commands - at least from the point of view of what’s needed and useful in a high level environment like 4D. The key is the new “This” self-referencing

Windows OS level backup trashing 4D

Hi I’m sure this is an age old issue but I thought I’d solicit some opinions on addressing it in case anyone cares to post their experiences. The OS level backup is saving the operating system (which nobody cares about) and trashing 4D (which everybody cares about). The site runs a mission

Windows network - cannot open structure of database {BaseName}

Hi I’m slightly stumped by what appears to be a networking/firewall/permissions issue but I’m not really sure. (Ports are open). A 4D Client connecting to 4D Server (v15) over a Windows LAN (Windows 10) connects but then dies while trying to download local resources. The error messages are:

Re: Windows network - cannot open structure of database {BaseName}

Hi Amazing how just typing the problem out catalyses your brain ! It wasn’t enough to allow just TCP protocol in the firewall. It had to allow UDP as well. (In fact I just changed it to “All Protocols”). Sorry for the noise :-) Peter

Re: Trapping the 'return' key in list forms

Hi Jeremy In fact, with this approach there’s not even any need for the invisible buttons - just associate the [Return] key with the visible default button and the script can decide whether to execute the query or the default “Accept” action. Regards Peter > On 4 Dec 2019, at 09:40, Jeremy

Re: Trapping the 'return' key in list forms

ver you choose matters less, I think, > than applying it consistently throughout the database. > > On Fri, Nov 29, 2019 at 1:44 PM Peter Jakobsson via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> This is so that users can hit the return key to execute a query (like >>

O/S Replication and Backup interaction with 4D (2004, v15)

Hi I have a legacy 4D server which appears to be getting trashed by the backup services in Windows 10 server. The platform contractor cannot turn off any of the backup stuff and I can’t upgrade to v17 for several weeks due to…..reasons, so need to find a way round this. (There are 2 virtual

Re: Doing a GOTO (widget) in the On Load event - stumped

> On 3 Dec 2019, at 00:58, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thanks Canon …sorry, I mean “Cannon” of course ;) ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d

Doing a GOTO (widget) in the On Load event - stumped

Hi ! Back again with a related issue to my previous theme of user interface behaviours. To move the cursor into a widget (in fact a derivative of Miyako’s “search” widget) I usually use a button with CTRL-F shortcut to call “EXECUTE IN SUBFORM($subform;”ACTION”) and then have the “ACTION”

Re: Doing a GOTO (widget) in the On Load event - stumped

Works a dream. Thanks Canon. I had forgotten about SET TIMER. Suddenly these query forms are perfectly user-intuitive. Start off in filter. Execute query with Return, accept form with return also. Could not be better…thanks for all the tips on here ! Peter > On 3 Dec 2019, at 00:47, Cannon

Re: Trapping the 'return' key in list forms

sing a timer to auto search for the user? > > i.e. user types: "App" > and after a brief delay the searches auto executed using the user > entered information? I use 120 ticks. > > then they do not have to hit return at all > > > On Tue, 3 Dec 2019 00:26:24

Re: O/S Replication and Backup interaction with 4D (2004, v15)

Hi Timothy That post was very useful. Many thanks. Regards Peter > On 4 Dec 2019, at 20:15, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > It sounds like you're dealing with a VM environment, possibly either Hyper-V > or VMWare ESxi

Re: Trapping the 'return' key in list forms

> On 3 Dec 2019, at 21:47, Peter Bozek wrote: > But doing it again, I would go for something simpler. …and that “something simpler” turns out to be Jeremy Roussak’s tip of removing the “Focusable” property from the default button on the form. This is the key to everything, including: 1. The

Re: Capturing barcodes without a 'text' field

Hi Dougie This is in fact what we do at the moment. (In fact it’s so simple I just use the 4D “Request” function to capture the barcode). The only thing that would make a marked improvement while not complicating things too much would be for the capture to auto-enter itself after the scan

Re: Capturing barcodes without a 'text' field

Thanks Jeff. Very useful information. I also checked out your even more detailed responses on last year’s thread about this which were very informative. Regards Peter > On 16 Oct 2019, at 00:54, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > If you want to use a USB barcode

Trapping the 'return' key in list forms

Hi Could anyone kindly bring me up to date me how we trap the [Return] key on a form these days with a default button when some other action is to be taken rather than accepting the form, depending on the last object that had the focus prior to executing the Default Button script ? In

Re: Trapping the 'return' key in list forms

Thanks for that input Chip. However I don’t see how this can work. How can the invisible button script know which field the cursor was in last ? (Or which object last had the focus prior to its own script being executed ?) Regards Peter > On 29 Nov 2019, at 22:13, Chip Scheide

4D Server Hosting - The Future ?

Hi ! I just finished a 1.5 hour phonecall with a support services manager at the technical services company who supply one of my customers with all their hardware/software/maintenance services. He basically brought me up to date on “how things work” today which is essentially that everything

Re: 4D Server Hosting - The Future ?

Thanks for your post Kirk. The guy I spoke to seemed to have it the other way around - the VM’s had 4-12 cores and the “metal” about 32. He also was of the categorical opinion that the only way to really keep applications “isolated” from each other (i.e. not bring everything else down when

Re: 4D Server Hosting - The Future ?

> On 10 Oct 2019, at 16:58, Chip Scheide <4d_o...@pghrepository.org> wrote: > > that all is great until the hardware running the 4,382,619 VMs crashes According to “the guy”, that’s all taken care of. Even if the “metal” melts down, the VM’s just “seamlessly” migrate themselves onto other

4D Write Preview Fails on certain workstation (Windows)

Hi I was wondering if anybody had encountered this issue. 4D Write document preview (created using "WR Build Preview”) displays a blank picture only on one workstation on the entire network (there are 8 workstations). There is nothing obviously distinct about that workstation: 4D v15

Re: v18 and 4D Write Classic - does it work ?

Many thanks for that comprehensive and extensive commentary Tim ! Looks like I have my work cut out. All the 4D Write code I have is in a component and the component makes around 30 calls or so to 4D Write. There’s no raw host calls anywhere. Hopefully it will be do-able but will take your

v18 and 4D Write Classic - does it work ?

Hi I’m going to be making the leap from v15 to v18. I think the biggest transition will be moving to 4D Write Pro as I have quite a lot of legacy 4D Write code to deal with. In the meantime, does anybody have experience of migrating big 4D Write codebases ? What are the major gotchas ? Will

What constitutes high-perf. hardware for 4D server these days ?

…that is the question ! I have a site that I just launched - usual moderate-trauma of initial days but basically holding up so far and improving by the day. I now need to try and optimise it a bit as it’s still slightly sluggish and was wondering what people were running in terms of hardware.

  1   2   >