[Andro-hacker] SF.net SVN: andro:[1075] trunk/andro/application/androBuild.php

[<ken...@us...>]

Revision: 1075
          http://andro.svn.sourceforge.net/andro/?rev=1075&view=rev
Author:   kendowns
Date:     2009-01-12 19:03:01 +0000 (Mon, 12 Jan 2009)

Log Message:
-----------
QUEUEPOS columns no longer default to zero, but to null.

Modified Paths:
--------------
    trunk/andro/application/androBuild.php

Modified: trunk/andro/application/androBuild.php
===================================================================
--- trunk/andro/application/androBuild.php	2009-01-12 17:56:55 UTC (rev 1074)
+++ trunk/andro/application/androBuild.php	2009-01-12 19:03:01 UTC (rev 1075)
@@ -3606,11 +3606,15 @@
 			$this->SpecDDL_TriggerFragment($table_id,"UPDATE","BEFORE","1011",$s1);
                 }
 		
-		if ($automation_id=="BLANK" || $automation_id=='QUEUEPOS') {
+        # KFD 1/12/08, for eBlue (PROMAT), no longer make queuepos
+        #              columns default to zero, have them stay null
+		if ($automation_id=="BLANK" /* || $automation_id=='QUEUEPOS' */) {
 			$def = $this->SQLFormatBLank($row["type_id"],true,true);
+            #$def = "(Select max(COALESCE($column_id,0)+100 from $table_id)";
 			$s1 = "\n".
 				"    -- 1020 Blank/queuepos default\n".
-				"    IF new.". $column_id . " IS NULL THEN new.". $column_id . " = ". $def . "; END IF;\n";
+				"    IF new.". $column_id . " IS NULL THEN new."
+                . $column_id . " = ". $def . "; END IF;\n";
 			$this->SpecDDL_TriggerFragment($table_id,"INSERT","BEFORE","1020",$s1);
 		}
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.