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]
