Subject Re: [Firebird-Architect] Strategic Replacement for Services API
Author Martijn Tonies
> >It might be me ... but why not have a "connect to server" piece and then
> >use SQL to get your info from pseudo tables? Why XML?
> >
> >
> >
> The requests are open ended, the data isn't tabular, and doesn't lend
> itself to querying. How do you express "restart server" in sql?

For example with a "system stored procedure".

sp_restartserver ('NOW')

sp_restartserver ('DISCONNECT_FIRST')

or whatever.

Point is, establishing a connection could be easy and could be done
with any tool supporting SQL connections to the server.

Obviously, depending on the user name etc, different functionality
is available.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!