Re: [firebird-support] Not visible columns

2012-08-15 Thread Tupy . . . nambá
I don´t know why, but I send a doc with pictures showing this, and it has been removed from my message. From: Tupy... nambá anhangu...@yahoo.com To: firebird-support@yahoogroups.com firebird-support@yahoogroups.com Sent: Wednesday, August 15, 2012 8:24 AM

Re: [firebird-support] Not visible columns

2012-08-15 Thread Mark Rotteveel
On Wed, 15 Aug 2012 04:36:16 -0700 (PDT), Tupy... nambá anhangu...@yahoo.com wrote: I don´t know why, but I send a doc with pictures showing this, and it has been removed from my message. You can't included attachments on the mailinglist.

Re: ***SPAM*** [firebird-support] Not visible columns

2012-08-15 Thread Tupy . . . nambá
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,  

Re: ***SPAM*** [firebird-support] Not visible columns

2012-08-15 Thread Lester Caine
Tupy... nambá wrote: 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,

[firebird-support] Re: Not visible columns

2012-08-15 Thread Tupy . . . nambá
Excuse me.   The only column wich is showed, is the Id_Cargo. The others are not showed at the DDL returned by the EMS and at designers. From: Lester Caine les...@lsces.co.uk To: firebird-support@yahoogroups.com Sent: Wednesday, August 15, 2012 9:20 AM

Re: [firebird-support] Not visible columns

2012-08-15 Thread Tupy . . . nambá
Mark,   Excuse me, but I think that docs and pictures can help and make clear many situations. This can be the rule, but I think the rule would be better if not forbidding all attachments. Not for me, but for all.   But the owner know what want to have, and this not to discuss, only a friendly

Re: [firebird-support] Re: Not visible columns

2012-08-15 Thread Mark Rotteveel
On Wed, 15 Aug 2012 05:23:09 -0700 (PDT), Tupy... nambá anhangu...@yahoo.com wrote: Excuse me.   The only column wich is showed, is the Id_Cargo. The others are not showed at the DDL returned by the EMS and at designers. Did you try: * Restarting EMS and/or designer * Restarting Firebird It

Re: [firebird-support] Re: Not visible columns

2012-08-15 Thread Tupy . . . nambá
Yes, after this has been found for the first time, the server and the machine running EMS have been restarted. From: Mark Rotteveel m...@lawinegevaar.nl To: firebird-support@yahoogroups.com Sent: Wednesday, August 15, 2012 9:28 AM Subject: Re:

RE: [firebird-support] Not visible columns

2012-08-15 Thread Svein Erling Tysvær
I already had this problem and this happened to me once again.   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

Re: [firebird-support] Re: Not visible columns

2012-08-15 Thread Tupy . . . nambá
Martijn,   I found the same problem running a reverse engineering at ErWin 4.1.4 with ODBC.   Best regards, Roberto Camargo. From: Martijn Tonies m.ton...@upscene.com To: firebird-support@yahoogroups.com Sent: Wednesday, August 15, 2012 9:40 AM Subject: Re:

Re: [firebird-support] Re: Not visible columns

2012-08-15 Thread Lester Caine
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

Re: [firebird-support] Re: Not visible columns

2012-08-15 Thread Mark Rotteveel
On Wed, 15 Aug 2012 07:01:50 -0700 (PDT), Tupy... nambá anhangu...@yahoo.com wrote: 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

Re: [firebird-support] Re: Not visible columns

2012-08-15 Thread Tupy . . . nambá
A good suggestion, it´s possible this will correct the problem.   I will try later.   Thanks. From: Mark Rotteveel m...@lawinegevaar.nl To: firebird-support@yahoogroups.com Sent: Wednesday, August 15, 2012 11:11 AM Subject: Re: [firebird-support] Re: Not visible

[firebird-support] Save database in table name format - Split database into table files?

2012-08-15 Thread williamevanw
Hi everyone, I am working on a project and have decided to implement Firebird DB. I have one question though and have not been able to find any answers to it online. I wish to link the root directory of my database to cloud services like Dropbox for version control. There is one problem with

RE: [firebird-support] Save database in table name format - Split database into table files? - Email found in subject

2012-08-15 Thread Leyne, Sean
William, I wish to link the root directory of my database to cloud services like Dropbox for version control. There is one problem with this though and it is the fact that the database is stored in a single file that will become to big to work effectively with this service. I think you

[firebird-support] Firebird 2.5 Optimiser Issue

2012-08-15 Thread ruan_h
Hi All While working on upgrading our database from Firebird 2.1.2 to 2.5.1, we found a query that runs a lot slower in 2.5 than in 2.1. We got the query down to a minimum to reproduce the issue and the pattern seems to be related to using derived table with aliased field names. Here is a

[firebird-support] Re: something changes after backup restore

2012-08-15 Thread Sergio
Hello Dmitry! First of all: THANKS FOR YOR ANSWER! S C:\Archivos de programa\Firebird\Firebird_2_5\bin\gbak S D:\DATABASE.fdb DATABASE.fbk -user sysdba -password newpassword -Limbo -v -y log.txt do your applications use 2pc transactions? No... as a matter of fact I use quite the same