X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fmanage%2Fcredit_status.php;h=af65a498b3f6448a96de1492329a19318f7f8c5b;hb=ce5f33c17196c1f32e05576da2fd9719db60c596;hp=aed0b1ffc9a622d74836be1c6d083f8ffb0406f3;hpb=ebc600101ceab69c06eac4b1bd4d1782af45de05;p=fa-stable.git

diff --git a/sales/manage/credit_status.php b/sales/manage/credit_status.php
index aed0b1ff..af65a498 100644
--- 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;
@@ -97,7 +93,7 @@ if ($Mode == 'RESET')
 $result = get_all_credit_status(check_value('show_inactive'));
 
 start_form();
-start_table("$table_style width=40%");
+start_table(TABLESTYLE, "width=40%");
 $th = array(_("Description"), _("Dissallow Invoices"),'','');
 inactive_control_column($th);
 table_header($th);
@@ -131,7 +127,7 @@ echo '<br>';
 
 //-----------------------------------------------------------------------------------
 
-start_table($table_style2);
+start_table(TABLESTYLE2);
 
 if ($selected_id != -1) 
 {
@@ -160,4 +156,3 @@ end_form();
 
 end_page();
 
-?>