In the trigger:
if (new.myfield is null) then
Best Regards
=========
|| ISMAEL ||
=========
----- Original Message -----
From: Tetram Corp
To: firebird-support@yahoogroups.com
Sent: Thursday, November 03, 2011 1:04 PM
Subject: [firebird-support] Detecting default values
Hi,
I have a table with a field for which i need a default value. My problem
is the default value can change at any time. So the solution I found is
to use a "before insert" trigger.
But now, i'm facing a new challenge: how to detect if the null status I
received in new.myfield is because the field was not in the insert
statement or because the insert statement set it to null ?
well, from
insert into mytable (field1) values (:field1)
or from
insert into mytable (field1, myfield) values (:field1, null)
[Non-text portions of this message have been removed]
