Re: SQL Navigator - syntax question

In article <ai86ig$18hq$1_at_ns.felk.cvut.cz>, Pavel.Vet_at_volny.cz says...
> Hello,
>
> I have relatively trivial question:
> Where should I use the "/" separator?
>
> I found, that I must use it when separating triggers, but I must not use it
> between creating indexes and so.
>
> Please - is this an SQL syntax or need of SQL navigator?
>
> Another question - please can I download a documentation for SQL Navigator
> somewhere? All I got here is a xerox copy of Getting Started Guide.
>

SQL Navigator has online-help, otherwise look on their site www.quest.com.

[Quoted] 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 Received on Wed Jul 31 2002 - 11:56:31 CEST