Hi,

I don't know what's wrong with this script, but it generates a "Invalid CREATE, CONNECT or DROP DATABASE syntax" :

IF (SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME = 'TYPES') IS NULL THEN
CREATE TABLE TYPES (
T_CODE VARCHAR( 5 ) NOT NULL PRIMARY KEY,
T_OMSCHR VARCHAR( 40 ))


Any idea ?

Thanks a lot,

Nico