[firebird-support] Remove non numeric characters

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Hi,

I want to remove non numeric characters from my values. I haven’t found a 
solution with regex. So I do it this way:

What I have: +49.511 1234 567
What I want: 4951112234567

select
'+49.511 1234 567' as WHAT_I_HAVE,
REPLACE(REPLACE(REPLACE(REPLACE('+49.511 1234 567', ' ', ''), '-', ''), '+', 
''), '.', '') as WHAT_I_WANT
FROM RDB$DATABASE

I find this solution very ugly. Is there a more suitable way to remove the non 
numeric values?

Regards
Martin

Re: [firebird-support] UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello River

Thanks for your suggestion but I need to use UPDATE OR INSERT.

I know that an INSERT without an IDENTITY column will work well. That's not
the problem.

But I never use INSERT, I always use UPDATE OR INSERT.

And with an IDENTITY column it is impossible to use UPDATE OR INSERT
therefore the IDENTITY columns are useless for me and I have returned to
the old and well fashioned generator/trigger method.

I have installed Firebird 2.5.9 and Firebird 3.0.7 because there are dozens
of applications using Firebird 2.5 and my new application is using Firebird
3.

So far, the only problem I have found with Firebird 3 is that IDENTITY
columns can not be used with UPDATE OR INSERT.

Greetings.

Walter.





<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Libre
de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Wed, Nov 25, 2020 at 6:13 AM 'River~~' river14ap...@gmail.com
[firebird-support]  wrote:

>
>
> hi Walter
>
> Try
>
> INSERT INTO mytable(column2) VALUES (12345)
>
> In other words, do not try to insert the column you want to be
> auto-generated. The database engine will notice that you are inserting
> only a subset of the columns, and SHOULD use the default values for
> the missing columns, which would be NULL unless you specified
> otherwise. In the case of column1 you have specified that the default
> value would be the auto-incremented value. If your table has a
> column3 then you should find that is set to NULL by my suggested
> syntax.
>
> I do not have v3 running currently so cannot test it myself, so please
> report back for the benefit of myself and everyone else whether that
> works for you or not.
>
> I am also interested to know if you find my syntax works on v2.5, if
> you still have it installed to test it? Please don't go to the trouble
> of re-installing it just to test it.
>
> It is arguable that v3 is correct in rejecting the syntax you have
> previously used, because it does not make logical sense to tell the
> database engine to insert a null when you mean something else. The
> syntax I suggested will be more portable to other db engines because
> it is closer to the standard.
>
> I hope that suggestion proves helpful
> Warmly
> River~~
>
> On 19/11/2020, 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support]
>  wrote:
> > Hello everybody
> >
> > A long, long time without writing neither reading this group, mostly
> > because all that I need about Firebird I knew.
> >
> > But now, I have a doubt.
> >
> > With Firebird 2.5.x I can have an auto-incremental column and use it in
> an
> > UPDATE OR INSERT, but such thing is not possible with Firebird 3.
> >
> > With Firebird 2.5.x a generator and a trigger are created and the value
> of
> > the column is put automatically. So, if I write:
> > UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL,
> 12345);
> >
> > and MyColumn1 is auto-incremental its value is set for the Firebird
> engine.
> >
> > but...if I use the new IDENTITY type in Firebird 3 I always have an
> error,
> > writing MyColumn1 in the UPDATE OR INSERT or not writing.
> >
> > So, my question is:
> >
> > Is it possible to use UPDATE OR INSERT with an IDENTITY column?
> >
> > Thanks in advance.
> >
> > Greetings.
> >
> > Walter.
> >
>
> --
> 9831*2^1441403+1 is prime, >400k digits
> 
>

Re: [firebird-support] UPDATE OR INSERT in Firebird 3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 25-11-2020 10:13, 'River~~' river14ap...@gmail.com [firebird-support] 
wrote:
[..]
> I am also interested to know if you find my syntax works on v2.5, if
> you still have it installed to test it? Please don't go to the trouble
> of re-installing it just to test it.
> 
> It is arguable that v3 is correct in rejecting the syntax you have
> previously used, because it does not make logical sense to tell the
> database engine to insert a null when you mean something else. The
> syntax I suggested will be more portable to other db engines because
> it is closer to the standard.

That is not the problem, the solution Walter used in Firebird 2.5 would 
work in Firebird 3 as well. The problem is that Walter switched from 
auto-increment columns generated by a trigger, to using identity columns.

When you use a trigger, you can explicitly handle null to generate a 
value, but when using an identity column, then you either have to leave 
out the column so it is generated, or you need to specify a non-null value.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] UPDATE OR INSERT in Firebird 3

['River~~' river14ap...@gmail.com [firebird-support]]

hi  Walter

Try

INSERT INTO mytable(column2) VALUES (12345)

In other words, do not try to insert the column you want to be
auto-generated. The database engine will notice that you are inserting
only a subset of the columns, and SHOULD use the default values for
the missing columns, which would be NULL unless you specified
otherwise. In the case of column1 you have specified that the default
value  would be the auto-incremented value. If your table has a
column3 then you should find that is set to NULL by my suggested
syntax.

I do not have v3 running currently so cannot test it myself, so please
report back for the benefit of myself and everyone else whether that
works for you or not.

I am also interested to know if you find my syntax works on v2.5, if
you still have it installed to test it? Please don't go to the trouble
of re-installing it just to test it.

It is arguable that v3 is correct in rejecting the syntax you have
previously used, because it does not make logical sense to tell the
database engine to insert a null when you mean something else. The
syntax I suggested will be more portable to other db engines because
it is closer to the standard.

I hope that suggestion proves helpful
Warmly
River~~

On 19/11/2020, 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]
 wrote:
> Hello everybody
>
> A long, long time without writing neither reading this group, mostly
> because all that I need about Firebird I knew.
>
> But now, I have a doubt.
>
> With Firebird 2.5.x I can have an auto-incremental column and use it in an
> UPDATE OR INSERT, but such thing is not possible with Firebird 3.
>
> With Firebird 2.5.x a generator and a trigger are created and the value of
> the column is put automatically. So, if I write:
> UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL, 12345);
>
> and MyColumn1 is auto-incremental its value is set for the Firebird engine.
>
> but...if I use the new IDENTITY type in Firebird 3 I always have an error,
> writing MyColumn1 in the UPDATE OR INSERT or not writing.
>
> So, my question is:
>
> Is it possible to use UPDATE OR INSERT with an IDENTITY column?
>
> Thanks in advance.
>
> Greetings.
>
> Walter.
>


-- 
9831*2^1441403+1 is prime, >400k digits

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello Daniel

Yes, I agree with you, IDENTITY columns are useless for me, so I quit using
them. Maybe for a log table or something so can serve, but for normal work
they are useless.

I had returned to the old and well suitable practice of generator/trigger,
so with a short stored procedure I can INSERT and UPDATE too. Fewer lines
of code are a good practice according to my point of view.

Greetings.

Walter.


On Tue, Nov 24, 2020 at 3:32 PM Daniel Miller dmil...@amfes.com
[firebird-support]  wrote:

>
>
> I experimented with IDENTITY fields myself - based on my experience and
> some older comments here I quit using them. I think they are presently
> suitable for "quick" tables - something that will be append only like a log.
>
> If you're looking for more advanced features, like supporting UPDATE OR
> INSERT (which I use myself), then you're much better off explicitly writing
> the appropriate insert and update triggers. Possibly version 4 will
> implement IDENTITY better but I don't use it all now.
>
> Daniel
>
> On 11/20/2020 5:59 AM, 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support] wrote:
>
> 
>

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

[Daniel Miller dmil...@amfes.com [firebird-support]]

I experimented with IDENTITY fields myself - based on my experience and 
some older comments here I quit using them. I think they are presently 
suitable for "quick" tables - something that will be append only like a log.


If you're looking for more advanced features, like supporting UPDATE OR 
INSERT (which I use myself), then you're much better off explicitly 
writing the appropriate insert and update triggers. Possibly version 4 
will implement IDENTITY better but I don't use it all now.


Daniel

On 11/20/2020 5:59 AM, 'Walter R. Ojeda Valiente' 
sistemas2000profesio...@gmail.com [firebird-support] wrote:



Hello Herman

I had used UPDATE OR INSERT for several years in several hundred of 
tables. No problem...with Firebird 2.5.x


But with Firebird 3.0.x I can not make it work.

If I write the identity column, doesn't work. If I don't write the 
identity column, doesn't work..


Thank you very much for your answer.

Greetings.

Walter.



On Fri, Nov 20, 2020 at 6:16 AM Herman Viaene herman.via...@edpnet.be 
<mailto:herman.via...@edpnet.be> [firebird-support] 
<mailto:firebird-support@yahoogroups.com>> wrote:


Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com
<mailto:sistemas2000profesio...@gmail.com> [firebird-support]:

I use firebird3 from libreoffice base, not directly, but in that
way I can make (and have done) such insert stattements.

CREATE TABLE MYTABLE (
  COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1)
NOT NULL,
  COLUMN2 VARCHAR(20));


ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);


I have similar tables



Then, is I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL,
'TEST')

The message is:
Validation error for column "MYTABLE"."COLUMN1", value "*** null
***".


That is quite normal and correct, since you define column1 as not
null, and now you try to insert a null value in it.



And if I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')


I have written similar insert statements and they work OK, BUT: I
write either an insert statement OR an update statement. The two
are fundamentally different as to the primary key handling:
in an insert statement you do not give a value to the PK, since it
is generated by the system.
in an update statement you have to define on which rows (all or by
giving a value for the PK or by a select statement) the update has
to apply.

I must confess I've never tried to use "UPDATE OR INSERT", and I
wonder about it.  I googled and checked the syntax, and I think
your statement will try to match your value 'TEST' against the PK,
and that does not work of course. You would have to use the
"matching (column2)" in your statement.

Just my 2c

Herman Viaene





The message is:
UPDATE OR INSERT field list does not match primary key of table
MYTABLE.


There is some solution? Or it is impossible to use an IDENTITY
column with an UPDATE OR INSERT?

Greetings.

Walter.




On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente
mailto:sistemas2000profesio...@gmail.com>> wrote:

I forget to say that my IDENTITY column is the Primary Key of
MyTable, therefore if I don't write it an error happens
because...the table needs a Primary Key.

On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente
mailto:sistemas2000profesio...@gmail.com>> wrote:

Hello everybody

A long, long time without writing neither reading this
group, mostly because all that I need about Firebird I knew.

But now, I have a doubt.

With Firebird 2.5.x I can have an auto-incremental column
and use it in an UPDATE OR INSERT, but such thing is not
possible with Firebird 3.

With Firebird 2.5.x a generator and a trigger are created
and the value of the column is put automatically. So, if
I write:
UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2)
VALUES (NULL, 12345);

and MyColumn1 is auto-incremental its value is set for
the Firebird engine.

but...if I use the new IDENTITY type in Firebird 3 I
always have an error, writing MyColumn1 in the UPDATE OR
INSERT or not writing.

So, my question is:

Is it possible to use UPDATE OR INSERT with an IDENTITY
column?

Thanks in advance.

Greetings.

Walter.

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello Herman

I had used UPDATE OR INSERT for several years in several hundred of tables.
No problem...with Firebird 2.5.x

But with Firebird 3.0.x I can not make it work.

If I write the identity column, doesn't work. If I don't write the identity
column, doesn't work.

Thank you very much for your answer.

Greetings.

Walter.



On Fri, Nov 20, 2020 at 6:16 AM Herman Viaene herman.via...@edpnet.be
[firebird-support]  wrote:

