Ops! Some typos in original post.
The ff JOIN does not work:
aliasDict = { "curPhone" : phoneDS }
ds = nameDS.execute("select dataset.fullname, curPhone.phone from
dataset join curPhone on dataset.pk=curPhone.fkName", aliasDict)
The error returned is:
"OperationalError: no such table: curPhone"
--------------------------------------------------------
Platform: Win
Python Version: 2.5.4 on win32
Dabo Version: Version 0.9.2; Revision ~5295
UI Version: 2.8.10.1 on wxMSW
On Tue, Jul 14, 2009 at 8:58 AM, tim awa<bop...@gmail.com> wrote:
> 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?
>
_______________________________________________
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/66b6c7c40907131807p66da189ape02bf30db6d69...@mail.gmail.com
