Re: [dabo-users] SQL Builder versus UserSQL

Ed Leafe <ed@...> 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)