Andy,
The way to know if a DB is accessible (online, and if the customer network can
reach you - can not be interconnected networks) is to make a small application
with a connection and attempting to connect.
With VB6, at this link, you have an explanation of how to do such application.
Olaf,
Stil for this problem, there is a possible solution. If you have only one user
at each time, and if the user have the possibility of deleting only the last
that have been inserted, you can use a delete trigger, that will renew the
value of the generator (the next value that will be
Olaf,
Du sagst, I habe ein Form und ein SubForm !!!
May I ask you wich development enviroment are you using for the front-end
application ? I see this kind of application building as having been built with
MsAccess !!! Because I work with VB, C# and Delphi, and I found this only with
the
Vorgang in den neuen verschmolzen in welchem der Kunde übereinstimmt.
Danke für deine Hilfe, viele Grüße nach Brasilien.
Von:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Im Auftrag von Tupy... nambá
Gesendet: Freitag, 6. Dezember 2013 12:05
An: firebird-support
Dear mrs.Ann,
Thanks for you remembering, excuse me for losing the focus.
Mr.Olaf is using almost no code in the application, he is working data-bound.
If he was using triggers, he could do it more easily yet, with generators. And
he has almost no control about the lock, because he is using
Olaf,
If you deliver us:
-the create table of the involved tables (including all created keys,
generators, a.s.o.);
-some real data of the involved tables (specially for the cases when the
problem happens);
you will help people to help you.
May be also the procedures involved in the data
Hi, Peter,
Read http://www.firebirdfaq.org/faq16/. May be this can help you in any way to
resolve (or not) your problem.
Good luck,
Roberto Camargo.
From: peter_...@yahoo.com peter_...@yahoo.com
To: firebird-support@yahoogroups.com
Sent: Tuesday, October 1,
.
Roberto Camargo.
From: Alexandre Benson Smith ibl...@thorsoftware.com.br
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 25, 2013 9:40 PM
Subject: Re: [firebird-support] GBak Backup Restore Problem
Roberto,
Em 25/6/2013 17:07, Tupy... nambá escreveu
Dear Friends,
We have a strange problem with GBak. We make a backup with gbak and then a
restore, also with the same.
We have a table with 60 rows where a not null type SmallInt column has 0 (zero)
as content.
When restoring, GBak returns null for this column. As this column is not null,
Backup Restore Problem
Hello, I think you have a row with null value. The option is update table
set column = 0 where column is null and then try to backup restore. I have
seen this issue when changing columns from null to not null and you have
rows in the table.
2013/6/25 Tupy... nambá
Hi, Dmitry,
Thanks for you response.
No one has changed this table. At most, as a not null column, someone could
have change it to another value, but not to null. And no one changed it´s
validation rule (as not null). This is discarded.
We repeated the action = we take the DB, checked the
Backup Restore Problem
Em 25/6/2013 16:23, Tupy... nambá escreveu:
Dear Friends,
We have a strange problem with GBak. We make a backup with gbak and then a
restore, also with the same.
We have a table with 60 rows where a not null type SmallInt column has 0
(zero) as content.
When
Dmitry,
Yes, the problem seems incredible. If I heard it from someone else, I would
also have difficult to believe on that. But this is as it is !
I will not repeat (ooops, I am already in the way !) that the source DB (for
the backup) is ok. And the backup, as only could be, really has the
Restore Problem
Thanks, Looks like it is working now. Appreciate your guidance
- Original Message -
From: Tupy... nambá
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 25, 2013 2:23 PM
Subject: [firebird-support] GBak Backup Restore Problem
Dear Friends
Dear friends,
Opening the table RDB$TRIGGERS, I saw many rows where the column
RDB$TRIGGER_SOURCE is empty (null or an empty string). And the related tables
doesn´t present these triggers.
I ask you:
-Are these rows at RDB$TRIGGERS useless ?
-May I delete these rows ?
-If I delete these
: Re: [firebird-support] about system table RDB$TRIGGERS
On 15-6-2013 15:20, Tupy... nambá wrote:
Dear friends,
Opening the table RDB$TRIGGERS, I saw many rows where the column
RDB$TRIGGER_SOURCE is empty (null or an empty string). And the related tables
doesn´t present these triggers.
I
Dear sirs,
These days, when restoring a backup of us, I noted that some foreign keys have
not been recreated at a new copy of a DB.
I don´t know exactly when this happens = if the backup itself is generated
without these faulting FK´s or if the fail happens at the DB recreation process.
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
les...@lsces.co.uk
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
Subject: Re: ***SPAM*** [firebird-support] Not visible columns
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
suggestion.
Thanks, Mark.
Roberto Camargo.
From: Mark Rotteveel m...@lawinegevaar.nl
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 15, 2012 8:40 AM
Subject: Re: [firebird-support] Not visible columns
On Wed, 15 Aug 2012 04:36:16 -0700 (PDT), Tupy
-support] Re: Not visible columns
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
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:
columns
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
Wenn man die Vorschlage aus Herrn Gödde folgen wird, man kann ein Googler
bauen. d.h., wenn man insert oder update macht, dann eine Tabelle mit
Suchwörte und Index wird aktualiziert.. stimmt das ?
This will need a complete change in the conception - this is really the only
way to get
Signore Fulvio Senore,
If the problem really is to limit the simultaneous connections, if after each
query, you close the connection, this will by his self assure that the
simultaneously connected users will be the minimum. And will bring other
benefits, as minimizing net traffic.
As
Dear sirs,
At our company, we use a copy of the production db as development db, for many
reasons.
When we do that, we make a phisycal copy of the fdb file.
We observed that, when we make this copy, the generators are not updated, what
forces us to update manually the development
: [firebird-support] Copy of the current db not updating
generators
To: firebird-support@yahoogroups.com
Date: Thursday, May 31, 2012, 4:10 PM
On Thu, 31 May 2012 04:25:02 -0700 (PDT), Tupy... nambá
anhangu...@yahoo.com wrote:
Ok, thanks. This is well known.
Then I ask = restoring the db
Alan,
yes, FORCED WRITES is checked.
--- On Thu, 5/31/12, Alan McDonald a...@meta.com.au wrote:
From: Alan McDonald a...@meta.com.au
Subject: RE: RES: [firebird-support] Copy of the current db not updating
generators
To: firebird-support@yahoogroups.com
Date: Thursday, May 31, 2012, 4:26
Rotteveel m...@lawinegevaar.nl
Subject: Re: RES: [firebird-support] Copy of the current db not updating
generators
To: firebird-support@yahoogroups.com
Date: Thursday, May 31, 2012, 4:56 PM
On Thu, 31 May 2012 14:29:41 +0200, Hannes Streicher hstreic...@gmx.de
wrote:
Hello Tupy... nambá,
what
Or, according to An Harrison´s explanation, the generators had not been updated
due to not have been commited
--- On Thu, 5/31/12, Tupy... nambá anhangu...@yahoo.com wrote:
From: Tupy... nambá anhangu...@yahoo.com
Subject: Re: RES: [firebird-support] Copy of the current db not updating
06:43:14 -0700 (PDT), Tupy... nambá
anhangu...@yahoo.com wrote:
Or, according to An Harrison´s explanation, the generators had not been
updated due to not have been commited
Even then, it would still show (older) values from production, not from
your previous test database.
On what platform
@yahoogroups.com] On Behalf Of Tupy... nambá
Sent: Thursday, May 31, 2012 3:43 PM
To: firebird-support@yahoogroups.com
Subject: Fw: Re: RES: [firebird-support] Copy of the current db not updating
generators
Or, according to An Harrison´s explanation, the generators had not been
updated due to not have been
, April 20, 2012, 10:13 AM
--- In firebird-support@yahoogroups.com, Ann Harrison aharrison@... wrote:
On Thu, Apr 19, 2012 at 11:13 AM, Tupy... nambá anhanguera@...wrote:
But, having many NFE (as many as the transactions), don´t you agree that
these BLOB´s will be a great source
, 2012, 6:42 PM
Hi Roberto,
Em 19/4/2012 08:52, Tupy... nambá escreveu:
Alexandre,
At my point of view, I prefer avoid using BLOB fields. First of all, because
these kind of field are not indicated for searches of any kind (most of them
are pictures). Second,
because
normally they have
MSSQL has two commands of the DBCC that allow to do defragmentation. The
defragmentation is not a garbage collection, but putting all parts of an object
(file or columns, hanging of the level - disc or DB) side by side, in a way
that the reading of data will be almost fast, because all data
Olaf,
I understand what you mean and Mark left it very clear about the no existence
of this situation with Firebird.
The question is that, according to the german culture, there is over and over
the worry about rights. And, still according to the german point of view, there
is no warranty
Sean,
I think the same way as you, but I told that as the only way to have no
concerns about this possibility.
And below, Helen Borrie speaks about this concern. Since the concern exists,
the possibility exists. And, as one of Murphy´s law say, if it´s very difficult
to something happens,
Dear mates,
I´m experiencing problems trying to import a date column to a Firebird db.
I used many possibilities, but with none of them I got to import this column.
I also tried FBExport but the orientations were not enough to resolve.
Does someone also have experienced this problem and
39 matches
Mail list logo