Jiri Cincura schreef:

> On 4/13/08, Jochem Maas <jochem@...> wrote:
>> the field doesn't allow a NULL, that's why you get the error.
>> one way to tackle this is use an insert trigger that sets
>> the new.id (from the relevant generator) when the given insert id
>> is not set ... and change your query to:
>
> I have a before insert trigger.

and firebird doesn't give a hoot about your trigger. the id field
is not NULLABLE, ergo you can't pass in NULL for the id value.

>
>> update or insert into polls (question, visible) values (?, ?) returning new.id
>
> But this isn't same as mine. This will do insert every time.

no it wont, you get an error on insert remember.

>