Ed Leafe <[EMAIL PROTECTED]> writes:
>
> That's odd - adding a couple of print statements shouldn't change
> the error.
>
> Are you sure that the UserSQL is set to a statement that has a field
> alias of 'phType'? Your original example did.
>
I apologize. The originally posted debug output was from a different error. The
actual error is the same as is generated with the altered
dDataControlMixinBase.py file. When SQL Builder constructs the
query and the field alias 'phType' is added,
field 'phType' is found in the dataset. When the same SQL is constructed
manually and UserSQL is invoked, the field alias 'phType' is not found in the
dataset, although it is created in the query :
testsql = """Select FotoInf.count0, FotoInf.recordID_fk, FotoInf.FInfoID_fk,
InfoPT.photoType as phType From FotoInf inner join InfoPT on
FotoInf.FInfoID_fk = InfoPT.InfoID"""
/***debug output that should have accompanied the original post********/
Dabo Info Log: Thu Aug 30 22:51:57 2007: 1 database connection definition(s)
loaded.
Dabo Info Log: Thu Aug 30 22:51:58 2007: User interface set to 'wx' by dApp.
Dabo Info Log: Thu Aug 30 22:51:58 2007: wxPython Version: 2.8.1.1 wxMSW
(unicode)
Dabo Info Log: Thu Aug 30 22:51:59 2007: WARNING: No BasePrefKey has been set
for this application.
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
/*****debug output after the dDataControlMixinBase.py was altered******/
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.
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
_______________________________________________
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]
