Ed Leafe wrote:
> On Aug 23, 2007, at 3:40 AM, Uwe Grauer wrote:
>
>> 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>
>
> No, that's the correct class - it's a subclass of the kinterbasdb
> Cursor class.
>
Sorry, i should have seen this before:
Dabo Error Log: Thu Aug 23 15:01:21 2007: Database Execution failed with
response: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL error
code = -104\n Token unknown - line 3, column 59\n $')
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 = 'ETYP')
The fieldnames in the system tables get quoted in a wrong way:
"RDB"$INDEX_NAME
"RDB"$CONSTRAINT_TYPE
should be:
"RDB$INDEX_NAME"
"RDB"$CONSTRAINT_TYPE"
This didn't happen prior to rev 3323 because the kinterbasdb cursor was
used instead of the cursormixin one.
So dblQuoteField() doesn't work correctly.
I hope you are able to fix it as i am not familiar enough with
regex matching.
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]
