on propertys of views i get no "Objects that depend on" but there exists. i can lookup fro this objects on systemtable rdb$dependencies
Confirmed on 0.9.3 x64 Windows (git hash 1186200, the latest snapshot).
Probably cause for/related to this problem: exporting database DDL gives the wrong order for views that depend on other views; e.g. the view part of the attached DDL script leads to an error:
At line 28, column 27
when trying to CREATE VIEW FLAT that depends on TESTSUITESFLAT
You seem to have CSS turned off.
Please don't fill out this field.
Problem still present on current snapshot.
Possible hint for solution (humbly given, I'm not a C/C++ guy at all): in a FreePascal/Lazarus Firebird management tool, TurboBird, we've implemented a topological sort of the dependencies within the views category, as well as the stored procedure category.
The relevant commit for stored procs:
- topological sort could be provided by a C/C++ implementation a la http://rosettacode.org/wiki/Topological_sort#C
- The procedure TdmSysTables.SortDependencies that takes a list of objects (stored proc names, view names etc, and sorts them using the rdb$dependencies table and the topological sort algorithm above) could be adapted to FlameRobin