>
>
> Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support]:
>
> I use firebird3 from libreoffice base, not directly, but in that way I can
> make (and have done) such insert stattements.
>
>
> CREATE TABLE MYTABLE (
>   COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
>   COLUMN2 VARCHAR(20));
>
>
> ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);
>
>
> I have similar tables
>
>
> Then, is I write it:
> UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL, 'TEST')
>
> The message is:
> Validation error for column "MYTABLE"."COLUMN1", value "*** null ***".
>
>
> That is quite normal and correct, since you define column1 as not null,
> and now you try to insert a null value in it.
>
>
> And if I write it:
> UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')
>
>
> I have written similar insert statements and they work OK, BUT: I write
> either an insert statement OR an update statement. The two are
> fundamentally different as to the primary key handling:
> in an insert statement you do not give a value to the PK, since it is
> generated by the system.
> in an update statement you have to define on which rows (all or by giving
> a value for the PK or by a select statement) the update has to apply.
>
> I must confess I've never tried to use "UPDATE OR INSERT", and I wonder
> about it.  I googled and checked the syntax, and I think your statement
> will try to match your value 'TEST' against the PK, and that does not work
> of course. You would have to use the "matching (column2)" in your statement.
>
> Just my 2c
>
> Herman Viaene
>
>
>
>
> The message is:
> UPDATE OR INSERT field list does not match primary key of table MYTABLE.
>
>
> There is some solution? Or it is impossible to use an IDENTITY column with
> an UPDATE OR INSERT?
>
> Greetings.
>
> Walter.
>
>
>
>
> On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente <
> sistemas2000profesio...@gmail.com> wrote:
>
>> I forget to say that my IDENTITY column is the Primary Key of MyTable,
>> therefore if I don't write it an error happens because...the table needs a
>> Primary Key.
>>
>> On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente <
>> sistemas2000profesio...@gmail.com> wrote:
>>
>>> Hello everybody
>>>
>>> A long, long time without writing neither reading this group, mostly
>>> because all that I need about Firebird I knew.
>>>
>>> But now, I have a doubt.
>>>
>>> With Firebird 2.5.x I can have an auto-incremental column and use it in
>>> an UPDATE OR INSERT, but such thing is not possible with Firebird 3.
>>>
>>> With Firebird 2.5.x a generator and a trigger are created and the value
>>> of the column is put automatically. So, if I write:
>>> UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL,
>>> 12345);
>>>
>>> and MyColumn1 is auto-incremental its value is set for the Firebird
>>> engine.
>>>
>>> but...if I use the new IDENTITY type in Firebird 3 I always have an
>>> error, writing MyColumn1 in the UPDATE OR INSERT or not writing.
>>>
>>> So, my question is:
>>>
>>> Is it possible to use UPDATE OR INSERT with an IDENTITY column?
>>>
>>> Thanks in advance.
>>>
>>> Greetings.
>>>
>>> Walter.
>>>
>> 
>

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

[Herman Viaene herman.via...@edpnet.be [firebird-support]]

Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente' 
sistemas2000profesio...@gmail.com [firebird-support]:


I use firebird3 from libreoffice base, not directly, but in that way I 
can make (and have done) such insert stattements.

CREATE TABLE MYTABLE (
  COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT 
NULL,

  COLUMN2 VARCHAR(20));


ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);


I have similar tables



Then, is I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL, 'TEST')

The message is:
Validation error for column "MYTABLE"."COLUMN1", value "*** null ***".


That is quite normal and correct, since you define column1 as not null, 
and now you try to insert a null value in it.




And if I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')


I have written similar insert statements and they work OK, BUT: I write 
either an insert statement OR an update statement. The two are 
fundamentally different as to the primary key handling:
in an insert statement you do not give a value to the PK, since it is 
generated by the system.
in an update statement you have to define on which rows (all or by 
giving a value for the PK or by a select statement) the update has to apply.


I must confess I've never tried to use "UPDATE OR INSERT", and I wonder 
about it.  I googled and checked the syntax, and I think your statement 
will try to match your value 'TEST' against the PK, and that does not 
work of course. You would have to use the "matching (column2)" in your 
statement.


Just my 2c

Herman Viaene





The message is:
UPDATE OR INSERT field list does not match primary key of table MYTABLE.


There is some solution? Or it is impossible to use an IDENTITY column 
with an UPDATE OR INSERT?


Greetings.

Walter.




On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente 
<mailto:sistemas2000profesio...@gmail.com>> wrote:


I forget to say that my IDENTITY column is the Primary Key of
MyTable, therefore if I don't write it an error happens
because...the table needs a Primary Key.

On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente
mailto:sistemas2000profesio...@gmail.com>> wrote:

Hello everybody

A long, long time without writing neither reading this group,
mostly because all that I need about Firebird I knew.

But now, I have a doubt.

With Firebird 2.5.x I can have an auto-incremental column and
use it in an UPDATE OR INSERT, but such thing is not possible
with Firebird 3.

With Firebird 2.5.x a generator and a trigger are created and
the value of the column is put automatically. So, if I write:
UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES
(NULL, 12345);

and MyColumn1 is auto-incremental its value is set for the
Firebird engine.

but...if I use the new IDENTITY type in Firebird 3 I always
have an error, writing MyColumn1 in the UPDATE OR INSERT or
not writing.

So, my question is:

Is it possible to use UPDATE OR INSERT with an IDENTITY column?

Thanks in advance.

Greetings.

Walter.





--
Plus je dors, mieux je me porte (Gaston Lagaffe)

Hoe meer ik slaap, hoe beter ik me voel (Guus Flater)

The more I sleep, the better I feel (Gomer Goof)

[firebird-support] Re: UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

CREATE TABLE MYTABLE (
  COLUMN1 INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
  COLUMN2 VARCHAR(20));


ALTER TABLE MYTABLE ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (COLUMN1);

Then, is I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN1, COLUMN2) VALUES (NULL, 'TEST')

The message is:
Validation error for column "MYTABLE"."COLUMN1", value "*** null ***".

And if I write it:
UPDATE OR INSERT INTO MYTABLE (COLUMN2) VALUES ('TEST')

The message is:
UPDATE OR INSERT field list does not match primary key of table MYTABLE.


There is some solution? Or it is impossible to use an IDENTITY column with
an UPDATE OR INSERT?

Greetings.

Walter.




On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente <
sistemas2000profesio...@gmail.com> wrote:

> I forget to say that my IDENTITY column is the Primary Key of MyTable,
> therefore if I don't write it an error happens because...the table needs a
> Primary Key.
>
> On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente <
> sistemas2000profesio...@gmail.com> wrote:
>
>> Hello everybody
>>
>> A long, long time without writing neither reading this group, mostly
>> because all that I need about Firebird I knew.
>>
>> But now, I have a doubt.
>>
>> With Firebird 2.5.x I can have an auto-incremental column and use it in
>> an UPDATE OR INSERT, but such thing is not possible with Firebird 3.
>>
>> With Firebird 2.5.x a generator and a trigger are created and the value
>> of the column is put automatically. So, if I write:
>> UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL, 12345);
>>
>> and MyColumn1 is auto-incremental its value is set for the Firebird
>> engine.
>>
>> but...if I use the new IDENTITY type in Firebird 3 I always have an
>> error, writing MyColumn1 in the UPDATE OR INSERT or not writing.
>>
>> So, my question is:
>>
>> Is it possible to use UPDATE OR INSERT with an IDENTITY column?
>>
>> Thanks in advance.
>>
>> Greetings.
>>
>> Walter.
>>
>

[firebird-support] Re: UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

I forget to say that my IDENTITY column is the Primary Key of MyTable,
therefore if I don't write it an error happens because...the table needs a
Primary Key.

On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente <
sistemas2000profesio...@gmail.com> wrote:

> Hello everybody
>
> A long, long time without writing neither reading this group, mostly
> because all that I need about Firebird I knew.
>
> But now, I have a doubt.
>
> With Firebird 2.5.x I can have an auto-incremental column and use it in an
> UPDATE OR INSERT, but such thing is not possible with Firebird 3.
>
> With Firebird 2.5.x a generator and a trigger are created and the value of
> the column is put automatically. So, if I write:
> UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL, 12345);
>
> and MyColumn1 is auto-incremental its value is set for the Firebird engine.
>
> but...if I use the new IDENTITY type in Firebird 3 I always have an error,
> writing MyColumn1 in the UPDATE OR INSERT or not writing.
>
> So, my question is:
>
> Is it possible to use UPDATE OR INSERT with an IDENTITY column?
>
> Thanks in advance.
>
> Greetings.
>
> Walter.
>

[firebird-support] UPDATE OR INSERT in Firebird 3

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello everybody

A long, long time without writing neither reading this group, mostly
because all that I need about Firebird I knew.

But now, I have a doubt.

With Firebird 2.5.x I can have an auto-incremental column and use it in an
UPDATE OR INSERT, but such thing is not possible with Firebird 3.

With Firebird 2.5.x a generator and a trigger are created and the value of
the column is put automatically. So, if I write:
UPDATE OR INSERT INTO MyTable (MyColumn1, MyColumn2) VALUES (NULL, 12345);

and MyColumn1 is auto-incremental its value is set for the Firebird engine.

but...if I use the new IDENTITY type in Firebird 3 I always have an error,
writing MyColumn1 in the UPDATE OR INSERT or not writing.

So, my question is:

Is it possible to use UPDATE OR INSERT with an IDENTITY column?

Thanks in advance.

Greetings.

Walter.

Re: [firebird-support] Support native JSON datatype for columns as MySQL / PostgreeSql

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 13-10-2020 18:42, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz 
[firebird-support] wrote:
> 
> 
> Support native JSON datatype for columns as MySQL / PostgreeSql
> 
> Some idea when this feateures will be scheduled?
> Or we are not be interested on it?

There is a ticket in the tracker: 
http://tracker.firebirdsql.org/browse/CORE-5148

But it is not planned for any version so far.

Mark

-- 
Mark Rotteveel

[firebird-support] Support native JSON datatype for columns as MySQL / PostgreeSql

['P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support]]

Support native JSON datatype for columns as MySQL / PostgreeSql

Some idea when this feateures will be scheduled?
Or we are not be interested on it?

Fabio Codebue


P-SOFT di Codebue Fabio

Via Nuova n. 9 - 24060 Tavernola B.sca (BG)

P.I. 03624950162

C.F. CDBFBA72A11C618T

Mobile: +39.348.3515786

Fax: +39.030.5100306

Web: http://www.p-soft.biz 



pec: amministrazi...@pec.p-soft.biz
cod.intermediario SDI: KRRH6B9

[firebird-support] Monitoring and troubleshooting server with lots of db's

[Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]]

Hello all.

Our data server is hosting about 100 databases for about as much as
different clients.
Usually the CPU load is very low, but we have some nasty spikes where
the cpu gets to 100% for a long time.

It's been very hard for us to find the culprit looking at the
application side, since there are a lot of very different ones too. 
I would like to know if there's any firebird-able tool server side that

could point out things like "which db's are consuming the most cpu
time", and troubleshooting information like that.

Thanks,

--
Rudi Feijó 

( (011) 2579 8789 


œ rudi.fe...@multidadosti.com.br
þ www.multidadosti.com.br [1] 


Links:
--
[1] http://www.multidadosti.com.br/

[firebird-support] ماجستيــــر إدارة المـــوارد البشريـــة المهنـــي المصغــــر

[غادة الرفاعى ghada.elref...@yahoo.com [firebird-support]]

 

ماجستير إدارة المـــوارد البشريـــة المهنـــي المصغر

للتسجيلاضغط هنا

https://docs.google.com/forms/d/e/1FAIpQLScKw5l9ywIV8QQi9PXAUFoKUen2i7ZOXo5D55pYQMMbiJCDXQ/viewform?vc=0=0=1

 

 

لمزيد من المعلومات برجاء الاتصال

مدير التدريب 

أ / ميرفت شاهين

جوال & واتس/ 00201009306111 - 00201110231700

mir...@uhrda.net

mirvatuhrda@gmail.com

[firebird-support] ماجستيــــر إدارة المـــوارد البشريـــة المهنـــي المصغــــر

[غادة الرفاعى ghada.elref...@yahoo.com [firebird-support]]

 

ماجستير إدارة المـــوارد البشريـــة المهنـــي المصغر

للتسجيلاضغط هنا

https://docs.google.com/forms/d/e/1FAIpQLScKw5l9ywIV8QQi9PXAUFoKUen2i7ZOXo5D55pYQMMbiJCDXQ/viewform?vc=0=0=1

 

 

لمزيد من المعلومات برجاء الاتصال

مدير التدريب 

أ / ميرفت شاهين

جوال & واتس/ 00201009306111 - 00201110231700

mir...@uhrda.net

mirvatuhrda@gmail.com

[firebird-support] fb_lock_print fails

[Nick Upson nick.up...@gmail.com [firebird-support]]

Hi,


I'm trying to track down some potential locking issues but I can't get this
to work


(firebird 2.5.7 on centos)


$ fb_lock_print -d /db/xxx.fdb

Unable to access lock table.

operating system directive shmem_data->sh_mem_length_mapped is 0 failed

-Success

--
Nick

Re: [firebird-support] is it a bug?

['River~~' river14ap...@gmail.com [firebird-support]]

I think this behaviour is consistent with the ANSI standard. The double
quotes are necessary (if my memory serves me correctly) if there are
characters in the user name that are not letters numbers and underscores.
Maybe hyphens/minus are allowed also. But it's the dot that is annoying the
database.

You might like to experiment and see what happens if you put dots in some
of the other values. That would show where FB3 objects because it's a user
name, or would object anyway.

In my experience, these kinds of issues often turn up when using a new
database engine: no two vendors seen to have read the same standard!

Most DBMSs are less pedantic about this sort of thing, but you can't really
hold it against FB3 if it follows the standard more closely than other
implementors of  SQL.

R~~

On 14:25, Tue, 28 Jul 2020 hamacker sirhamac...@gmail.com
[firebird-support] 
>
> If I try in FB3 (latest version):
> CREATE
>   USER  'ROBOT.CUSTOS' -- wont run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
>
> Not run! but If I try:
>   CREATE
>   USER  "ROBOT.CUSTOS" -- it´s run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
>
> I think that double quotes are used only if you want case sensitive, but I
> see that only method to create login with "." and maybe others separators..
> 
>

Re: [firebird-support] is it a bug?

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

The firebird-support Yahoo Group has moved to Google Groups at 
https://groups.google.com/d/forum/firebird-support. Please subscribe and 
post your question there.

Mark

On 2020-07-28 15:23, hamacker sirhamac...@gmail.com [firebird-support] 
wrote:
> If I try in FB3 (latest version):CREATE
>   USER  'ROBOT.CUSTOS' -- wont run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
> 
> Not run! but If I try:
>   CREATE
>   USER  "ROBOT.CUSTOS" -- it´s run
>   PASSWORD  'password'
>   FIRSTNAME 'ROBOT'
>   MIDDLENAME 'DE'
>   LASTNAME 'CUSTOS' ;
> 
> I think that double quotes are used only if you want case sensitive,
> but I see that only method to create login with "." and maybe others
> separators.

Re: [firebird-support] is it a bug?

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

28.07.2020 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> I think that double quotes are used only if you want case sensitive

   They are required for any SQL identifier that contains non-allowed 
characters.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] is it a bug?

