Subject Re: [ib-support] XCase and Interbase 6
Author Ann Harrison
At 05:42 PM 2/7/2001 +0100, Paul Reeves wrote:

>Without [SET TERM] ISQL believes you are trying to execute the following
>of statements:
> INTO :row_count ;
> EXCEPTION xc_i_res ;
>Not surprisingly, an error is thrown.
>I'm surprised that XCase doesn't deal with this automatically - it is a pretty
>fundamental aspect of Client/Server SQL scripting. Perhaps you have missed a
>setting somewhere?

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.


We have answers.