r5862 - trunk/gnue-common/src/schema/scripter/processors

[btami]

Author: btami
Date: 2004-06-07 09:08:55 -0500 (Mon, 07 Jun 2004)
New Revision: 5862

Modified:
   trunk/gnue-common/src/schema/scripter/processors/interbase.py
Log:
addad IS NULL check to before insert trigger

Modified: trunk/gnue-common/src/schema/scripter/processors/interbase.py
===================================================================
--- trunk/gnue-common/src/schema/scripter/processors/interbase.py       
2004-06-04 20:07:19 UTC (rev 5861)
+++ trunk/gnue-common/src/schema/scripter/processors/interbase.py       
2004-06-07 14:08:55 UTC (rev 5862)
@@ -76,7 +76,8 @@
     epi.append ("CREATE TRIGGER trg_%s FOR %s" % (gsField.name, tableDef.name))
     epi.append ("  ACTIVE BEFORE INSERT POSITION 0 AS")
     epi.append ("  BEGIN")
-    epi.append ("    NEW.%s = GEN_ID (%s,1);" % (gsField.name, gen))
+    epi.append ("    IF NEW.%s IS NULL THEN" % (gsField.name, gen))
+    epi.append ("      NEW.%s = GEN_ID (%s,1);" % (gsField.name, gen))
     epi.append ("  END ^")
     epi.append ("SET TERM ; ^")