FlameRobin Files

FlameRobin 26.8.7 Release Notes

FlameRobin v26.8.7 delivers important bug fixes for clipboard export operations, dependency inspection for system domains and indices, and table column creation.

Highlights & Key Improvements

1. Unexpected Comma on Timestamp Copy Operations Fix (#694)

• Settings Configuration Fix: Corrected default TimestampFormat in conf-defs/fr_settings.confdef from D.N.Y, H:M:S.T to D.N.Y H:M:S.T (removing the misplaced comma between date and time) to align with standard SQL syntax and existing parser fallbacks.
• Automatic Configuration Migration: Added legacy setting migration in GridCellFormats::loadFromConfig() so users upgrading with existing configurations automatically migrate from D.N.Y, H:M:S.T to D.N.Y H:M:S.T.
• SQL Literal Formatting for Clipboard Export: Updated DataGridTable::getCellValueForInsert() to use Firebird-formatted SQL literals via DataGridRows::getFieldFirebirdValue() (TimestampColumnDef::getAsFirebirdString, DateColumnDef, TimeColumnDef, StringColumnDef, BlobColumnDef) ensuring valid SQL without locale decorators across "Copy as INSERT", "Copy as UPDATE", "Copy as UPDATE OR INSERT", and "Copy as IN list".
• Flexible Timestamp Parsing: Updated GridCellFormats::parseTimestamp() to gracefully accept both space and comma separators between date and time.
• Automated Tests: Updated DataGridDateTest.cpp with timestamp format validation.

2. System Domain Dependencies & Double-Click Navigation Fix (#695)

• Resolved "Unsupported type" Error: Mapped ntSysDomain (and ntSysRole, ntSysPackage, ntSysIndices) in MetadataItem::getDependencies() to eliminate the Unsupported type error when inspecting Dependencies for system domains (e.g. RDB created by legacy tools).
• Domain Usage Resolution: Added dependency query resolution for domain references in relation fields (RDB), procedure parameters (RDB), and function arguments (RDB on Firebird 3+) so referencing tables, columns, and parameters are listed under Dependencies.
• Double-Click Properties Navigation: Added ntSysDomain, ntSysCollation, ntGTT, and ntUsrIndices to MainFrame::OnTreeItemActivate() so double-clicking on system domains in the database tree automatically opens their properties.
• Icon Support: Added ART_SystemDomain icon mapping in MetadataItemPropertiesFrame.cpp.

3. System Indices & User Indices Dependencies Resolution (#696)

• Resolved Empty Dependencies Lists: Added comprehensive dependency queries in MetadataItem::getDependencies() for ntIndex, linking indices to their underlying table and column segments (RDB + RDB), table constraints (RDB), and foreign key partner indices / target tables (RDB.RDB).
• Unified Index Lookup: Updated Database::findByNameAndType() to search across indicesM, sysIndicesM, and usrIndicesM.

4. Boolean Column Definition Character Set / Collation Syntax Error Fix (#698)

• Field Properties Datatype Definition: Fixed isChar metadata property in FieldPropertiesDialog.cpp for the Boolean datatype so Character Set and Collation choices are disabled for Boolean columns.
• Valid SQL Generation: Prevented invalid CHARACTER SET ... COLLATE ... clauses from being emitted in generated ALTER TABLE ... ADD COLUMN statements for boolean fields.

Full Commit Log since v26.8.6

• d46b2c70 Release v26.8.7: Bug fixes for timestamp copy, system domains/indices dependencies, and boolean columns (#694, [#695], [#696], [#698])