bugs querying metadatas
Brought to you by:
progdigy
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
++