Subject Re: [firebird-php] Inserting NULLs as parameter
Author Jochem Maas
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 (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
> But this isn't same as mine. This will do insert every time.

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