'Asynchronous Statement Cancel'?

Regards
Ray

----- Original Message -----
From: <IB-Architect@yahoogroups.com>
To: <IB-Architect@yahoogroups.com>
Sent: Wednesday, December 05, 2001 4:39 PM
Subject: [IB-Architect] Digest Number 436


To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com


------------------------------------------------------------------------

There are 5 messages in this issue.

Topics in this digest:

1. Re: Updatable views
From: "Ivan Prenosil" <prenosil@...>
2. Re: Updatable views
From: Jim Starkey <jas@...>
3. Help On Interbase Architecture and Interbase 6.0 Open Source Server
optimization
From: "Julien Van Der Pluym" <julien@...>
4. Re: Help On Interbase Architecture and Interbase 6.0 Open Source
Server optimization
From: Helen Borrie <helebor@...>
5. Borland has released Interbase v. 6.5.
From: "Kim Madsen" <kbm@...>


________________________________________________________________________
________________________________________________________________________

Message: 1
Date: Tue, 4 Dec 2001 12:58:46 +0100
From: "Ivan Prenosil" <prenosil@...>
Subject: Re: Updatable views

> That is correct. Any pre-insert trigger was presumed to override
> any automatic view insert semantics.

o.k., here is one more exaple:

CREATE TABLE tab (...);

CREATE VIEW v AS
SELECT * FROM tab;

CREATE TRIGGER trv FOR v BEFORE INSERT ...;

CREATE VIEW w AS
SELECT * FROM v;

CREATE TRIGGER trw FOR w BEFORE INSERT ...;

Should this command
INSERT INTO w (...) ...;
fire both triggers trv and trw, or only trw ?

Ivan



________________________________________________________________________
________________________________________________________________________

Message: 2
Date: Tue, 04 Dec 2001 10:05:05 -0500
From: Jim Starkey <jas@...>
Subject: Re: Updatable views

At 12:58 PM 12/4/01 +0100, Ivan Prenosil wrote:
>> That is correct. Any pre-insert trigger was presumed to override
>> any automatic view insert semantics.
>
>o.k., here is one more exaple:
>
>CREATE TABLE tab (...);
>
>CREATE VIEW v AS
> SELECT * FROM tab;
>
>CREATE TRIGGER trv FOR v BEFORE INSERT ...;
>
> CREATE VIEW w AS
> SELECT * FROM v;
>
> CREATE TRIGGER trw FOR w BEFORE INSERT ...;
>
>Should this command
> INSERT INTO w (...) ...;
>fire both triggers trv and trw, or only trw ?
>

That rather depends on what the trigger "trw" does. If it
does an insert into view "v", then yes, of course. If not,
then no, of course not.

Jim Starkey


________________________________________________________________________
________________________________________________________________________

Message: 3
Date: Wed, 5 Dec 2001 09:38:14 +0200
From: "Julien Van Der Pluym" <julien@...>
Subject: Help On Interbase Architecture and Interbase 6.0 Open Source Server
optimization





________________________________________________________________________
________________________________________________________________________

Message: 4
Date: Wed, 05 Dec 2001 18:42:19 +1100
From: Helen Borrie <helebor@...>
Subject: Re: Help On Interbase Architecture and Interbase 6.0 Open Source
Server optimization

At 09:38 AM 05-12-01 +0200, Julien Van Der Pluym wrote:

Help On Interbase Architecture and Interbase 6.0 Open Source Server
optimization

Please join the ib-support list:

<mailto:ib-support-subscribe@yahoogroups.com>

Thanks.
Helen
(moderator)



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________


________________________________________________________________________
________________________________________________________________________

Message: 5
Date: Wed, 5 Dec 2001 09:01:43 +0100
From: "Kim Madsen" <kbm@...>
Subject: Borland has released Interbase v. 6.5.

Hi,

Anybody noticed this?
Except for the much touted XML, whats the difference to Firebird?

best regards
Kim Madsen
kbm@...
www.components4developers.com




________________________________________________________________________
________________________________________________________________________



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/