Fidel Viegas wrote:

>> Both fields inside quotes. I tested again:
>>
>> CREATE TABLE "Demo" (
>> "Codigo" INTEGER NOT NULL,
>> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 8192,
>> "Nombre" VARCHAR(50) NOT NULL COLLATE PXW_SPAN,
>> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 4096
>> );

Where did you look and see this?

Since this kind of situation should not be possible, my guess is that
the tool you're using is reporting that those columns exist, while they
do not. If you connect with isql at that point and issue:

SHOW TABLE "Demo"

what is the output?


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com