Questions about the 'Sum' function

2017-04-12 Thread Peter Jakobsson via 4D_Tech
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

2017-04-12 Thread Peter Jakobsson via 4D_Tech
On 12 Apr 2017, at 13:38, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> wrote: > My understanding is a selection or array i think it works for both. Thanks ! Peter ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Questions about the 'Sum' function

2017-04-12 Thread Peter Jakobsson via 4D_Tech
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

2017-04-05 Thread Peter Jakobsson via 4D_Tech
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

2017-04-06 Thread Peter Jakobsson via 4D_Tech
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

2017-04-05 Thread Peter Jakobsson via 4D_Tech
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.

2017-04-16 Thread Peter Jakobsson via 4D_Tech
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?

2017-04-21 Thread Peter Jakobsson via 4D_Tech
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

Migrating Tables with Relations Between Structures

2017-04-05 Thread Peter Jakobsson via 4D_Tech
Hi I visited this subject a few years ago and was wondering what people prefer to do in this situation. Let’s say you have a group of tables with complex relations. You want to copy them from one structure to another as a coherent block, retaining the relations. What’s the best way ? - drag

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

2017-04-14 Thread Peter Jakobsson via 4D_Tech
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"

2017-04-17 Thread Peter Jakobsson via 4D_Tech
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

2017-07-17 Thread Peter Jakobsson via 4D_Tech
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

2017-07-17 Thread Peter Jakobsson via 4D_Tech
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: Arrays vs Object for Key/Value pair lookups

2017-07-17 Thread Peter Jakobsson via 4D_Tech
Thanks Alexander. Which style of implementation did you use ? Did you use the old array lookup key as the new object key in the key/value pair ? i.e. did you enumerate the keys like this: ? === OLD WAY === ARRAY LONGINT(vArrKeysID; 1000) ARRAY LONGINT(vArrKeysNames; 1000) $x:=Find in

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

2017-07-18 Thread Peter Jakobsson via 4D_Tech
This is just a brief commentary on my experience with objects after about a year of using them intensively. I now use them extensively for certain things but have ditched them for others where I had initially thought they may have a role. But one of the reasons I don’t use 4D objects too

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

2017-07-21 Thread Peter Jakobsson via 4D_Tech
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...)

2017-07-21 Thread Peter Jakobsson via 4D_Tech
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

2017-07-20 Thread Peter Jakobsson via 4D_Tech
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

2017-07-02 Thread Peter Jakobsson via 4D_Tech
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

2017-07-02 Thread Peter Jakobsson via 4D_Tech
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

2017-07-01 Thread Peter Jakobsson via 4D_Tech
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?

2017-04-21 Thread Peter Jakobsson via 4D_Tech
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

2017-04-24 Thread Peter Jakobsson via 4D_Tech
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 ?

2017-05-18 Thread Peter Jakobsson via 4D_Tech
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 ?

2017-05-17 Thread Peter Jakobsson via 4D_Tech
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?

2017-05-04 Thread Peter Jakobsson via 4D_Tech
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

2017-10-06 Thread Peter Jakobsson via 4D_Tech
> 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

2017-10-06 Thread Peter Jakobsson via 4D_Tech
> 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

2017-10-24 Thread Peter Jakobsson via 4D_Tech
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

2017-12-05 Thread Peter Jakobsson via 4D_Tech
> 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

2017-12-06 Thread Peter Jakobsson via 4D_Tech
> 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

2017-12-05 Thread Peter Jakobsson via 4D_Tech
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

2017-10-24 Thread Peter Jakobsson via 4D_Tech
> 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

2018-06-18 Thread Peter Jakobsson via 4D_Tech
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

2018-06-17 Thread Peter Jakobsson via 4D_Tech
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

2018-01-19 Thread Peter Jakobsson via 4D_Tech
> 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

2018-01-19 Thread Peter Jakobsson via 4D_Tech
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

2018-01-18 Thread Peter Jakobsson via 4D_Tech
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

2018-09-10 Thread Peter Jakobsson via 4D_Tech
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

2018-01-18 Thread Peter Jakobsson via 4D_Tech
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

2018-04-09 Thread Peter Jakobsson via 4D_Tech
> 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

2018-02-28 Thread Peter Jakobsson via 4D_Tech
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?

2018-10-24 Thread Peter Jakobsson via 4D_Tech
> 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 ?

2018-11-05 Thread Peter Jakobsson via 4D_Tech
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 ?

2018-11-05 Thread Peter Jakobsson via 4D_Tech
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

2018-10-10 Thread Peter Jakobsson via 4D_Tech
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

2018-10-11 Thread Peter Jakobsson via 4D_Tech
> 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

2018-10-11 Thread Peter Jakobsson via 4D_Tech
> 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

2019-01-04 Thread Peter Jakobsson via 4D_Tech
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

2019-01-09 Thread Peter Jakobsson via 4D_Tech
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

2018-09-12 Thread Peter Jakobsson via 4D_Tech
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

2018-09-12 Thread Peter Jakobsson via 4D_Tech
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

2018-09-12 Thread Peter Jakobsson via 4D_Tech
> 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

2018-09-12 Thread Peter Jakobsson via 4D_Tech
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

2018-09-12 Thread Peter Jakobsson via 4D_Tech
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

2019-04-08 Thread Peter Jakobsson via 4D_Tech
> 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

2019-02-26 Thread Peter Jakobsson via 4D_Tech
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

2019-02-20 Thread Peter Jakobsson via 4D_Tech
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

2019-03-15 Thread Peter Jakobsson via 4D_Tech
> 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 ?

2019-02-15 Thread Peter Jakobsson via 4D_Tech
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

2019-02-16 Thread Peter Jakobsson via 4D_Tech
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

2019-02-16 Thread Peter Jakobsson via 4D_Tech
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

2019-02-20 Thread Peter Jakobsson via 4D_Tech
> 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

2019-02-19 Thread Peter Jakobsson via 4D_Tech
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

2019-02-19 Thread Peter Jakobsson via 4D_Tech
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

2019-04-06 Thread Peter Jakobsson via 4D_Tech
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

Re: Unexpected authentication window appears in web area

2019-04-25 Thread Peter Jakobsson via 4D_Tech
Hi Randy Thanks for your reply. Just to clarify, there’s no code involved. It’s simply a web area through which I’m accessing the web. Behaves as expected on the Mac but generates this authentication dialog out of nowhere on Windows. Peter > On 25 Apr 2019, at 22:23, Randy Engle via 4D_Tech

Unexpected authentication window appears in web area

2019-04-25 Thread Peter Jakobsson via 4D_Tech
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: Capturing workstation timezone from the OS

2019-05-06 Thread Peter Jakobsson via 4D_Tech
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

2019-05-06 Thread Peter Jakobsson via 4D_Tech
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

Miyako Excel Component

2019-05-24 Thread Peter Jakobsson via 4D_Tech
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

2019-05-24 Thread Peter Jakobsson via 4D_Tech
> 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): >

Web area fail on accessing secure area

2019-06-01 Thread Peter Jakobsson via 4D_Tech
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: