Lester,
 
I was sure that nothing was wrong with my DDL command, because at the same DB I created a RH_Cargos2 with the rest identical and the table was created without problems.
 
You used my script (DDL command) and you could manage the table with Flamerobin, but I also could use it with EMS, as told above.
 
I don´t believe that the problem is of EMS because, as I also told, for the same table, the problem also happens with ErWin. I believe there is something miss with my DB. Or, under unknown conditions, sometimes this happens, sometimes it does´nt happen.
 
Personally, I believe something happened to the system tables of my DB. And I have the impression that Firebird have some informations replicated at system tables, and at design time (running DDL´s), they are got off one place, and at SQL commands, this information are got from other place ou system tables.
 
But, I see no one has idea about what is happening. Thanks to all, I will survive !
 
Best regards,
Roberto Camargo.
 

________________________________
From: Lester Caine <lester@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 15, 2012 10:22 AM
Subject: Re: [firebird-support] Re: Not visible columns

Tupy... nambá wrote:

> I found the same problem running a reverse engineering at ErWin 4.1.4 with ODBC.

ODBC like Jaybird which I mentioned privately does not have all of the latest
stuff available as both tend to make things look as similar as possible across
different database engines.

As I indicated, only EMS can advise why they can't display your table, there is
nothing wrong with the table as shown in Flamerobin,
CREATE TABLE RH_CARGOS
(
  ID_CARGO Integer NOT NULL,
  DESCRICAO Varchar(70) CHARACTER SET WIN1252 DEFAULT '' NOT NULL,
  STATUS Integer NOT NULL,
  CARGO_SEM_DETALHE Integer NOT NULL,
  TIPO_CARGO Integer NOT NULL,
  ACESSO_APPS Integer NOT NULL,
  CONSTRAINT PK_RH_CARGOS_1 PRIMARY KEY (ID_CARGO)
);

ALTER TABLE RH_CARGOS ADD
  CHECK (CARGO_SEM_DETALHE  in (0,1));
ALTER TABLE RH_CARGOS ADD
  CHECK (TIPO_CARGO in (0,1,2,3));

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk/
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk/
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk/




------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org/ 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



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