On Thursday, August 18, 2011 09:39:47 am Vineet Deodhar wrote: > Dear John & other list-members, > I have pasted the code on http://dabo.codepad.org/FBIoYWUe > But it can't be run as it is. > It requires web2py framework. > Fortunately, its deployment is JUST copy & paste. > If the code lines pasted there are not sufficient to debug, I can upload > the entire code (25 MB) .zip file on yahoo & send the link in email. Pl. > see if you can help in trapping the error. > > Thanks, > Vineet > From: John Fabiani <jo...@jfcomputer.com> > To: Vineet Deodhar <d_vin...@yahoo.com>; Dabo Users list > <dabo-users@leafe.com> Sent: Thursday, 18 August 2011, 19:26 > Subject: Re: [dabo-users] Error in _getRecord() of dCursorMixin() > > On Thursday, August 18, 2011 06:34:37 am Vineet Deodhar wrote: > > Hi ! > > As stated earlier on this list, I am using standalone 'bizobj' class with > > 'web2py'. I imported the entire dabo folder in my app. > > Database server is MySQL DB. > > There is a parent bizobj named as 'statBizObj'; (it has a child bizobj > > named as 'distBizObj') > > Upon encountering 'statBizObj.requery()' statement, > > exception is thrown when it runs 'requeryAllChildren()' method. > > I debugged via 'PyScripter' & could see that the bizobj can talk to the > > database & fetch rows. > > When it encounters '_getRecord()' method in 'dCursorMixin()', following > > traceback is displayed:-- -------------------------Traceback (most recent > > call last): > > File "F:\py\web2py\gluon\restricted.py", line 192, in restricted > > exec ccode in environment > > File "F:/py/web2py/applications/mywheels/models/aafirst.py", line 54, in > > <module> statBizObj.requery() > > File "F:\py\web2py\site-packages\dabo\biz\dBizobj.py", line 1098, in > > requery self.requeryAllChildren() > > File "F:\py\web2py\site-packages\dabo\biz\dBizobj.py", line 1706, in > > requeryAllChildren child.requery() > > File "F:\py\web2py\site-packages\dabo\biz\dBizobj.py", line 1063, in > > requery _childParamTuple = self.setChildLinkFilter() > > File "F:\py\web2py\site-packages\dabo\biz\dBizobj.py", line 1130, in > > setChildLinkFilter (self.Parent.IsAdding and not self.ParentLinkField): > > File "F:\py\web2py\site-packages\dabo\biz\dBizobj.py", line 2528, in > > _isAdding return self._CurrentCursor.IsAdding > > File "F:\py\web2py\site-packages\dabo\db\dCursorMixin.py", line 2823, in > > _getIsAdding getattr(self.Record, kons.CURSOR_TMPKEY_FIELD) > > File "F:\py\web2py\site-packages\dabo\db\dCursorMixin.py", line 2872, in > > _getRecord ret = self._cursorRecord = dabo.db._getRecord(self) > > AttributeError: 'module' object has no attribute '_getRecord' > > Code line in ''dCursorMixin()' is: > > ret = self._cursorRecord = dabo.db._getRecord(self) > > > > > > > > Pl. tell me where I may be mistaken. > > (for advising on this error, if you need any additional info about my > > code, pl. tell.) > > Thanks, > > ---Vineet------------------------- > > Please post your code at > http://dabo.codepad.org/ > Johnf
Please try moving a little code statBizObj = PublicStatBizobj(oConn) distBizObj = PublicDistBizobj(oConn) distBizObj.ParentLinkField = 'statid' distBizObj.LinkField = 'statid' distBizObj.FillLinkFromParent = True statBizObj.addChild(distBizObj) You do not need to distBizObj.requery() - it is the child of the parent (stat) and the requery it is done for you in Dabo. Also I believe you wanted to show all the records from 'dist' with the associated 'statid'. I thought you understood you needed to add a third datasource. I believe I provide several ways to get that done. Or you could reverse the parent and child relationship and display all of the records from dist in a grid. If the number of records in dist will be small (less than 1000) you will not have to touch the 'limit'. Johnf --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/201108181124.59384.jo...@jfcomputer.com