On Aug 31, 2007, at 11:18 PM, dw wrote:

> 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"""

I'm stumped. I just used the Class Designer to create a form, and

create a grid on it using the Data Environment wizard as you did. I

used a connection file to an SQLite database that I use for tracking

suspicious IP addresses that hit my server. I changed the DataField

for a column to an alias that didn't exist in the table, and then

changed the generated bizobj code to delete the SQL Builder stuff,

and define the UserSQL to include the aliased field. Here's the

bizobj code:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

def createBizobjs(self):

class IphitsBizobj(dabo.biz.dBizobj):

def afterInit(self):

self.DataSource = "iphits"

self.KeyField = "pkid"

self.UserSQL = """select pkid, hittime, ipaddress as crappo

from iphits

order by hittime desc"""

def validateRecord(self):

"""Returning anything other than an empty string from

this method will prevent the data from being saved.

"""

ret = ""

# Add your business rules here.

return ret

iphitsBizobj = IphitsBizobj(self.Connection)

self.addBizobj(iphitsBizobj)

def afterInitAll(self):

self.requery()

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

The grid column that was originally created with a DataField of

'ipaddress' was changed so that it now had DataField = "crappo". I

ran the design, and everything appeared as expected. From the running

design, I pressed Cmd-D to bring up a command window, and typed

'print self.PrimaryBizobj.getDataSet()', and the output showed a

series of rows, each of which had a key named 'crappo'.

Is it possible that SQLite is changing the case of the alias name?

Try this: right after your self.requery(), add the line:

print self.PrimaryBizobj.getDataSet()[0].keys()

...in order to see what the fields in your data set are actually named.

-- Ed Leafe

-- http://leafe.com

-- http://dabodev.com