| Subject | Re: [ib-support] poor administration tools |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-01-26T12:00:40Z |
At 12:37 PM 26-01-02 +0100, you wrote:
Of course, you have to understand that they don't work with classic servers nor with sub-6 versions of InterBase. IB 6 was the first version to have a published Services API.
The big problem with service components is that the so-called "Services API" which they support is itself a big mess. Opinions vary as to whether it should be fixed or just left to rot. The command-line tools at least work; IBO components give you access to quite a substantial proportion of the "so-called Services API" through isc_info* calls; and it's not rocket science to build a GUI for the command-line tools.
>I hope also IBO will complete the components, for theAs far as the service components are concerned, IBX does support Firebird. Firebird hasn't changed the Services API. Have you actually tried to use them? For me they work "as expected" inside any Delphi application, including IBO.
>API-Service. i cannot use IBX for it, because IBX will not
>support Firebird ...
Of course, you have to understand that they don't work with classic servers nor with sub-6 versions of InterBase. IB 6 was the first version to have a published Services API.
The big problem with service components is that the so-called "Services API" which they support is itself a big mess. Opinions vary as to whether it should be fixed or just left to rot. The command-line tools at least work; IBO components give you access to quite a substantial proportion of the "so-called Services API" through isc_info* calls; and it's not rocket science to build a GUI for the command-line tools.
----- Original Message -----
> From: Duilio Foschi
> To: ib-support@yahoogroups.com
> Sent: Saturday, January 26, 2002 9:49 AM
> Subject: [ib-support] poor administration tools
>
>
> until now, I have tried WISQL, IB_SQL and IBAdmin.
>
> None of them seems able to answer this simple question:
>
> given a certain table A that I want to drop, which are the tables that have
> constraints on A (and that prevent me from dropping the table) ?
>
> Is it difficult to answer such a question ?
The admin tools assume that you know SQL. To build a GUI that makes the metadata transparent to an absolute beginner would require a major development project. The developers of the tools available (there are a lot and most of them are good-to-excellent) focus on the needs of developers doing production work and assume their users understand what they are doing.
IOW, I doubt whether you will find any database management tool that teaches you what you don't know, or circumvents the need to get knowledge of how the database works or to learn the syntax of its language.
regards,
Helen
All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________