the output with the modified dBizobj.py is:
REQUERY RecName
REQUERY FotoInf
REQUERY tbAssoc
Dabo Info Log: Sat Sep 01 21:58:29 2007: Application finished.
Traceback (most recent call last):
File "C:\projects\dabo\dabo\ui\uiwx\dGrid.py", line 297, in IsEmptyCell
return not bizobj.getFieldVal(field, row)
File "C:\projects\dabo\dabo\biz\dBizobj.py", line 1286, in getFieldVal
return cursor.getFieldVal(fld, row)
File "C:\projects\dabo\dabo\db\dCursorMixin.py", line 781, in getFieldVal
raise dException.FieldNotFoundException, "%s '%s' %s" % (
dabo.dException.FieldNotFoundException: Field 'phType' does not exist in the
data set
Ed Leafe <[EMAIL PROTECTED]> wrote: On Sep 1, 2007, at 7:52 PM, dw wrote:
> adding : # run the requery
> uiException = None
> cursor = self._CurrentCursor
> try:
> cursor.requery(params)
> print "REQUERY", self.DataSource
>
> except dException.ConnectionLostException, e:
>
> generated the following error:
>
> Traceback (most recent call last):
[snip]
> self.afterInit()
> File "c:\docume~1\dew\locals~1\temp\tmp55u9fk.py", line 394, in
> afterInit
> except dException.ConnectionLostException, e:
> NameError: global name 'dException' is not defined
It looks to me like you added that code to your bizobj, and not
dabo.biz.dBizobj, as I had suggested. Either that, or your
indentation didn't match (make sure only tabs are used; tabs are
standard in all Dabo framework code.
What I'm hoping to find out is whether the bizobj with
DataSource="FotoInf" has actually had its requery run at the
framework level before anything tries to reference the aliased field.
So please change your bizobj code back to:
class FotoinfBizobj(dabo.biz.dBizobj):
def afterInit(self):
self.DataSource = "FotoInf"
self.KeyField = "count0"
self.LinkField = "recordID_fk"
testsql = """Select FotoInf.count0, FotoInf.recordID_fk,
FotoInf.FInfoID_fk, InfoPT.photoType
From FotoInf inner join InfoPT on FotoInf.FInfoID_fk =
InfoPT.InfoID"""
self.UserSQL= testsql
...and make the suggested debugging change to dBizobj.py.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
[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/dabo-users/[EMAIL PROTECTED]
