On Friday, March 02, 2012 11:04:50 AM Paul McNett wrote: > On 3/2/12 10:55 AM, Paul McNett wrote: > > When confronted by things like this, I like to reduce them down with as > > few variables as possible, in a single, simple script. Please look at > > this script and run it, which seems to prove that there isn't anything > > obviously wrong at the Dabo layer, although you should tweak the script > > to better match your situation, like adding the second table, etc.: > > > > http://paulmcnett.com/test_sqlite_view.py > > Oh, hang on... a click on a grid header results in the traceback: > > {{{ > Traceback (most recent call last): > File "/home/pmcnett/dabo-full/trunk/dabo/ui/uiwx/dGrid.py", line 4161, in > __onWxHeaderMouseLeftUp > self.raiseEvent(dEvents.GridHeaderMouseLeftUp, evt, col=col) > File "/home/pmcnett/dabo-full/trunk/dabo/ui/uiwx/dPemMixin.py", line > 1074, in raiseEvent > super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, > **kwargs) File "/home/pmcnett/dabo-full/trunk/dabo/lib/eventMixin.py", line > 81, in raiseEvent bindingFunction(event) > File "/home/pmcnett/dabo-full/trunk/dabo/ui/uiwx/dGrid.py", line 3632, in > _onGridHeaderMouseLeftUp > self.processSort(col) > File "/home/pmcnett/dabo-full/trunk/dabo/ui/uiwx/dGrid.py", line 2894, in > processSort biz.sort(columnToSort, sortOrder, self.caseSensitiveSorting) > File "/home/pmcnett/dabo-full/trunk/dabo/biz/dBizobj.py", line 1209, in > sort cc.sort(col, ordr, caseSensitive) > File "/home/pmcnett/dabo-full/trunk/dabo/db/dCursorMixin.py", line 593, > in sort self.__sortRows(newCol, newOrd, caseSensitive) > File "/home/pmcnett/dabo-full/trunk/dabo/db/dCursorMixin.py", line 619, > in __sortRows self.__unsortedRows.append(row[kf]) > KeyError: u'id' > }}} > > I messed up writing the script and had the KeyField defined in the bizobj as > "id" and not "Id". Making that change makes grid sorting work just fine, as > well as probably everything else that relies on KeyField. I've fixed the > test script online: > > http://paulmcnett.com/test_sqlite_view.py > > Paul
Your code suggest that it is NOT Dabo that is having the trouble. But what about what ClassDesigner may add to the mix? Could the bizobj class be wrong? Johnf _______________________________________________ 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/2313626.bbqcq51jPc@linux-12
