Re: v17 conundrum in design

Hi Chuck, Is it happening on a line of code which is split up in several lines ('\')? I've seen this happening a number of times. Mainly quitting and restarting 4D is enhough to solve this issue. You might try to remove the slash chars, set a breakpoint at the remaining line and remove it right

Odd thing with iso dates

I do not understand what is happening here in V17.0: String(Date("14/8/2017");ISO date GMT) //UK date format gives 2017-08-13T23:00:00Z i.e. the day before! My regional setting are correct. Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar

Re: Odd thing with iso dates

At a guess, it’s because at that time of year, British Summer Time is active; so 00:00 on 14th August local time is 23:00 on 13th August GMT. Jeremy > On 8 Feb 2019, at 14:32, Uist Macdonald via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > I do not understand what is happening here in

Re: Odd thing with iso dates

The ‘Z’ stands for Zulu time. > On Feb 8, 2019, at 9:01 AM, Epperlein, Lutz (agendo) via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Jeremy is right, mind the "Z" at the end of the date string. > > > Regards > Lutz > >> At a

Named Selections

Is there a way to determine if a named selection exists? something like this: if (Not(Named Selection Exists("Selection_Name"))) Copy Named Selection([table];"Selection_Name") end if Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing

RE: Set Time question

Kirk, You can create an independent process that is hidden to user which simply wakes up, does the calculation, and then calls the process. It you use IP variables you can have them auto-update based on the call to the process. We do this for projects that require this type of updatingno

RE: Odd thing with iso dates

Jeremy is right, mind the "Z" at the end of the date string. Regards Lutz > At a guess, it’s because at that time of year, British Summer Time is active; > so 00:00 > on 14th August local time is 23:00 on 13th August GMT. > > > >

Set Time question

Hi List, I have never used Set timer very much so I've got a noobie question. I'm adding some real-time updating code to financial forms: think Invoices, Billing Account summaries. that sort of thing. An invoice is the most obvious - User A has a form open that displays the invoice details (total

Re: v17 conundrum in design

No it is not and I have quite and restarted many times Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com

Re: Set Time question

> Le 8 févr. 2019 à 17:48, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] Is there a way to trap use actions like that so I can block the > On timer code from running? Each new SET TIMER "kills" the previously set one, so it allows to postpone or cancel next 'On timer'.

Re: v17 conundrum in design

Chuck, I have encountered this a few times since at least v15 (now using v17.0 HF3). The only way I found to clear it is to - create a new method - copy the code across - delete old method I found it impossible to “make it happen” for a reproducible bug for 4D, though I did report it anyway (a

Re: Relation naming for ORDA in v17? Best Practices anyone?

> Le 8 févr. 2019 à 19:50, Ed Hammond via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Have any of you come up with a convention for naming relations for use with > ORDA? What have you found that works? or doesn't? Hi Ed, the relation name is the direction in which we go from one field to

Relation naming for ORDA in v17? Best Practices anyone?

Hey all of you ORDA pioneers and converts! Have any of you come up with a convention for naming relations for use with ORDA? What have you found that works? or doesn't? Edgar Hammond

RE: Named Selections

Thanks, I was hoping there was a an already existing command. On Fri, 8 Feb 2019 13:31:05 -0600, David Ringsmuth wrote: > Chip, > > We did this same things with sets by using an On Err > Call(“Error_SetDoesNotExist”). > > Write an On Err Call for Named Selections, and then use it, and test >

Re: Set Time question

Hi Arnaud, Aha. That hadn't even occurred to me. I think that's exactly what I was looking for. Off the top of my head I think using the On Before Data Entry for listboxes and On before keystroke for fields. Thank you! On Fri, Feb 8, 2019 at 10:18 AM Arnaud de Montard via 4D_Tech <

Re: Relation naming for ORDA in v17? Best Practices anyone?

> I went much simpler… This is quite the same, but the problem with this approach is, that i cannot parse relations generically. -- Grüße/Regards, [heubach-media] | Christian Sakowski christian.sakow...@heubach-media.de Tel: +49/(0)40/52 10 59-23 > Am 08.02.2019 um 20:15 schrieb Neil Dennis

WR ON COMMAND in Write Pro

Is there a way to trap 4D Write Pro commands like WR ON COMMAND did in 4D Write? I'd like to trap call from the toolbar widget or the contextual menu. Thanks -- -- Tom Dillon 375 S Main

Re: Relation naming for ORDA in v17? Best Practices anyone?

> Le 8 févr. 2019 à 20:18, Christian Sakowski via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > >> I went much simpler… > > This is quite the same, but the problem with this approach is, that i cannot > parse relations generically. I do agree, a name that allows to identify the function is

Re: Relation naming for ORDA in v17? Best Practices anyone?

Yes, since years i use the following: Given two tables: [Invoice] [InvoiceItems] The id from the invoice is named as: [InvoiceItems]_Invoice__ (one leading underscore and double underscore as postfix) For ORDA i name the relation: [InvoiceItems]_Invoice__MO (MO means Many to One) which is

Re: Relation naming for ORDA in v17? Best Practices anyone?

Given two tables: [Invoice] [InvoiceItems] I went much simpler… The many to one from InvoiceItems to Invoice I simply name invoice The one to many from Invoice to Invoice Items I simply named invoiceItems Then the dot notation comes out to be Invoice.invoiceItems InvoiceItems.invoice

RE: Named Selections

Chip, We did this same things with sets by using an On Err Call(“Error_SetDoesNotExist”). Write an On Err Call for Named Selections, and then use it, and test the result of your call error handler. Hth! David Ringsmuth From: Chip Scheide via 4D_Tech Sent: Friday, February 8, 2019 11:52 AM

RE: Bug in SMTP methods in 4D Internet Commands plugin

Randy Engle wrote: >Received both emails including: " Invalid subject containing changed by” So… >Something else is hokey-pokey I can’t figure what it’s all about. It fails using a brand new database, on two different machines, on two different networks, connected to two different SMTP

Remote Runtime Error (What is an "entity set"?)

The following runtime error appears on remote client in interpretive mode: 1802 — The “XX” entity set cannot be found https://i.postimg.cc/8c643XbC/p01-entity-set-error.png The documentation has a **different** description for error

Re: WR ON COMMAND in Write Pro

I don't think that's possible. I suppose WR ON COMMAND made more sense for 4D Write which was a completely opaque product. with Write Pro we can create our own contextual menu (Dynamic popup menu + INVOKE ACTION) so rather than trapping the existing menu, the way to customise behaviour would