[hamacker sirhamac...@gmail.com [firebird-support]]

If I try in FB3 (latest version):
CREATE
  USER  'ROBOT.CUSTOS' -- wont run
  PASSWORD  'password'
  FIRSTNAME 'ROBOT'
  MIDDLENAME 'DE'
  LASTNAME 'CUSTOS' ;

Not run! but If I try:
  CREATE
  USER  "ROBOT.CUSTOS" -- it´s run
  PASSWORD  'password'
  FIRSTNAME 'ROBOT'
  MIDDLENAME 'DE'
  LASTNAME 'CUSTOS' ;

I think that double quotes are used only if you want case sensitive, but I
see that only method to create login with "." and maybe others separators.

[firebird-support] It a CTE possible here?

['Check_Mail' check_m...@satron.de [firebird-support]]

Hello,

 

the following stored Procedure calls a second one and I get for each product
some parts where included. Now, I group this at all, but some products uses
the same parts and I would group it in this function, without calling with
another one which groups it. It is possible?

 

create or alter procedure P_GETTEILEMATPULPS (

PSJAHR integer,

PSKW integer)

returns (

MATNR varchar(16),

ANZ double precision,

EINHEIT integer)

AS

declare variable teil varchar(16);

declare variable menge double precision;

BEGIN

  for select teilenr, sum(stck_je_tag) from tplan_kw_pos where ltjahr =
:psjahr and ltkw = :pskw

  and abgearbeitet = 0

  group by teilenr

  into :teil, :menge do

  begin

if(menge is null) then menge = 0;

for select materialnr, sum(anzahlm) as anzahlm, einheit from
P_GETTEILEMATps_pul(:teil, :menge)

group by materialnr, einheit

into :matnr, :anz, :einheit do suspend;

  end

END

 

Thank you.

 

Best regards

 

Olaf

 

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 25-06-2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> Is it possible to create databases on a 3.0.5 server with a user other 
> than sysdba?
> when i try in flamerobin create a database with another user it gives me 
> the following error:
> Context:Database::Create
> Message:isc_dsql_execute_immediate failed
> SQL Message:-551
> This user not have privilege to perform this operation on this object
> Engine Code :335544352
> no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

See also 
https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3-databases.html#qsg3-databases-creating-nonsysdba

-- 
Mark Rotteveel

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

Thank you, I will follow your instructions.
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message - 
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

To: 
Sent: Friday, June 26, 2020 3:34 PM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on 
server 3.0.5


> 26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
> [firebird-support] wrote:
>> I don't know if I will be such a novice, but I can't find the language
>> reference manual for firebird 3
>
> https://firebirdsql.org/en/reference-manuals/
>
>   Google Translate can help you read it.
>
> -- 
>   WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
> 








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++
--------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 26-06-2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> I don't know if I will be such a novice, but I can't find the language
> reference manual for firebird 3

It is documented in the release notes: 
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-access-sql.html#rnfb30-security-metadataprivs

PS. Please move this discussion to the new firebird-support list on 
Googlegroups.
-- 
Mark Rotteveel

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> I don't know if I will be such a novice, but I can't find the language
> reference manual for firebird 3

https://firebirdsql.org/en/reference-manuals/

   Google Translate can help you read it.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

I don't know if I will be such a novice, but I can't find the language 
reference manual for firebird 3

I install firebird3 in devuan which is the operating system I use and it 
asks me for the password of the user sysdba.

Then if I create the user from flamerobin or using gsec it never lets me use 
that user that I create to create a new database, that has never happened to 
me with firebird 2.5.x

And the truth is that I have tried in several ways, but the truth did not 
achieve positive results.

Can't someone give me a more detailed explanation of how to create a 
database in firebird 3 with a user other than sysdba?

I know that time is money, but I do not think that it is so much for those 
who really have the knowledge of how to do it, I have already searched the 
internet and I have not found it, perhaps it is not possible to search there 
either.

Best regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message - 
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

To: 
Sent: Thursday, June 25, 2020 3:18 PM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on 
server 3.0.5


> 25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
> [firebird-support] wrote:
>> And how do I assign the pre-benefits to the user that I am going to use 
>> to
>> create the database?
>
>   Using "GRANT" statement as described in Language Reference.
>
> -- 
>   WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
> 








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++
--------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
    firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> And how do I assign the pre-benefits to the user that I am going to use to
> create the database?

   Using "GRANT" statement as described in Language Reference.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

And how do I assign the pre-benefits to the user that I am going to use to 
create the database?

Reiterated greetings
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

- Original Message - 
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

To: 
Sent: Thursday, June 25, 2020 11:07 AM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on 
server 3.0.5


> 25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
> [firebird-support] wrote:
>> Is it possible to open database 2.5.9 on servers 3.0.5?
>
>   No.
>
>> Is it possible to create databases on a 3.0.5 server with a user other 
>> than sysdba?
>
>   Yes, but appropriate privilege must be granted to the user.
>
>   Actually it is plainly written in the error messages.
>
> -- 
>   WBR, SD.
>
>








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

You have sent your email to the old list, please post to the new list at 
firebird-supp...@googlegroups.com (or 
https://groups.google.com/d/forum/firebird-support).

If you're not subscribed yet, you can do it on above link, or by sending 
an email to firebird-support+subscr...@googlegroups.com (if your email 
address is not associated with a Google account, make sure to confirm by 
replying to the email).

Mark

On 2020-06-25 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> Is it possible to open database 2.5.9 on servers 3.0.5?
> 
> when I try to open it with flamerobin it gives me the following error:
> 
> Context:Database::Connect
> Message:isc_attach_database failed
> 
> SQL Message:-820
> wrong or obsolete version
> 
> Engine Code :335544379
> Engine Message:
> unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2,
> support 12.2
> IProvider::attachDatabase failed when loading mapping cache
> 
> Is it possible to create databases on a 3.0.5 server with a user other
> than sysdba?
> 
> when i try in flamerobin create a database with another user it gives
> me the following error:
> Context:Database::Create
> Message:isc_dsql_execute_immediate failed
> 
> SQL Message:-551
> This user not have privilege to perform this operation on this object
> 
> Engine Code :335544352
> no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

RE: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]]

Release Notes

"New ODS Number
Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12. 
In the initial release, a database
with an older ODS cannot be opened by Firebird 3.0. In order to work with a 
database with an older ODS it will
be necessary to make a backup using gbak  under the older server and restore it 
with gbak on Firebird 3.
Note
A legacy provider for databases with ODS 8 to 11.2 is planned for a future 
sub-release"

Paul
-Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 25 June 2020 16:46
To: Firebird Support
Subject: [firebird-support] error when trying to open databases 2.5 on server 
3.0.5



Is it possible to open database 2.5.9 on servers 3.0.5?

when I try to open it with flamerobin it gives me the following error:
Context:Database::Connect
Message:isc_attach_database failed

SQL Message:-820
wrong or obsolete version

Engine Code :335544379
Engine Message:
unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, support 
12.2
IProvider::attachDatabase failed when loading mapping cache

Is it possible to create databases on a 3.0.5 server with a user other than 
sysdba?

when i try in flamerobin create a database with another user it gives me the 
following error:
Context:Database::Create
Message:isc_dsql_execute_immediate failed

SQL Message:-551
This user not have privilege to perform this operation on this object

Engine Code :335544352
no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu 
[firebird-support] wrote:
> Is it possible to open database 2.5.9 on servers 3.0.5?

   No.

> Is it possible to create databases on a 3.0.5 server with a user other than 
> sysdba?

   Yes, but appropriate privilege must be granted to the user.

   Actually it is plainly written in the error messages.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

Is it possible to open database 2.5.9 on servers 3.0.5?

when I try to open it with flamerobin it gives me the following error:
Context:Database::Connect
Message:isc_attach_database failed

SQL Message:-820
wrong or obsolete version

Engine Code :335544379
Engine Message:
unsupported on-disk structure for file /mnt/ccs/libsc.fdb; found 11.2, support 
12.2
IProvider::attachDatabase failed when loading mapping cache

Is it possible to create databases on a 3.0.5 server with a user other than 
sysdba?

when i try in flamerobin create a database with another user it gives me the 
following error:
Context:Database::Create
Message:isc_dsql_execute_immediate failed

SQL Message:-551
This user not have privilege to perform this operation on this object

Engine Code :335544352
no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.06.2020 14:20, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> the issue is not resolved. Now it complains the database does not exist.

   That's another issue. Check that path and name of database are right.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Wed, 24 Jun 2020, 4:47 pm Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support],  wrote:

> 24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > the Process Explorer reports the dll as under  :
> >
> > D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll
>
>That's the problem. This library must not be used from this place but
> copied into
> %WINDOWS%\SysWOW64\ (or anywhere else).
>
>
The fbclient.dll file already existed in the  %WINDOWS%\SysWOW64\ folder so
rechecked again after removing the fbclient.dll in the D:\Program
Files\Firebird\Firebird_3_0\WOW64\ directory, the issue is not resolved.
Now it complains the database does not exist.


> The library already exists in the SysWOW64 folder. So now trie
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> the Process Explorer reports the dll as under  :
> 
> D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll

   That's the problem. This library must not be used from this place but copied 
into 
%WINDOWS%\SysWOW64\ (or anywhere else).

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Wed, Jun 24, 2020 at 2:10 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > Use Process Explorer to find out which exactly fbclient.dll is
> loaded.
> >
> > I do not find fbclient.dll listed in the Task Manager of the client
> Windows machine when i
> > attempt to connect to the Firebird on the remote Ubuntu machine using
> flamerobin on the
> > Windows client machine.
>
>In this case you must use Process Explorer instead of Task Manger.
>
>
the Process Explorer reports the dll as under  :

D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll


> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
>     Use Process Explorer to find out which exactly fbclient.dll is loaded.
> 
> I do not find fbclient.dll listed in the Task Manager of the client Windows 
> machine when i 
> attempt to connect to the Firebird on the remote Ubuntu machine using 
> flamerobin on the 
> Windows client machine.

   In this case you must use Process Explorer instead of Task Manger.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, Jun 23, 2020 at 9:53 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > I have not set any environment variable.
> >
> > But I do have Firebird 3..0 installed on the client Windows machine, to
> this the
> > flamerobin connects without issues.
>
>Use Process Explorer to find out which exactly fbclient.dll is loaded.
>

