Sql TB_PREF corrections

[fa-stable.git] / sales / includes / db / sales_invoice_db.inc

diff --git a/sales/includes/db/sales_invoice_db.inc b/sales/includes/db/sales_invoice_db.inc
index 49f9252f4808696fa57fe4ddd1a1c32a6d6454a6..55dc0bb0308d2473753448f32b85d57cfc7e01ab 100644 (file)
--- a/sales/includes/db/sales_invoice_db.inc
+++ b/sales/includes/db/sales_invoice_db.inc
@@ -4,7 +4,7 @@ function set_invoice_links(&$cart, $invoice) {
          
          $del = $cart->trans_no;
          if(is_array($del)) $del = $del[0]; 
-         $sql = 'UPDATE debtor_trans SET trans_link = ' . $del .
+         $sql = 'UPDATE '.TB_PREF.'debtor_trans SET trans_link = ' . $del .
                  ' WHERE type=10 AND trans_no='.$invoice;
          db_query($sql, 'Invoice link cannot be updated');    
 
@@ -17,7 +17,7 @@ function set_invoice_links(&$cart, $invoice) {
        
        }
 
-    $sql = 'UPDATE debtor_trans SET trans_link = ' . $invoice .
+    $sql = 'UPDATE '.TB_PREF.'debtor_trans SET trans_link = ' . $invoice .
        ' WHERE type=13 AND (';
 
     $deliveries = $cart->trans_no;