Hello Mark,
within 2.5 we uses classic server (problematic superservers does’nt use more
cores), since 3 we installed the superserver-version (which supports more cores
too).
The isolation-level is given by the odbc-driver and should be not the problem.
I have actually no idea,
Hello Mark,
for some firebird-problems – yes, one of them is fixed. About odbc I got no
reaction.
We are using some stored procedures and tables, I thought, it is possible that
fb 3 works every time correct how fb 2.1 and my tests without many clients ends
great..
Von:
Hello again,
the most funkctionality are very simply, just tables who linked to msaccess.
I thought that firebird in every version can do this without any problems -
how I said is this not in every case true. Also the stored procedures -
simplel sql - can do something and should work in fb 3 too.
Hello Helen,
sorry for my phrase in English, I cannot describe the problems very perfect.
-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 11. Mai 2016 00:35
An: firebird-support@yahoogroups.com
Betreff: Re:
Hello @ll.
We had FB 2.5 CS before our migration to fb 3 SS. After this, the Frontend
(MS-ACCESS) calls a stored procedure and sometimes the odbc-driver does not
wait until the procedure finished and writes the new records. In this case
the user must close the access-formular to get the new
Hi Thomas, I will study this :)
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 14. April 2016 16:12
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] How to interprete gstat-results
Hi Olaf,
> Database
Hello,
each record gets a barcode number (generated with a generator), everything
is fine. But if the Position Number is the same, both records should get the
same value. How can I realize this?
Update table a set field = gen_id(xxx,1) where field is not null group by
pos?
Thanks.
Hello Thomas..
Database "D:\INTERBASE\IFLS.GDB"
Database header page information:
Flags 0
Generation 2939162
System Change Number0
Page size 4096
ODS version 12.0
Oldest
Hello @ll,
we are using firebird 3.0 RC2 and have some questions about open
transactions. (Clients connect over odbc) The gstat output gives 7
transactions between the oldest and the current transaction, if we look into
the monitoring table, we see only 10 transactions. The "oldest one" we
Hello,
I've a problem with our database, firebird 3.0 RC2, some Clients (C++,
Microsoft Access over Firebird ODBC). There are 7 open transactions. But
in the monitoring Table, I cannot see the one who is the oldest was shown.
Why?
INSERT INTO MON$TRANSACTIONS (MON$TRANSACTION_ID,
: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 12. April 2016 17:08
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] String function extract last word from a
string
12.04.2016 17:00, 'Checkmail' check_m...@satron.de [firebird-support
Hello,
is it possible to extract the last complete word from a string until the
last blank? For example "I would like to eat a bacon" In this case I would
like to have the "bacon" as result.
Thank you.
Ibexpert told me, this gds32 is the 64 Bit Version of dll?
In the program list (windows) I can see only the old fb version rc2. I need
to update.
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 23. März 2016 14:12
An:
Hello,
I have installed the fb 3 rc2 before and now I would update to 3.0.0.32383.
I have deactivated the fb service and copied all content to the firebird
install directory - replace. After this, start the install_service.bat and
instclient.exe with copy fbclient and gds32 to the syswow64.
Hello,
we traced to find performance problems and we saw some messages output for
example the following:
2016-03-17T09:01:52.5030 (2544:0C661670) ERROR AT JRequest::receive
D:\INTERBASE\IFLS.GDB (ATT_21976, SYSDBA:NONE, NONE,
TCPv4:192.168.0.70/50182)
Hello,
since FB 3 RC2 our C++ Application gets only the first post_event, some
following there are not notice. Now we have insert a timer (sleep(500) after
initevent) and it works (at the moment).
Many Thanks
Hello again,
there are some problems which are present since the migration of firebird
3.0 RC2. Two of them I have reportet, does anyone know where now some
records locked and ibexpert can change them?
thanks
Von: firebird-support@yahoogroups.com
Hello,
fb3 rc2, newest odbc driver.. If I have to change some records, it works
fine with ibexpert, but with odbc connection (linked tables) I get for he
same records an lock conflict. No problem with the old version 2.5 or 2.1.
Do you know which time firebird 3 final will realeased?
Hi,
my third ticked within three days. What should I do, windows ticket? E-Mail an
microsoft? ;)
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 11. März 2016 13:26
An: firebird-support@yahoogroups.com
Betreff: Re: Re: [firebird-support]
Hello,
since 3 days during production the modified date does not chenge, is there a
reason why? Its the right database.
Thanks.
Hello,
I have created an example:
SET SQL DIALECT 3;
CREATE TABLE T_MAIN (
TNR VARCHAR(16) NOT NULL,
MINB INTEGER
);
ALTER TABLE T_MAIN ADD CONSTRAINT PK_T_MAIN PRIMARY KEY (TNR);
SET SQL DIALECT 3;
CREATE TABLE T_STOCK (
TNR VARCHAR(16),
One hint,
the trigger is required because the user can delete the one record, in this
case the trigger deletes the referenced too. But if I delete the entire
Order, the record will be delete twice. How can I solve this in fb 3?
Von: Checkmail [mailto:check_m...@satron.de]
Gesendet:
Hello again,
now I have in FB3 a problem. A stored Procedure should delete some records.
ID some fields ID_AUTOINSERT
123xxx null
234 xxx null
255 xxx 266
266 xxx null
Now there is a trigger after delete in this table
Hello,
your are right. But in FB 3, it will be handled different.
I need the left join tlager_sum, because I’d like to have all records too there
no records in tlager_sum. But in this case I get now in fb 3 the tteile.teilenr
clean without the amaount of tlager_sum (the a.minb is greater
Hello again,
sorry, outlook corrects me in German. At the moment, I have no sulution for the
problem. Anything ideas?
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 8. März 2016 16:39
An: firebird-support@yahoogroups.com
Betreff: AW:
Hell Mark,
I would get all material, where the minimum inventory amount iss maller the the
inventory amount.
Tlager_sum contains the inventory amount, tteile.minb the theoretical minimum
amount it should be.
Now, the simplified query gets all records where the amount is to small and
Hello,
in the further version of firebird I can execute the following and get the
real value of m (exists in tlager_sum)
select a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m, a.typ
from tteile a left join tlager_sum b on (a.teilenr = b.teilenr)
where ((a.minb >
Many Thanks, Ann :)
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Samstag, 5. März 2016 20:29
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2
ss
On Fri, Mar 4, 2016 at
Ann, another question.
If I must go back tot he 5.5 version of firebird, how can I gbak the new
backup-file to the old version?
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 3. März 2016 17:53
An: firebird-support@yahoogroups.com
Thank you, Ann :)
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 3. März 2016 17:53
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] differences between firebird 2.5 cs and 3.0 rc2
ss
On Thu, Mar 3, 2016 at
Hello,
I've postet my problems with the new odbc driver and firebird 2.5 cs, the
slow queries and all other issus. Now I have installed the firebird 3.0 rc2,
the performance is great, superservers takes all cpu-cores and the problems
now banned. I have not changed anything, is this a result of
Hello,
Unfortunately until today I have no answer. What can I do? With the newest
ODBC-Driver I have this issue, the old RC2 not..
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 18. Februar 2016 10:36
An: firebird-support@yahoogroups.com
Hello @all,
Unfortunately, I get not answer of my question on the odbc devel list,
that's why I tell ths one here again.
After I updated the ODBC form 2.0.0 to 2.0.3, the most queries in MS Access
are very slow. From 2 seconds bevore to 1 minute with the new one! I have
updated all linked
Thanks Paul, I have found the issue :)
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 17. Februar 2016 15:38
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Problem Firebird 2.5
<>
Usually caused (AFAIK) by a
-support@yahoogroups.com
Betreff: Re: [firebird-support] Problem Firebird 2.5
17.02.2016 15:14, 'Checkmail' check_m...@satron.de [firebird-support] wrote:
> .it is not the gbak from firebird 2.1
The error shows that the backup was created with gbak 2.1 but from server
2.5. Nothing you can
.it is not the gbak from firebird 2.1 and I'm using the -user sysdba -pas
masterkey switches. What can I do?
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 17. Februar 2016 14:32
An: firebird-support@yahoogroups.com
Betreff: [firebird-support]
Hello @ll,
during a restore of a firebird gbk on a fres installed system with the same
firebird 2.5 cs server like the original server, I get this error:
attemp to store duplicate value (visible to active transactions) inn unique
index "RDB$Index_39" Problematic key value is ("RDB$ROLE_NAME"
Okay, Thank you..
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 9. Februar 2016 13:16
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Foreign Key on update and after update trigger
No, it does not seem
Hello,
is my question too complicated?
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 5. Februar 2016 12:27
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Foreign Key on update and after update trigger
Hello
Hello,
I'm using Firebird 2.5 cs. Yesterday I had inserted a new column and changed
some Trigger-Code. Some of the clients connected before to the database. The
bevore insert trigger set the new column with a generator-value. How can I
change the behavior that the old connections don't uses
Hello @all,
the database server, fb 2.5.5 cs on Win 2008 Server 32 Bit, The Frontend MS
Access linked tables. Before the migration, it works all very well. With the
newest odbc driver I get performance Problems, therefore I have installed
the old driver again.
But also with this, there is
Hello and good morning,
the situation, firebird classic server 2.1 before, firebird classic server
2.5 (newest) after. The frontend is Microsoft Access, the tables odbc
linked. Now, after the migration I open a Formular in Access, everything is
fast, in less then one second the Data were
It looks like a problem with the odbc driver. The 2.0.0.150_32 works fine,
the 2.0.3 buggy.
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 20. Januar 2016 07:07
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Performance
Hello,
I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to Firebird
2.5. Is there a 64 Bit OS recommend and a 64 Bit installation of Firebird
too? I connect with odbc. Known Issues while migration, metadata etc. ?
Thanks in advance.
Best regards.
Olaf
Verbose :)
-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 8. Januar 2016 16:30
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Small Database with very very bad
performance on LAN
Hello,
Hello Thomas,
Thanks. For some Years, we have had in use the superserver, but since we
have a quadcore CPU, we are using cs.
UDFs can I replace with build in functions
Now, I have restored the database with 2.5, but.. Errors :( Now I have seen
the new switches -fix_fss_d and m, but now I get
-verbose :) I remember me.
So I can see what table is he problematic one.
Have a nice weekend, Thomas, many Thanks :)
-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 8. Januar 2016 17:28
An:
Yes, Thomas,
it woks with 2.1. In the release notes of 2.5.X is written:
Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw
the error "value exceeds the range for valid timestamp".
But where can I search 200 Tables...
-Ursprüngliche Nachricht-
Von:
Hello,
now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1
It works fine, but there is another problem to fix. Now I get the error,
that value exceeds the range for valid timestamps. How can I fix this issue?
I have installed fb as cs without superclassic under 32 Bit
200 Tables :( Looking for timestamps before '16.11.1858 00:00:01'
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 8. Januar 2016 17:01
An: firebird-support@yahoogroups.com
Betreff: AW: AW: [firebird-support] Architecture
Hello,
now,
Hello,
but this ist almost realized in my code, isn't it?
>From right until there is no * present
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 7. Dezember 2015 23:28
An: firebird-support@yahoogroups.com
Betreff: RE:
Thank you Set :)
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 7. Dezember 2015 20:59
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] string difficulty
Den 07.12.2015 13:55, skrev 'checkmail'
Hi,
first, thank you!
But it should only delete the right *
For example, the ID is ABCDEFG, the interface will tell me ABCDEFG*01
In this case, from right, all * should deleted.
But If the ID is ABC*DEFG, I get ABC*DEFG01 and in this case only all *
from right
Hello @ll,
I have an input string ABCDEFG, filled with * to 16 chars, ABCDEFG*,
followed with zwo digits, f. e. 01
ABCDEFG*01
01 can I cut for an other function, now I have ABCDEFG*
The filled * I can delete for my real ID (ABCDEFG)
left(:str, position('*' in
things easier for future users, think about changing the single '*' to e.g.
'-' and then you can keep your existing select statements and not have this
problem when a new ABC*DEFG01 becomes ABC*DEFGHIJKLMN*01
Alan J Davies
Aldis
On 07/12/2015 08:29, 'checkmail' check_m...@satron.de
But in this case The comparision should be for two chars
while (ii<=iy) do
begin
if (position(substring(m_sir from ii for 2),m_char)=0) then
m_str=m_str||substring(m_sir from ii for 1);
ii=ii+1;
end
But, if the original ID like TEIL***ABC Then
.. and if the ID has the length of 15 chars and only the las * is for filling
out to 16, i get a wrong result too.
Can I compact my code?
if(char_length(str)>16) then
begin
str = left(:str,16);
while (k = 1) do
begin
if(right(str, 1) = '*') then
begin
Hello,
currently I save a path to a picture like this in my database:
s:\20150201101005_1\r0001.tif - firebird 2.5
But this path I can compose from the other informations. First I have a
timestamp 2015-02.,, _1 is the line where it is created, 1 is the picture
Number.
Now I would create a
Hello,
I would like to a variable for the in-function
Declare str_var varchar(20)
While.
Str_var = str_var || integer
(str_var = 4,7,8)
Select 1 from rdb$database where (select . where field in (:str_var)
Is there a way to realize it? I know, I can use a statement.. execute
Hello,
the situation:
state for each element (can be 0 or 1 for Example) = 1001000..
Is it faster to insert this in a varchar-field or is it better to store it
in zwenty smallint separate database fields? I would like to analyze it
later.
(read substring or each field)
Thanks in
Hello @ll,
I have already a big Problem with this combination, msaccess (all versions)
and firebird 2 (testet with 2, 2.1, 2.5) and the actually odbc driver.
First the constellation:
Table a
Primary Key year and number, so 2015 1, 2015 2, unique with main data for
orders, one field is
Okay,
Thanks @ll! It was in fact a char instead a varchar item.
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 25. März 2015 22:11
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] coalesce
one short
Hey everyone,
one short question, why is the Result of
coalesce(:variableVarchar(10),'NULL') not ,NULL' but rather 'NULL '
with blanks from varchar(10) length?
Thank you.
Best regards.
Olaf
Thank you set :)
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2015 10:07
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] Index
Hello everybody,
I'm looking in a table for an existing record bevore I
Thank you :)
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2015 09:35
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Index
Hello Olaf,
A combined index, with the field that has the largest number
Hello,
there is a table with all Material (stock), each one has a number. Now, in a
second table there is listed the material that is a part of the Material.
For example:
Material ABC
Material BCD
Material XXX
Material OMV
Material KOM
Material OMV can be a Part of XXX and XXX
Hello Mark,
-That is not surprising. You are executing a query and for each row you are
-executing another query. Use joins and/or subqueries instead.
-Mark
Sometimes, there is the normalization of the database a disadvantage. I should
save the timestamp and data in one table, so I save the
Hello Mark,
I don’t know why, but I haven’t get this e-mail. Thank you very much!
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 15. Dezember 2014 09:00
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] group by date
Hello,
I save values in some tables (simpler description)
First a Table who saved the timestamp of the mensuration
Table A timestamps
ID primary key
TS timestamp
Second a Table with the measured data (25 records/measured sensors will be
saved every 10 Minutes, one record in Table
Hello @ll,
I would like to group my records by day or month. The date is saved as
timestamp. If I do the following,
SELECT EXTRACT(day FROM m.messzeit), COUNT(*) as CountMessages
FROM te_messzeiten m
GROUP BY EXTRACT(day FROM m.messzeit)
I get all days (1 to 31), but I need group
Hello,
the following sql statement is almost done, just one thing is problematic.
SELECT TTEILE.TEILENR, TTEILE.BEZEICHNUNG, TLAGER_SUM.MENGE, TTEILE.MINB,
TLAGER_SUM.TYP, TTEILE.TYP
FROM TTEILE LEFT JOIN TLAGER_SUM ON TTEILE.TEILENR = TLAGER_SUM.TEILENR
WHERE (((TLAGER_SUM.MENGE)[minb])
Hello SET,
first, thank you!
[Minb] should be tteile.minb the minimum inventory amount.
Can you tell me what about the statements before the where conditions? Until
now I dont know about.
Your syntax returns me too many records, some of them has entries in the
table tlager_sum,
I think I have it:
SELECT TT.TEILENR, TT.BEZEICHNUNG, LS.MENGE, TT.MINB, LS.TYP, TT.TYP
FROM TTEILE TT
LEFT JOIN TLAGER_SUM LS
ON TT.TEILENR = LS.TEILENR
AND LS.TYP = 1
WHERE TT.TYP=1
AND (LS.MENGE IS NOT NULL
AND LS.MENGEtt.minb
OR TT.MINB0 and ls.menge is null)
ORDER BY
Set, many thanks for your kind support :)
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 28. August 2014 15:33
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] Difficult condiion question
I think I have it:
Hello,
1st, the following condition does not work unfortunately. (call a stored
procedure in the where-condition in a coalesce..)
and d.bsnr = coalesce(select ag from p_getmaxag(:teilenr,:typ,1),d.bsnr) and
d.bsnr coalesce (select ag from p_getmaxag(:teilenr,:typ,2),100)
I have some
This works:
and (d.bsnr = coalesce((select ag from
p_getmaxag(a.teilenr,:typ,1)),d.bsnr))
but how can I get the records without a bsnr, without an workstep, no record
in the table d.bsnr..)
Thanks
Hello,
1st, the following condition does not work unfortunately. (call a stored
and mod(id,:teiler)=0)
it works
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 22. Juli 2014 14:47
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Skip records
Hello,
I would like to read every n record,
Hello again,
is there another solution to get every 5th record? Mod is problematic,
because the starting record is not in every case the first number mod (x) =
0 and I would take all records to calculate.
Thank you
--
and mod(id,:teiler)=0)
it works
Von:
Hello
wrote:
Hello Mark,
Here the code of the sub-Procedure:
create or alter procedure P_U_CN_TO_INT (
CN_IN varchar(30))
returns (
INT_OUT integer,
STATUS smallint)
AS
declare variable I_ISNUMERIC smallint;
BEGIN
select true_param from p_u_isnumeric(:cn_in) into :i_isnumeric;
Hello everybody,
I need to split an input string and import some data in tables, like this
(simplified) '123423453456'
In this case, the value 1 is 1234, value 2 = 2345. With a while loop the
values were inserted, if I get an error (value is not a integer), then I
will delete all records with
Hello,
If I use the following code to extract a part of a string, it works fine:
s_datum = substring(:dat from 13 for 4);
s_datum = char(4)
Now I would give the same a stored procedure, the first input parameter is
XXX varchar(30), it returns me the integer-value and the status
@yahoogroups.com
Betreff: Re: [firebird-support] substring
On 18-7-2014 14:00, 'checkmail' check_m...@satron.de [firebird-support]
wrote:
If I use the following code to extract a part of a string, it works fine:
s_datum = substring(:dat from 13 for 4); s_datum = char(4)
Now I would give the same
82 matches
Mail list logo