The colum is not calculated. The table is as follows:

CREATE TABLE Assay (
assayID DOUBLE PRECISION NOT NULL,
assayNo CHAR(10),
name CHAR(30),
assayCategoryID DOUBLE PRECISION,
displayPos INTEGER
);

The query is SELECT * from ASSAY

where DISPLAYPOS is the field causing problems...