Ed Leafe <ed@...> writes:

>

>

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

>

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

>

the output with print self.PrimaryBizobj.getDataSet()[0].keys() is:

['Date0', 'StorageBox0', 'Type0_fk', 'location0', 'InfSource0', 'Descript0',

'Name0',

'RecSource0', 'RecID', 'HideOnline']

Dabo Info Log: Sat Sep 01 12:56:48 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

However, my grid is filled with a dataset that is a child of the PrimaryBizobj,

so the field alias and other grid fields are not listed with

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

dwarder