From: "trondmorken" <trond@...>

> 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 = ?

Although there are "bugs" being worked out for FB 2, you should start be
creating correct SQL statements.

Select R.* from Rate R

If you assign an alias to a table, then you should use that alias in all
field selections. We won't get into the argument about not using "*" at all
in a query instead of listing each field name individually. That's a whole
other discussion. :)

Woody (TMW)