Subject | IB_SQL Browser not displaying list of generators |
---|---|
Author | Helen Borrie |
Post date | 2008-07-25T15:14:51Z |
Jason,
The needed fix is to change the SQL for frmBrowse.qrGenInf in IBF_Browse.pas from
SELECT RDB$GENERATOR_NAME
FROM RDB$GENERATORS
WHERE RDB$SYSTEM_FLAG IS NULL
ORDER BY RDB$GENERATOR_NAME
to
SELECT RDB$GENERATOR_NAME
FROM RDB$GENERATORS
WHERE RDB$SYSTEM_FLAG IS NULL
or rdb$system_flag = 0
ORDER BY RDB$GENERATOR_NAME
This affects all FB versions 2.0 and higher.
Helen
The needed fix is to change the SQL for frmBrowse.qrGenInf in IBF_Browse.pas from
SELECT RDB$GENERATOR_NAME
FROM RDB$GENERATORS
WHERE RDB$SYSTEM_FLAG IS NULL
ORDER BY RDB$GENERATOR_NAME
to
SELECT RDB$GENERATOR_NAME
FROM RDB$GENERATORS
WHERE RDB$SYSTEM_FLAG IS NULL
or rdb$system_flag = 0
ORDER BY RDB$GENERATOR_NAME
This affects all FB versions 2.0 and higher.
Helen