Subselects and INSERT statements with McKoi

Hi,

I tried the following query:

INSERT INTO SKILLS (ID, NAME, DESCRIPTION) VALUES ((SELECT MAX(ID)+1 FROM
SKILLS), "Java", "Java programming");

...on a table defined as:

CREATE TABLE IF NOT EXISTS SKILLS (
 ID                     INTEGER       NOT NULL,
 NAME                   VARCHAR(32)   NOT NULL,
 DESCRIPTION            VARCHAR(4096) NOT NULL,
 PRIMARY KEY (ID),
 UNIQUE(NAME)
);

McKoi DB's SQL parser rejects this query.  Is there any way I can perform
something along those lines without triggers/sequences?

Thanks,
Chris B




---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]