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', ' ', ''), '-', ''),
tm_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)
&
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 a
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.
>
&g
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
>
@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, do
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 fro
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
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
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
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
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
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:
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
ماجستير إدارة المـــوارد البشريـــة المهنـــي المصغر
للتسجيلاضغط هنا
https://docs.google.com/forms/d/e/1FAIpQLScKw5l9ywIV8QQi9PXAUFoKUen2i7ZOXo5D55pYQMMbiJCDXQ/viewform?vc=0=0=1
لمزيد من المعلومات برجاء الاتصال
مدير التدريب
أ / ميرفت شاهين
جوال & واتس/ 00201009306111 -
ماجستير إدارة المـــوارد البشريـــة المهنـــي المصغر
للتسجيلاضغط هنا
https://docs.google.com/forms/d/e/1FAIpQLScKw5l9ywIV8QQi9PXAUFoKUen2i7ZOXo5D55pYQMMbiJCDXQ/viewform?vc=0=0=1
لمزيد من المعلومات برجاء الاتصال
مدير التدريب
أ / ميرفت شاهين
جوال & واتس/ 00201009306111 -
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
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
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):CRE
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,
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
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
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:
> C
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-supp
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/documen
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.
--
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
se
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.
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-su
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
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
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 b
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
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,
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\Firebir
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
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.
> &
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
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 install
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
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 '
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 envi
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
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.
--
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 plug
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 e
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
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
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. ;(
>
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 langu
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
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
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,
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
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
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,
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
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
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
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
Hi
First change group from yahoo to google group.
And without whole reproducible script no one can help i suppose
Regards,
Karol Bieniaszewski
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-supe
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
nable 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.c
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:
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 + +
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
>&g
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
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]
>
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,
?
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 ver
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.lo
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
.
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
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
> accoun
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
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:5
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
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
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
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
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
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,
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 a
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,
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
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]
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
ut 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 ti
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 v
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
!
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 af
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
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
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
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
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-s
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 lo
iaszewski
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
> 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 approac
1 - 100 of 17252 matches
Mail list logo