mi crea la tabella mi crea il generatore....ma mi da errore la trigger
questo il codice:

codice:
CREATE TABLE prova(
id INTEGER NOT NULL,
testo VARCHAR(255),
PRIMARY KEY(id)
);

CREATE GENERATOR GEN_PK_prova;
COMMIT;

CREATE TRIGGER BI_prova FOR prova
ACTIVE BEFORE INSERT
AS
BEGIN
  IF(NEW.id IS NULL) THEN 
    NEW.ID = GEN_ID(GEN_PK_prova, 1);
END
errore:

codice:
Starting transaction...
Preparing query: CREATE TRIGGER BI_prova FOR prova
ACTIVE BEFORE INSERT
AS
BEGIN
  IF(NEW.id IS NULL) THEN 
    NEW.ID = GEN_ID(GEN_PK_prova, 1)
*** IBPP::SQLException ***
Context: Statement::Prepare( CREATE TRIGGER BI_prova FOR prova
ACTIVE BEFORE INSERT
AS
BEGIN
  IF(NEW.id IS NULL) THEN 
    NEW.ID = GEN_ID(GEN_PK_prova, 1) )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command


Execute time: 00:00:00.