Uwe Grauer wrote:
> Ed Leafe wrote:
>> dabo Commit
>> Revision 5180
>> Date: 2009-04-18 06:55:13 -0700 (Sat, 18 Apr 2009)
>> Author: Ed
>> Trac: http://trac.dabodev.com/changeset/5180
>>
>> Changed:
>> U   trunk/dabo/biz/dBizobj.py
>> U   trunk/dabo/db/dCursorMixin.py
>>
>> Log:
>> Revamped the code for determining the alias used in a child filter. 
>> Previously the bizobj's DataSource was used, which incorrectly assumed that 
>> that would be the correct alias. This addresses the issue (Trac #1228) 
>> raised by Sibylle Koczian.
>>
>>
> 
> I noticed that this commit breaks my code.
> 
> With rev 5180, i get:
>  ./fwadm.py
> Calling app.setLanguage("en_US", "UTF8")
> Database Activity Log: Thu May 28 17:28:22 2009:
> kinterbasdb.init(type_conv=300)
> self.Charset: UTF8
> connect with ugApp.Charset = UTF8
> Database Activity Log: Thu May 28 17:28:25 2009: SQL: SELECT  first 1000
> etyp."E_VAL",        etyp."E_TOK",        etyp."IID"   from etyp  order
> by e_tok
> Database Activity Log: Thu May 28 17:28:25 2009: SQL:  SELECT
> S.RDB$FIELD_NAME AS COLUMN_NAME           FROM RDB$RELATION_CONSTRAINTS
> RC  LEFT JOIN RDB$INDICES I ON (I.RDB$INDEX_NAME = RC."RDB$INDEX_NAME")
>                      LEFT JOIN RDB$INDEX_SEGMENTS S ON (S.RDB$INDEX_NAME
> = I.RDB$INDEX_NAME)            WHERE (RC."RDB$CONSTRAINT_TYPE" =
> 'PRIMARY KEY')                AND (I.RDB$RELATION_NAME = 'ENUM')
> Database Activity Log: Thu May 28 17:28:25 2009: SQL:   SELECT
> b.RDB$FIELD_NAME, d.RDB$TYPE_NAME,  c.RDB$FIELD_LENGTH,
> c.RDB$FIELD_SCALE, b.RDB$FIELD_ID  FROM RDB$RELATIONS a  INNER JOIN
> RDB$RELATION_FIELDS b  ON a.RDB$RELATION_NAME = b.RDB$RELATION_NAME
> INNER JOIN RDB$FIELDS c  ON b.RDB$FIELD_SOURCE = c.RDB$FIELD_NAME  INNER
> JOIN RDB$TYPES d  ON c.RDB$FIELD_TYPE = d.RDB$TYPE  WHERE
> a.RDB$SYSTEM_FLAG = 0  AND d.RDB$FIELD_NAME = 'RDB$FIELD_TYPE'  AND
> a.RDB$RELATION_NAME = 'ENUM'  ORDER BY b.RDB$FIELD_ID
> Traceback (most recent call last):
>   File "/usr/lib/python2.5/site-packages/dabo/ui/uiwx/dControlMixin.py",
> line 27, in _onWxHit
>     self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)
>   File "/usr/lib/python2.5/site-packages/dabo/ui/uiwx/dPemMixin.py",
> line 949, in raiseEvent
>     super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
> **kwargs)
>   File "/usr/lib/python2.5/site-packages/dabo/lib/eventMixin.py", line
> 93, in raiseEvent
>     bindingFunction(event)
>   File "/home/uwe/mysrc/ugfw/fwadm/EtypEnumForm.py", line 151, in
> onHit_btnSearch
>     self.requerybysearch()
>   File "/home/uwe/mysrc/ugfw/fwadm/EtypEnumForm.py", line 106, in
> requerybysearch
>     self.requery()
>   File "/usr/lib/python2.5/site-packages/dabo/ui/uiwx/dForm.py", line
> 482, in requery
>     response = bizobj.requery()
>   File "/usr/lib/python2.5/site-packages/dabo/biz/dBizobj.py", line 905,
> in requery
>     self.requeryAllChildren()
>   File "/usr/lib/python2.5/site-packages/dabo/biz/dBizobj.py", line
> 1433, in requeryAllChildren
>     child.requery()
>   File "/usr/lib/python2.5/site-packages/dabo/biz/dBizobj.py", line 871,
> in requery
>     self.setChildLinkFilter()
>   File "/usr/lib/python2.5/site-packages/dabo/biz/dBizobj.py", line 932,
> in setChildLinkFilter
>     self._CurrentCursor.setChildFilter(linkField, val)
>   File "/usr/lib/python2.5/site-packages/dabo/db/dCursorMixin.py", line
> 2150, in setChildFilter
>     alias = self.sqlManager._fromClause.split()[-1]
> IndexError: list index out of range
> 
> rev 5179 works for me.
> 
> If you need more info, just ask.

Did you see this thread:

http://leafe.com/archives/showMsg/418990

Does revision 5204 (http://trac.dabodev.com/changeset/5204) change or fix your 
issue?

Paul


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[email protected]

Reply via email to