[Weberp-cvs] SF.net SVN: web-erp:[4462] trunk

[<dai...@us...>]

Revision: 4462
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4462&view=rev
Author:   daintree
Date:     2011-01-08 08:45:36 +0000 (Sat, 08 Jan 2011)

Log Message:
-----------
Ricard fixes

Modified Paths:
--------------
    trunk/Z_ChangeBranchCode.php
    trunk/Z_ChangeCustomerCode.php
    trunk/doc/Change.log.html

Modified: trunk/Z_ChangeBranchCode.php
===================================================================
--- trunk/Z_ChangeBranchCode.php	2011-01-06 05:16:06 UTC (rev 4461)
+++ trunk/Z_ChangeBranchCode.php	2011-01-08 08:45:36 UTC (rev 4462)
@@ -183,7 +183,7 @@
 
 	$result = DB_Txn_Commit($db);
 
-	$result = DB_IgnoreForeignKeyChecks($db);
+	$result = DB_IgnoreForeignKeys($db);
 	prnMsg(_('Deleting the old customer branch record'),'info');
 	$sql = "DELETE FROM custbranch
 					WHERE debtorno='" . $_POST['DebtorNo'] . "'
@@ -191,7 +191,7 @@
 			
 	$ErrMsg = _('The SQL to delete the old customer branch record failed because');
 	$result = DB_query($sql,$db,$ErrMsg,$DbgMsg,true,true);
-	$result = DB_ReinstateForeignKeyChecks($db);
+	$result = DB_ReinstateForeignKeys($db);
 
 }
 

Modified: trunk/Z_ChangeCustomerCode.php
===================================================================
--- trunk/Z_ChangeCustomerCode.php	2011-01-06 05:16:06 UTC (rev 4461)
+++ trunk/Z_ChangeCustomerCode.php	2011-01-08 08:45:36 UTC (rev 4462)
@@ -58,7 +58,8 @@
 									`editransport`,
 									`ediaddress`,
 									`ediserveruser`,
-									`ediserverpwd`)
+									`ediserverpwd`,
+									`typeid`)
 					SELECT '" . $_POST['NewDebtorNo'] . "',
 									`name`,
 									`address1`,
@@ -83,7 +84,8 @@
 									`editransport`,
 									`ediaddress`,
 									`ediserveruser`,
-									`ediserverpwd`
+									`ediserverpwd`,
+									`typeid`
 							FROM debtorsmaster
 							WHERE debtorno='" . $_POST['OldDebtorNo'] . "'";
 

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2011-01-06 05:16:06 UTC (rev 4461)
+++ trunk/doc/Change.log.html	2011-01-08 08:45:36 UTC (rev 4462)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>8/1/11 Ricard Andreu: Z_ChangeCustomerCode.php added typeid field that made change customer code fail. Also corrected typo for foreign key checking side stepping for Z_ChangeBranchCode.php</p>
 <p>5/1/11 Phil: Bug fixes AssetLocationTransfer and Supplier Contacts</p>
 <p>4/1/11 Paul T: Bug# 3151192 - insert underscore for superglobal.</p>
 <p>5/1/11 Phil: Bug fixes AssetLocationTransfer and Supplier Contacts</p>


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