> I have a simple query
>
> SELECT B.BANKA_ID
> FROM BANKA B
>
> KeyRelation = B
> KeyLinks = BANKA_ID
>
> Button Generate forTable in UpdateSQL tab in TIB_Query Editor
> generates following SQL.
>
> EDIT:
>
> UPD TE SET
> WHERE
> RDB$DB_KEY = :DB_KEY
>
> INSERT:
>
> INSER) INTO (
> VALUES )
>
> DELETE:
>
> DELETE FROM
> WHERE
> RDB$DB_KEY = :DB_KEY
>
>
> What am i doing wrong (it is the same for interbase7.0 or firebird2.0)
>
> Rade

how bizarre!
just for an experiment, change the query to
SELECT BANK_ID FROM BANKA
delete the KeyRelation entry
KeyLinks should be
BANKA.BANK_ID
and uncheck KeyLinksAutoDefine
BUT also ensure that BANK_ID is defined in your database as a PK
Alan