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

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

[firebird-support] Identity vs Before Insert Trigger

The fault or misunderstanding is probably mine, but: I thought the "identity" definition was functionally the same as the before-insert with generator. Particularly with regards to handling null values during inserts. However, given: create table TEST1 ( TEST_ID integer generated by

Re: [firebird-support] Will we move when yahoo Groups close theirs doors?

I'm curious...why not use Sourceforge mailing lists? Daniel On 10/21/2019 8:43 AM, Lester Caine les...@lsces.uk [firebird-support] wrote: > On 21/10/2019 16:05, Kevin Stanton kevin.stan...@rdb-solutions.com > [firebird-support] wrote: >> Oregon Delphi Users Groups has the same issue. Looks

Re: [firebird-support] Re: Off-Topic: Firebird future

On 10/14/2019 11:42 PM, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > > > On 11/10/19 10:52 am, Daniel Miller dmil...@amfes.com [firebird-support] > wrote: >> >> >> There are a few (Windows-only) applications that are quite powerful - &g

Re: [firebird-support] Re: Off-Topic: Firebird future

On 10/9/2019 9:08 AM, pablo sanchez pab...@adinet.com.uy [firebird-support] wrote: > I use Firebird since 0.x version (open interbase?) . > > It's the most versatile db I've found so far : embedded and full server, > linux(99%) and windows, odbc or jaybird. > > Installs in 5 minutes with db

Re: [firebird-support] Scaling Firebird - Azure

On 10/6/2019 9:49 AM, Rune Horneland rune.hornel...@kravia.net [firebird-support] wrote: > > > Hi, > We are running Firebird 2 in an Azure VM. It can only take so much in > terms of concurrent connections. > What top-level advice would you give to scale this? > > We are connecting to it from

Re: [firebird-support] Why I cannot remove FK constraint

On 1/25/2019 7:11 PM, Daniel Miller dmil...@amfes.com [firebird-support] wrote: On 1/24/2019 7:56 AM, respekt...@post.cz [firebird-support] wrote: Hello I have problem with part of our databases. All our databases should have the same structure, but in some of them I cannot drop constraint

Re: [firebird-support] Why I cannot remove FK constraint

On 1/24/2019 7:56 AM, respekt...@post.cz [firebird-support] wrote: Hello I have problem with part of our databases. All our databases should have the same structure, but in some of them I cannot drop constraint ALTER TABLE VYKONY_AUT DROP CONSTRAINT FK_VYKONY_AUT_VYKON chyba:

[firebird-support] Altering views

This is a bit of a philosophical question - as such there are probably many opinions. But I'll ask anyway. With relational databases there can be associations between tables that are often repeated to where it is desirable to store and re-use them. During app development, the use and therefore

Re: [firebird-support] Is Firebird favor Intel's CPU?

I am not aware of any such bias with Firebird but it certainly can exist with other software. Intel provides what I am told is an excellent compiler - which they provide for free - and many software companies utilize it. That compiler has long been known to generate executables that are

Re: [firebird-support] Show Columns

That...is an unbelievably helpful page and that query should be made part of the official docs! Daniel On 3/23/2018 9:18 AM, edmende...@gmail.com [firebird-support] wrote: Daniel, Not sure if this answers your question but I’ve had situations where I needed a way to get column details and

[firebird-support] Show Columns

Using some system table queries, is there a view or stored procedure that can, in "full", replicate the output of "show columns from table" available from other servers? Ideally this would be a "drop in" alternative to the "show columns" sql statement that returns the same data in the same

Re[2]: [firebird-support] How I can speed up this query

On 10/12/2017 12:24:11 AM, "Luigi Siciliano luigi...@tiscalinet.it [firebird-support]" wrote: >Hallo, > >Il 11/10/2017 20.38, setysvar setys...@gmail.com [firebird-support] ha >scritto: >>I think this should give the same result as your query, whether or not

Re[2]: [firebird-support] select column if it exists

I don't think you could express it in the SELECT directly (someone else will probably build a statement refuting that) but you could do: SELECT r.RDB$FIELD_NAME FROM RDB$RELATION_FIELDS r where r.RDB$RELATION_NAME= and then process that result set to build your appropriate SELECT for the

Re[2]: {Disarmed} [firebird-support] Using FB2.5 with NFS for Virtualbox VM

The performance of vboxsf is horrible - that's why there are so many recommendations to use NFS or CIFS for guests. So again I'm asking if there's any issue with accessing the .fdb via NFS - given the exclusive access I've described. I don't see why there would be...other than ensuring that

[firebird-support] Using FB2.5 with NFS for Virtualbox VM

I have a single Linux host server with several Virtualbox guest VM's. I've been attempting to move everything possible from the host to one of the guests. One of the last holdovers is Firebird. The reason is I use NFS to mount host folders within the guest for critical data - and the .fdb

Re[4]: [firebird-support] Find duplicate multi-row entries

into :ROUTE_UPDATED do begin NODE = CHECK_NODE; suspend; end END^ -- Daniel On 10/1/2017 3:31:57 PM, "'Daniel Miller' dmil...@amfes.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: Maybe a little progress. This procedure doe

Re[3]: [firebird-support] Find duplicate multi-row entries

utes r on nr.NODE = r.NODE Does this get you the result you want? Set 2017-09-28 9:19 GMT+02:00 'Daniel Miller' dmil...@amfes.com [firebird-support] <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com>>: Thanks - but that still doesn't work. I get a huge ret

[firebird-support] Suggested table structure for otherwise multi-row sets

Well...one of the joys of development is recognizing a design that was perfect...is less so in a given context. And what I thought was an elegant & correct solution appears to not lend itself to answering the questions I'm now asking. So...I'm asking for suggestions on my next revision. My

Re[2]: [firebird-support] Find duplicate multi-row entries

t.NODE = rh.NODE and t.ROUTE_UPDATED = rh.ROUTE_UPDATED and r.NODE is null)) select r.NODE, r.ROUTE_INDEX, r.LINK_NODE, r.QUALITY from new_routes nr join routes r on nr.NODE = r.NODE HTH, Set Den 28.09.2017 11:00, skrev 'Daniel Miller' dmil...@amfes.com [firebird-support]: This appears n

