Ann Harrison wrote:

>
> In defense of XCase, isql is being unusually moronic. Many tools either
> parse declarations well enough to recognize the end, or establish a syntactic
> convention (e.g. DEFINE TRIGGER .... END_TRIGGER;) to avoid parsing without
> sending partial commands.
>

Well the only Case tool I know and use inserts SET TERMs without trouble. It is
the sort of thing a decent case tool does, I thought.

And I recall that Oracle also requires specific changing of the terminator when
it parses triggers and SPs, so we are at least in illustrious company, although
it is not a role model I would recommend.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further