Re: [dabo-users] SQL Builder versus UserSQL

Author: dw

Posted: 2007-08-31 at 18:28:05

Ed Leafe <ed@...> writes:

>

> On Aug 31, 2007, at 5:26 PM, dw wrote:

>

>

> I have an idea what's going on here, but if you would be willing to

> help me out a little more...

>

> If you could modify C:\projects\dabo\ui\dDataControlMixinBase.py so

> that the following two unnumbered debugging lines are added between

> the current lines 108-109

>

> 107 if self.Source and self._srcIsBizobj:

> 108 # First see if DataField refers to a method of the bizobj:

> print "SOURCE", self.Source

> print "DATAFIELD", self.DataField

> 109 method = getattr(self.Source, self.DataField, None)

> 110 if method is not None:

> 111 self.Value = method()

>

> Run the code that uses the UserSQL version, and then post the

> debugging output here.

>

With the modifications, the debugging output is:

Dabo Info Log: Fri Aug 31 19:19:37 2007: 1 database connection definition(s)

loaded.

Dabo Info Log: Fri Aug 31 19:19:38 2007: User interface set to 'wx' by dApp.

Dabo Info Log: Fri Aug 31 19:19:38 2007: wxPython Version: 2.8.1.1 wxMSW

(unicode)

Dabo Info Log: Fri Aug 31 19:19:38 2007: WARNING: No BasePrefKey has been set

for this application.

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD RecID

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Name0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD location0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Date0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD InfSource0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD RecSource0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD StorageBox0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Type0_fk

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD HideOnline

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Descript0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD RecID

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Name0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD location0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Date0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD InfSource0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD RecSource0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD StorageBox0

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Type0_fk

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD HideOnline

SOURCE <__builtin__.RecnameBizobj (baseclass dabo.biz.dBizobj, id:34985392)>

DATAFIELD Descript0

Dabo Info Log: Fri Aug 31 19:19:50 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 1285, 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

dwarder

©2007 dw