On Saturday 03 March 2007 12:36, Ken Dibble wrote:
> >When my query runs, I get a "Please wait...requerying dataset..." window
> >that doesn't go away. The grid does not populate, and an error having to
> > do with the bizobj's KeyField property is generated.
>
> Oops, forgot the traceback:
>
> Traceback (most recent call last):
> File "C:\Program Files\Dabo Runtime\dabo\lib\eventMixin.py", line 97, in
> raiseEvent
> File "ClassDesigner.py", line 1464, in onRunDesign
> File "C:\Program Files\Dabo Runtime\ide\ClassDesignerFormMixin.py", line
> 499, in onRunDesign
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\__init__.py", line 883,
> in createForm
> File "c:\docume~1\kend\locals~1\temp\tmp2g04pa.py", line 9, in __init__
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dForm.py", line 791, in
> __init__
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dForm.py", line 43, in
> __init__
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dFormMixin.py", line
> 68, in __init__
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dPemMixin.py", line
> 200, in __init__
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dForm.py", line 69, in
> _afterInit
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dFormMixin.py", line
> 116, in _afterInit
> File "C:\Program Files\Dabo Runtime\dabo\ui\uiwx\dPemMixin.py", line
> 304, in _afterInit
> File "c:\docume~1\kend\locals~1\temp\tmp2g04pa.py", line 65, in
> afterInit File "c:\docume~1\kend\locals~1\temp\tmp2g04pa.py", line 109, in
> setupBizobj File "C:\Program Files\Dabo Runtime\dabo\biz\dBizobj.py", line
> 707, in requery
> File "C:\Program Files\Dabo Runtime\dabo\biz\dBizobj.py", line 852, in
> _moveToPK
> File "C:\Program Files\Dabo Runtime\dabo\db\dCursorMixin.py", line 1379,
> in moveToPK
> File "C:\Program Files\Dabo Runtime\dabo\db\dCursorMixin.py", line 1362,
> in _getRecordByPk
> KeyError: 'musRecs.pkid'
Your select statement must provide "all" the fields that are part of the
bizobj you defined. So:
addField("field1")
addField("field2")
Your SQL statement must provide field2 and field2.
So the error is tell you that 'musRecs.pkid' is missing from your select
statement.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
