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/!~!uenerkvcmdkaaqacaaaaaaaaaaaaaaaaabgaaaaaaaaaafa2fnyupuomnfpiynbeqckaaaaqaaaavt6wfe2b1u2rapgb8hctnaeaa...@charter.net
