Re: v17 conundrum in design

[Koen Van Hooreweghe via 4D_Tech]

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 away and then split your 
line again.

HTH
Koen
 
> Op 7 feb. 2019, om 21:39 heeft Chuck Miller via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> I have an object method that shows no break points either in the method or 
> when I show break points, yet it continues to stop at a particular line of 
> code and it is annoying. Any ideas out there what it might be.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Odd thing with iso dates

[Uist Macdonald via 4D_Tech]

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
Fife KY15 5QJ

+44 (0) 1334 828002

Registered in Scotland : SC107838

An ISO 9001 registered company.

This message including any attachments, is intended and authorized for
the addressee only, and may contain privileged and/or confidential
information.  If you are not the authorized addressee, you are not
authorized to either review or disseminate this message.  Accordingly,
if you are not the intended and authorized recipient, please disregard
this message and notify the sender.  If you are the authorized
addressee, you may use this for the purpose for which it was intended; a
direct, personal communication to you and your legal agents.  You may
not distribute it to or publish it in any public forum without prior,
specific, written permission from the sender.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Odd thing with iso dates

[Jeremy Roussak via 4D_Tech]

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 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



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Odd thing with iso dates

[Jody Bevan via 4D_Tech]

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 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.
>>> 
>>> 2017-08-13T23:00:00Z

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Named Selections

[Chip Scheide via 4D_Tech]

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 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Set Time question

[Stephen J. Orth via 4D_Tech]

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 real interruption to the user.

Just one thought..


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc.  Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Kirk Brooks via 
4D_Tech
Sent: Friday, February 8, 2019 10:48 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Kirk Brooks 
Subject: 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 amount, balance due). 
I want to update the balance due when a new payment is applied which could be 
from anywhere in the system. I have the code for all that worked out the issue 
is managing displaying the balance due part.

Set timer is one solution. Every couple of seconds the form can simply reload 
the invoice details. The issue is the interruption to the user if they are 
doing something else on the form. Like entering data in a field or variable. Is 
there a way to trap use actions like that so I can block the On timer code from 
running?

--
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Odd thing with iso dates

[Epperlein, Lutz (agendo) via 4D_Tech]

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.
> >
> > 2017-08-13T23:00:00Z
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Set Time question

[Kirk Brooks via 4D_Tech]

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
amount, balance due). I want to update the balance due when a new payment
is applied which could be from anywhere in the system. I have the code for
all that worked out the issue is managing displaying the balance due part.

Set timer is one solution. Every couple of seconds the form can simply
reload the invoice details. The issue is the interruption to the user if
they are doing something else on the form. Like entering data in a field or
variable. Is there a way to trap use actions like that so I can block the
On timer code from running?

-- 
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v17 conundrum in design

[Chuck Miller via 4D_Tech]

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 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Feb 8, 2019, at 3:23 AM, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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 away and then split 
> your line again.
> 
> HTH
> Koen
> 
>> Op 7 feb. 2019, om 21:39 heeft Chuck Miller via 4D_Tech 
>> <4d_tech@lists.4d.com> het volgende geschreven:
>> 
>> I have an object method that shows no break points either in the method or 
>> when I show break points, yet it continues to stop at a particular line of 
>> code and it is annoying. Any ideas out there what it might be.
> 
> 
> 
> 
> Compass bvba
> Koen Van Hooreweghe
> Kloosterstraat 65
> 9910 Aalter
> Belgium
> tel +32 495 511.653
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Set Time question

[Arnaud de Montard via 4D_Tech]

> 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'. For example when the user types into a search box, send 
the query after he has stopped input since one or 2 seconds. 

Maybe something like this in form method could work:

jobPostponed:=60*2  //2 seconds, for example
case of
  on keystroke
set timer(jobPostponed)
  on timer 
set timer(0)
job.do(please)
set timer(jobPostponed)
end case

Thinking after, there is surely more events to consider (On click, double clic, 
menu, etc.)

-- 
Arnaud de Montard 


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v17 conundrum in design

[Keith Goebel via 4D_Tech]

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 long time ago).

My biggest “problem” with v17HF3 on Win7 is its habit of ignoring new beak 
points after a while when debugging - what a massive pain… (i have reported it)
I have to restart 4D and then it respects the breakpoints already set on 
startup.
I hope this has been fixed but haven’t seen any mention in later version bug 
fixes.
I have not seen anyone else mention it so maybe it only affects me.
But I digress… 
HTH, Keith

> I have an object method that shows no break points either in the method or 
> when I show break points, yet it continues to stop at a particular line of 
> code and it is annoying...
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Arnaud de Montard via 4D_Tech]

> 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 another. 
Thus I stick to my table and fields naming to identify in the relation name:
- the destination table
- the direction (many to one ≠ one to many)
The "from" is unnecessary (redundant) because ORDA starts with it:
  ds.dataclass.{property}

For example:
  [company]PK  primary key
  [employee]FK_company ... foreign key
  company_p .. relation to one   {from ds.employee}
  employee_f . relation to many  {from ds.company}

ORDA will be like this:
  ds.employee.company_p … (many to one, to Primary…)
  ds.company.employee_f … (one to many, to Foreign…)

