phoneDS / PhoneDS are not the same. Capitalization counts - it's not Foxrpo...:}
On Tue, Jul 14, 2009 at 3:41 PM, tim awa <bop...@gmail.com> 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, <lalo...@charter.net> wrote: > > > > Does changing... > > aliasDict = { "curPhone" : phoneDS } > > > > to.. > > aliasDict = { "curPhone" : PhoneDS } > > > > work? > > > > Larry Long > > > >> -----Original Message----- > >> From: dabo-users-boun...@leafe.com > >> [mailto:dabo-users-boun...@leafe.com] On Behalf Of tim awa > >> Sent: Monday, July 13, 2009 8:59 PM > >> To: dabo-users@leafe.com > >> 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: Dabo-users@leafe.com 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/732cbe580907141547l26430b19w426d454fd7b6f...@mail.gmail.com