I do not find fbclient.dll listed in the Task Manager of the client Windows
machine when i attempt to connect to the Firebird on the remote Ubuntu
machine using flamerobin on the Windows client machine.


>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> I have not set any environment variable.
> 
> But I do have Firebird 3..0 installed on the client Windows machine, to this 
> the 
> flamerobin connects without issues.

   Use Process Explorer to find out which exactly fbclient.dll is loaded.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, Jun 23, 2020 at 9:12 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA'
> password 'myPassword';
>
>I see. Normally Firebird client library cannot find plugins and don't
> try to use them.
> Is environment variable FIREBIRD set to something like "d:\Program
> Files\Firebird_3_0\"?
>

I have not set any environment variable.

But I do have Firebird 3.0 installed on the client Windows machine, to this
the flamerobin connects without issues.

>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA' 
> password 'myPassword';

   I see. Normally Firebird client library cannot find plugins and don't try to 
use them. 
Is environment variable FIREBIRD set to something like "d:\Program 
Files\Firebird_3_0\"?

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, Jun 23, 2020 at 8:27 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote:

> 23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > Do not use embedded mode.
> >
> > I am not using embedded mode.
>
>Show connection string.
>

connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA'
password 'myPassword';

>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
>     Do not use embedded mode.
> 
> I am not using embedded mode.

   Show connection string.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

On Tue, 23 Jun 2020, 7:37 pm Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support],  wrote:

> 23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > But when I try to connect using Flamerobin, i get the message:
> >
> > Error loading plugin Engine12
> > Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can
> > be loaded
> > unknown Win32 error 193
>
>Flame Robin is 32 bit executable. d:\Program
> Files\Firebird_3_0\plugins/Engine12.dll
> most likely 64 bits library. Result is unavoidable.
>Do not use embedded mode.
>

I am not using embedded mode.

>
> --
>WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] Error Loading Pluggin Engine12

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> But when I try to connect using Flamerobin, i get the message:
> 
> Error loading plugin Engine12
> Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can
> be loaded
> unknown Win32 error 193

   Flame Robin is 32 bit executable. d:\Program 
Files\Firebird_3_0\plugins/Engine12.dll 
most likely 64 bits library. Result is unavoidable.
   Do not use embedded mode.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Error Loading Pluggin Engine12

[LtColRDSChauhan rdsc1...@gmail.com [firebird-support]]

Hi,

I have installed Firebird 3.0 on Ubuntu 20.04 machine and I am trying to
connect through a Windows 10 machine. I am able to connect using isql from
the Ubuntu and Windows machine both. But when I try to connect using
Flamerobin, i get the message:

Error loading plugin Engine12
Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can
be loaded
unknown Win32 error 193

I do have a Firebird 3.0 installed on my WIndows machine also.

Please help.

Regards,
Rajiv

[firebird-support] Error when recalculate the statistics of the index

[Marco Andreolli dra...@gmail.com [firebird-support]]

Hi,
On serveral database I have this error:
This operation is not defined for system tables.
unsuccessful metadata update
request depth exceeded. (Recursive definition?)

When I try to recalculate the statistics of the index with:
SET STATISTICS INDEX 

For different indices and tables
I use FireBird 2.5

Why?
the same operations on other db with the same table and index don't do this
error


Thanks in advance

Re: [firebird-support] Firebird running many databases

[Louis Kleiman lklei...@sstms.com [firebird-support]]

I'm jumping in late on this one, but I'm wondering if you could implement a
single database that all users share but they are restricted to seeing only
their own data.  I know it isn't the question you asked, but I believe that
many rows are more easily handled than many databases.

I'm glad you got your problem fixed, but I fear it is only a matter of time
before this issue pops up again.

Good luck!

Louis Kleiman


On Wed, May 6, 2020 at 7:34 PM Tony Christiansen t...@adegroup.com.au
[firebird-support]  wrote:

> Thank you for spelling that out - my deductive powers are weak. ;(
>
> Best regards
>
> On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
> > 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au
> [firebird-support] wrote:
> >> It just shows
> >>
> >> Firebird SQL Server (32 bit)
> >> - Firebird Server - DefaultInstance
> >>
> >> No mention of the mode that I can see.
> > You should also read documentation about differences between the
> modes. Classic server
> > runs process per attachment.
> >
>
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] SQL Error 303

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.05.2020 13:29, 'Olaf Kluge' olaf.kl...@satron.de [firebird-support] wrote:
> what function can I take instead of the isc_expand_dpb?

   There is no replacement for this function. You must use the same allocation 
function 
that was used for original DPB which depends on the host language.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] SQL Error 303

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

The Firebird-support mailing list has moved from Yahoo Groups to Google 
Groups, https://groups.google.com/d/forum/firebird-support (or subscribe 
by emailing to firebird-support+subscr...@googlegroups.com and confirm 
by replying to the confirmation request). Could you please subscribe to 
the list on Google Groups and repost your question to that list?

Mark

On 2020-05-27 11:56, 'Check_Mail' check_m...@satron.de 
[firebird-support] wrote:
> Hello,
> 
> we have some problems since migration VC++ 2005 to VC++ 2016. The same
> code, the same fbclient.dll but now we get the error after connect:
> 
> Dynamic SQL Error
> 
> SQL error code = -303
> 
> Implementation of text subtype 205 not located.
> 
> What could it be? The charset is ISO8859_1, Firebird 3.0 superserver,
> no UDFs.
> 
> Thank you. Best regards.
> 
> Olaf

AW: [firebird-support] SQL Error 303

['Olaf Kluge' olaf.kl...@satron.de [firebird-support]]

Hello dmitry,

what function can I take instead of the isc_expand_dpb?

Thank you.


Mit freundlichen Grüßen / with best regards

Olaf Kluge



S A T R O N  Sachsen 
Steuerungstechnik GmbH
Johann-Gottlob-Pfaff Straße 7
D-09405 Zschopau


Tel: +49 (0) 3725 / 3506-31
Fax:    +49 (0) 3725 / 3506-12
Mobil:  +49 (0) 170 / 9292375
E-Mail:  olaf.kl...@satron.de
Internet: http://www.satron.de/

..
.
Geschäftsführer: Gerd Kaden
Amtsgericht: Chemnitz HRB1218
Ust-ID-Nr: DE141294791

..
.
Diese E-Mail ist vertraulich. Wenn Sie nicht der beabsichtigte Empfänger
sind, dürfen Sie die Informationen nicht offen legen oder benutzen. Wenn Sie
diese E-Mail durch einen Fehler bekommen haben, teilen Sie uns dies bitte
mit, indem Sie die E-Mail an den Absender zurücksenden. Bitte löschen Sie
danach diese E-Mail.
This email is confidential. If you are not the intended recipient, you must
not disclose or use the information contained in it.
If you have received this mail in error, please tell us immediately by
return email and delete the document.



-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com  
Gesendet: Mittwoch, 27. Mai 2020 12:53
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] SQL Error 303

27.05.2020 12:51, 'Check_Mail' check_m...@satron.de [firebird-support]
wrote:
> The name of the function is /*isc_expand_dpb*/

   This function is deprecated since Firebird 1.0.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

Re: [firebird-support] SQL Error 303

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.05.2020 12:51, 'Check_Mail' check_m...@satron.de [firebird-support] wrote:
> The name of the function is /*isc_expand_dpb*/

   This function is deprecated since Firebird 1.0.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

AW: [firebird-support] SQL Error 303

['Check_Mail' check_m...@satron.de [firebird-support]]

The name of the function is isc_expand_dpb

 

Von: firebird-support@yahoogroups.com  
Gesendet: Mittwoch, 27. Mai 2020 12:39
An: firebird-support@yahoogroups.com
Betreff: AW: [firebird-support] SQL Error 303

 

  

Sorry, one thing. The firebird.dll from version 2 is working, the from fb3
not. Can anyone tell me what is different in this case from 2 to 3?

 

Von: firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>  mailto:firebird-support@yahoogroups.com> > 
Gesendet: Mittwoch, 27. Mai 2020 11:56
An: firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com> 
Betreff: [firebird-support] SQL Error 303

 

  

Hello,

 

we have some problems since migration VC++ 2005 to VC++ 2016. The same code,
the same fbclient.dll but now we get the error after connect:

 

Dynamic SQL Error

 

SQL error code = -303

 

Implementation of text subtype 205 not located.

 

What could it be? The charset is ISO8859_1, Firebird 3.0 superserver, no
UDFs.

 

Thank you. Best regards.

 

Olaf

 

 

AW: [firebird-support] SQL Error 303

['Check_Mail' check_m...@satron.de [firebird-support]]

Sorry, one thing. The firebird.dll from version 2 is working, the from fb3
not. Can anyone tell me what is different in this case from 2 to 3?

 

Von: firebird-support@yahoogroups.com  
Gesendet: Mittwoch, 27. Mai 2020 11:56
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] SQL Error 303

 

  

Hello,

 

we have some problems since migration VC++ 2005 to VC++ 2016. The same code,
the same fbclient.dll but now we get the error after connect:

 

Dynamic SQL Error

 

SQL error code = -303

 

Implementation of text subtype 205 not located.

 

What could it be? The charset is ISO8859_1, Firebird 3.0 superserver, no
UDFs.

 

Thank you. Best regards.

 

Olaf

 

 

[firebird-support] SQL Error 303

['Check_Mail' check_m...@satron.de [firebird-support]]

Hello,

 

we have some problems since migration VC++ 2005 to VC++ 2016. The same code,
the same fbclient.dll but now we get the error after connect:

 

Dynamic SQL Error

 

SQL error code = -303

 

Implementation of text subtype 205 not located.

 

What could it be? The charset is ISO8859_1, Firebird 3.0 superserver, no
UDFs.

 

Thank you. Best regards.

 

Olaf

 

 

Re: [firebird-support] How To Track Deadlocks

[DougC d...@moosemail.net [firebird-support]]

You need to move this question to mailto:firebird-supp...@googlegroups.com



See https://groups.google.com/d/forum/firebird-support



 On Wed, 13 May 2020 16:39:15 -0400 Roberto Vieweg 
jjw.roberto.fireb...@gmail.com [firebird-support] 
 wrote 


 Hi.
 
 I have a environment with 150 connections over my database.
 
 My application needs to use "Wait On Locks".
 A recent change in my application (client / server architeture) starts
 to get in some deadlocks.
 
 I found this article
 https://ib-aid.com/en/how-to-track-deadlocks-in-firebird/ but the
 massive use of the database turns impossible to motitor the FBTRACE
 output.
 
 So, there is some way to track this deadlocks using the MON$ tables
 using a query?

[firebird-support] How To Track Deadlocks

[Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support]]

Hi.

I have a environment with 150 connections over my database.

My application needs to use "Wait On Locks".
A recent change in my application (client / server architeture) starts
to get in some deadlocks.

I found this article
https://ib-aid.com/en/how-to-track-deadlocks-in-firebird/ but the
massive use of the database turns impossible to motitor the FBTRACE
output.

So, there is some way to track this deadlocks using the MON$ tables
using a query?

[firebird-support] FB Win -> Linux - Character Set not installed

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello Friends.

I am migrating a FB DB from Windows 10 64 to Linux 64 (CentOS 7.8).

When restoring FBK (generated in Windows) to the Linux FB DB the Error:  
CHARACTER SET WIN1252 is not installed is showed.

I already tried to replace DEFAULT CHARACTER SET to UTF8 in the Windows FB DB 
before backuping, but did not work.

Any suggestion?

Thank you.

Atenciosamente,

+ + Hugo Eyng + +

RE: [firebird-support] Firebird x CentOS 7

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Thank you Mr. Makowski

Atenciosamente,

+ + Hugo Eyng + +


De: firebird-support@yahoogroups.com  em nome 
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] 

Enviado: quarta-feira, 13 de maio de 2020 06:40
Para: firebird-support@yahoogroups.com 
Assunto: Re: [firebird-support] Firebird x CentOS 7

Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
>
> About:
>
> "According to Fedora packaging rules, firebird service is not started
>   automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
>   If you want to have firebird started at each boot, as root :
>   for SuperServer :
> systemctl enable firebird-superserver.service"
>
> How to start "classic" or "superclassic"? Is it possible? And would you use 
> one of those instead "superserver"?
>
Read the Firebird documentation for that
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links

ODP: [firebird-support] Trigger created as inactive

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Hi

First change group from yahoo to google group.

And without whole reproducible script no one can help i suppose

Regards,
Karol Bieniaszewski

Re: [firebird-support] Firebird x CentOS 7

[Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]]

Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
> 
> About:
> 
> "According to Fedora packaging rules, firebird service is not started
>   automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
>   If you want to have firebird started at each boot, as root :
>   for SuperServer :
> systemctl enable firebird-superserver.service"
> 
> How to start "classic" or "superclassic"? Is it possible? And would you use 
> one of those instead "superserver"?
> 
Read the Firebird documentation for that
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
    firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Trigger created as inactive

[Robert martin r...@chreos.com [firebird-support]]

Hi  All

I have a script that creates my database structure.  I create the 
following trigger for a table but unlike my other triggers this one is 
created 'inactive'.  I can run 'ALTER TRIGGER FilterStore_Inc ACTIVE' 
and activate the trigger without issue. The table and sequence are 
already created in the DB before the trigger is created.

CREATE OR ALTER TRIGGER FilterStore_Inc FOR FilterStore

     ACTIVE BEFORE INSERT POSITION 0
     AS BEGIN
         IF (NEW.FilterStoreRef IS NULL) THEN BEGIN
             NEW.FilterStoreRef = GEN_ID(FilterStoreRef_Seq, 1);
         END
     END^

Any idea why this might be?

Thanks
Rob

RE: [firebird-support] Firebird x CentOS 7

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello Mr. Makowski,

About:

"According to Fedora packaging rules, firebird service is not started
  automatically. You need to start it, as root :
systemctl start firebird-superserver.service
  If you want to have firebird started at each boot, as root :
  for SuperServer :
systemctl enable firebird-superserver.service"

How to start "classic" or "superclassic"? Is it possible? And would you use one 
of those instead "superserver"?





Atenciosamente,

+ + Hugo Eyng + +

________
De: firebird-support@yahoogroups.com  em nome 
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] 

Enviado: sábado, 9 de maio de 2020 12:18
Para: firebird-support@yahoogroups.com 
Assunto: Re: [firebird-support] Firebird x CentOS 7

Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à
21:07 :
> Dear Friends,
>
> Where can I find a good tutorial to learn how to install FB 2.5.9 ( or 
> higher) in CentOS 7?
>
> If anyone already installed and used FB in this SO: what the best option: 
> 1-superserver, 2-classic, 3-superclassic?
>
you can install Firebird 3 from this repository :

https://copr.fedorainfracloud.org/coprs/makowski/firebird/

Differences between upstream and the Fedora package
===

* In /usr/bin you have isql-fb for Firebird isql.
  We can't name it isql to avoid conflict with isql from UNIX-ODBC.
  In /usr/bin you have also gstat-fb for Firebird gstat.
  We can't name it gstat to avoid conflict with gstat from Ganglia-gmond.

* By default, Firebird is set as superserver mode.
  Please read the Firebird doc if you want to change the mode.
  To help you, you have systemd units in /usr/share/firebird/misc.

* According to Fedora packaging rules, firebird service is not started
  automatically. You need to start it, as root :
  for SuperServer :
systemctl start firebird-superserver.service
  If you want to have firebird started at each boot, as root :
  for SuperServer :
systemctl enable firebird-superserver.service

--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links

Re: [firebird-support] Firebird x CentOS 7

[Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]]

Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à
21:07 :
> Dear Friends,
> 
> Where can I find a good tutorial to learn how to install FB 2.5.9 ( or 
> higher) in CentOS 7?
> 
> If anyone already installed and used FB in this SO: what the best option: 
> 1-superserver, 2-classic, 3-superclassic?
> 
you can install Firebird 3 from this repository :

https://copr.fedorainfracloud.org/coprs/makowski/firebird/

Differences between upstream and the Fedora package
===

* In /usr/bin you have isql-fb for Firebird isql.
  We can't name it isql to avoid conflict with isql from UNIX-ODBC.
  In /usr/bin you have also gstat-fb for Firebird gstat.
  We can't name it gstat to avoid conflict with gstat from Ganglia-gmond.

* By default, Firebird is set as superserver mode.
  Please read the Firebird doc if you want to change the mode.
  To help you, you have systemd units in /usr/share/firebird/misc.

* According to Fedora packaging rules, firebird service is not started
  automatically. You need to start it, as root :
  for SuperServer :
systemctl start firebird-superserver.service
  If you want to have firebird started at each boot, as root :
  for SuperServer :
systemctl enable firebird-superserver.service

-- 
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
    firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Firebird x CentOS 7

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Dear Friends,

Where can I find a good tutorial to learn how to install FB 2.5.9 ( or higher) 
in CentOS 7?

If anyone already installed and used FB in this SO: what the best option: 
1-superserver, 2-classic, 3-superclassic?

Thank you.



Atenciosamente,

+ + Hugo Eyng + +

Re: [firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

Thank you for spelling that out - my deductive powers are weak. ;(

Best regards

On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] 
> wrote:
>> It just shows
>>
>> Firebird SQL Server (32 bit)
>> - Firebird Server - DefaultInstance
>>
>> No mention of the mode that I can see.
> You should also read documentation about differences between the modes. 
> Classic server
> runs process per attachment.
>







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] 
wrote:
> It just shows
> 
> Firebird SQL Server (32 bit)
> - Firebird Server - DefaultInstance
> 
> No mention of the mode that I can see.

   You should also read documentation about differences between the modes. 
Classic server 
runs process per attachment.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

It just shows

Firebird SQL Server (32 bit)
- Firebird Server - DefaultInstance

No mention of the mode that I can see.

On 6/05/2020 7:28 pm, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
> 06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] 
> wrote:
>> Is there a way to check what mode FB v3.0 server is running in?
> Windows Task Manager.
>







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] 
wrote:
> Is there a way to check what mode FB v3.0 server is running in?

   Windows Task Manager.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

Thanks Dimitry

We have changed to 64-bit FB and it has significantly reduced the errors 
so I suspect it was RAM etc resource related.

I will check firebird.log for more info.

Is there a way to check what mode FB v3.0 server is running in? Is the 
only way to look at servermode in firebird.conf?

Many thanks

 >>My application (Delphi using IBX) has started randomly raising 
exceptions "Error writing data to the connection" when the user queries 
their database.


On 5/05/2020 9:22 pm, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:
>   FB server version be better than the other in this scenario?
> Yes. Recent versions used to be better than old ones. Classic server may 
> workaround
> some problems while they are not fixed but still you must detect and 
> investigate them.
>







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Firebird running many databases

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.05.2020 06:57, Tony Christiansen t...@adegroup.com.au [firebird-support] 
wrote:
> My application (Delphi using IBX) has started randomly raising
> exceptions "Error writing data to the connection" when the user queries
> their database.

   What is in server's firebird.log at this timestamp?

> Would the number of databases being accessed cause load issues for FB?

   Yes. Each database uses own page and metadata cache.

> Would one FB server version be better than the other in this scenario?

   Yes. Recent versions used to be better than old ones. Classic server may 
workaround 
some problems while they are not fixed but still you must detect and 
investigate them.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Firebird running many databases

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

Hi

I have firebird installed on a server with my application. There are say 
200 users each accessing their own database (size is trivial <50mb)

My application (Delphi using IBX) has started randomly raising 
exceptions "Error writing data to the connection" when the user queries 
their database.

We think this must be related to adding more users to the server as it 
is a recent problem.

My application creates and connects a database object on start and 
destroys on finish.

Should I be creating and connecting to the database for every query?

Would the number of databases being accessed cause load issues for FB? I 
cannot see any config settings that would address this situation.

Would one FB server version be better than the other in this scenario?

Any clues or comments would be appreciated.

Regards
Tony

RE: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

['Jason (PN)' ja...@jac2.co.uk [firebird-support]]

“so I guess this account is bonded to some  google email account”

When you subscribe it asks you to confirm an e-mail address you want associated 
with the group.  I hardly every use my gmail account, so linked it to the same 
e-mail as the yahoo one and getting notifications come through.

But, yes, you have to log into the group via a google login.

 

Jason Chapman

JAC2 Consultancy Limited

 

From: firebird-support@yahoogroups.com  
Sent: 05 May 2020 02:47
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

 

  

I've never used Google Groups, so I guess this account is bonded to some 
google email account and they want me to use that one. I'll check when I 
have some spare time.

Maybe it's time to give a new spin to some netscape.com email account ?

Pablo
> 
> I tried to use the new google group and have it send you an invite to 
> join the group. What Google responded with was:
> 
> Some email addresses cannot be added to this group because their
> accounts are disabled or are blocked from Google Groups.
> 
> So Google does not like your email address for some reason.
> 
> Doug C.





[Non-text portions of this message have been removed]

Re: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 05-05-2020 02:25, DougC d...@moosemail.net [firebird-support] wrote:
> I tried to use the new google group and have it send you an invite to 
> join the group. What Google responded with was:
> 
> Some email addresses cannot be added to this group because their
> accounts are disabled or are blocked from Google Groups.
> 
> So Google does not like your email address for some reason.

According to 
https://answers.yahoo.com/question/index?qid=20131030040143AACtioj:

"""
Unfortunately, the issue is on your friends side. She has disabled the 
option to allow Moderators or Groups to 'Invite' her to a group. She 
will need to go into her email settings and change it to allow it again.
"""

In other words, if this emailaddress is associated with a Google 
account, then on groups.google.com under My settings (first icon 
top-right) > My global settings under "Add/Invite settings" the option 
"Allow group managers to invite me to their groups" is disabled.

Mark
-- 
Mark Rotteveel

[firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[pablo sanchez pab...@adinet.com.uy [firebird-support]]

I've never used Google Groups, so I guess this account is bonded to some 
google email account and they want me to use that one. I'll check when I 
have some spare time.

Maybe it's time to give a new spin to some netscape.com email account ?

Pablo
> 
> I tried to use the new google group and have it send you an invite to 
> join the group. What Google responded with was:
> 
> Some email addresses cannot be added to this group because their
> accounts are disabled or are blocked from Google Groups.
> 
> So Google does not like your email address for some reason.
> 
> Doug C.

Re: [firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[DougC d...@moosemail.net [firebird-support]]

Pablo-

I tried to use the new google group and have it send you an invite to join the 
group. What Google responded with was:
Some email addresses cannot be added to this group because their accounts are 
disabled or are blocked from Google Groups.




So Google does not like your email address for some reason.

Doug C.

 On Mon, 04 May 2020 18:22:49 -0400 pablo sanchez 
mailto:pab...@adinet.com.uy [firebird-support] 
<mailto:firebird-support@yahoogroups.com> wrote 


 I sent an email to mailto:firebird-support+subscr...@googlegroups.com :
 
 /Quote
 From - Mon May 04 19:15:56 2020
 X-Mozilla-Status: 0001
 X-Mozilla-Status2: 0080
 X-Mozilla-Keys: 
 
 To: mailto:firebird-support+subscr...@googlegroups.com
 From: =?UTF-8?Q?Pablo_S=c3=a1nchez?= <mailto:pab...@adinet.com.uy>
 Subject: Subscribe
 Message-ID: mailto:-83d1-5846-68a2-8f4f48b6a...@adinet.com.uy>
 Date: Mon, 4 May 2020 19:15:55 -0300
 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.7.0
 MIME-Version: 1.0
 Content-Type: text/plain; charset=utf-8; format=flowed
 Content-Transfer-Encoding: 7bit
 Content-Language: en-US
 
 Subscribe
 
 /UnQuote
 
 And I got :
 
 Address not found
 Your message wasn't delivered to 
 mailto:firebird-support+subscr...@googlegroups.com because the address 
couldn't 
 be found, or is unable to receive mail.
 
 Cheers...
 
 Pablo
 
 > 
 > You don't need a Google account to join. Email to
 > mailto:firebird-support+subscr...@googlegroups.com and confirm the join 
 > request
 > by **replying** to the join request.
 > 
 > But yes, if your email address is associated with a google account, then
 > Google will default to your gmail address, even if you subscribed from a
 > different address. To fix this you need to go to
 > https://groups.google.com/forum/#!myforums, find the group, click
 > **Edit** after your name, and change "Email used for membership" to your
 > preferred address.
 > 
 > Mark
 > -- 
 > Mark Rotteveel
 > 
 > 
 >
 

[firebird-support] Re: IMPORTANT MESSGAGE: This group is moving

[pablo sanchez pab...@adinet.com.uy [firebird-support]]

I sent an email to firebird-support+subscr...@googlegroups.com :

/Quote
 From - Mon May 04 19:15:56 2020
X-Mozilla-Status: 0001
X-Mozilla-Status2: 0080
X-Mozilla-Keys: 

To: firebird-support+subscr...@googlegroups.com
From: =?UTF-8?Q?Pablo_S=c3=a1nchez?= 
Subject: Subscribe
Message-ID: 
Date: Mon, 4 May 2020 19:15:55 -0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
  Thunderbird/68.7.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US

Subscribe

/UnQuote


And I got :

  Address not found
Your message wasn't delivered to 
firebird-support+subscr...@googlegroups.com because the address couldn't 
be found, or is unable to receive mail.


Cheers...

Pablo

> 
> You don't need a Google account to join. Email to
> firebird-support+subscr...@googlegroups.com and confirm the join request
> by **replying** to the join request.
> 
> But yes, if your email address is associated with a google account, then
> Google will default to your gmail address, even if you subscribed from a
> different address. To fix this you need to go to
> https://groups.google.com/forum/#!myforums, find the group, click
> **Edit** after your name, and change "Email used for membership" to your
> preferred address.
> 
> Mark
> -- 
> Mark Rotteveel
> 
> 
>

Re: [firebird-support] Next attachment ID

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-05-04 10:34, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Hi
> 
> How can i read Next Attachement ID?
> 
> I know that i can read it by gstat -h but how to read it from
> connection?
> 
> Is there something simple like for OAT – read from MON$DATABASE or
> API isc_transaction_info?
> 
> Regards,
> 
> Karol Bieniaszewski

Hi Karol, could you repost to firebird-supp...@googlegroups.com?

Mark

[firebird-support] Next attachment ID

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Hi

How can i read Next Attachement ID?
I know that i can read it by gstat -h but how to read it from connection?
Is there something simple like for OAT – read from MON$DATABASE or API 
isc_transaction_info?

Regards,
Karol Bieniaszewski

Re: ODP: [firebird-support] IMPORTANT MESSGAGE: This group is moving

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 03-05-2020 10:39, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> I have joined but i cannot change name to show instead my email name.
> 
> I have followed hint on the group to go to settings – but to change this 
> settings i must login. I do not have google accout to login.
> 
> How to change it?

You cannot change it if you have subscribed with an email address that 
is not associated with a Google account. And as far as I'm aware, it 
will use the display name of your email address when actually posting a 
message.

Mark
-- 
Mark Rotteveel

ODP: [firebird-support] IMPORTANT MESSGAGE: This group is moving

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Hi

I have joined but i cannot change name to show instead my email name.
I have followed hint on the group to go to settings – but to change this 
settings i must login. I do not have google accout to login.
How to change it?

Regards,
Karol Bieniaszewski

Re: [firebird-support] IMPORTANT MESSGAGE: This group is moving

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 02-05-2020 11:38, Lester Caine les...@lsces.uk [firebird-support] wrote:
> On 02/05/2020 00:29, Helen Borrie hele...@tpg.com.au [firebird-support]
> wrote:
>> Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
>> need to resubscribe yourself, in one of two ways:
> 
> The other problem with pigging Google is their drive to make us use a
> Gmail account. They had removed my own email address and given me a
> @gmail.com one which is what they have just tried to resubscribe me with
>  it IS possible to retain a real email address, but personally I was
> trying to kill of using Google AT ALL because of the crap they keep
> pushing. SO if things don't improve I will be simply closing my google
> account completely!

You don't need a Google account to join. Email to 
firebird-support+subscr...@googlegroups.com and confirm the join request 
by **replying** to the join request.

But yes, if your email address is associated with a google account, then 
Google will default to your gmail address, even if you subscribed from a 
different address. To fix this you need to go to 
https://groups.google.com/forum/#!myforums, find the group, click 
**Edit** after your name, and change "Email used for membership" to your 
preferred address.

Mark
-- 
Mark Rotteveel

Re: [firebird-support] IMPORTANT MESSGAGE: This group is moving

[Lester Caine les...@lsces.uk [firebird-support]]

On 02/05/2020 00:29, Helen Borrie hele...@tpg.com.au [firebird-support] 
wrote:
> Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
> need to resubscribe yourself, in one of two ways:

The other problem with pigging Google is their drive to make us use a 
Gmail account. They had removed my own email address and given me a 
@gmail.com one which is what they have just tried to resubscribe me with 
 it IS possible to retain a real email address, but personally I was 
trying to kill of using Google AT ALL because of the crap they keep 
pushing. SO if things don't improve I will be simply closing my google 
account completely!

-- 
Lester Caine - G8HFL
-
Contact - https://lsces.uk/wiki/Contact
L.S.Caine Electronic Services - https://lsces.uk
Model Engineers Digital Workshop - https://medw.uk
Rainbow Digital Media - https://rainbowdigitalmedia.uk

Re: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

OK, so the last change was successful: The +0 as suggested by Set works. 
The query now uses the faster query plan through the entire batch (at 
least it still does after 1769 chunks.

Many thanks for all your input! I still think it would be interesting 
with some theories about why the engine behaves like this, perhaps from 
the dev team...?

Mvh,
Kjell

Den 2020-05-01 kl. 09:53, skrev Kjell Rilbe 
kjell.ri...@marknadsinformation.se [firebird-support]:
>
> Well, the changed subselect didn't do the trick, but I think it speeds
> up the query slightly, overall.
>
> Now, it's this query that's causing problems:
>
> insert into "TmpFKExportUhant" ("ECO_ID", "Bärartyp")
> select FtgOmsar."Uppgiftshanterare", 'FöretagOmsättningsår' "Bärartyp"
> from "Företag" F
> inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
> inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" =
> F."ECO_ID" + 0
> inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår" + 0
> where not exists (
>     select 1
>     from "FöretagOmsättningsår" FtgOmsar2
>     inner join "År" Ar2 on Ar2."ECO_ID" = FtgOmsar2.."Omsättningsår"
>     where FtgOmsar2."Företag" = F."ECO_ID"
>   and Ar2."Årtal" > Ar."Årtal"
>   );
>
> The "breaking point" has now moved to 361 executions. Before that point,
> the "fast" execution plan looks like this (both styles):
>
> PLAN JOIN (
>   L NATURAL,
>   F INDEX ("IX_PK_Företag"),
>   FTGOMSAR INDEX ("IX_FöretagOmsättningsåDBN"),
>   AR INDEX ("IX_PK_År")
> )
>
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR2" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range Scan
> (full match)
>     -> Filter
>     -> Table "År" as "AR2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Table "TmpFKExportId" as "L" Full Scan
>     -> Filter
>     -> Table "Företag" as "F" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_Företag" Unique Scan
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range Scan
> (full match)
>     -> Filter
>     -> Table "År" as "AR" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
>
> After the slowdown, the "bad" query plan looks like this:
>
> PLAN JOIN (
>   L NATURAL,
>   F INDEX (IX_PK_Företag),
>   FTGOMSAR INDEX (IX_FöretagOmsättningsåDBN),
>   AR INDEX (IX_PK_År)
> )
>
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR2" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningsåDBN" Range Scan
> (full match)
>     -> Filter
>     -> Table "År" as "AR2" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_År" Unique Scan
> Select Expression
>     -> Nested Loop Join (inner)
>     -> Table "År" as "AR" Full Scan
>     -> Filter
>     -> Table "FöretagOmsättningsår" as "FTGOMSAR" Access By ID
>     -> Bitmap
>     -> Index "IX_FöretagOmsättningså9OF" Range Scan
> (full match)
>     -> Filter
>     -> Table "TmpFKExportId" as "L" Access By ID
>     -> Bitmap
>     -> Index "PK_TmpFKExportId" Unique Scan
>     -> Filter
>     -> Table "Företag" as "F" Access By ID
>     -> Bitmap
>     -> Index "IX_PK_Företag" Unique Scan
>
> It's worth noting that the old-style query plans are identical, but the
> new-style ones do have a difference, which is probably causing the 
>

[firebird-support] IMPORTANT MESSGAGE: This group is moving

[Helen Borrie hele...@tpg.com.au [firebird-support]]

Hello Firebird-support members,

The firebird-support list is moving to Google Groups. The new location is
https://groups.google.com/d/forum/firebird-support

Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
need to resubscribe yourself, in one of two ways:

(1) If you have a Google account, log in to Google, go to the group's home page
(https://groups.google.com/forum/#!forum/firebird-support;context-place=overview),
Click the link labelled 'Join this group' and follow instructions there.

(2) Without a Google account, you can apply to join by emailing this
address using the email account you want to use for communicating with
the group:
firebird-support+subscr...@googlegroups.com
You should receive a confirmation email.  Respond as directed to
complete. (this does not require a Google account).

For posting to the list you can use firebird-supp...@googlegroups.com

Note, if you are subscribed to more than one Firebird-related Yahoo!
group, your will need to go through a similar process for each of your
groups.

Helen Borrie
for Firebird Project



-- 
This email has been checked for viruses by AVG.
https://www.avg.com

Re: ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

Sorry I can't help at all, Kjell, I'm all "old style query plan". Though
I'm baffled by the new style changing when the old style remains and would
love if someone could explain...

Set

fre. 1. mai 2020 kl. 11:56 skrev Karol Bieniaszewski
liviusliv...@poczta.onet.pl [firebird-support] <
firebird-support@yahoogroups.com>:

>
>
> You can try also pseudo inner join (left join with where clause)
>
>
>
> Instead of
>
>
>
> T1 INNER JOIN T2 ON T1.ID1=T2.ID2
>
>
>
> change it to
>
>
>
> T1 LEFT JOIN T2 ON T1.ID1=T2.ID2
>
> WHERE
>
> T2. ID2 IS NOT NULL
>
>
>
> regards,
>
> Karol Bieniaszewski
>
>
> 

ODP: ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

You can try also pseudo inner join (left join with where clause)

Instead of

T1 INNER JOIN T2 ON T1.ID1=T2.ID2

change it to

T1 LEFT JOIN T2 ON T1.ID1=T2.ID2
WHERE
T2. ID2 IS NOT NULL

regards,
Karol Bieniaszewski

Re: ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

e of slowdown/change of query strategy.

The only thing I can see in FBMonitor's graphs is that about 35 minutes 
before the slowdown, the I/O activity graph shows an increase in cache 
hits, but no apparent change in disk reads or disk writes. Studying the 
actual statements around that time, I fail to see any significant change 
in the statistics. The statistics do change significantly at the time of 
slowdown though, when the bad query plans starts being used.

I think Firebird's behavior is really really weird here. It consistently 
changes to a worse query plan for the same query on essentially the same 
data, just because it's already been executed N times, where N = 316-320 
with the old query and apparently N = ~361 with the current query.

This must be caused by some internal transient state, associated with 
the app's activity history. Some buffer filling up or some other 
resource being depleted or something like that. Is it abug? If so, how 
on earth could it possibly be investigated? Ugh...

Mvh,
Kjell

Den 2020-05-01 kl. 01:12, skrev Kjell Rilbe 
kjell.ri...@marknadsinformation.se [firebird-support]:
>
> Hi Set!
>
> Understood and I thank you for pointing it out. My last attempt was to
> put all the Uhant."ECO_ID" in a temp table and then use that to run the
> last part of the query. That avoids the unions, but adds some extra work
> to store the records in the temp table. All in all I suppose it's
> slightly more work for the engine.
>
> But as it turns out, it's that part of the query that suddenly takes a
> lot longer to execute.
>
> Trying now with the alternative subselect you suggested earlier, i.e.
> not exists (...). If that doesn't work out, I'll try the +0 you suggest
> below. Thumbs up!
>
> Regards,
> Kjell
>
> Den 2020-04-30 kl. 23:14, skrev Svein Erling Tysvær setys...@gmail.com
> [firebird-support]:
> > Hej Kjell,
> >
> > I'm not used to seeing plans this way, but if I'm reading the plan
> > correctly, then adding +0 or || '' (depending on the field type)
> > immediately after your first union like this:
> >
> >      select 'FöretagOmsättningsår' "Bärartyp", FtgOmsar."ECO_ID"
> > "Bärare", Uhant."ECO_ID"
> >      from "Företag" F
> >      inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
> >      inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag"
> > = F."ECO_ID" +0
> >      inner join "År" Ar on Ar."ECO_ID" = FtgOmsar.."Omsättningsår" +0
> >      inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
> > FtgOmsar."Uppgiftshanterare"
> >
> > ought to speed up your query. The point being that your slow plan only
> > is an option if indices can be used for FtgOmsar."Omsättningsår" and
> > F."ECO_ID" and that this kind of addition prevents those indices from
> > being used.
> >
> > HTH,
> > Set
> >
> > tor. 30. apr. 2020 kl. 17:43 skrev Kjell Rilbe
> > kjell.ri...@marknadsinformation.se
> > <mailto:kjell.ri...@marknadsinformation.se> [firebird-support]
> >  > <mailto:firebird-support@yahoogroups.com>>:
> >
> > Thanks Karol! I will consider explicit plan if my current rewrite
> > of the
> > query doesn't pan out.
> >
> > The table "TmpFKExportId" will always have the same number of
> > records,
> > but a different set (each chunk of the batch will load the same
> > number
> > of id:s, but of course different id values). Statistics should be
> > constant.
> >
> > The other tables will vary slightly over time, but the database
> > contains
> > 2+ million companies and related data. During the batch, the only
> > updates to this data is from our TM staff who phone companies and
> > enter
> > data manually, one company at a time. So overall, the change rate is
> > minute. And in particular, there's no big change exactly 318
> > chunks into
> > the batch job, every time.
> >
> > Yes, the query is hardcoded as a string literal into the app's source
> > code. It can't get more "same" than that. :-)
> >
> > Mvh,
> > Kjell
> >
> > Den 2020-04-30 kl. 17:06, skrev Karol Bieniaszewski
> > liviusliv...@poczta.onet.pl <mailto:liviusliv...@poczta.onet.pl>
> > [firebird-support]:
> > >
> > > I suppose you have two different queries – one with where clause
> > and
> > > one without on one of the tables involved in the query.
> > > Are you sure that the queries are the same?
> > >
> > > But also it is quite usual that after new data changes the plan is
> > > about to change.
> > > Is this true for your case that some table got more records
> > after fill
> > > then previously second table?
> > > Especially this one?:
> > >
> > > You can try also modify your query to have static plan (some +0) or
> > > update index statistics after some count of operations.
> > >
> > > Regards,
> > > Karol Bieniaszewski
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > 
> > Posted by: Kjell Rilbe  > <mailto:kjell.ri...@marknadsinformation.se>>
> > 
> >
> > ++
> >
> > Visit http://www.firebirdsql.org and click the Documentation item
> > on the main (top) menu.  Try FAQ and other links from the
> > left-side menu there.
> >
> > Also search the knowledgebases at
> > http://www.ibphoenix.com/resources/documents/
> >
> > ++
> > 
> >
> > Yahoo Groups Links
> >
> >
> > firebird-support-fullfeatu...@yahoogroups.com
> > <mailto:firebird-support-fullfeatu...@yahoogroups.com>
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] new Google groups

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-05-01 02:20, Hamish Moffatt ham...@risingsoftware.com 
[firebird-support] wrote:
> The firebirdsql.org site lists new Google groups to replace the yahoo
> firebird-support and firebird-general lists, but the links don't work -
> I get permission denied errors trying to visit them.
> 
> Are these new lists set up and ready to go?

I believe that right now those groups haven't been configured with the 
right (public) visibility yet.

Mark

[firebird-support] new Google groups

[Hamish Moffatt ham...@risingsoftware.com [firebird-support]]

The firebirdsql.org site lists new Google groups to replace the yahoo 
firebird-support and firebird-general lists, but the links don't work - 
I get permission denied errors trying to visit them.

Are these new lists set up and ready to go?


Hamish

Re: ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Hi Set!

Understood and I thank you for pointing it out. My last attempt was to 
put all the Uhant."ECO_ID" in a temp table and then use that to run the 
last part of the query. That avoids the unions, but adds some extra work 
to store the records in the temp table. All in all I suppose it's 
slightly more work for the engine.

But as it turns out, it's that part of the query that suddenly takes a 
lot longer to execute.

Trying now with the alternative subselect you suggested earlier, i.e. 
not exists (...). If that doesn't work out, I'll try the +0 you suggest 
below. Thumbs up!

Regards,
Kjell

Den 2020-04-30 kl. 23:14, skrev Svein Erling Tysvær setys...@gmail.com 
[firebird-support]:
> Hej Kjell,
>
> I'm not used to seeing plans this way, but if I'm reading the plan 
> correctly, then adding +0 or || '' (depending on the field type) 
> immediately after your first union like this:
>
>      select 'FöretagOmsättningsår' "Bärartyp", FtgOmsar."ECO_ID" 
> "Bärare", Uhant."ECO_ID"
>      from "Företag" F
>      inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
>      inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" 
> = F."ECO_ID" +0
>      inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår" +0
>      inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" = 
> FtgOmsar."Uppgiftshanterare"
>
> ought to speed up your query. The point being that your slow plan only 
> is an option if indices can be used for FtgOmsar."Omsättningsår" and 
> F."ECO_ID" and that this kind of addition prevents those indices from 
> being used.
>
> HTH,
> Set
>
> tor. 30. apr. 2020 kl. 17:43 skrev Kjell Rilbe 
> kjell.ri...@marknadsinformation.se 
> <mailto:kjell.ri...@marknadsinformation.se> [firebird-support] 
>  <mailto:firebird-support@yahoogroups.com>>:
>
> Thanks Karol! I will consider explicit plan if my current rewrite
> of the
> query doesn't pan out.
>
> The table "TmpFKExportId" will always have the same number of
> records,
> but a different set (each chunk of the batch will load the same
> number
> of id:s, but of course different id values). Statistics should be
> constant.
>
> The other tables will vary slightly over time, but the database
> contains
> 2+ million companies and related data. During the batch, the only
> updates to this data is from our TM staff who phone companies and
> enter
> data manually, one company at a time. So overall, the change rate is
> minute. And in particular, there's no big change exactly 318
> chunks into
> the batch job, every time.
>
> Yes, the query is hardcoded as a string literal into the app's source
> code. It can't get more "same" than that. :-)
>
> Mvh,
> Kjell
>
> Den 2020-04-30 kl. 17:06, skrev Karol Bieniaszewski
> liviusliv...@poczta.onet.pl <mailto:liviusliv...@poczta.onet.pl>
> [firebird-support]:
> >
> > I suppose you have two different queries – one with where clause
> and
> > one without on one of the tables involved in the query.
> > Are you sure that the queries are the same?
> >
> > But also it is quite usual that after new data changes the plan is
> > about to change.
> > Is this true for your case that some table got more records
> after fill
> > then previously second table?
> > Especially this one?:
> >
> > You can try also modify your query to have static plan (some +0) or
> > update index statistics after some count of operations.
> >
> > Regards,
> > Karol Bieniaszewski
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
> Posted by: Kjell Rilbe  <mailto:kjell.ri...@marknadsinformation.se>>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the
> left-side menu there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
> firebird-support-fullfeatu...@yahoogroups.com
> <mailto:firebird-support-fullfeatu...@yahoogroups.com>
>
>
> 


[Non-text portions of this message have been removed]

Re: ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

Hej Kjell,

I'm not used to seeing plans this way, but if I'm reading the plan
correctly, then adding +0 or || '' (depending on the field type)
immediately after your first union like this:

 select 'FöretagOmsättningsår' "Bärartyp", FtgOmsar.."ECO_ID" "Bärare",
Uhant."ECO_ID"
 from "Företag" F
 inner join "TmpFKExportId" L on L."ECO_ID" = F."ECO_ID"
 inner join "FöretagOmsättningsår" FtgOmsar on FtgOmsar."Företag" =
F."ECO_ID" +0
 inner join "År" Ar on Ar."ECO_ID" = FtgOmsar."Omsättningsår" +0
 inner join "Uppgiftshanterare" Uhant on Uhant."ECO_ID" =
FtgOmsar."Uppgiftshanterare"

ought to speed up your query. The point being that your slow plan only is
an option if indices can be used for  FtgOmsar."Omsättningsår" and
F."ECO_ID" and that this kind of addition prevents those indices from being
used.

HTH,
Set

tor. 30. apr. 2020 kl. 17:43 skrev Kjell Rilbe
kjell.ri...@marknadsinformation.se [firebird-support] <
firebird-support@yahoogroups.com>:

> Thanks Karol! I will consider explicit plan if my current rewrite of the
> query doesn't pan out.
>
> The table "TmpFKExportId" will always have the same number of records,
> but a different set (each chunk of the batch will load the same number
> of id:s, but of course different id values). Statistics should be constant.
>
> The other tables will vary slightly over time, but the database contains
> 2+ million companies and related data. During the batch, the only
> updates to this data is from our TM staff who phone companies and enter
> data manually, one company at a time. So overall, the change rate is
> minute. And in particular, there's no big change exactly 318 chunks into
> the batch job, every time.
>
> Yes, the query is hardcoded as a string literal into the app's source
> code. It can't get more "same" than that. :-)
>
> Mvh,
> Kjell
>
> Den 2020-04-30 kl. 17:06, skrev Karol Bieniaszewski
> liviusliv...@poczta.onet.pl [firebird-support]:
> >
> > I suppose you have two different queries – one with where clause and
> > one without on one of the tables involved in the query.
> > Are you sure that the queries are the same?
> >
> > But also it is quite usual that after new data changes the plan is
> > about to change.
> > Is this true for your case that some table got more records after fill
> > then previously second table?
> > Especially this one?:
> >
> > You can try also modify your query to have static plan (some +0) or
> > update index statistics after some count of operations.
> >
> > Regards,
> > Karol Bieniaszewski
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
> Posted by: Kjell Rilbe 
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
>

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Sorry Carlos - I read that wrong.  Thought you were asking if the script could 
be run with isql.

Cheers,
Kevin



 

> On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br 
> [firebird-support]  wrote:
> 
> Step 1 is better if you are going from dialect 1 to 3, mostly due to
> the difference in the numerics internal storage.
> 
> I see no problem with any of the approaches.
> 
> I would add that, imho, step 4 in process 2 is not really necessary,
> unless you want to reset the metadata versions count of the objects
> from 1 to 0.
> 
> Also, about step 3, you can prepare a script with "create or alter"
> statements of your procedures, triggers, etc. and run it using any
> tool or even isql.
> 
> []s
> Carlos
> Migration Guide to FB 3
> http://www.firebirdnews.org/migration-guide-to-firebird-3/ 
> <http://www.firebirdnews.org/migration-guide-to-firebird-3/>
> 
> KSKSRScfs> Greetings!
> 
> KSKSRScfs> Process 1:
> KSKSRScfs> Via a script, I have successfully exported and migrated
> KSKSRScfs> all data and objects from a FB1 database to FB3.
> KSKSRScfs> Creating the objects originally had just a few errors but
> KSKSRScfs> those have been fixed and it now goes across cleanly, no errors.
> KSKSRScfs> This process has been the one most widely recommended.
> 
> KSKSRScfs> Process 2:
> KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the 
> following:
> KSKSRScfs> 1. Backup the database with FB1.
> KSKSRScfs> 2. Restore the database with FB3.
> KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all
> KSKSRScfs> Procedures and b) Recompile all Triggers. (No errors)
> KSKSRScfs> 4. Performed a backup / restore with no errors.
> 
> KSKSRScfs> My question: is Process 2 an acceptable path? The only
> KSKSRScfs> reason I ask is one of my customers has many millions of
> KSKSRScfs> records and I believe Process 2 will save me a weekend of
> KSKSRScfs> work. (My next step is to benchmark how long Process 1
> KSKSRScfs> will take for this customer’s database).
> 
> KSKSRScfs> Many Thanks!
> 
> KSKSRScfs> Kevin
> 
> 
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] Timestamp in different regions

[Gregor Kobler gregorkob...@yahoo.com [firebird-support]]

Of course your software uses the client-library. Normaly FireDAV uses by 
default fbclient.dll. Your software will look at the windows path

I copy the fbclient.dll from firebird install folder to my client program 
folder. But be aware to use the right version 32/64Bit! the 32 bit version you 
will find at C:\Program Files\Firebird\Firebird_3_0\WOW64, the 64 Bit at 
C:\Program Files\Firebird\Firebird_3_0

also copy the two following dll's"msvcr100.dll" and "msvcp100.dll" do your 
program folder. This are also an option, that a client PC not has to install 
any firebird software. Your program will run without firebird installed (but 
just at client-PC's)!

Add a TFDPhysFBDriverLink component to your Delphi project, and define the 
propertie VendorLib to e.g. "C:\Temp\myprojectpath\fbclient.dll". What ever you 
whant, set the path where the three dll's are!

Gregor

Sent from Yahoo Mail. Get the app 

On Thursday, April 30, 2020, 6:52:20 PM GMT+2, 'Zoran' zoran...@gmail.com 
[firebird-support]  wrote:  
 
     
Hi Gregor

Thank you for the answer.

I’m using FireDAC components. FB version is 3.0.5. My middle-ware server 
program and FB engine are on VPS located in US. I’m developing client app also 
in US. All works ok since both programs are in the same region.

I have VM with Win 10 and region set to Europe. I’ve installed FB and server 
middle-ware in this VM as well. When I execute client app connecting to US 
server, I get the error. When I execute client app connecting to the local 
server (which on the same VM machine) all works ok.

I’m not using client-library fbclient.dll or GDS32.dll. This is multi-user app, 
some users are in US some are in Europe.

Error happens as soon as I execute ‘qry.Open;’ statement. Karol suggested to 
debug the code and I will. But this will go to FireDAC code which is rather 
complicated. That’s why I’ve asked here if someone experienced similar problem.

Regards

Zoran

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' zoran...@gmail.com [firebird-support] 

Subject: Re: [firebird-support] Timestamp in different regions

Hello Zoran

Witch Component do you useing in Delphi FireDAC?

Are you shure, that that your clients uses the right client-library 
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5

What FB Version do you use?

Best Regards
Gregor

Sent from Yahoo Mail. Get the app

On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' zoran...@gmail.com 
[firebird-support]  wrote: 

Thank you, Karol.

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement..

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

I do not suppose that this is Firebird message.

This looks like client program message. 

regards,

Karol Bieniaszewski

Firebird 3.0.5, Delphi 10.3.3

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

Does anyone experience this, or am I missing something here?_,

Thank you

Zoran

[Non-text portions of this message have been removed]


  #yiv5410137613 #yiv5410137613 -- #yiv5410137613ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5410137613 
#yiv5410137613ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5410137613 
#yiv5410137613ygrp-mkp #yiv5410137613hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5410137613 #yiv5410137613ygrp-mkp #yiv5410137613ads 
{margin-bottom:10px;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad 
{padding:0 0;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad p 
{margin:0;}#yiv5410137613 #yiv5410137613ygrp-mkp .yiv5410137613ad a 
{color:#ff;text-decoration:none;}#yiv5410137613 #yiv5410137613ygrp-sponsor 
#yiv5410137613ygrp-lc {font-family:Arial;}#yiv5410137613 
#yiv5410137613ygrp-sponsor #yiv5410137613ygrp-lc #yiv5410137613hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5410137613 
#yiv5410137613ygrp-sponsor #yiv5410137613ygrp-lc .yiv5410137613ad 
{margin-bottom:10px;padding:0 0;}#yiv5410137613 #yiv5410137613actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5410137613 
#yiv5410137613activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5410137613
 #yi

RE: [firebird-support] Timestamp in different regions

['Zoran' zoran...@gmail.com [firebird-support]]

Hi Gregor

 

Thank you for the answer.

 

I’m using FireDAC components. FB version is 3.0.5. My middle-ware server 
program and FB engine are on VPS located in US. I’m developing client app also 
in US. All works ok since both programs are in the same region.

 

I have VM with Win 10 and region set to Europe. I’ve installed FB and server 
middle-ware in this VM as well. When I execute client app connecting to US 
server, I get the error. When I execute client app connecting to the local 
server (which on the same VM machine) all works ok.

 

I’m not using client-library fbclient.dll or GDS32.dll. This is multi-user app, 
some users are in US some are in Europe.

 

Error happens as soon as I execute ‘qry.Open;’ statement. Karol suggested to 
debug the code and I will. But this will go to FireDAC code which is rather 
complicated. That’s why I’ve asked here if someone experienced similar problem.

 

Regards

Zoran

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' zoran...@gmail.com [firebird-support] 

Subject: Re: [firebird-support] Timestamp in different regions

 

  

Hello Zoran

Witch Component do you useing in Delphi FireDAC?

Are you shure, that that your clients uses the right client-library 
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5

What FB Version do you use?

Best Regards
Gregor



Sent from Yahoo Mail. Get the app



On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' zoran...@gmail.com 
[firebird-support]  wrote: 

 

 

 

Thank you, Karol.

 

Probably not FB message. I guess it’s coming from Delphi. It happens right 
after I execute ‘qry.Open;’ statement..

What I was hopping for is if someone with Delphi background can shed some light 
on Delphi handling this situation.

 

 

From: firebird-support@yahoogroups.com  
Sent: Thursday, April 30, 2020 11:09 AM
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Timestamp in different regions

 

  

I do not suppose that this is Firebird message.

This looks like client program message. 

 

regards,

Karol Bieniaszewski

 

 

Firebird 3.0.5, Delphi 10.3.3

 

In a table I have TIMESTAMP column. If I read that table from the client in the 
same Region as server all is ok. If I read the same table where client is in 
the different region than server, I get error message 'Could not parse SQL 
TimeStamp string'. 

 

In another words if server is in US and client is in US all is ok. If server is 
in Europe and client is in Europe, all is ok. But, if server is in US and 
client is in Europe (and vice-versa) I get this error.

 

Does anyone experience this, or am I missing something here?_,

 

Thank you

Zoran





[Non-text portions of this message have been removed]

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Great - thanks Mark.  I only need FR just for that, simple queries and the 
occasional update/delete sql.


 

> On Apr 30, 2020, at 9:09 AM, Mark Rotteveel m...@lawinegevaar.nl 
> [firebird-support]  wrote:
> 
> On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com 
> <mailto:kevin.stan...@rdb-solutions.com> 
> [firebird-support] wrote:
> > I always tend to do back / restores not only in this migration but on
> > a regular basis. I’m maybe a little on the paranoid side. :)
> > I have noticed some extra lines in the restore log for FB3 (this is
> > true even on a completely new FB3 database):
> > 
> > gbak:fixing views dbkey length
> > gbak:updating ownership of packages, procedures and tables
> > gbak:adding missing privileges
> > gbak:fixing system generators
> > gbak:finishing, closing, and going home
> > gbak:adjusting the ONLINE and FORCED WRITES flags
> > 
> 
> Those are just steps that gbak will apply, even if there is 'nothing to 
> fix'.
> 
> > 
> > The script is very easily generated out of IB Expert. I cannot praise
> > this tool enough.
> > 
> > I haven’t tried the script using isql but I would be surprised if it
> > didn’t work. I will give it a shot possibly over this coming weekend.
> > I’m slammed at the moment.
> > 
> > I also use FlameRobin for FB1. Not sure if that is compatible with
> > FB3? There were some concerns in previous postings.
> 
> FlameRobin works with Firebird 3, but it doesn't support the new boolean 
> datatype, and it has no support for packages and PSQL function, which 
> might incorrectly show procedures from packages, or functions. In 
> addition, user management should now be done through SQL, so the user 
> management options in FlameRobin will still work, but they will only 
> work with the first (default) UserManager. There might be some more 
> issues, but for general query work it will work fine.
> 
> Mark
> 
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] FB1 to FB3

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com 
[firebird-support] wrote:
> I always tend to do back / restores not only in this migration but on
> a regular basis.  I’m maybe a little on the paranoid side.  :)
> I have noticed some extra lines in the restore log for FB3 (this is
> true even on a completely new FB3 database):
> 
> gbak:fixing views dbkey length
> gbak:updating ownership of packages, procedures and tables
> gbak:adding missing privileges
> gbak:fixing system generators
> gbak:finishing, closing, and going home
> gbak:adjusting the ONLINE and FORCED WRITES flags
> 

Those are just steps that gbak will apply, even if there is 'nothing to 
fix'.

> 
> The script is very easily generated out of IB Expert.  I cannot praise
> this tool enough.
> 
> I haven’t tried the script using isql but I would be surprised if it
> didn’t work.  I will give it a shot possibly over this coming weekend.
>  I’m slammed at the moment.
> 
> I also use FlameRobin for FB1.  Not sure if that is compatible with
> FB3?  There were some concerns in previous postings.

FlameRobin works with Firebird 3, but it doesn't support the new boolean 
datatype, and it has no support for packages and PSQL function, which 
might incorrectly show procedures from packages, or functions. In 
addition, user management should now be done through SQL, so the user 
management options in FlameRobin will still work, but they will only 
work with the first (default) UserManager. There might be some more 
issues, but for general query work it will work fine.

Mark

Re: ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

[Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]]

Thanks Karol! I will consider explicit plan if my current rewrite of the 
query doesn't pan out.

The table "TmpFKExportId" will always have the same number of records, 
but a different set (each chunk of the batch will load the same number 
of id:s, but of course different id values). Statistics should be constant.

The other tables will vary slightly over time, but the database contains 
2+ million companies and related data. During the batch, the only 
updates to this data is from our TM staff who phone companies and enter 
data manually, one company at a time. So overall, the change rate is 
minute. And in particular, there's no big change exactly 318 chunks into 
the batch job, every time.

Yes, the query is hardcoded as a string literal into the app's source 
code. It can't get more "same" than that. :-)

Mvh,
Kjell

Den 2020-04-30 kl. 17:06, skrev Karol Bieniaszewski 
liviusliv...@poczta.onet.pl [firebird-support]:
>
> I suppose you have two different queries – one with where clause and 
> one without on one of the tables involved in the query.
> Are you sure that the queries are the same?
>
> But also it is quite usual that after new data changes the plan is 
> about to change.
> Is this true for your case that some table got more records after fill 
> then previously second table?
> Especially this one?:
>
> You can try also modify your query to have static plan (some +0) or 
> update index statistics after some count of operations.
>
> Regards,
> Karol Bieniaszewski
>
> [Non-text portions of this message have been removed]
>
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] FB1 to FB3

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

