вопрос

← →
Pavel (2004-04-29 15:16) [0]

ЗДРАСТВУЙТЕ.

ВЫПОЛНЯЮ В INTERBASE SQL:

CREATE TRIGGER SETMUSICGEN FOR ARTIST BEFORE INSERT AS
begin
new.code = gen_id(music_gen, 1)
end

ВЫДАЕТ ОШИБКУ :

Dynamic SQL Error
SQL error code = -104
Token unknown - line 4, char -1
end
Statement: CREATE TRIGGER SETMUSICGEN FOR ARTIST BEFORE INSERT AS
begin
new.code = gen_id(music_gen, 1)
end

/////////////****************
TABLE ARTIST - IS
music_gen GENERATOR - IS

зАРАНИЕ БЛАГОДАРЕН ЗА ПОМОЩЬ.

← →
Johnmen © (2004-04-29 15:19) [1]

; в конце операции присваивания...

← →
Pavel (2004-04-29 15:22) [2]

; СТАВЬ НЕ СТАВЬ ПОГОДЫ НЕ МЕНЯЕТ

← →
stone © (2004-04-29 15:28) [3]

SET TERM !! ;
CREATE TRIGGER SETMUSICGEN FOR ARTIST BEFORE INSERT AS
begin
new.code = gen_id(music_gen, 1);
end !!
SET TERM ; !!

> new.code = gen_id(music_gen, 1)

Dialect 3?
new."code" = gen_id("music_gen", 1);

← →
Pavel (2004-04-29 15:33) [5]

Спасибо STONE.
работает.

вопрос Найти похожие ветки