Subject RE: [IBDI] Firebird 1
Author Claudio Valderrama C.
Joining several pages?
Or did you think about joining several tables?

The server is able to keep a consistent view of the data if you manipulate
the transaction isolation level and don't close the transaction. For that
transaction, the so called db_key will be stable. Even the impaired MS-ASP
can cope with transactions.

It seems that most of this thread is about making a C/S server acting as a
file server or a desktop db. In this case, it seems very reasonable to use a
RDBMS able to fully emulate a desktop db (Oracle???) or to use Paradox and
the like. Paradox won't scale with a lot of requirements, but that's another
tale. Personally, I don't have any desire to spoil the engine just to
satisfy a particular approach, until a decent technical solution exists and
is found. There are enough companies offering middleware.

C.

> -----Original Message-----
> From: Paulo Gaspar [mailto:Paulo.Gaspar@...]
> Sent: Martes 5 de Junio de 2001 10:57
> To: IBDI@yahoogroups.com
> Subject: RE: [IBDI] Firebird 1
>
>
> In general, how does that help if the data being fetched is the
> result of a
> "select" joining several pages?
>
> Thanks,
> Paulo Gaspar
>
> > -----Original Message-----
> > From: Claudio Valderrama C. [mailto:cvalde@...]
> > Sent: Saturday, June 02, 2001 8:11 AM
> > To: IBDI@yahoogroups.com
> > Subject: RE: [IBDI] Firebird 1
> >
> > ...
> >
> > A typical relational table has a PK. A PK is unique by nature. If your
> > tables don't implement any concept of basic relational theory,
> locating an
> > exact record is only one of the many problems your db design will have.
> >
> > C.
> >
>
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>