Lester,
 
Below, the DDL command used to build the table.
CREATE TABLE RH_CARGOS (
  ID_CARGO INTEGER NOT NULL,
  DESCRICAO VARCHAR(70) CHARACTER SET WIN1252 DEFAULT '' NOT NULL COLLATE WIN1252,
  STATUS INTEGER NOT NULL,
  CARGO_SEM_DETALHE INTEGER NOT NULL,
  TIPO_CARGO INTEGER NOT NULL,
  ACESSO_APPS INTEGER NOT NULL);
 
As you can see, no reserved word, and so, no reason for using any kind of quotes (so I believe) for the table words (this same DDL command was used in another DB and and build and brought me the table correctly).
 

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

Tupy... nambá wrote:

> I have a table whose columns are showed as not existing, at designers (as at EMS SQL Studio or ErWin) and also at the DDL comands for the table. But if you execute a SELECT command on it, it list all existing columns, and their data.
>
> For your delight, I send pictures showing the situation.

Without the picture it's a little difficult to comment, but I'd go for there
being a problem with the use or no of double quotes around the field name.
Either a reserved word which the designers automatically wrap, but then may not
be visible if the table's column was not defined with double quotes. Or
alternatively something case sensitive which would also need to be wrapped properly.

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