SF.net SVN: ledger-smb:[3235] trunk/LedgerSMB

[..hidden..]

Revision: 3235
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3235&view=rev
Author:   ehuelsmann
Date:     2011-06-13 09:21:50 +0000 (Mon, 13 Jun 2011)

Log Message:
-----------
Replace 'shipto' table name with its new name 'new_shipto' to allow further testing.

Modified Paths:
--------------
    trunk/LedgerSMB/IR.pm
    trunk/LedgerSMB/OE.pm

Modified: trunk/LedgerSMB/IR.pm
===================================================================
--- trunk/LedgerSMB/IR.pm	2011-06-13 09:16:06 UTC (rev 3234)
+++ trunk/LedgerSMB/IR.pm	2011-06-13 09:21:50 UTC (rev 3235)
@@ -936,7 +936,7 @@
     $sth = $dbh->prepare($query);
     $sth->execute( $form->{id} ) || $form->dberror($query);
 
-    $query = qq|DELETE FROM shipto WHERE trans_id = ?|;
+    $query = qq|DELETE FROM new_shipto WHERE trans_id = ?|;
     $sth = $dbh->prepare($query);
     $sth->execute( $form->{id} ) || $form->dberror($query);
 

Modified: trunk/LedgerSMB/OE.pm
===================================================================
--- trunk/LedgerSMB/OE.pm	2011-06-13 09:16:06 UTC (rev 3234)
+++ trunk/LedgerSMB/OE.pm	2011-06-13 09:21:50 UTC (rev 3235)
@@ -325,7 +325,7 @@
             $sth   = $dbh->prepare($query);
             $sth->execute( $form->{id} ) || $form->dberror($query);
 
-            $query = qq|DELETE FROM shipto WHERE trans_id = ?|;
+            $query = qq|DELETE FROM new_shipto WHERE trans_id = ?|;
             $sth   = $dbh->prepare($query);
             $sth->execute( $form->{id} ) || $form->dberror($query);
 
@@ -725,7 +725,7 @@
     $query = qq|DELETE FROM orderitems WHERE trans_id = ?|;
     $sth->finish;
 
-    $query = qq|DELETE FROM shipto WHERE trans_id = ?|;
+    $query = qq|DELETE FROM new_shipto WHERE trans_id = ?|;
     $sth   = $dbh->prepare($query);
     $sth->execute( $form->{id} ) || $form->dberror($query);
     $sth->finish;
@@ -801,7 +801,7 @@
         for ( keys %$ref ) { $form->{$_} = $ref->{$_} }
         $sth->finish;
 
-        $query = qq|SELECT * FROM shipto WHERE trans_id = ?|;
+        $query = qq|SELECT * FROM new_shipto WHERE trans_id = ?|;
         $sth   = $dbh->prepare($query);
         $sth->execute( $form->{id} ) || $form->dberror($query);
 


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