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

2019-02-09 Thread Arnaud de Montard via 4D_Tech
> Le 9 févr. 2019 à 15:31, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I always use singular table names and the relationship names are singular or > plural based on their type. [...] Hi, using grammatical rules makes reading code closer to human langage. But I prefer to ha

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

2019-02-09 Thread John DeSoi via 4D_Tech
I always use singular table names and the relationship names are singular or plural based on their type. For example, I have a structure that imports 4D code and builds a database of each method path and the related methods it directly calls: [Method_Call]ID [Method_Call]Caller_Method_ID -> [M

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

2019-02-08 Thread 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 gre

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

2019-02-08 Thread 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 a

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

2019-02-08 Thread 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

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

2019-02-08 Thread 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

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

2019-02-08 Thread 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 a

Relation naming for ORDA in v17? Best Practices anyone?

2019-02-08 Thread 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