Re[2]: [firebird-support] LIST gives inconsistent results

t; <firebird-support@yahoogroups.com> wrote: >On 2017-09-28 10:49, 'Daniel Miller' dmil...@amfes.com >[firebird-support] wrote: >>It's certainly possible my database is corrupted - I don't think it >>is. But I'm willing to test if someone tells me how. However... >> >

Re[6]: [firebird-support] Find duplicate multi-row entries

e left joins can be replaced by (nested) NOT EXISTS. HTH, Set 2017-09-28 7:22 GMT+02:00 'Daniel Miller' dmil...@amfes.com [firebird-support] <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com>>: On 9/27/2017 9:20:54 PM, "liviuslivius livius

[firebird-support] LIST gives inconsistent results

It's certainly possible my database is corrupted - I don't think it is. But I'm willing to test if someone tells me how. However... At the moment, after several painful hours, I think I've determined the following: CREATE TABLE NODES ( NODE smallint NOT NULL, ROUTE_UPDATED timestamp,

Re: [firebird-support] Multiple LIST columns

by h.ROUTE_UPDATED desc This ensures the "lists" are matching - but brings up another problem which I'll start another thread on. -- Daniel On 9/27/2017 10:26:31 PM, "'Daniel Miller' dmil...@amfes.com [firebird-support]" <firebird-support@yahoogroups.com> wr

Re[4]: [firebird-support] Find duplicate multi-row entries

ull Note that I use IS NOT DISTINCT so that NULLs are considered equal. If you prefer, the left joins can be replaced by (nested) NOT EXISTS. HTH, Set 2017-09-28 7:22 GMT+02:00 'Daniel Miller' dmil...@amfes.com [firebird-support] <firebird-support@yahoogroups.com>: On 9/27/2017 9:20:54

[firebird-support] Multiple LIST columns

With a statement such as: select n.NODE, h.ROUTE_UPDATED, list( h.ROUTE_INDEX ) LI, list( h.LINK_NODE ) LN, list( h.QUALITY ) LQ from NODES n join ROUTE_HISTORY h on n.NODE=h.NODE where n.NODE=5104 group by n.NODE, h.ROUTE_UPDATED order by h.ROUTE_UPDATED desc Are the LISTS guaranteed to

Re[2]: [firebird-support] Find duplicate multi-row entries

On 9/27/2017 9:20:54 PM, "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" wrote: group by + having is your friend. E.g. Select field1, field2, count(*) From tablex Group by field1, field2 Having count(*)>1 But in your scenario i do not know if

[firebird-support] Find duplicate multi-row entries

I have a table like: CREATE TABLE ROUTES ( NODE smallint NOT NULL, ROUTE_INDEX smallint NOT NULL, LINK_NODE smallint NOT NULL, QUALITY smallint, CONSTRAINT PK_ROUTES PRIMARY KEY (NODE,ROUTE_INDEX) ); In use, this table can have from 0-8 rows per NODE. Similar to: 555711116

[firebird-support] Firebird Alpha 4 Release Notes

The misunderstanding is probably mine - but I've never heard of 34-bit values/precision before.  Is that a typo for either 32 or 64?  Or "34" is correct? -- Daniel

[firebird-support] Transactions for read-only selects

When closing a read-only transaction for a read operation - does it matter if COMMIT vs ROLLBACK is used? -- Daniel

[firebird-support] php transactions

I have an application I'm developing with PHP & Firebird. While it mostly works fine - I've been having what I believe to be transaction issues. One problem was visibility - committed changes were not visible to selects. I know they were committed - after executing the commit within the

[firebird-support] When do calculated columns calculate?

Seems a silly question, but: Given two columns: A SmallInt B SmallInt And it so happens that the data that will be stored will always be a four digit integer for "A" and a single digit integer for "B", so I can make calculated column "C": (cast(A as char(5)) || cast(B as char(1))) as a

Re: was [firebird-support] Delete visibility - now bonehead insert/delete with generators

Still haven't answered my visibility question - but figured out the brilliant bug I implemented which caused me to question things. I have a primary key defined as a Smallint and an associated generator. You've probably already know what's coming... This table has a high amount of

[firebird-support] Delete visibility

Just had a problem come up in a database that was previously working - at least I thought it was. I'm using PHP as the client. Table Nodes has ID. Table Routes has foreign key NODE_ID. Table Elevations has foreign key ROUTE_ID. The foreign keys have cascade update & delete. As

[firebird-support] Users for application

I don't know if this specific question has been asked - but searches haven't given me a close enough answer so hopefully this is a little new. Separate from security theories and considerations of "good practice", what, if any, benefits accrue from using multiple users when accessing a

Re[2]: [firebird-support] select parent based on multiple child conditions

With correction for one or two typos - those both worked, thank you! Had to read, and read, and read - to try to understand HOW these work. Which was exactly what I was hoping for - to better understand usage of Firebird SQL. Looking at the query plans, it appears Alternative 2 - which uses

Re: [firebird-support] select with constant value in where-clause

As an amateur - I'd suggest using an indexed field in the where clause, and choosing an invalid value that is less than the 1st real entry. -- Daniel -- Original Message -- From: "josef.gschwendt...@quattro-soft.de [firebird-support]" To:

[firebird-support] select parent based on multiple child conditions

I'm not sure how to construct this. There's probably an elegant solution available - I'm trying to feel my way there but... Two tables. CREATE TABLE NODES ( ID Smallint NOT NULL, NODE Smallint NOT NULL, PRIMARY KEY (ID), UNIQUE (NODE) ); CREATE TABLE ROUTES ( ID Integer NOT NULL,

Re: [firebird-support] select parent based on multiple child conditions

Took me a bit to feel my way through, but my first attempt appears to be working: select distinct n.NODE, count(r.NODE_ID) from NODES n join ROUTES r on n.ID=r.NODE_ID where (r.ROUTE_INDEX=1 and (r.QUALITY<7)) or (r.ROUTE_INDEX=2 and (r.QUALITY<7)) group by n.NODE union SELECT n.NODE,