Re: [firebird-support] Re: Not visible columns
- View SourceA good suggestion, it´s possible this will correct the problem.
I will try later.
From: Mark Rotteveel <mark@...>
Sent: Wednesday, August 15, 2012 11:11 AM
Subject: Re: [firebird-support] Re: Not visible columns
On Wed, 15 Aug 2012 07:01:50 -0700 (PDT), Tupy... nambá
> I was sure that nothing was wrong with my DDL command, because at the
> DB I created a RH_Cargos2 with the rest identical and the table wascreated
> without problems.informations replicated
> 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
> at system tables, and at design time (running DDL´s), they are got offone
> place, and at SQL commands, this information are got from other place ouwill
> system tables.
> But, I see no one has idea about what is happening. Thanks to all, I
> survive !Does the problem continue if you backup the database and restore it to a
different database file?
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]
- View SourceI have seen similar problems when the connections charset is set to none
when the DDL was executed and to a specific charset (eg UNICODE_FSS) for
the ems application. I usually take great care to use the correct
connection charset from the beginning and keep it the same on all my
application that access this database after I stumbled on this.
Let me assert at this point that I think the problem surfaces only when
the ddl is executed with charset = none in any other case it shouldn't.
>[Non-text portions of this message have been removed]
> 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@... <mailto:lester%40lsces.co.uk>>
> To: firstname.lastname@example.org
> 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
> being a problem with the use or no of double quotes around the field
> 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]