Menu

#1 bugs querying metadatas

open
nobody
None
5
2010-01-14
2010-01-14
Anonymous
No

1/ FindTableName('RDB$INDICES').AsDDL returns
CREATE TABLE RDB$INDICES (
RDB$INDEX_NAME CHAR(10) CHARACTER SET UNICODE_FSS,
CHAR(10) instead of CHAR(31)

2/ SQL error
Ambiguous field name between table RDB$FIELDS and table RDB$COLLATIONS
RDB$CHARACTER_SET_ID
solved by adding FLD prefix (line 1094 of uibmetadata)
QRYSysDomains =
'select ' +
' RDB$FIELD_TYPE' +
', RDB$FIELD_SCALE' +
', RDB$FIELD_LENGTH' +
', RDB$FIELD_PRECISION' +
', FLD.RDB$CHARACTER_SET_ID' + // CHARACTER SET <<<<<<-------- HERE

See thread in french here : http://www.developpez.net/forums/d862040/bases-donnees/firebird/connexion-aux-bases-donnees/uib-asdll-retourne-valeurs-etranges/#post4919052

++

Discussion


Log in to post a comment.