Subject Re: [firebird-support] Set term gives Token unknown error
Author Helen Borrie
At 08:20 AM 26/04/2008, you wrote:
>Ah ok I was trying to run it in the DSQL window. (I told you I haven't used
>this stuff in quite a while lol!)
>Why does SET TERM ^ ; not work in the DSQL window in IB_SQL, and it also
>does not work in Database Explorer (from the Enter SQL window), but it works
>from within IB_SQL when you select Execute Script from the Connection tab?
>What I am trying to do is to create a new table and create a primary key
>generator stored procedure. Standard stuff I think?

1. SET TERM isn't a DSQL statement. It's a special command that works only in the isql command-line tool. But if you run it in a script box using ib_sql, ib_sql's parser handles it by recognising it and then skipping it.

2. In a DSQL tool you can't run scripts (batches of statements).

3. Don't forget to include COMMIT statements in scripts on any object that you're going to refer to later in the script.