Thanks much, Svein. I do need to ask about a couple more features
also -
Are cross database joins and multidirectional cursors supported ?

Appreciate any help.

- R.




--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> Hello R, and welcome!
>
> --- In firebird-support@yahoogroups.com, "R" wrote:
> > Hi,
> >
> > I'm thinking of migrating to Firebird, and I was wondering if the
> > following features were supported in it -
> >
> > Natural Join
> I assume this is the same as a FULL OUTER JOIN. Firebird supports

both

> inner and outer joins.
>
> > UNIQUE predicate
> Unique constraints are possible, so is SELECT DISTINCT (I'm not
> completely certain which of these you mean)
>
> > Cascade delete
> > Cascade Update
> As part of foreign keys, yes.
>
> > Bulk insert
> > Bulk update
> > Bulk fetch
> Hmm, here I don't know. Of course it is possible to do
> INSERT INTO <table>
> SELECT FROM <othertable>
> and similar for update. It is also possible to use external files

when

> defining tables and use these as a way to import files. Hopefully
> someone else will jump in and give you a better answer when it

comes

> to these 'bulky things', I don't quite get what you are asking.
>
> Set