I created and set a generator as follows:

CREATE GENERATOR UNIQNO;

SET GENERATOR UNIQNO TO 10000;


I also created a view as follows:

CREATE VIEW "VUNIQNO"
(
"UNIQ_NO"
) AS
SELECT GEN_ID(UNIQNO, 1) FROM RDB$DATABASE;


In IBConsole, I connect to my database and click on VIEWS. Then
after double-clicking the VUNIQNO view I attempt to click on the
DATA tab. The following message appears:

Dynamic SQL Error
SQL error code = -104
Token unknown – line 1, char 24
)


Can anyone tell me what I am doing wrong here? I am using Firebird
1.0 for Linux.

Thanks,
Paul