I´ve tried supressing the "value>0" check, and FB still gives the same
error (related now with "value in (1,2)" check)
It´s a bug?

olaf_bredv escribió:

> 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:
>
>> 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
>>
>>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

--
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



[Non-text portions of this message have been removed]