Subject IBO4.7b14 UpdateSQL Bug
Author James N Hitz
Using Delphi 7, Firebird 2.0, IBObjects 4.7.Beta 14

When using table aliases, the SQL code generated under EditSQL and
InsertSQL of the UpdateSQL tab of IB[O_]* component(s) is generated with
an error. For example using this SQL code and KeyLinks:

SELECT country, currency from country;
KeyLinks = country

...and clicking "Generate for Table" works perfectly. However if you
erase the generated code and change the SQL to use table aliases:

SELECT c.country, c.currency from country c;
KeyLinks = Country

...IBO yields:

UPD TE SET
WHERE
RDB$DB_KEY = :DB_KEY

...and:

INSER) INTO (
VALUES )

... (spaces and all) under EditSQL and InsertSQL respectively.

Definitely an error. Also, notice IBO's use of DB_KEY even though
KeyLinks has been specified. This shouldn't be the case I suppose?

I realize UpdateSQL is provided mostly for the sake of backward
compatibility but I reckon it needs to work none the less.