On 11/29/06, trondmorken <trond@...> wrote:

> Hello, I'm using beta 8a of ibo4.7
>
> 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 = ?
>
>
> Regards
> Trond Morken

Hi,
have you tried using

SELECT R.* FROM Rate R

as your select statement?

Regards,
Markus