On Sunday 17 January 2010 07:01:57 am Jacek Kałucki wrote: > self.addJoin( > > > "doctor_speciality", > > "doctor_speciality.pkid = doctor.fk_speciality", > > "LEFT"
might be it needs self.addJoin( "doctor_speciality", "doctor_speciality.pkid = doctor.fk_speciality", joinType = "Left") Also you do not need the LinkField. You should be able to review the sql by opening a dShell and just typing the bizobj.CurrentSQL at the prompt. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
