[firebird-support] How can I prevent that my database can be opened with another security.fdb.

Hi all How can I prevent that my database can be opened with another security.fdb. For testing we use firebird 3. We use our database as its own security database. If we copy our database to another Firebird installation it is possible to open it with sysdba and masterkey. Is there a way to

[firebird-support] user on embedded

Hello, i have a question of usersettings in version 3.0 of firebird. i would create a user at database, because i use firebird as server and embedded. i want to protect my database. on version 2.5 i can´t create a user on embedded database. every user can read the embedded database on a

RE: Re: [firebird-support] Firebird V3RC2 Primary Key question

Would you be so kind to provide an example SQL which shows how to do primary key with a case insensitive collation? Thanks. Ertan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, April 7, 2016 8:54 PM To:

Re: [firebird-support] Re: First-In-First-Out (FIFO) stock valuation

Den 07.04.2016 08:42, skrev venussof...@gmail.com [firebird-support]: Hi all Sorry for resurrecting this very old thread but I have come across a situation (hopefully Jose would be able to answer). I have found a bug in the bQty column it was not able to reduce itself to the current stock,

Re: [firebird-support] VIEW optimization

On Thu, Apr 7, 2016 at 3:41 PM, Ann Harrison wrote: > On Thu, Apr 7, 2016 at 2:27 PM, Gabor Boros gaborbo...@yahoo.com > [firebird-support] wrote: > >> 2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl >>

Re: [firebird-support] VIEW optimization

On Thu, Apr 7, 2016 at 2:27 PM, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > 2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl > [firebird-support] írta: > > > > > > For a join (inner join), the rows must exist in both

Re: [firebird-support] FB on LAN

Hello Mark. I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB Than I changed from FB 32 to FB 64 and it stopped working. After that, after that even turnning to FB 32 it doesn´t work using this structure. I only works using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or

Re: [firebird-support] test

Checked :) Em 07/04/2016 13:33, Z T Minhas ztmin...@yahoo.com [firebird-support] escreveu: Just checking -- Atenciosamente, Hugo Eyng

Re: [firebird-support] help to repair a corrupted database

Hi. Are you able to backup and restore the database instead of "gfixing"? Em 07/04/2016 12:28, korkl...@yahoo.it [firebird-support] escreveu: hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database file is of about 30 gb. i have disconnected all the user, i did a copy of

Re: [firebird-support] VIEW optimization

2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] írta: > > > For a join (inner join), the rows must exist in both tables, so both > tables need to be evaluated. > > Mark I understand this. Try describe my problem with other words. Is the VIEW an atomic

Re: [firebird-support] Firebird V3RC2 Primary Key question

This is the default and expected behavior. If you want case insensitive, then you need to create the primary key column with a case insensitive collation. Mark - Bericht beantwoorden - Van: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"

[firebird-support] Firebird V3RC2 Primary Key question

Hi, It's been a while since I last used Firebird. I am testing new release candidate at the moment. Just found something I am not so sure. I have a database created using "CharSet WIN1254" parameter. Below is the SQL I used to create a table in that database: CREATE TABLE KULLANICI (

Re: [firebird-support] VIEW optimization

Also consider the situation with multiple rows on the other side of the join: in that case the one side repeats as many times as there are rows - Bericht beantwoorden - Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]" Aan:

Re: [firebird-support] VIEW optimization

For a join (inner join), the rows must exist in both tables, so both tables need to be evaluated. Mark - Bericht beantwoorden - Van: "Gabor Boros gaborbo...@yahoo.com [firebird-support]" Aan: Onderwerp:

Re: [firebird-support] VIEW optimization

2016. 04. 07. 18:48 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] írta: > Why wouldn't it be necessary, this is an inner join, so the joined table > needs to be evaluated if the matches row is present. > > SELECT RDB$FIELD_NAME FROM VIEW1 SELECT RDB$FIELD_NAME FROM

Re: [firebird-support] VIEW optimization

Why wouldn't it be necessary, this is an inner join, so the joined table needs to be evaluated if the matches row is present. Mark - Bericht beantwoorden - Van: "Gabor Boros gaborbo...@yahoo.com [firebird-support]" Aan:

