On Apr 9, 2018, at 5:52 PM, Richard Wright 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 Rich,
It might be possible in the future to create custom data classes that would act
like SQL views. I’m not sure exactly how the custom data classes will work or
be implemented in 4D.
For now ORDA provides complete access to everything in the database. All tables
and all fields. But accessing data in related tables is now “hidden” behind
named relations. That is where using ORDA has the biggest impact.
For several versions now the property palette for relations in the structure
editor has a place to assign a name to a relation. Doubtful that anyone is
using this property since you currently can’t do anything with it in 4D. Maybe
it is useful using 4D Mobile, I don’t know. But now with ORDA, naming relations
is needed to take make the code readable. “Link20.customer.name” is not as
readable as “manager.customer.name”.
We’ll have to wait for possibly a v17 R release or v18 for custom data classes.
That might be when you could implement something like SQL views that can be
used in 4D methods to reference database tables and records. Doing the
automatic joins and filtering of records like you can do in SQL views.
SQL views are super powerful, but they are so “old school”. We are living in
the “new world” of ORDA and object oriented relational database access. If 4D
does it right, ORDA will be even more powerful than SQL views.
Too bad Laurent does not monitor this list, I’m sure he would be able to
immediately answer your question. JPR does monitor the list, maybe he knows
more about this and could comment.
Tim
Tim Nevels
[email protected] <mailto:[email protected]>
Innovative Solutions
785-749-3444
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
