Subject Re: [IB-Architect] Re: Creating invalid procedures and views... Just an idea
Author Dmitry Kuzmenko
Hello, Ann!

"Ann W. Harrison" wrote:

> Sounds like a good idea to me - I'd probably use the same inactive
> mechanism that triggers use. However, this is an ODS change
> and will make Firebird databases incompatible with InterBase since
> InterBase will not understand the new state. Hardly the end of
> the world.

FireBird 1.0 will be incompatible with Borland's IB anyway -
if FB will support SELECT TOP, any application that uses such syntax will
not work with IB. Also FB's backup with SELECT TOP in procedure or trigger
will not be restorable with Borland's IB.
(Right now FB's backup can corrupt database being restored with IB, if
there are lot of generators in backup - isn't it?)

A lot of people already decided to stay with FB or IB. I know some people
who still playing with both, but at last they will choose one.
Motivations to choose FB are:
1. builds are free (not certified, but they exist)
2. there are more OS supported (Darwin, FreeBSD, Solaris(Intel))
3. people can monitor bugfixes
4. developers more closer to community, because they are part of community itself.

sorry for subject follow-off.

Dmitry Kuzmenko, Epsylon Technologies.