BTW, in french, "p" stands for "père" (father) an "f" for "fils" (sons), it 
suits me. Maybe an english reader would prefer O, M, for one, many, use a 
prefix instead. Some like plural/singular I've seen, like "company" and 
"allEmployees". Too much grammar for me  ;-) 

As two fields in the same table can't have the same name, two properties in the 
same entity must have different names. In case of multiple relation, I still 
follow my foreign keys naming, I add to the names what makes them different. 
For example this table:
  [Human]
   PK
   FK_humanFather
   FK_humanMother
Relations:
  from PK to FK_humanFather: humanFather_f
  from PK to FK_humanMother: humanMother_f
  from FK_humanFather to PK: human_p, father_p, etc.
  from FK_humanMother to PK: human_p, mother_p, etc.

-- 
Arnaud de Montard 



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Relation naming for ORDA in v17? Best Practices anyone?

[Ed Hammond via 4D_Tech]

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 
ehamm...@questinformation.com

Quest Information Systems



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Named Selections

[Chip Scheide via 4D_Tech]

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 
> the result of your call error handler.
> 
> Hth!
> 
> David Ringsmuth
> 
> From: Chip Scheide via 4D_Tech
> Sent: Friday, February 8, 2019 11:52 AM
> To: 4D iNug Technical
> Cc: Chip Scheide
> Subject: 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 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
> 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Set Time question

[Kirk Brooks via 4D_Tech]

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 <
4d_tech@lists.4d.com> wrote:

>
> > 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'. For example when the user types into a
> search box, send the query after he has stopped input since one or 2
> seconds.
>
> Maybe something like this in form method could work:
>
> jobPostponed:=60*2  //2 seconds, for example
> case of
>   on keystroke
> set timer(jobPostponed)
>   on timer
> set timer(0)
> job.do(please)
> set timer(jobPostponed)
> end case
>
> Thinking after, there is surely more events to consider (On click, double
> clic, menu, etc.)
>
> --
> Arnaud de Montard
>
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

What can be said, can be said clearly,
and what you can’t say, you should shut up about

*Wittgenstein and the Computer *
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Christian Sakowski via 4D_Tech]

> 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 :
> 
> 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
> 
> 
> 
> 
> Neil
> 
> 
> 
> 
> 
> 


--
heubach media
Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
22529 Hamburg
tel: 040 / 52 10 59 - 10 | fax: -99
mail: i...@heubach-media.de
home: www.heubach-media.de
Geschäftsführer|CEO: Matthias Heubach

Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei:
http://www.milo-rental.com

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten 
haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht 
gestattet.
 
This e-mail may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

WR ON COMMAND in Write Pro

[Tom Dillon via 4D_Tech]

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 St #405
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
Clean wears itself thin.  --- Sunastar
   --


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Arnaud de Montard via 4D_Tech]

> 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 great:
  find regex("^FK_";property;1) -> foreign key
  find regex("_p$";property;1) -> many to one relation
And these names are not supposed to change every day…  

-- 
Arnaud de Montard 





**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Christian Sakowski via 4D_Tech]

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 an entity and

[Invoice]_InvoiceItems__OM

(One to Many) which is an entitySelection
--

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 19:50 schrieb Ed Hammond via 4D_Tech <4d_tech@lists.4d.com>:
> 
> 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 
> ehamm...@questinformation.com
> 
> Quest Information Systems
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **


--
heubach media
Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
22529 Hamburg
tel: 040 / 52 10 59 - 10 | fax: -99
mail: i...@heubach-media.de
home: www.heubach-media.de
Geschäftsführer|CEO: Matthias Heubach

Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei:
http://www.milo-rental.com

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten 
haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht 
gestattet.
 
This e-mail may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Neil Dennis via 4D_Tech]

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




Neil






**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Named Selections

[David Ringsmuth via 4D_Tech]

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
To: 4D iNug Technical
Cc: Chip Scheide
Subject: 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 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Ben Kershaw via 4D_Tech]

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 
servers. In 30 years of 4D development, this is the strangest issue I’ve seen.

Thanks for testing it out. I figured it couldn’t be an IC plugin bug, but 
everything I saw pointed to that. Oh well - it’ll be fun finding out what it 
really is.

Thanks,
Ben Kershaw
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Jeremy French via 4D_Tech]

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 #1802, which is:

1802 — Failed to execute INSERT command.
https://doc.4d.com/4Dv17/4D/17/SQL-Engine-Errors-1001-3018.300-3729644.en.html 



Questions:

1) What is an “entity set”? (Note the word “set” rather than “collection” in 
the error message.)

2) Why are “Edit” and “Trace” buttons disabled? 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: WR ON COMMAND in Write Pro

[Keisuke Miyako via 4D_Tech]

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 be to not use it at all.

I tested the new toolbar widget, again,
in theory it could have posted a CALL SUBFORM CONTAINER for every action,
but evidently it is not written that way.

so it seems the way to customise it is to download the source and roll out our 
own.

> 2019/02/09 4:53、Tom Dillon via 4D_Tech <4d_tech@lists.4d.com>のメール:
> 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.




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**