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/66b6c7c40907141541m63e617f0jb6ea30c2b8154...@mail.gmail.com