The mailinglist doesn't support attachments, please post the error message as
text.
Mark
- Reply message -
Van: "'Raman, Anitha' anitha.ra...@am.jll.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Regarding ODBC
Datum: do, aug. 20, 2015 23:19
Hello group - I have installed
Hi Set!
Thank you very much - you've answered most of my question - but created
another:
> I've assumed route_index is part of the routes table, and that a.id,
> b.id and c.quality are unique in each table.
Your assumptions are correct. My apologies for not being clearer.
>
> select r.id,
>
Hello group - I have installed Firebird and trying to import structures using
an ETL Application called Informatica PowerCenter. ODBC connection seems to be
valid as I am able to connect using EXCEL and select from the tables. But when
I try using my application to import structures I get the fo
20.08.2015 16:53, 'Louis van Alphen' wrote:
> The same thing happens in many other queries where I use views and IMHO
> I find it non-sensical. I have come to the conclusion that FB does not
> choose great query plans when using views.
True, when views contain outer joins.
> It is really hard to
Hi Daniel!
>select r.id, a.node node, route_index, b.node link_node, c.quality_label
>from routes r
> join nodes a on r.node_id = a.id
> join nodes b on r.link_id = b.id
> join route_qualities c on r.quality = c.QUALITY
> order by node, route_index;
>
>Is there an alternate way of
I'm trying to figure out what I did wrong. It seemed to work fine...but
now I'm seeing discrepancies.
Edit: I figured it out - I didn't have all the values in my table
"route_qualities". After tearing apart my query and doing numerous
tests - I finally actually looked at the data and saw wha
Thanks Ann,
Doing multiple simultaneous backups is never intentional. There will be a
process that does hourly backups in the background, and someone (unaware of
that) might decide to do a manual backup to another location at the same time.
I was considering disabling garbage collection in the
Hello everybody
For add a Primary Key to a table we can write:
ALTER TABLE MyTable ADD PRIMARY KEY (ID);
or we can write:
ALTER TABLE MyTable ADD CONSTRAINT MyPK PRIMARY KEY (ID);
In the first case, the Firebird puts the name of the Primary Key, in the
second case we choose that name, but...
Ok so I have a ‘master table called SKIN_ loosely defined as follows:
Table SKIN_
ID bigint not null (primary key)
COLOUR_ID bigint (optional lookup field to COLOUR_ table)
For the purposes of convenience, I have created a view SKIN on SKIN_ to in
> On Aug 19, 2015, at 5:49 PM, tvd...@ymail.com [firebird-support]
> wrote:
>
> I believe it is generally safe to have multiple simultaneously running
> instances of Gbak backing up the same server, when all of them read data from
> within their own transaction.
Right. Gbak is just another a
If by QBICSYSTEMS you mean QBIC III Systems Inc. then the database will be
Firebird.
Regards
Paul
in this case I can't replace FOR EXECUTE STATEMENT 'SELECT.. ' with FOR
SELECT.. because is much slower
thanks
From: "Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]"
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 19, 2015 4:18 PM
Subject: [firebir
not FIELD3 COULD BE NULL, VARIABLE :F3 AND THAT MEANS NO FILTER ON FIELD3
thanks
From: "liviusliv...@poczta.onet.pl [firebird-support]"
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 19, 2015 8:00 PM
Subject: Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX
13 matches
Mail list logo