Ed Leafe wrote:
> dabo Commit
> Revision 3323
> Date: 2007-08-22 18:07:43 -0700 (Wed, 22 Aug 2007)
> Author: Ed
> Trac: http://svn.dabodev.com/trac/dabo/changeset/3323
>
> Changed:
> U trunk/dabo/db/dBackend.py
> U trunk/dabo/db/dCursorMixin.py
> U trunk/dabo/db/dbFirebird.py
> U trunk/dabo/db/dbMsSQL.py
> U trunk/dabo/db/dbMySQL.py
> U trunk/dabo/db/dbOracle.py
> U trunk/dabo/db/dbPostgreSQL.py
> U trunk/dabo/db/dbSQLite.py
>
> Log:
> Revamped some of the routines that called for the backend object to create
> its own cursor. These now are called from dCursorMixin passing along the
> AuxCursor, so that there should be no discrepancy between the 'selected'
> database, as was reported by a few people.
>
> As I haven't run into this in my apps, the fact that all my apps are working
> OK with these changes doesn't reassure me very much, so please test these
> changes and let me know if a) the problem is fixed; b) if the problem
> remains; or c) if new problems are appearing.
>
This change doesn't work for me:
...
Database Activity Log: Thu Aug 23 09:28:10 2007: SQL: SELECT first 1000
e_val, e_tok, iid from etyp order by e_tok
Database Activity Log: Thu Aug 23 09:28:10 2007: FAILED SQL: select
inseg."RDB"$field_name from rdb$indices idxs join
rdb$index_segments inseg on idxs."RDB"$index_name
= inseg."RDB"$index_name where
idxs."RDB"$relation_name = 'ETYP' and idxs."RDB"$unique_flag = 1 ,
PARAMS:
Dabo Error Log: Thu Aug 23 09:28:10 2007: Database Execution failed with
response: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL error
code = -104\n Token unknown - line 1, column 20\n $')
SQL: select inseg."RDB"$field_name
from rdb$indices idxs join rdb$index_segments inseg
on idxs."RDB"$index_name = inseg."RDB"$index_name
where idxs."RDB"$relation_name = 'ETYP'
and idxs."RDB"$unique_flag = 1
I locked at the cursor object in dbFirebird.getFields():
<dabo.biz.dBizobj.cursorMix (baseclass dabo.biz.dBizobj.cursorMix,
id:149913068)>
This is wrong, as it should be something like:
<kinterbasdb.Cursor object at 0x8faf150>
I didn't look further, as i think you will know where it is wrong.
Uwe
_______________________________________________
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/dabo-dev/[EMAIL PROTECTED]
