I am getting some progress with pdb thru google. On Thu, Jul 16, 2009 at 6:40 AM, tim awa<[email protected]> wrote: > In the class designer, when running the form, there is a debugger > window. I have been looking at this window but there seems to be no > activity there even when there is an error. To be able to see the > error, I have to run the form/app at the console using python test.py. > > I found this at the wiki - http://dabodev.com/wiki/WinPDB. Any simpler > alternative to WinPDB? > > > On Thu, Jul 16, 2009 at 12:19 AM, <[email protected]> wrote: >> Tim, >> >> Great! When I get into trouble, one of the first things I do is go thru the >> call stack and look at the functions and parameters to try to see what it is >> expecting. That's how I tracked this one down for ya. >> >> Larry >> >>> -----Original Message----- >>> From: [email protected] >>> [mailto:[email protected]] On Behalf Of tim awa >>> Sent: Wednesday, July 15, 2009 8:59 AM >>> To: Dabo Users list >>> Subject: Re: [dabo-users] Joins on datasets >>> >>> Nice one Larry, you solved the puzzle (cursorDict=). Thanks! >>> >>> >>> On Wed, Jul 15, 2009 at 1:57 PM, <[email protected]> wrote: >>> > Try... >>> > ds = nameDS.execute("select dataset.fullname, curPhone.phone from >>> > dataset join curPhone on >>> dataset.pk=curPhone.fkName",cursorDict={ "curPhone" : >>> > phoneDS }) >>> > >>> > >>> >> -----Original Message----- >>> >> From: [email protected] >>> >> [mailto:[email protected]] On Behalf Of tim awa >>> >> Sent: Wednesday, July 15, 2009 12:25 AM >>> >> To: Dabo Users list >>> >> Subject: Re: [dabo-users] Joins on datasets >>> >> >>> >> I actually tried various combinations and nothing worked. >>> >> Each reasonable attempt yields the same error - >>> >> "OperationalError: no such table: curPhone". >>> >> >>> >> The alias curPhone seems to be not pointing to the actual dataset >>> >> which is phoneDS. It traces back to line 372 in >>> dabo\db\dDataSet.py >>> >> >>> >> >From the error message, curPhone is the table being queried >>> >> in the sql >>> >> statement w/c may not be the case as the actual dataset is phoneDS. >>> >> Just my thought. >>> >> >>> >> For a workaround, I created a Bizobj for the join. However, this >>> >> dataset join issue still appears as a bug to me. >>> >> >>> >> >>> >> On Wed, Jul 15, 2009 at 11:34 AM, <[email protected]> wrote: >>> >> > Tim, >>> >> > >>> >> > Dunno, looks right. Is it possible that there are no >>> phoneDS.fkName >>> >> > matching nameDS.pk? >>> >> > >>> >> > One possible thing...check to make sure that the field >>> "fkName" is >>> >> > actually spelled (capitalized) the way you have it in the >>> >> dataset. I >>> >> > don't know if it works the same here but in Postgres if >>> you have a >>> >> > mixed case name it sometimes needs to be enclosed in quotes >>> >> in the select statement. >>> >> > >>> >> > HTH, >>> >> > Larry >>> >> > >>> >> > >>> >> >> -----Original Message----- >>> >> >> From: [email protected] >>> >> >> [mailto:[email protected]] On Behalf Of tim awa >>> >> >> Sent: Tuesday, July 14, 2009 9:15 PM >>> >> >> To: Dabo Users list >>> >> >> Subject: Re: [dabo-users] Joins on datasets >>> >> >> >>> >> >> I revisited the issue noticing that I had the typo "PhoneDS" >>> >> >> on my original post. Following is the code that i tested: >>> >> >> >>> >> >> """" >>> >> >> nameDS = self.PrimaryBizobj.getDataSet() phoneDS = >>> >> >> self.getBizobj(dataSource="public.tblphone").getDataSet() >>> >> >> >>> >> >> nameDS.execute("select * from dataset") >>> phoneDS.execute("select * >>> >> >> from dataset") >>> >> >> >>> >> >> aliasDict = { "curPhone" : phoneDS } ds = >>> nameDS.execute("select >>> >> >> dataset.fullname, curPhone.phone from dataset join curPhone on >>> >> >> dataset.pk=curPhone.fkName", >>> >> >> aliasDict) """" >>> >> >> >>> >> >> I tried again with the above code but still no joy. >>> >> >> >>> >> >> >>> >> >> >>> >> >> On Wed, Jul 15, 2009 at 8:23 AM, tim >>> awa<[email protected]> wrote: >>> >> >> > My eyes are fooling me. I am aware of the >>> case-sensitiveness of >>> >> >> > Python. But for some reasons, I was not able to >>> detect it. LOL. >>> >> >> > >>> >> >> > >>> >> >> > On Wed, Jul 15, 2009 at 6:48 AM, Ed Leafe<[email protected]> wrote: >>> >> >> >> On Jul 14, 2009, at 5:41 PM, tim awa wrote: >>> >> >> >> >>> >> >> >>> I can't spot any difference in the two lines of code that >>> >> >> you posted. >>> >> >> >> >>> >> >> >> PhoneDS != phoneDS >>> >> >> >> >>> >> >> >> Case sensitivity sucks, but that's the way Python >>> >> >> works. Your >>> >> >> >> code mixes the capitalized and lower-case versions. >>> >> >> >> >>> >> >> >> >>> >> >> >> -- Ed Leafe >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> >> >> >> >>> >> >> >> [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/[email protected]
