hi lester,
lol, you say i need two tools: IB_SQL. and if marathon comes back: marathon

> - documenting (html) (1% of use)

Documenting What?
structure of db, tables, fields, descripton
(i found another tool for it on www.ibphoenix.com : Interbase Description Tool,
from Zimmeman Software)

> - one click to set statistics on all indexes ... (5% of use)

??
i mean the following p.e.:

procedure TForm1.set_statistics_on_xxx_db;
var
db_flistix :TStringlist;
i :integer;
v_string :string;
begin
memo1.clear;
memo1.lines.add('::::::::SET STATISTICS ON XXXX.GDB:::::::::::::::');
db_flistix:= tstringlist.create;
with q_read_indices do begin
close;
sql.clear;
sql.add('select * from rdb$indices');
open;
first;
while not eof do begin
v_string:= copy((q_read_indexes.fieldbyname('RDB$INDEX_NAME').AsString), 1, 4);
if v_string <> 'RDB$' then
db_flistix.Add(q_read_indexes.fieldbyname('RDB$INDEX_NAME').AsString);
next;
end;
close;
end;
for i:= 0 to (db_flistix.count - 1) do begin
with q_temp do begin
close;
sql.clear;
sql.add('set statistics index '+db_flistix[i]+' ');
execsql;
memo1.lines.add(db_flistix[i]);
end;
q_temp.close;
end;
db_flistix.free;
memo1.lines.add(':::END:::::::::::::::::::::::::::::::::::::::::::::::::');
end;
--------> in many cases it increase the performance very dramatical

> - graphical-relationship -> print (important for thinking about the db)

If you want pictures you can do the software your self <g> (
A lot of effort for little return? )
mhm, if you have to reorganize a big old db, that you don't know, or if you have a new
developer, its very good, to have db-plan in front of you, i have have such allways hanging near me,
a time before i used a tool for it: Erwin, from Computer Associates .., but the reversial engeneering side,
i never used. It's a professional help.
Erwin supports IB very bad, and only over ODBC :(
a tool i found for this is: XCase www.xcase.com
it supports Interbase and Interbase6 dialect 3

> IB_SQL

I searched for the source-code from IB_SQL, but couldn't found it, till now.
In my evulation copy of IBO i didn't found it :(
can you tell me, where i can find it?

- gerhard


[Non-text portions of this message have been removed]