How can I get the folder where FireBird is installed.
I use Delphi and I want to copy the UDF folder after a silent installation.
Not sure if this is the best method, but I read the DefaultInstance registry
key. It work for me for FB 1.5, 2.1 and 2.5:
RootKey := HKEY_LOCAL_MACHINE;
Found :=
How can I get the folder where FireBird is installed.
I use Delphi and I want to copy the UDF folder after a silent
installation.
Not sure if this is the best method, but I read the DefaultInstance
registry key. It work for me for FB 1.5, 2.1 and 2.5:
RootKey := HKEY_LOCAL_MACHINE;
Hello there,
i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine.
Doing a restore is failing due to the following error:
gbak: ERROR:attempt to store duplicate value (visible to active transactions) in
unique index RDB$INDEX_20
gbak:Exiting before completion due to
i have a problem with my 27Gb FB2.5 Database. Doing a backup is workíng fine.
Doing a restore is failing due to the following error:
gbak: ERROR:attempt to store duplicate value (visible to active transactions)
in
unique index RDB$INDEX_20
gbak:Exiting before completion due to errors
Hello there!
Thanks for your quick response.
The query
select
rdb$collation_name
from
rdb$collations
group by
rdb$collation_name
having
count(*) 1
results in:
RDB$COLLATION_NAME
NULL
Greetings from Lutherstadt Wittenberg :-)
Maik Sommer
IT-Systemadministrator
processed by
Thanks for your quick response.
The query
select
rdb$collation_name
from
rdb$collations
group by
rdb$collation_name
having
count(*) 1
results in:
RDB$COLLATION_NAME
NULL
And what's the result of:
select
i.rdb$relation_name
, s.rdb$field_name
from
rdb$indices i join
The Result is:
RDB$RELATION_NAMERDB$FIELD_NAME
RDB$COLLATIONSRDB$COLLATION_NAME
Regards
Maik Sommer
IT-Systemadministrator
processed by David.fx
Subject: Re: Re-2: [firebird-support] Restore fails due to duplicate Value in
unique Index (13-Sep-2012 14:13)
From:Thomas
Hello,
My name is Jason and I am a Medical Physicist in Canberra,
Australia. I am also a beginner of firebird.
Radiation records? Such as might possibly form evidence in a court
case or scientific studies?
Shouldn't your organization look for a person who has experience with
Firebird
On Wed, Sep 12, 2012 at 8:56 PM, fidel_filio fidel_fi...@yahoo.com wrote:
...
add hor_uactu varchar(2) default extract(hour from cast('now' as date))
not null
I get this error:
Invalid token.
SQL error code = -104.
Token unknown - line 3, char 34.
extract.
the querys are executed in a copy of that db. On tuesday, i recognized the
issue (that came without any reason). After a gbak, i stopped programs that
were using the database, stopped the default instance and made a copy to a
different volume, so i have a database i can Analyse. Currently,
If I run the sub proc to get the balance one by one though, it runs
at
1-2 seconds. So, using IBExpert, I manually worked my way through
the list, and on the 5th account - 22 seconds to execute. I try the
very same account again, and it takes 1 seconds. I need to carry on
down the
Hi,
the Result is NULL
Question: An index-reorg should fix this, right? Because i`ve done so tuesday
night...
Mit freundlichen Grüßen aus der Lutherstadt
Maik Sommer
IT-Systemadministrator
processed by David.fx
Subject: Re: Re-6: [firebird-support] Restore fails due to duplicate
the Result is NULL
Question: An index-reorg should fix this, right? Because i`ve done so tuesday
night...
How did you do that?
Regards,
Thomas
We`ve got a CRM-System here, therefore is the database. Within this software,
you`re abled to do a check of the database structure, optional with
reorganisation of the indexes.
Mit freundlichen Grüßen aus der Lutherstadt
Maik Sommer
IT-Systemadministrator
processed by David.fx
Hello Maik,
database, stopped the default instance and made a copy to a different
volume, so i have a database i can Analyse. Currently, i made another
copy, that i use to Analyse it with IBFirstAid 2.6.
This is a database corruption, but our IBFirstAID will not help in this
case, since it's
At 01:17 AM 14/09/2012, Ann Harrison wrote:
you're using an ancient version of
Firebird which doesn't support the function EXTRACT at all.
Actually, Ann, we got EXTRACT() with IB 6.0, albeit with support for fewer
time-parts than it has today.
Cheers,
Helen
Hi!
This is a first for me. When creating a new table on one Firebird 2.5
installation, I am getting the following error:
ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
request depth exceeded. (Recursive definition?)
Statement: CREATE TABLE v9karty_log (
v9_klic
17 matches
Mail list logo