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: [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/[email protected]
