| Subject | Re: [IBO] Set Term in Stored Procedure creation statement |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-04T00:18:15Z |
At 11:53 PM 3/11/2003 +0000, you wrote:
in a script.
2. You can't run multiple statements in a query. They must be run in a
script.
3. If you want to create a procedure module (trigger, SP) interactively,
use IB_SQL, the DSQL window, click the Params checkbox off, and you won't
need SET TERM. (Don't put a terminator on the last END statement though).
IB_SQL also has a very handy script tool that uses TIB_Script.
Helen
>The following code works fine in IBConsole (6.0.1.6)1. SET TERM isn't a DSQL command - it's ISQL and will only work in ISQL or
>But falls over in IBQuery saying
>
>Token unknown - line 1, char 4
>TERM
>
>I have no Ideas. Can anyone help?
>BTW without Set Term not even IBConsole works.
in a script.
2. You can't run multiple statements in a query. They must be run in a
script.
3. If you want to create a procedure module (trigger, SP) interactively,
use IB_SQL, the DSQL window, click the Params checkbox off, and you won't
need SET TERM. (Don't put a terminator on the last END statement though).
IB_SQL also has a very handy script tool that uses TIB_Script.
Helen