On Friday, March 02, 2012 07:33:00 PM Dewald Jacobs wrote:

> Hi,

>

> I tried that and I can now successfully choose a View from "Add controls

> from Data Environment" in class designer. The column names also show up in

> the grid. The app runs, but I get the following traceback:

>

> Traceback (most recent call last):

> File "C:\Python27\lib\site-packages\wx-2.8-msw-unicode\wx\_core.py", line

> 1466 9, in <lambda>

> lambda event: event.callable(*event.args, **event.kw) )

> File "C:\projects\dabo\ui\uiwx\dGrid.py", line 2250, in _restoreSort

> self.processSort(sortCol, toggleSort=False)

> File "C:\projects\dabo\ui\uiwx\dGrid.py", line 2894, in processSort

> biz.sort(columnToSort, sortOrder, self.caseSensitiveSorting)

> File "C:\projects\dabo\biz\dBizobj.py", line 1209, in sort

> cc.sort(col, ordr, caseSensitive)

> File "C:\projects\dabo\db\dCursorMixin.py", line 560, in sort

> _("Invalid column specified for sort: ") + col)

> dabo.dException.dException: Invalid column specified for sort: Gebeurtenis

>

> Gebeurtenis is a column in the grid/view. When I then proceed to click on

> the tab in which the grid in question is situated I get an endless loop

> with the following traceback:

>

> Traceback (most recent call last):

> File "C:\projects\dabo\ui\uiwx\dGrid.py", line 331, in GetValue

> ret = self.getStringValue(bizobj.getFieldVal(field, row))

> File "C:\projects\dabo\biz\dBizobj.py", line 1872, in getFieldVal

> ret = self._CurrentCursor.getFieldVal(fld, row,

> _rowChangeCallback=changeRow NumCallback)

> File "C:\projects\dabo\db\dCursorMixin.py", line 940, in getFieldVal

> _("Field"), fld, _("does not exist in the data set")))

> dabo.dException.FieldNotFoundException: Field 'Julian' does not exist in the

> dat a set

>

> Julian is a column in the grid/view. This traceback repeats and cycles all

> the column names from the View. How should I proceed? Is there any other

> info you need from me?

>

> Thanks again.

> Dewald

>

Hmmmmmmm! I don't know enough about SQLite to really be a help. I don't know

if the issue lies with the view or the column data type (never really

understood SQLites lack of data types).

Here's how I'd move forward:

I would try and determine if the issue lies with view or the column by

creating a real table with the same fields and try using it with

ClassDesigner. If works then it has something to do with the view. If not

then it has someting to do with the data type and how the code is trying to

sort.

There have been recent changes to the ClassDesigner and maybe those changes

are causing new issues. Maybe someone with a little experience with SQLite

will jump in and provide a little insight.

Johnf

_______________________________________________

Post Messages to: Dabo-users@leafe.com

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/8019684.MRniqbd0Py@linux-12