Subject Re: [IBO] Some further IBO/FB1 incompatibility considerations
Author lester@lsces.co.uk
> I beg your pardon because I don't understand
> where is the problem with Firebird 1.0.
>
> Could you please send me a very simple example,
> even privately

IBObjects has always created the required SQL automatically,
from the information supplied. For the INSERT command this
has - incorrectly - been generated as

INSERT INTO TABLE ( TABLE.COLUMN1, TABLE.COLUMN2 ) VALUES (
1, 2 )

On all previous versions this has been accepted, and always
give the right answer, since the TABLE. is not actually
needed.

Now that other bugs relating to the incorect use of table.*
and some other table referenced names have been fixed in
Firebird, we find that the above statement is also rejected.
Since it has been used in IBO since the early days ( and I
think even Jason has forgoten why ) then any existing
application will fail when inserting records if the site
switches to FB1 Final in preparation for using the FB1 new
features.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services