Subject | Re: [firebird-support] Re: Not visible columns |
---|---|
Author | Lester Caine |
Post date | 2012-08-15T13:22:26Z |
Tupy... nambá wrote:
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
> 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