Subject RE: [IBO] Error with aliases when refreshing rows after a delete from a query
Author Jason Wharton
> I have a query with this sql :
> SELECT * FROM Rate R
>
> which works fine, but after deleting a row with this query ibo
> tries to refresh the row and generates a sql statemen of
>
> SELECT * FROM Rate R WHERE RATE.Id = ?
>
> which fails with firebird 2, Rate.id is unknown
>
> Correct generation of statement should bee
>
> SELECT * FROM Rate R WHERE R.Id = ?

I have provided a fix for this so that it will work.

It works on both Firebird 1.5 and 2.0.

When auto generating the KeyLinks I need to use the alias instead of the
table name.

Thanks,
Jason Wharton