I have a table with a primary key set by a generator in a trigger.

If I append a record to a dataset opened with a select * I get an
exception "Field 'x' must have a value".

Presumably this is because the field value set by the trigger is
overwritten to NULL by Delphi when it updates the field on post.

What is the correct way to avoid this?
Should I select explicit fields (approx 200 so I don't like this idea)
Should I set the generator value with a second query to GEN_ID()?
Is there something I have missed?

thanks, Martin Clarke.