Subject | Illegal use of keyword VALUE |
---|---|
Author | Jorge Andrés Brugger |
Post date | 2006-03-30T12:21:37Z |
Hi. Can anyone tell me what's wrong with this statement?
CREATE TABLE RESERVAS_STOCK(CODIGO_DEPOSITO D_CODIGO_DEPOSITO NOT NULL,
NUMERO_TERMINAL SMALLINT NOT NULL,
CODIGO_PRODUCTO D_CODIGO_PRODUCTO NOT NULL,
CANTIDAD INTEGER NOT NULL CHECK(value > 0),
TIPO_RESERVA SMALLINT NOT NULL CHECK(value in (1,2)));
It returns:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
Dynamic SQL Error.
SQL error code = -901.
Illegal use of keyword VALUE.
Using FB 1.5.3
Regards!!
--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar
CREATE TABLE RESERVAS_STOCK(CODIGO_DEPOSITO D_CODIGO_DEPOSITO NOT NULL,
NUMERO_TERMINAL SMALLINT NOT NULL,
CODIGO_PRODUCTO D_CODIGO_PRODUCTO NOT NULL,
CANTIDAD INTEGER NOT NULL CHECK(value > 0),
TIPO_RESERVA SMALLINT NOT NULL CHECK(value in (1,2)));
It returns:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
Dynamic SQL Error.
SQL error code = -901.
Illegal use of keyword VALUE.
Using FB 1.5.3
Regards!!
--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar