Subject | IBO4.7b14 UpdateSQL Bug |
---|---|
Author | James N Hitz |
Post date | 2007-01-29T08:27:48Z |
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.
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.