Ok, I realize something:

I can't use value in table check. But, if I define a no-domain field,
and later add a value check, that check is defined over a system
domain (RDB$108, en my case), and allowed. But later I can't use the
DDL creation script for that table.

--- In firebird-support@yahoogroups.com, "jbrugger" <listas@...> wrote:
>
> If I run:
>
> CREATE TABLE CONSUMOS_FARMACIA
> (ID_REGISTRO INTEGER NOT NULL,
> CANTIDAD_DISPENSADA SMALLINT NOT NULL CHECK(value > 0);
>
> I get:
>
> Dynamic SQL Error.
> SQL error code = -901.
> Illegal use of keyword VALUE.
>
> But:
> CREATE TABLE CONSUMOS_FARMACIA
> (ID_REGISTRO INTEGER NOT NULL,
> CANTIDAD_DISPENSADA SMALLINT NOT NULL CHECK(CANTIDAD_DISPENSADA > 0);
>
> Works fine.
>
> Why?
>
> Thanks!
>