Subject | Error with aliases when refreshing rows after a delete from a query |
---|---|
Author | trondmorken |
Post date | 2006-11-29T13:35:52Z |
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
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