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
