Re: [firebird-support] Trigger checking for empty strings and replace with NULL

2019-10-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.10.2019 15:43, 'pc_f...@bluewin.ch' pc_f...@bluewin.ch [firebird-support] wrote: > Is it Possible to create a solution that checks every existing field that > exists on the > table ? No. -- WBR, SD.

[firebird-support] Trigger checking for empty strings and replace with NULL

2019-10-04 Thread 'pc_f...@bluewin.ch' pc_f...@bluewin.ch [firebird-support]
Hello, I don't know if this is the right place to ask my question about Firebird syntax. Please correct me if this is the wrong place. Im using FB 2.5 with IBExpert. I currently try to create a Trigger that checks on insert if the inserting values are Empty Strings, if yes replace

Re: [firebird-support] Firebird-net-provider

2019-10-04 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
I'll try again. I did not receive an approval email. ` On Fri, Oct 4, 2019 at 12:03 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 4-10-2019 15:39, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > > > > > Yesterday, I sent

Re: [firebird-support] Firebird-net-provider

2019-10-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 4-10-2019 15:39, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > > > Yesterday, I sent an email to > =>"I'm wondering if I > subscribed correctly?" > > I have not received a response.  Any suggestions?  I would like to start >

[firebird-support] Firebird 3 an 2.5 SS on the same Linux Server !

2019-10-04 Thread gugui_sarubi_mac...@yahoo.com.br [firebird-support]
Hi all, I need 2 versions of Firebird running in my Debian 10 Linux 3.0 CS on port 3055 2.5 SS on port 3050 is it possible ? because both installations is in /opt/firebird... Thanks in advance

[firebird-support] Firebird-net-provider

2019-10-04 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
Yesterday, I sent an email to => "I'm wondering if I subscribed correctly?" I have not received a response. Any suggestions? I would like to start code writing for a Firebird database. On Thu, Oct 3, 2019 at 11:40 AM Mark Rotteveel m...@lawinegevaar.nl

Re: [firebird-support] Re: Negative impact on system performance querying monitoring tables.

2019-10-04 Thread Marcelo Guimaraes mfguimar...@gmail.com [firebird-support]
Thanks all for the clarify! Regards, Marcelo Guimarães Em sex, 4 de out de 2019 às 10:19, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] < firebird-support@yahoogroups.com> escreveu: > 04.10.2019 15:50, Mark Rotteveel wrote: > > > The problem is inherent to the monitoring

[firebird-support] Re: Negative impact on system performance querying monitoring tables.

2019-10-04 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
04.10.2019 15:50, Mark Rotteveel wrote: > The problem is inherent to the monitoring tables. If you query one > monitoring table, Firebird needs to collect and prepare a snapshot of > the data for all other monitoring tables to be able to provide a stable > and consistent view of the monitoring

Re: [firebird-support] Negative impact on system performance querying monitoring tables.

2019-10-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-10-04 14:01, Marcelo Guimaraes mfguimar...@gmail.com [firebird-support] wrote: > Hello everyone! > > Reading about FB performance, I hit this page: > https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx05-montables.html > > My surprise on the

[firebird-support] Re: Negative impact on system performance querying monitoring tables.

2019-10-04 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
04.10.2019 15:01, Marcelo Guimaraes wrote: > > Reading about FB performance, I hit this page: > https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx05-montables.html > > My surprise on the note  was the warning: "In a highly loaded > environment,

[firebird-support] Negative impact on system performance querying monitoring tables.

2019-10-04 Thread Marcelo Guimaraes mfguimar...@gmail.com [firebird-support]
Hello everyone! Reading about FB performance, I hit this page: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx05-montables.html My surprise on the note was the warning: "In a highly loaded environment, collecting information via the monitoring