Hi Gediminas,

> SQL:
>
> select "Name" , "Description"
> from "Dances"
>
> KeyLinks are set to "Dances_ID", which is PK and generated by
> generator

KeyLinks fields must be part of the selected fields, so this setup
would give you an IBO error upon prepare!
("Invalid Keylinks" or something like that.)

Are you sure you showed the complete SQL?

Also, I thought your generated PK was called "ID".

Also also, did you set GeneratorLinks for the PK _and_ change the
before insert trigger (see my reply earlier in this thread) ?
Otherwise your generated PK will be overwritten if you post the
inserted record, and if you later edit the record the PK will be
invalid. This will probably result in a "Record not found to update"
error.


Greetings,
Paul Vinkenoog