phoneDS / PhoneDS are not the same. Capitalization counts - it's not Foxrpo...:}
On Tue, Jul 14, 2009 at 3:41 PM, tim awa <[email protected]> wrote: > Larry, > > I can't spot any difference in the two lines of code that you posted. > > > > On Tue, Jul 14, 2009 at 10:16 PM, <[email protected]> wrote: > > > > Does changing... > > aliasDict = { "curPhone" : phoneDS } > > > > to.. > > aliasDict = { "curPhone" : PhoneDS } > > > > work? > > > > Larry Long > > > >> -----Original Message----- > >> From: [email protected] > >> [mailto:[email protected]] On Behalf Of tim awa > >> Sent: Monday, July 13, 2009 8:59 PM > >> To: [email protected] > >> Subject: [dabo-users] Joins on datasets > >> > >> I have two tables, tblname and tblphone. > >> > >> The ff works Ok: > >> > >> nameDS = self.PrimaryBizobj.getDataSet() phoneDS = > >> self.getBizobj(dataSource="public.tblphone").getDataSet() > >> > >> nameDS.execute("select * from dataset") > >> PhoneDS.execute("select * from dataset") > >> > >> The ff JOIN does not work: > >> > >> aliasDict = { "curPhone" : phoneDS } > >> ds = nameDS.execute("select dataset.fullname, curPhone.phone > >> from dataset join curInfo on dataset.pk=curInfo.fkName", aliasDict) > >> > >> The error returned is: > >> > >> "OperationalError: no such table: curPhone" > >> > >> The steps that I have done above seems to follow the tutorial > >> in http://dabodev.com/wiki/DataSet. > >> > >> What am I missing? > >> > >> [excessive quoting removed by server] _______________________________________________ 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]
