Hi ORDA users
I am starting to explore ORDA and with many false steps I have reduced some
code to just a few lines which is great. However, I am struggling to extract a
field from a related one table when working principally in the many table.
In the following selection – I cannot find the code to extract the field value
from a related one table (Events is the many table) – I am building a calendar
view with hmCal.
I have named my relation and looked at the various examples and cheat sheets
and just can’t get to grips with this.
4D there would be a good place for a 4D ORDA manual like when SQL was
introduced for those of us that are not full time at this!
I am sure I am missing something very obvious so any suggestions would be
gratefully received!
Thanks
Steve
UKVD
--------------------------------------------------------------------------------------------------
C_OBJECT(emp)
For each (emp;ds.Events.query("StartDate > :1 & StartDate < :2 & Calendar =
:3";vMondaydate;vMondayDate2;True)
$text:= a related one value!
$err:=hmCal_Add Appointment
(calarea;emp.AppointmentNumber;$text;emp.MainContact
emp.AllDay;emp.StartDate;emp.StartTime;emp.FinishDate;emp.FinishTime;0)
Blah blah …
End for each
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
