If by QBICSYSTEMS you mean QBIC III Systems Inc. then the database will be
Firebird.
Regards
Paul
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
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 what
On Aug 19, 2015, at 5:49 PM, tvd...@ymail.com [firebird-support]
firebird-support@yahoogroups.com 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.
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
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]
firebird-support@yahoogroups.com
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] Regarding ODBC
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
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...
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 writing
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
11 matches
Mail list logo