Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / sales / manage / credit_status.php

diff --git a/sales/manage/credit_status.php b/sales/manage/credit_status.php
index aed0b1ffc9a622d74836be1c6d083f8ffb0406f3..90fc179e4a2dc05519540ff4e3a6f0060c5b95c2 100644 (file)
--- a/sales/manage/credit_status.php
+++ b/sales/manage/credit_status.php
@@ -58,11 +58,7 @@ if ($Mode=='UPDATE_ITEM' && can_process())
 
 function can_delete($selected_id)
 {
-       $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtors_master 
-               WHERE credit_status=".db_escape($selected_id);
-       $result = db_query($sql, "could not query customers");
-       $myrow = db_fetch_row($result);
-       if ($myrow[0] > 0) 
+       if (key_in_foreign_table($selected_id, 'debtors_master', 'credit_status'))
        {
                display_error(_("Cannot delete this credit status because customer accounts have been created referring to it."));
                return false;