I always tend to do back / restores not only in this migration but on a regular 
basis.  I’m maybe a little on the paranoid side.  :)
I have noticed some extra lines in the restore log for FB3 (this is true even 
on a completely new FB3 database):

gbak:fixing views dbkey length
gbak:updating ownership of packages, procedures and tables
gbak:adding missing privileges
gbak:fixing system generators
gbak:finishing, closing, and going home
gbak:adjusting the ONLINE and FORCED WRITES flags






The script is very easily generated out of IB Expert.  I cannot praise this 
tool enough.

I haven’t tried the script using isql but I would be surprised if it didn’t 
work.  I will give it a shot possibly over this coming weekend.  I’m slammed at 
the moment.

I also use FlameRobin for FB1.  Not sure if that is compatible with FB3?  There 
were some concerns in previous postings.


Cheers,
Kevin



 

> On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br 
> [firebird-support]  wrote:
> 
> Step 1 is better if you are going from dialect 1 to 3, mostly due to
> the difference in the numerics internal storage.
> 
> I see no problem with any of the approaches.
> 
> I would add that, imho, step 4 in process 2 is not really necessary,
> unless you want to reset the metadata versions count of the objects
> from 1 to 0.
> 
> Also, about step 3, you can prepare a script with "create or alter"
> statements of your procedures, triggers, etc. and run it using any
> tool or even isql.
> 
> []s
> Carlos
> Migration Guide to FB 3
> http://www.firebirdnews.org/migration-guide-to-firebird-3/ 
> <http://www.firebirdnews.org/migration-guide-to-firebird-3/>
> 
> KSKSRScfs> Greetings!
> 
> KSKSRScfs> Process 1:
> KSKSRScfs> Via a script, I have successfully exported and migrated
> KSKSRScfs> all data and objects from a FB1 database to FB3.
> KSKSRScfs> Creating the objects originally had just a few errors but
> KSKSRScfs> those have been fixed and it now goes across cleanly, no errors.
> KSKSRScfs> This process has been the one most widely recommended.
> 
> KSKSRScfs> Process 2:
> KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the 
> following:
> KSKSRScfs> 1. Backup the database with FB1.
> KSKSRScfs> 2. Restore the database with FB3.
> KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all
> KSKSRScfs> Procedures and b) Recompile all Triggers. (No errors)
> KSKSRScfs> 4. Performed a backup / restore with no errors.
> 
> KSKSRScfs> My question: is Process 2 an acceptable path? The only
> KSKSRScfs> reason I ask is one of my customers has many millions of
> KSKSRScfs> records and I believe Process 2 will save me a weekend of
> KSKSRScfs> work. (My next step is to benchmark how long Process 1
> KSKSRScfs> will take for this customer’s database).
> 
> KSKSRScfs> Many Thanks!
> 
> KSKSRScfs> Kevin
> 
> 
> 



[Non-text portions of this message have been removed]