Re: [firebird-support] help to repair a corrupted database

Hi, Gfix visits each page of the database, so 90 minutes is not so long if your disk subsystem is not based SSD. In general, follow these steps http://ib-aid.com/en/articles/how-to-repair-a-corrupt-firebird-database/ Check firebird.log too - gfix reports there its findings. Regards, Alexey

Re: [firebird-support] VIEW optimization

07.04.2016 18:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > Plan contains the JOIN but that not needed for the selected field. But it is needed to find out how many records with this value you'll get. -- WBR, SD.

[firebird-support] VIEW optimization

Hi All, VIEW: CREATE VIEW VIEW1 AS SELECT RDB$RELATION_FIELDS.RDB$RELATION_NAME, RDB$FIELD_NAME FROM RDB$RELATION_FIELDS JOIN RDB$RELATIONS ON RDB$RELATION_FIELDS.RDB$RELATION_NAME=RDB$RELATIONS.RDB$RELATION_NAME; SELECT: SELECT RDB$FIELD_NAME FROM VIEW1 PLAN: PLAN JOIN (VIEW1

[firebird-support] test

Just checking 

Re: [firebird-support] help to repair a corrupted database

On Thu, Apr 7, 2016 at 11:28 AM, korkl...@yahoo.it [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database > file is of about 30 gb. > > i have disconnected all the user, i did a copy of the file and then i >

[firebird-support] help to repair a corrupted database

hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database file is of about 30 gb. i have disconnected all the user, i did a copy of the file and then i executed the command gfix -validate 'dbname' with the credentials of the user that created the db (not the sysdba) now the

Re: [firebird-support] FB on LAN

On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Thanks for answer my question. > > I changed the connection (Deplhi XE10 / DBX) to > \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. With this change you are using a different protocol than you

[firebird-support] Re: FB on LAN

If you access a database from a mapped drive on a share, please read: Can I access a database from a mapped drive on a share? http://www.firebirdfaq.org/faq46/ Greetings. Can I access a database from a mapped drive on a share? http://www.firebirdfaq.org/faq46/ Collection of answers to

Re: [firebird-support] FB on LAN

Hello. Thanks for answer my question. I changed the connection (Deplhi XE10 / DBX) to \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. Em 06/04/2016 18:21, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] escreveu: Have you checked the difference between the two

RE: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

Arno, Thanks for your pointing out the issue with my SQL statement. Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, April 06, 2016 4:36 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] SQL Error Code -104:

RE: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

Tomasz, Thanks for your guidance and explanation for a much simpler solution. Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, April 07, 2016 2:58 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] SQL Error Code

Re: [firebird-support] Timestamp conversion issue

On 2016-04-07 5:26, Alex Castillo acr_k...@yahoo.com [firebird-support] wrote: > I've no doubt this is a bug for the linux release. It should be > filtering the string literals before doing the conversion as it does > on Windows. I don't think it is a bug. Firebird supports the SQL standard

Re: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

On 06.04.2016 o 22:03, 'stwizard' stwiz...@att.net [firebird-support] wrote: > SELECT DISTINCT P.AREA_CODE, P.PHONE_NO, > >(SELECT COUNT(*) > > FROM PHONE P2 > > WHERE P2.PHONE_ID = P.PHONE_ID) AS CNT > >FROM PHONE P > > WHERE P.AREA_CODE IS NOT NULL > > GROUP BY

Re: [firebird-support] Re: First-In-First-Out (FIFO) stock valuation

I have confirmed that the part , COALESCE((SELECT SUM(PurchaseBillItemInner.bQty) If I remove the SUM() I get an error that there are multiple records returned in a singleton select. There is an iID field on each row of each table (I have tried to use it to no avail) that can distinguish both

Re: [firebird-support] Re: First-In-First-Out (FIFO) stock valuation

Hi all Sorry for resurrecting this very old thread but I have come across a situation (hopefully Jose would be able to answer). I have found a bug in the bQty column it was not able to reduce itself to the current stock, eg. 3, and still it returns two row with a qty of 3+2 = 5 qty is valued