Re: ** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Rita Liotta wrote: > Hi, Helen: > > Can you name some of these tools? I'm just floundering try to find one. > Only you can know what you need, according to your expertise with databases and SQL and your comprehension of the drivers needed to use a particular toolset. As a rule, the free

Re: ** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread DougC d...@moosemail.net [firebird-support]
There was a link to a list of tools in Helen's message: https://firebirdsql.org/en/third-party-tools/ On Wed, 05 Jun 2019 13:40:11 -0400 Rita Liotta ritalio...@roadrunner.com [firebird-support] wrote Can you name some of these tools? I'm just floundering try to find

[firebird-support] Re: Web application with Firebird 3 and SaaS

2019-06-05 Thread my...@techsol.org [firebird-support]
We have over 50 web applications using PHP & Firebird on Apache 2 web servers. Some are deployed to be public facing Internet apps and others are private. I've been developing these applications on Firebird SQL since about 2006. They are reliable, fast and scale very well. That said,

Re: [firebird-support] Default value in DDL not work

2019-06-05 Thread m_brahi...@yahoo.fr [firebird-support]
Yes this happen when I omit the field the default value is not applied. I do this insert part into a stored procedure with other SQL statement for other tables. INTITULE_SALAIRE='N-'||F_GET_MONTH_NAME(:MOIS)||' '||:ANNEE; INSERT INTO SALAIRES (EMPLOYEUR_ID, EMPLOYE_ID, UNITE_ID, MOIS,

Re: ** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread Rita Liotta ritalio...@roadrunner.com [firebird-support]
Hi, Helen: Can you name some of these tools? I'm just floundering try to find one. TIA Rita On 06/05/19 3:30 AM, Helen Borrie hele...@tpg.com.au [firebird-support] wrote: Rita Liotta wrote: > I don't know what happened, but this isn't my question. What happened is that you replied to a

Re: ** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread Rita Liotta ritalio...@roadrunner.com [firebird-support]
Helen: Thank you so much for your reply. Will look into 3rd party tools. I appreciate your patience. Best regards, Rita On 06/05/19 3:30 AM, Helen Borrie hele...@tpg.com.au [firebird-support] wrote: Rita Liotta wrote: > I don't know what happened, but this isn't my question. What

Re: [firebird-support] Default value in DDL not work

2019-06-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 5-6-2019 10:22, m_brahi...@yahoo.fr [firebird-support] wrote: > I build tables under IBEXPERT and define some fields with default value > > FIELD_NAME INTEGER DEFAULT 0 > > I except 0 as value but has always NULL > > Any idea ? If you do `insert into yourtable (other_field, field_name)

RE: {Disarmed} [firebird-support] Web application with Firebird 3 and SaaS

2019-06-05 Thread 'Louis van Alphen' lo...@nucleo.co.za [firebird-support]
This is the classic multi-tenant question. It depends on which of the isolation models you are using and where you will host. Each model has advantages and disadvantages. DB per tenant Pros: Your code does not have to take tenant into account. As long as you can route your queries to the

Re: {Disarmed} [firebird-support] Web application with Firebird 3 and SaaS

2019-06-05 Thread Elmar Haneke el...@haneke.de [firebird-support]
> I am planning the infrastructure and security and I have several > doubts. My initial idea would be to have a database where users can > save their emails and create a separate database for each client. For an Web-Application this is not really common practice as you prevent e.g. usage of

Re: [firebird-support] Default value in DDL not work

2019-06-05 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
HiDefault value is used when you ommit field in the insert statement. What is your usage case?Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "m_brahi...@yahoo.fr [firebird-support]" Data: 05.06.2019 10:22 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat:

[firebird-support] Re: Default value in DDL not work

2019-06-05 Thread m_brahi...@yahoo.fr [firebird-support]
My FB version is Firebird-3.0.3.32900_0_Win32 under XP PRO SP3

[firebird-support] Default value in DDL not work

2019-06-05 Thread m_brahi...@yahoo.fr [firebird-support]
Hi all, I build tables under IBEXPERT and define some fields with default value FIELD_NAME INTEGER DEFAULT 0 I except 0 as value but has always NULL Any idea ? Thanks

** NOT ** Re: [firebird-support] Firebird upgrade advise

2019-06-05 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Rita Liotta wrote: > I don't know what happened, but this isn't my question. What happened is that you replied to a thread that was on a different subject - it is called "hijacking". You should have started a new topic. > What I asked was > if there was any way I can access and sort the

Re: ODP: [firebird-support] Page cache size in Firebird 3.0.4

2019-06-05 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
I resend my email - it do not reaach the yahoo group :-(   Hi   Yes you have missed config in your db itself   Database properties ODS Version 12 Page size 16384 Pages 437728 Size on disk 6.68GB >>>Page buffers 10240 Read only false   You have page buffers set inside your DB.