Re: SQL Navigator - syntax question
From: Pavel Vetesnik <Pavel.Vet_at_volny.cz>
Date: Wed, 31 Jul 2002 13:00:06 +0200
Message-ID: <ai8fvn$1bnl$1_at_ns.felk.cvut.cz>
Date: Wed, 31 Jul 2002 13:00:06 +0200
Message-ID: <ai8fvn$1bnl$1_at_ns.felk.cvut.cz>
> You should use a slash after each multiline SQL command (such as CREATE
> TRIGGER) in Navigator's SQL Script Editor:
>
> DELETE FROM emp
> WHERE empno = 1
> /
> COMMIT
> /
> CREATE TRIGGER ...
> /
>
> You can also use a semicolon after a single-line command:
>
> DELETE FROM emp WHERE empno = 1;
> COMMIT;
>
> In Navigator's "Single SQL Editor" don't use any terminators at all.
>
> hth,
> Tom
Hi Tom,
thank you for quick answer.
I actually run my code within the SQL Editor and without separating triggers
with "/" I always got a message "CREATE not found" or something like that.
But it works now, so I am happy <g>,
Pavel
Received on Wed Jul 31 2002 - 13:00:06 CEST