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
