Subject | RE: [IBO] Error with aliases when refreshing rows after a delete from a query |
---|---|
Author | Jason Wharton |
Post date | 2006-11-30T01:37:41Z |
> I have a query with this sql :I have provided a fix for this so that it will work.
> 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 = ?
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