At 05:42 PM 2/7/2001 +0100, Paul Reeves wrote:

>...
>Without [SET TERM] ISQL believes you are trying to execute the following
>series
>of statements:
>
>DECLARE VARIABLE row_count INTEGER;
>...
> INTO :row_count ;
>...
> EXCEPTION xc_i_res ;
>...
>END;
>
>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.


Regards,

Ann
www.ibphoenix.com
We have answers.