| Subject | Re: Illegal use of keyword VALUE |
|---|---|
| Author | olaf_bredv |
| Post date | 2006-03-30T12:47:55Z |
I think the "integer check(value>0)" is not allowed.
If you write "CANTIDAD INTEGER NOT NULL" the value must be greater
then null or 0
At Integer there is no difference between null and 0.
--- In firebird-support@yahoogroups.com, Jorge Andrés Brugger
<listas@...> wrote:
If you write "CANTIDAD INTEGER NOT NULL" the value must be greater
then null or 0
At Integer there is no difference between null and 0.
--- In firebird-support@yahoogroups.com, Jorge Andrés Brugger
<listas@...> wrote:
>Patagonia
> 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
> Comodoro Rivadavia, Chubut, Argentina
> Teléfono (0297) 446-4444 int. 103
> Correo electrónico: jbrugger@...
> Website: www.dasu.com.ar
>